Skip to main content

Power BI tutorial 1: Installing Power BI and creating a simple Bar Graph.

In this tutorial, we are going to look at how to install my favorite Business intelligence tool, Microsoft Power BI and also try to solve a problem using it.

Installation steps:

Step 1: Click on this link.
Step 2: Under Power BI, click on the download button as shown in the image below.


Step 3: After the download is complete. Double click and open the PBIDesktop.msi file and follow the instructions to complete the installation.


Once the installation is complete, open Power BI from your start menu.

Dataset: Download the Vancouver Crime dataset from Kaggle (crime.csv).

Problem: We have been tasked to find out which crime has happened the most in Vancouver. So let's get started.



1. As shown in the figure, click on the Get Data button. 


2. Select Text/CSV option and click on connect.


3. Select the crime.csv file from wherever you have saved it and click OK.

4. Click Load in the preview window.


5. If the data is loaded is properly, then the Fields pane on the leftmost end of the window will be loaded with the fields from the csv file.


6. From the Fields section, click and drag the TYPE field to the center of the report page as shown in the figure. 


7. Click and drag the TYPE field onto the table that has already been created in the reports page.


8. In Visualization pane, Under fields, you will be able to see two TYPE Values present. On the second TYPE, value click on the small arrow to access a menu.


9. From the menu select count.


10. After that, you should be able to have a table as shown above. The next step is to convert this into a graph.


11. Click on the Bar Graph icon on the visualization pane. VOILA, you have a bar graph.


12. So let us get back to our small problem. From the bar graph, we can see that Theft from Vehicle happens more than any other crime on the list. 

I will see you guys in another tutorial in the future.

Comments

Post a Comment

Popular posts from this blog

Sberbank Realty Price prediction Kaggle Challenge

Sberbank Challenge GitHub Code
Post a Comment
Read more

Aggregation using SQL (Game Consoles dataset)

Let's analyze the sales of Console Games. We are tasked to extract insights from the company. The dataset we will be using is the Console Games Dataset . I have imported the data into my MS SQL Server (Transact SQL). Table Design: Challenge #1: What are the total sales of video games in North America, Europe, and Japan. SELECT SUM(na_sales) AS TOTAL_NA_SALES, SUM(eu_sales) AS TOTAL_EU_SALES, SUM(jp_sales) AS TOTAL_JP_SALES FROM [dbo].[console_games]; Result:  In North America, the total sales were 4310.5M copies, in Europe, it was 2382.36M and in Japan it was 1266.38M. So what if I had to get the total sales in the world. The easier method would be to create a column to have total sales. Challenge #2: Create a new column to get the total sales. ALTER TABLE [dbo].[console_games] ADD global_sales float; UPDATE [dbo].[console_games] SET global_sales = na_sales + eu_sales + jp_sales + other_sales; Result: I have a new column with the glob...
Read more

You Hungry? Use this dashboard to find restaurants in India.

Dataset:  Zomato Kaggle Dataset The dashboard acts as a tool to search for restaurants in the major cities of India.  Go ahead and select the city from the slicer and find out what is the average cost to have food in your city is. Do you want food to be delivered, click on deliveries and find out which restaurants deliver nearby? The dashboard was created using Microsofts Power BI.
Post a Comment
Read more