Skip to content

About

Contains SQL code to create a bigger version of FactIntrenetSales from AdventureWorks and PBIX files based on the table to analyze PBI's compression rate.

Resources

Stars

3 stars

Watchers

1 watching

Forks

Latest commit

 

History

9 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

DateTimeCompressionRateInPBI

Contains SQL code to create a bigger version of FactIntrenetSales from AdventureWorks and PBIX files based on the table to analyze PBI's compression rate.

For the first two files, I had to upload the pbit files since they were larger than 25 MB which is the limit for my GitHub. For the pbit files, point them to AdventurWorks with the modified tables and refresh to load data.

See accompanying blog post here: https://shabnamwatson.wordpress.com/2020/09/21/how-much-space-does-splitting-date-time-columns-into-separate-date-and-time-columns-save-in-power-bi-models/

About

Contains SQL code to create a bigger version of FactIntrenetSales from AdventureWorks and PBIX files based on the table to analyze PBI's compression rate.

Resources

Stars

3 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages