Data Warehousing 2
Data Warehousing 2
Embedded Files
Integrated Datasets of different formats from different sources to store and run queries in MS SQL Server to analyze daily/weekly sales and product levels in stock
Integrated Datasets of different formats from different sources to store and run queries in MS SQL Server to analyze daily/weekly sales and product levels in stock
Process Flow
Selected Daily/Weekly Product details, Daily/Weekly Stock levels, Daily/Weekly Sales Transactions in different Stores, and Promotional datasets to build a data warehouse
Formulated Business Questions to answer for Analytics
Browsed through different sources to avail and download datasets for Data Warehouse
Cleaned and standardized files to our requirements
Created tables in MS SQL Server with Primary and Foreign Key references
Loaded (SSIS) all the integrated files from different sources into the designated tables in MS SQL Server using Export /Import Wizard
Performed Data Mapping
Finally Ran SQL Queries to answer business questions
The below screenshot showcases all the created tables using Data Definition Language (DDL)
The screenshot below is the diagram flow showcasing the data mapping (including dimension tables and fact tables ) of the data warehouse from the Microsoft SQL Server to create a data warehouse for weekly sales data
The screenshots below showcase few of the SQL queries using Data Manipulation Language (DML) to analyze the datasets inside the Data Warehouse
Business Question: How much was spent on promotions for each department in a given week?
Business Question: Which city generates the highest revenue?
My Role: This was an individual project: I was in charge of loading all the datasets in the SQL Server, creating tables, performing ETL and running SQL queries to answer business questions.
Page updated
Google Sites
Report abuse