Forum Discussion
PowerPivot data model with multiple fact tables
Hi PB76 ,
A good model is the beginning of everything.
Understand star schema and the importance for Power BI
-- Should I append all the mapped transaction extracts and use that data set as a singular fact table?
If possible, this is the preferred solution. PowerPivot is optimized for handling large, flat tables. A single fact table can improve performance compared to multiple fact tables. And it simplifies the creation of metrics and calculations because you only need to reference one table.
-- Each company's transaction extract varies from 50K-150K rows at year-end.
Considering the amount of data you are working with and the increase in the amount of data each year, it may be worth considering a platform other than Excel. While Excel is powerful, it can be slow and cumbersome when working with large datasets. One example is Power BI.
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi PB76 ,
A good model is the beginning of everything.
Understand star schema and the importance for Power BI
-- Should I append all the mapped transaction extracts and use that data set as a singular fact table?
If possible, this is the preferred solution. PowerPivot is optimized for handling large, flat tables. A single fact table can improve performance compared to multiple fact tables. And it simplifies the creation of metrics and calculations because you only need to reference one table.
-- Each company's transaction extract varies from 50K-150K rows at year-end.
Considering the amount of data you are working with and the increase in the amount of data each year, it may be worth considering a platform other than Excel. While Excel is powerful, it can be slow and cumbersome when working with large datasets. One example is Power BI.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum