Embedded Files
Power BI is a powerful data visualization and business intelligence tool that can help individuals and organizations make sense of their data. It's like creating interactive and visually appealing reports and dashboards. Here's an explanation suitable for high school students:
Imagine you have a lot of data, like numbers and information about different things. Power BI helps you take all that data and turn it into colorful and easy-to-understand charts, graphs, and reports. It's like making a picture out of numbers.
With Power BI, you can see trends, patterns, and insights in your data that might not be obvious just by looking at numbers in a table. This can be super helpful for businesses to make decisions, like figuring out which products are selling the best or where they should open a new store.
It's kind of like turning a pile of puzzle pieces into a beautiful picture, helping you understand what's going on with your data. And that's why Power BI is used in many businesses and organizations to make smarter choices.
Get the free Desktop app
For your actual report, take screenshots of the Spotfiy file. You can take them for the GDP file if you wan too.
If you're using the Spotify file, we want to see if you can work out how to import Data from a CSV file or spreadsheet. The process is similar to the GDP practice you will have done.
Download Power BI Desktop
You can get Power BI either from within Microsoft Teams or from the Microsoft Store on the taskbar.
You want the Power BI Desktop (Free)
Press the white 'x' in the top-right corner
Use this instruction when working on the Spotify file.
From the Home Tab, click Get Data
Web (for the Spotify file, click Text/CSV), then skip ahead to Step #11 and continue on Transforming
Paste this URL into the field: https://en.wikipedia.org/wiki/List_of_countries_by_GDP_(PPP)_per_capita
Press OK
5. If you get this screen, select the drop-down menu and choose the last option.
6. Press Connect
7. Select the GDP table
8. The other tables are on the web page
You will see a preview of your Data
9. Select Load
9a. You also have the option to select Web View (instead of Table View)
This box will go away at the top once it builds all the queries
This is called the 'fields list'
Press the (>) greater than symbol to expand
They are called column
10. Press on the grid icon to see your data
11. Press File
12. Save as
13. Find a suitable location
14. Give it the filename: GDP (or Spotify)
By default, it will have the file extension: .pbix
If you hover over the name next to the (>) greater than symbol, it will tell you name of the table that was imported.
F
From the . . . there are many options:
> Refresh data
> Edit query
> Rename (the table)
> etc
10. On the Home tab
11. Click Transform data
12. Transform data
This is Power Query Editor (which is also used in Microsoft Excel)
Queries (you can have multiple of them) and Query Settings
Selecting the All Properties link, opens up a box where you can type the Description of it, should you want to remember what you did '6 months' from now.
Notice in this section, a history of every changed you've applied to your query.
At this particular instance, Power BI made all these changes.
If you wanted to see the URL of where you got this information, you could click on Source
The next step is the table that Power BI extracted
13. From the Home tab, click Use First Row as Headers
14. Rename each of the columns where Power BI wrapped text that was in a table onto a second row
14a) IMF [5] [6] to IMF Estimate, IMF Year, World Bank Estimate, World Bank Year, CIA Estimate, CIA Year
15. Right-click on the first column and select Rename
Because we renamed the Headers, we can get rid of the first row
16. Select Remove
17. Remove Top Rows (For the Spotify file, choose the rows or columns you want to remove)
18. Put the number 1 in
19. Press OK
Notice that more steps are being added to APPLIED STEPS
We want to format some of the data types in the column.
For example in the IMF Estimate, there are text values further down in the column, but for the most part it's a whole number we want (formatted).
20. In the Transform drop-down menu
21. Select Data Type: Text
22. Select Whole Number
Notice when we make the change, that we get error messages.
Notice there is a thin green line that goes along the bottom of each column header and then a small red section. If you hover over this line, it produces this message about 33 (14%) Errors. If you selected Remove Errors, it would remove each of the rows that contain that error (which is not what we want to do). But it is an option should you want to in another Query.
23. Make sure you've adjusted each of the 3 columns highlighted (green) below
24. Select IMF Estimate, hold down the Ctrl key and press the IMF Year, CIA Est, and CIA Year columns as we are going to remove them
25. On the Home tab, select Remove Columns
26. Remove Columns
27. Right-click on the World Bank Est column
28. Remove Errors
29. Select the drop-down menu in the column for World Bank Est
30. Sort Descending (this will put the highest numbers at the top)
In the next step, I want to remove all the asterixes ( * )
We want to replace all the asterixes with the word star
31. In the Transform tab
32. Click on Replace Values (Screenshot)
33. Replace Values
34. Value To Find = * | Replace With = star
35. Select Extract
36. Text Before Delimiter
37. star
38. Press OK
39. On the Home tab
40. Select Keep Rows
41. Keep Top Rows (screenshot)
42. The 25
43. Click OK
This will keep the top 25 countries sorted by World Bank Estimate.
44. Remember to click Close & Apply, then Close & Apply (Same for the Spotify file)
Now it is creating a data model and returning you to the Power BI Desktop
45. Let's switch now into Report View
45. On the far right, you've got your Visualizations and Data
46. Select the first visualization (Stacked Bar Chart) - (For Spotify, you choose which visualisations, at least two)
47. Select the Country/Territory Table
48. Σ World Bank Est (this puts the numbers in)
49. Expand the Stacked Bar Chart (screenshot)
50. Try other Visualizations (screenshot)
Funnel
Treemap (screenshot)
If you have more than one Visualization and you select any one item, it selects it on both. Click off one of the Visualizations to insert another one, in the whitespace
If you are unsure of what a menu is called, click in the search
I was looking for 'title' here, because I wanted to change the Text of it
Page updated
Google Sites
Report abuse