Power BI - Assignment No. 1& 2.

Vikyat Prabhu Apr 07 2021 · 2 min read
Share this

This is my first assignment in Power BI Tool.

Power BI is a BI tool provided by Microsoft. It has amazing features to create interactive visualization for creating dashboards and reports .

Assignment No. 1 Sky Data.

                                                                              Complete Project
  • 1. You should hide the category ID and Original  Steps.
  • Steps to remove the column.

    First we have to click the specific column and then choose remove columns, and the specified column will be removed.

    Then we have to select Apply and the close from the top left corner of the page and move to visualization.

  • 2.Create a table showing by  customer name, Revenue, Total Miles, Trip type.
  • As shown in above image. select table visualization and add Customer, Revenue, Total miles and Trip type to the Value.

  • 3.Summarize the Revenue and Total Miles.
  • Select a Clustered column chart Visualization, and add Total miles & Revenue to the value and Customer to Axis.

    To get summarized view of Revenue and Total Miles

    Select a Card Visualization and add Total revenue to the fields and select counts.

    To get the total counts of revenue generated and miles traveled.

    Assignment No. 2 Trip Analysis.

                                                                             Complete Project
  • 1. KPIs for Total Miles, Revenue, Cost.
  • Here we have to use Cards Visualization instead of KPIs and get the counts of Total miles, Revenue, Shipping cost.
  • 2. Revenue Vs Miles by shipping State.
  • 3. Revenue Vs Miles by Shipping City.
  • Here we have to select clustered column chart and add Total Miles and revenue in Vales and Original states in Axis.

    As we can see from the above image in which state sky transport has covered more miles and generated higher revenue.

    Here we have to select clustered column chart and add Total Miles and revenue in Vales and Original City in Axis.

    As we can see from the above image in which city sky transport has covered more miles and generated higher revenue.

  • 4. Total Trips Vs Trips by Trip Types.
  • Here we can select Donut chart and add Trip Type to legends and Total miles & Trip ID to vales.

    From the above images we can understand total miles covered by air transport by different type of trips.

  • 5.Percentage of trips by shipping state.
  • Here we can select Pie chart and add Original states to legends and Total miles to vales.

    From the above images we can understand total miles covered by air transport on different states.

  • 6. Revenue Miles Vs Total Miles.
  • Here we have to select clustered column chart and add Total Miles and Loaded Miles in Vales.

    From the above images we can see the miles loaded for the trips and the actual total miles covered by the trips.

    In the above 2 assignments i have just highlighted the visualization i wanted to explain to make my points clear.

    Thanks & Regards,

    Vikyat Prabhu.

    Comments
    Read next