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

Highlights:

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

Highlights:

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

Highlights:

Enable Drill Down / Drill Up Capabilities

DAX

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

Highlights:

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

Highlights:

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

Highlights:

Data modeling

Append data

Split data

Column Formatting

Transpose table

Pivot/unpivot

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

Highlights:

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

Highlights:

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

Highlights:

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)

Highlights:

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

Highlights: