Setup
1. Register for the lab and receive your credentials at https://www.power-labs.org/access/. Use the "Event code" provided by the lab facilitator. Make sure you are familiar with the Terms of Use and Privacy Policy of PowerLabs.
2. Log in into https://app.powerbi.com using the credentials received in email. These credentials will last 10 days.
Load Data
3. Download 3 csv file to your desktop from https://www.power-labs.org/lab_files.zip
4. Open Power BI Desktop
5. Go to Home -> Get data -> Text/CSV
6. Choose ""covid_case_and_death.csv"" and click OK
7. Select "Transform Data"
8. Click Table options -> Use First Row as Header
9. Click "Close & Apply"
10. Go to Table view to check the newly loaded table
11. Stop and Watch the WRONG way of creating report
Transform Data
12. Go to Home -> Transform data
13. Hold Ctrl button and select both "iso_code" and "Value" columns
14. Go to Transform -> Unpivot Columns -> Unpivot Other Columns
15. Select "Attribute" column and Click on "ABC" icon to change the column type to "Date"
16. Select "Value" column
17. Go to Transform -> Pivot Column, and Choose "Value.1" in Values Column
18. Double click "Attribute" column and change name to "Month"
19. Go to Home -> "Close & Apply"
Create Report Part 1
20. Choose Visualizations -> Stacked column chart
21. Click "Total Death" and Click "Month"
22. Go to Data pane, right click the table, and choose "New measure"
23. In the formular bar enter: Death = SUM(covid_case_and_death[Total Death])
24. Go to Data pane, right click the table, and choose "New measure"
25. In the formular bar enter: Cases = sum(covid_case_and_death[New Cases])
Create Data Model
26. Go to Home -> Transform data
27. Go to Home -> New Source -> Text/CSV
28. Choose "country_codes.csv" and click OK
29. Click Table options -> Use First Row as Header
30. Go to Home -> "Close & Apply"
31. Go to Model view
32. Double click the connecting line between the tables, observe the selections and click OK
Create Report Part 2
33. Go to Report view
34. Choose Visualizations -> Slicer
35. Click continent and location to create the dropdown slicer
36. Try different selections with the slicer
37. Try holding Ctrl to select multiple values
38. Drag and drop "location" into Filters -> Filters on all pages
39. Choose "Select all" and Deselect "(blank)"
40. Choose Visualizations -> ArcGIS Maps
41. Drag and drop Cases into Size field; Drag and drop location into Location field
Save, Publish and Share
42. Go to File -> Save As to save the report
43. Click "Sign in" at the top right corner
44. Go to Home -> Publish
45. Select My Workspace (or a standard workspace if available)
46. Wait for the Publishing Screen to say Success and Click the Open report link
47. Select "Share" at the top of the report page
48. Select "Specific people" and untick "Allow recipients to share..." -> Apply
49. Enter the names or email address of people you want to share with and select "Copy link"