PowerBi-Project

Problem Statement 1: Objective: Data Transformations Use Case: Design a dashboard to analyze the trend of admissions into state universities. Source: USA StateUniversity Admissions Analytics: Use Query Editor to perform data modeling by applying transformations like,

1. Append Data
2. Split Data
3. Column Formatting
4. Fill Columns
5. Transpose Table
6. Pivot / Unpivot
7. Merge Join
8. Conditional Columns
9. Index Columns
10. Summary Tables

Problem Statement 2: Objective: Advanced Visualizations. Use Case: Design a dashboard to analyze the trend of admissions into state universities. Source: USA StateUniversity Admissions Analytics: Use expressions and filters to build custom visualizations

Dashboard - Applications Analysis

1. Total Applications vs. Target Trend by State
2. Total Application by State Geo Dashboard
3. Tabular presentation of universities and funds
4. % of Applications by Race

Dashboard - Universities Analysis

1. Top 10 Universities by Applications
2. Top 10 Universities by Applications with and without Special Grants
3. Bottom 10 Universities by Applications
4. Percentage of Applications vs. Universities Fund Allocations

Problem Statement 3: Use Case: Top Down and Bottoms Up Analysis to identify shipping costs leakages Source: Superstore sales Analytics: Build a set of visualizations to identify underlying outliers and flip the same set of visualizations to perform bottom up analysis.

Top Down Analysis

1. Shipping Costs by Order Priority - Bar Chart
2. Shipping Costs by Shipping Mode - Funnel Chart
3. Shipping Costs by Customers - Scatter Plot
4. Transactional view of underlying data

Bottom Up Analysis

1. Duplicate above dashboard and change interactions .
2. Replace Transactional View with Donut and Scatter Plot with Tree map.