OnlineMusicStore-BI

BI project with sample database and data warehouse, using SQL Server 2016 and SSDT for Visual Studio 2017 (including SSIS, SSRS, OLAP and TABULAR)

Data for database and data warehouse can be find on following links:

-DB - https://edufit-my.sharepoint.com/:f:/g/personal/emrah_djulan_edu_fit_ba/EoFvDlfKWnlCr1y_4nPFKGABQi-BHStDX4QSeuW4bINq4Q?e=WFwuJ0

-DW - https://edufit-my.sharepoint.com/:f:/g/personal/emrah_djulan_edu_fit_ba/Esd-GC8EX8ZJsXuredpCPW0Beh3xIbwVcvvS2N7L_a3tQw?e=g0HeIP

#DB tables contain:

-Albums 12000 rows

-Artists 20000 rows

-Cities 93 rows

-Countries 30 rows

-CreditCards 90000 rows

-CustomerCreditCard 90000 rows

-Customers 50000 rows

-Genres 12 rows

-Labels 870 rows

-Regions 6 rows

-Reviews 500000 rows

-SalesOrder 1500000 rows

-SalesOrderDetail 1500000 rows

-Songs 129000 rows

#DW tables contain:

-DimAlbum 12000 rows

-DimArtist 20000 rows

-DimDate 3653 rows

-DimGender 3 rows

-DimGenre 12 rows

-DimLabel 870 rows

-DimLocation 93 rows

-DimSong 129000 rows

-FactSales 1499992 rows

This sample data makes posible to create reports with PowerBI, Excel and ReportBuilder. Sample reports can be found at:

-Reports - https://edufit-my.sharepoint.com/:f:/g/personal/emrah_djulan_edu_fit_ba/Eta35uIJA5FKrKL5AFdNgUsBpnZ3xtR5RgumRZNMwISgGw?e=WDQ404