In this project, You have to create a Power BI Report. You will get hands-on experience on Tabular Visualization, Matrix Visualization, Funnel chart, Pie chart, Scatter plot, Sand dance plot
Project: In United States, there are many stores in which a survey was conducted based on students i.e. How much they are spending on different kinds of purchases like Video games, Indoor games, Toys, Books, Gadgets, etc. Create a Power BI Report to demonstrate Tabular Visualization, Matrix Visualization, Funnel Chart, pie chart, scatter plot, sand dance plot. Also Restrict data access for the given users in User mapping table. Publish the report on Power BI cloud service and Design the Master Dashboard consisting of Funnel chart and scatter plots. Then create a schedule refresh for six times in every 4 hours for the Dashboard in a day.
Topics: Basic Calculation using DAX, Data Transformations, Advanced Visualisations, Advanced features of Power BI Cloud Service, Context, Gateway and Schedule Refresh, Creation of Report, Sand-Dance and Percentile, Row Level Security
- Tabular Visualization
- Matrix Visualization
- Funnel chart
- Pie chart
- Scatter plot
- Sand dance plot
- Advanced features of Power BI Cloud Service
- Row Level Security
Case Study 1: Power BI Desktop, Cloud Service and End to End Workflow
Problem Statement: Design dashboard with basic set of visualizations and deploy to Power BI Cloud Service. Show top level brief overview of Transport Corp data using aggregated KPIs, Trends, Geo Distributions and Filters.
Topics: Creation of Report, Publishing to Cloud
- Key Performance Indicator
- Creation of Report
- Publishing to Cloud
Case Study 2: Visualizations, Configuring Extended Properties and Data Calculations DAX – Introduction
Problem Statement: Design dashboard to make use of Power BI DAX formulas to perform calculations. Analyze scheduled deliveries of loads. Use correlations across measures. Implement drill downs and reference lines.
Topics: DAX Introduction
- Enable Drill Down / Drill Up Capabilities
Case Study 3: Combination Visualizations for Correlated Value Columns
Problem Statement: Design dashboard to make use of Power BI DAX formulas and perform calculations. Create Bucketed Categories to represent value measures on categories axis. Use scatter plot to identify outliers or outperformers.
Topics: Basic Calculation using DAX, Measures on Category Axis
- Calculation using DAX
- Measures on Category Axis
Case Study 4: Data Transformations
Problem Statement: Design an audit dashboard. Make use of Power Query. Use Query Editor to perform data modeling by apply transformations. Manage relationships
Topics: Data Transformations
- Query Editor
- Data Transformations
Case Study 5: Data Transformations -Cont.
Problem Statement: Design a dashboard to analyze the trend of admissions into state universities. Use Query Editor to perform data modeling by apply transformations like append data, split data, column Formatting, fill columns, transpose table, pivot/unpivot, merge join, conditional columns, index columns, summary tables.
Topics: Designing a Dashboard, Transformations
- Data modeling
- Append data
- Split data
- Column Formatting
- Transpose table
- Merge join
- Conditional columns
- Index columns
- Summary tables.
Case Study 6: Advanced Visualizations
Problem Statement: Design a dashboard to analyze the trend of admissions into state universities. Use expressions and filters to build custom visualizations.
Topics: Advanced Visualizations
- Advanced Visualizations
- Expressions and filters
- Custom visualizations
Case Study 7: Advanced features of Power BI Cloud Service
Problem Statement: Knowledge check on Ad hoc analytics with Power BI Q&A, Dashboard Notifications and Alerts, get Data from Google Analytics and Customize Pre Loaded Visualizations
Topics: Advanced features of Power BI Cloud Service
- Ad hoc analytics with Power BI Q&A
- Dashboard Notifications and Alerts
- Google Analytics
- Customize Pre Loaded Visualizations
Case Study 8: Advanced features of Power BI Desktop Client
Problem Statement: Knowledge check on Advanced features of Power BI Desktop Client (Integrate Custom Visualizations and Create Sand Dance Visualization).
Topics: Advanced features of Power BI Desktop Client
- Integrate Custom Visualizations
- Create Sand Dance Visualization
Case Study 9: Top Down and Bottoms Up Analysis to identify Shipping Costs Leakages
Problem Statement: Build a set of visualizations to identify underlying outliers and flip the same set of visualizations to perform bottoms up analysis.
Topics: Power Bi Dashboard(Top Down and Bottom Up Analysis)
- Top Down and Bottom Up Analysis
Case Study 10: Value & Volume based analysis on hospital records to analyze Charges vs. Patients Inflow
Problem Statement: Build a set of visualizations linked to dynamic measures to flip analytics on user demand
Topics: Value and Volume based analysis
- Value and Volume based analysis