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.