Forum Discussion
Modeling Data over Time
Have a look at the two example files in this folder.
Example 1 is a very basic example of how your snapshotted SQL table could look with a custom date table related to it in order to enable future analysis.
Example 2 then uses power query to shape the data into a better star schema which will keep the model faster as your data volume grows. This data transformation could be done at source in SQL Server using SSIS for example.
Hope they show how it could look.
Have a look at the two example files in this folder.
Example 1 is a very basic example of how your snapshotted SQL table could look with a custom date table related to it in order to enable future analysis.
Example 2 then uses power query to shape the data into a better star schema which will keep the model faster as your data volume grows. This data transformation could be done at source in SQL Server using SSIS for example.
Hope they show how it could look.
Thank you very much! That makes a lot of sense. Greatly appreciate your time with this!