Power BI Assignment -2

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

Use Case — Design dashboard with basic set of visualizations

Source — Sky Transport

Analytics — Develop a dashboard to show top level brief overview of Sky

Transport Report/Dashboard — Transport Data

• KPIs for Total Miles, Revenue, Cost
• Revenue Vs Miles by Shipping State
• Revenue Vs Miles by Shipping City
• Total Trips Vs Trips by Trip Types

• % of Trips by Shipping State Revenue Miles vs Total Miles

Save this Power BI file with the name Trip Analysis

• Result — At the end you will have a idea about KPIs, Tables

Step 1: Lets load data into PowerBi desktop from

Get data -> Excel -> Sky_Transport_Corp

• Revenue Vs Miles by Shipping State

• Revenue Vs Miles by Shipping City

• Total Trips Vs Trips by Trip Types

• % of Trips by Shipping State

• Revenue Miles vs Total Miles

• Revenue Miles vs Total Miles

Final Basic Dashboard