SKY TRANSPORT DATA & TRIP ANALYSIS

##powerbi ##columnhide ##typesofgraph ##dashboard

md shabbir Dec 10 2020 · 3 min read
Share this

Assignment-1

Objectives: We need to analyze the data for Sky Transport Corp.

Source: Excel file (Skytransport.xlsl)

Tool using: Microsoft Power BI.

We need to do the analysis for the below scenario-

(i)    Hide category ID and origin state.

(ii)   Create a table showing by Customer Name, Revenue, Total Miles & Trip Type.

(iii)   Summarize revenue and total miles and save this PBI file as SkyData.

Steps & Screen shot-

i)   Launch Power BI .

ii)   Load the Excel data from get data option.

iii) check the trips and Click on load .

i)   Hide Category ID and Origin State by right-clicking on Category ID and Origin State.

ii)  under the visualization field select the table format. Then drag the attributes into the value section. After selecting the attributes to the values section automatically the Revenue and Total Miles will be summarized.

Conclusion-

I)   We get the knowledge & basic functions of Power BI i.e. How to transform, load the data and certain manipulation about it.

II)  Also learn to Hide couple of columns which are not required, and also we created Graph for better visualization.

III) Save the Power BI file with the extension of “.pbix”.

Assignment-2

Here we learn in brief analysis like KPI, comparing visualization using different type of Graph (Line, Bar, Donut, Gauge etc.) with the help of same data source i.e. sky transport.

We need to do the analysis for the below scenario-

i)   KPIs for Total Miles, Revenue, Cost

ii)  Revenue Vs Miles by Shipping State

iii)  Revenue Vs Miles by Shipping City

iv)  Total Trips Vs Trips by Trip Types

v)    % of Trips by Shipping State

vi)    Revenue Miles vs Total Miles

* KPI-( Key Performance Indicators)- Key Performance Indicators (KPIs) are the elements of  your plan that express what you want to achieve by when. There are five pillars for KPI-

·   A Measure – Every KPI must have a measure. The best KPIs have more expressive measures.

·    A Target – Every KPI needs to have a target that matches your measure and the time period of your goal. These are generally a numeric value you’re seeking to achieve.

·   A Data Source – Every KPI needs to have a clearly defined data source so there is no gray area in how each is being measured and tracked.

·   Reporting Frequency – Different KPIs may have different reporting needs, but a good rule to follow is to report on them at least monthly.

Examples of Sales KPIs

1. Number of New Contracts Signed Per Period

2. Dollar Value for New Contracts Signed Per Period

3. Number of Engaged Qualified Leads in Sales Funnel

4. Hours of Resources Spent on Sales Follow Up

5. Average Time for Conversion

6. Net Sales – Dollar or Percentage Growth

Examples of Financial KPIs

7. Growth in Revenue

8. Net Profit Margin

9. Gross Profit Margin

10. Operational Cash Flow

11. Current Accounts Receivables

12. Inventory Turnover

Steps & Screen shot-

Task :1:  KPIs for Revenue, Total Miles and Cost.

Here i used a DONUT chart to show the values.

Task :2:  Revenue Vs Miles by Shipping State

Here I used Line and stacked column chart from the visualizations tab after that drag the Revenue value in columns and row in Destination state and in line value Total miles.

Task :3:   Revenue Vs Miles by Shipping City

Here I used CLUSTERED column chart from the visualizations tab after that drag the Revenue & Total mile value in columns and row in Destination city.

Task :4: Total Trips vs Trip by Trip Types.

Here I used TREE MAP chart from the visualizations tab after that drag the Trip type & Trip ID.

 Task :5: % of Trips by Shipping State

Here I used PIE chart from the visualizations tab after that drag the Destination State & Trip ID.

 Task :6: Revenue Miles vs Total Miles.

Here I used Scatter chart from the visualizations tab drag and drop Loaded Miles Total Miles axis and Destination State on Legend

Final Dashboard: -

Comments
Read next