This is my first assignment as part of the iNeuron Business Data Analytics course. Here we are going to cover the basics of Power BI and Why are we using Power BI ahead of other Tools and small hands-on in PowerBI
What is Power BI?:
Power BI is data visualization tool which help to understand the insights of the data which we take it from various data sources irrespective of structed or no-structured data and make the business decision from that and present the detail evaluation to the stakeholders and higher managements. Power BI is a collection of software services, apps and connectors that work together to turn our raw data into useful information. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.
Why Power BI?
Power BI is easy, fast, and robust, which makes it possible even for the non-technical people to analyze the data visually and share the same. Moreover, the tool empowers Business Intelligence in a way that it reduces the distance between data and insights.
Power BI Key Features
1. Interactive Power BI desktop
2. Customized Visualization
Power BI- Top Three Components
1. Power Pivot
2. Power Query
3. Power View
Assignment - 1
In this assignment we are performing the below steps.
1. Connecting a Sky Transport excel sheet with the Power BI
2. Hiding the columns Category ID and Origin State from the report
3. Create a table showing by Customer Name
2. Total Miles
3. Trip Type
4. Summarize the Revenue & Total Miles
5. Save this Power BI file with the name SkyData.
First we have to load the data by clicking on the Import data from Excel icon on the screen.
Select the Sky Transport excel sheet from the respective path and open it on the Power BI Application. Once its opened, Navigator window will get opened and the table from the Sky Transport excel sheet get displayed on the screen. By selecting the checkbox besides the Trips table, user can see the data gets displayed on the Navigator window along with Load and Transform Data button gets enabled.
By clicking on the load button, Trips data gets loaded in the Power BI application and the table and columns details are displayed under the fields section.
To hide the columns from the table, user need to navigate to Data layout by selecting Data icon from left side of the screen. Right click on the respective columns and select "Hide in Report View" option. After selecting "Hide in Report View", the selected columns should grayed out and the columns will be disappeared from the Fields section.
To create a better visualization we create a table with four fields and create few charts for better understanding. To create a table need to select the 'table' icon from the visualization section and select the columns 'Customer, Revenue, Total Miles and Trip Type'. After selecting the column we could see the data automatically updated in the table.
In this report we get to see the Sky transport data report, we can see Total miles covered and total revenue of Sky Transport data.
Table which contains columns like Customers , Revenue , Total Miles , Trip Type provides information to the stakeholders so that they get to know about their customers.
A visualization 'Pie Chart' clearly shows the total miles covered (13.76%) and total revenue generated (86.24%).
Bar chart show the total revenue earned by the customer.
Assignment - 2
The Key Performance Indicators (KPIs) are crucial metrics that evaluate and measure the performance of a business. KPIs reflect the way that a business is performing in terms of key parameters that every manager should identify. These parameters should be easy to understand to create the most effective meanings for all levels of a company and to evaluate whether the strategy in on track.
As a data scientist or data analyst, not only we should measure the performance of our models, we also pay attention to the performance of our projects identifying, first the best metrics, and second measuring the project KPIs
Data set we are going to use is Sky Transport, which contains the data from 2016 and in contains various parameters. From that we are going to derive the KPIs for better understanding and analyze he key data insights.
The KPIs analyzed are the following:
KPI for Total Miles, Revenue, and Cost
KPI have been calculated for Revenue based on the Shipping cost by Total miles. We got a positive positive KPI score where you can see the below.
The conclusions of the analysis shown in the figure above are the following.
To create a chart, one must select the respective chart from the Visualization section, after that need to select the data from the Fields section. This fields go as X-Axis, Y-Axis or Shared Axis depending on the visuals created by the user.
To make the better visuals one can change the properties by selecting Format icon from the Visualizations section and do the necessary changes like change font, text size, color etc.
This is my understanding and the visualization on the assignment. Please read and suggest me for better visualization and ideas.
Thank you iNeuron, Amit and Teams :)