Call/WhatsApp: +1 914 416 5343

Data Analysis

Download and import data to SQL server(database: AdventureWorksDW2012). Create an Analysis Services multidimensional project using SQL Server Data Tools, create a Data Source View, imported the necessary tables into it, create necessary dimension tables and fact table, deploy this project CUBE. Use Excel to calculate sales amount of black product ordered in quarter 1 and quarter 2, the sales amount only includes two cities in California: Berkeley, Beverly Hills.

Leave a Reply