Power BI - Do it Yourself Tutorial - Understanding Visualizations - DIY -3-of-50

Thanks! Share it with your friends!

You disliked this video. Thanks for the feedback!

Added 4 years ago by Voyage

5 Views

Microsoft Power BI - Do it Yourself(DIY) Tutorial - Understanding Visualizations - DIY -3-of-50
by
Bharati DW Consultancy
cell: +1-562-646-6746 (Cell & Whatsapp)
email: bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/

Power BI - Do it Yourself Tutorial - Understanding Visualizations - DIY -3-of-50

In this video, we will get started in Power BI.
1- Click on Get Data, and then Select Excel Datasource
2- Load the PBI_DIY_BDCS_Sales.xlsx File
(Download the file from this location https://goo.gl/33P87q)
3- Verify the data, and click on Load.
4- Goto Page 1
5- Check the Channel Type, Customer Country and Sales_Amt from the Fields pane. Notice the values appearing on the reports area.
6- Change the visualizations using Visualizations pane. Select the Pie chart.
7- Now let's look at the properties of the pie chart.
8- Next, click on the line chart. Select the Sales Date, Sales Amount.
9- Notice the Date Hierarchy levels, this is a very intuitive property of Power BI.
10- Now let's look at the properties of this line chart.
11- Do the following Hands on exercises.

Hands on - DIY #3
1- Add a new page, from the bottom of the screen.
2- Select the Pay Type, Item Category and Sales_Cost from the Fields pane. Notice the values appearing on the reports area.
3- Change the visualization to Bar chart. Then Clustered bar charts.
4- Add Area chart with Pay Type, Item Name and Sales_Qty, Scatter Charts with Department, Manager, and Sales_Qty.
5- Notice the properties of the charts.

Hands on - DIY #4
1- Add a new page, from the bottom of the screen.
2- Select the Pay Type, Department and Sales_Cost from the Fields pane. Notice the values appearing on the reports area.
3- Change the visualization to Tree Map.
4- Add Line chart with Pay Type, Item Name and Sales_Qty, Scatter Charts with Department, Manager, and Sales_Qty. Note that you might have to drag and drop the columns in other areas of the properties.
5- Notice the properties of the charts.

Power BI, Do it Yourself Tutorial, Getting Started, Microsoft Power BI, Understanding Visualizations