top of page

Get Help In Power BI Assignment and Project | Sample Question Papers | Realcode4you


Practice Set 1:

Objective: Power BI Desktop, Cloud Service and End to End Workflow


Use Case: Design dashboard with basic set of visualizations and deploy to

Power BI Cloud Service


Source: Trips Log Entries (Excel Workbook - Lans Transport Corp)


Analytics: Develop a dashboard to show top level brief overview of Transport

Corp data using aggregated KPIs, Trends, Geo Distributions and Filters.


Dashboard: Transport Dashboard

  1. KPIs for Total Miles, Revenue, Cost

  2. Revenue vs. Miles by Shipping State [Trend]

  3. Revenue vs. Miles by Shipping City [Map]

  4. Total Trips vs. Trips by Trip Types

  5. Percentage of Trips by Shipping State

  6. Revenue Miles vs. Total Miles



Practice Set 2:

Objective: Visualizations, Configuring Extended Properties and Data Calculations DAX - Introduction


Use Case: Design dashboard to make use of Power BI DAX formulas to perform calculations.


Source: Shipping Categories and Shippers (Open Data - Northwind OData) and Lans Transport Corp.


Analytics: Develop a dashboard to analyze scheduled deliveries of loads. Use correlations across measures. Implement drill downs and reference lines.


Dashboard: Delivery Analysis

  1. Revenue Miles vs. Total Miles by Category

  2. Add Analytical Lines

  3. Tips by Delivery Status by Shipper (Row Context)

  4. Enable Drill Down / Drill Up Capabilities

  5. [Drill Down by Level, Hierarchical Drill Down, Select Drill Down] [Record View vs. Data View]

  6. Shipping Costs vs. Revenue by Category

  7. Create a Hierarchy on Location, Default Time Hierarchy


Practice Set 3:

Objective: Combination visualizations for correlated value columns.


Use Case: Design dashboard to make use of Power BI DAX formulas and perform calculations.


Source: Shipping Categories and Shippers (Open Data - Northwind OData) and Lans Transport Corp.


Analytics: Create bucketed categories to represent value measures on categories axis. Use scatter plot to identify outliers or outperformers.


Dashboard: Delivery Analysis

  1. Trips by Shipping Days binned by Trip Type (Create Table)

  2. Delivery Days vs. Due Days

  3. Delivery Days vs. Due Days by DestinationCity

  4. KPIs for Cost Per Miles, Revenue Per Miles, On Time Deliveries, Avg. Miles Per Trip (Set Context)


Practice Set 4:

Objective: Data Transformations


Use Case: Design an audit dashboard. Make use of Power BI Power Query [M].


Source: Trips Check Points (for Target) and Transport Corp (for Actual).


Analytics: Use Query Editor to perform data modeling by applying transformations. Manage relationships.


Dashboard: Checkpoints Analysis

  1. Target vs. Actual Checkpoints Audit

  2. Target vs. Actual Checkpoints by Week

  3. Detailed Visualizations for Selected Audit

  4. Cross Table - Checkpoints by Trip Type by Shipper



Practice Set 5:

Objective: Data Transformations Cont.


Use Case: Design a dashboard to analyze the trend of admissions into state universities.


Source: USA State University Admissions


Analytics: Use Query Editor to perform data modeling by apply 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



Practice Set 6:

Objective: Advanced Visualizations


Use Case: Design a dashboard to analyze the trend of admissions into state universities.


Source: USA State University 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. Percentage 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



Practice Set 7:

Objective: Advanced features of Power BI Cloud Service


Source: Google Analytics

  1. Ad hoc analytics with Power BI Q&A

  2. Feature, Favorite and Dashboards Settings

  3. Dashboard Notifications and Alerts

  4. Get data from Google Analytics and customize pre-loaded visualizations


Practice Set 8:

Objective: Advanced features of Power BI Desktop Client


Source: Transport Corp Data

  1. Integrate Custom Visualizations and Create Sand Dance Visualization

  2. Use shapes and symbols to increase report readability

  3. Category Options, Summarizations, Show Blank Categories and Filters

  4. Folder as a Source


Practice Set 9:

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 Donut and Scatter Plot with treemap



Practice Set 10:

Use Case: Value and Volume Based Analysis on hospital records to analyze Charges vs. Patients Inflow


Source: Country wide hospital inpatients records


Analytics: Build a set of visualizations linked to dynamic measures to flip analytics on user demand.

1. Dashboard

  1. Create KPIs of Total Charges and Trends on Hospital Type and Categories

  2. Create Geo Distribution of Hospitals

2. Hospital Analysis

  1. Stacked Trend of Hospitals by State by City and by Category

3. Hospital Search

  1. Details View and Slicers for Hospital Type, Category, State and City


DAX Expression - DynamicMeasure = IF(

FIRSTNONBLANK(AnalysisSetting[AnalysisSetting],TRUE())="Inflow"

,SUM(InpatientRecords[ Total Discharges ]),SUM(InpatientRecords[ Total

Payments ] ))



To get any other help related to Power BI assignments, projects and homework you can contact us. We are group of 25+ computer science experts and professionals that have 5+ year of experience in related domain.


For more details you can contact us at:


Comentarios


bottom of page