SalesAnalysis_SQL_PowerBI

SalesAnalysis_SQL_PowerBI

Setup

• This project requires SQL Server (SQL Express), Power BI Desktop
• We will work with backup Data Warehouse (DW) data and Lightweight (LT) data. Obtain data and restore following instructions from here.
• Compare DW and LT data to understand the difference between structured and unstructured data. We will primarily be working with Data Warehouse data.
• Update Data Warehouse data using sql script.

Business Request & User Stories

• Read the sample business request, demand overview & filled-out user stories to understand the problem we are trying to solve with Data Analysis and what we consider as a solution.

Clean the Data using T-SQL

• Understand the difference between FACT tables & Dimension tables.
• Identify which tables in the data are of interest with the help of the Business Request form.
• Choose which columns are of interest to export by preparing and transforming these columns in SQL using concepts such as: renaming columns, combining columns, commenting in SQL script, formatting of SQL statements, WHERE clause, ORDER BY, LEFT JOIN, CASE() function and ISNULL() function.

Create Dashboard in Power BI

• Load Data
• Organize & Prepare Tables
• Connect Tables for Data Model
• Import Fact_Budget
• Calculation Measures
• Dashboard Design
• Import Custom Visual
• Measure Table
• Pie Chart
• Line Chart
• Bar Charts
• Map Graph
• Top 10 Graphs
• Gradient Bar Chart Color
• Customer Details
• Pivot Table

Dashboard

• Download the file and open in Power BI Desktop for interactive viewing.
• See a screenshot of the Dashboard in pdf.