172
Welcome
Download the Data
1. Introduction
2. Prerequisites
3. Power BI & Learning Outcome
4. Downloading & Installing Power BI
5. Typical Power BI Flow
6. Understanding Power BI Desktop User Interface
7. Configuring Report Page
8. Changing Canvas Background & Wallpaper
9. Introducing the dataset
10. Intro to getting data into power bi
11. Importing Data into Power Query
12. Understanding how Power Query works
13. Changing Data Types in Power Query
14. Refreshing data and re-opening Power Query
15. Reusing M Queries
16. Intro to Data Analysis and Visualization
17. Categorizing Data for Visualization
18. Intro to Reporting in Power BI Desktop
Copy of Configuring Visuals
19. Creating Visuals on Power BI Desktop
20. Intro to chart formatting
21. Common Formatting Options
22. Changing Visuals
23. Creating additional visuals
24. Intro to Visuals Field Buckets
25. Understanding the Axes and Legend
26. X axis Y axis and Legends example
27. Intro to Small Multiples
29. Small Multiples in Power BI Desktop
30. Enable Drill Down
Configuring Power BI Visuals
31. Introduction to Power BI Reporting
32. Prepare data for reporting (Add Day of Week)
33. Working with Shapes
34. Working with Text Boxes
35. Display trends with line charts
36. Visualizing Rank Changes with Ribbon Chart
37. Sorting Charts
38. Apply Gradient Conditional Formatting
39. Re-Using Charts and Editing Conditional Formatting
40. Editing Visual Interaction
41. Using Slicers
42. Synchronize Slicers
43. Intro to the Filters Pane
44. Create Top N Report
45. Bottom N Report
46. Using Tables and Matrix Table
47. Apply Conditional Formatting on Matrix
48. Basic Matrix Table Formatting
49. Using Maps
51. Creating Report Page Tooltip
52. Report Drill Through
53. Customize Drill through header text
54. Summary of reports
55. Use Decomposition Tree
56. Use AI to drill decomposition tree
57. Key Influencer Visual
58. Intro to Bookmarks and Selections
59. Implement Bookmarks
60. Using Q and A
61. Design Mobile View and prepare to publish
62. Open a Microsoft 365 Developer Account for Free Power BI License
62. Export to pdf and publish to web
Wrap up
Visualization Assignment
Zoom Class Joining Link
Download the Power BI course agenda
Week 1 files
PowerBI Day 1 Class Recording
PowerBI Day 2 Class Recording
Week 1 assignment
Week 2 Files
Week 2 Assignment
Power BI Day 3 Class Recording
PowerBI Day 4 Class Recording
Week 3 Assignment
Power BI Day 5 Class Recording
Power BI Day 6 Class Recording
PowerBI Day 7 Class Recording
Power BI Day 8 Class Recording
Download this PBIX Report
Week 5 Assignment
Power BI Day 9 Class Recording
Power BI Day 10 Class Recording
Week 6 Assignment
Power BI Day 11 Class Recording
Power BI Day 12 Class Recording
Data as the most strategic business asset
Data Story Telling and Categories of Data Analytics
Roles in Data
Tasks of data analyst
Connecting to Data Sources (Flat files)
Connecting to Data Sources (Flat files)
Evaluate and Transform Column Data Types
Applying User Friendly naming conventions to columns and queries
Applying User Friendly naming conventions to columns and queries
Combine Queries
Identifying and Creating appropriate Keys for Joins
Identifying and Creating appropriate Keys for Joins
Configure data loading
Prepare Data Reading from Microsoft Learn
Configure the Report Page
Adding Visualization items to Reports
Format and configure visuals
Week 2 Assignment
Download Day 10 PBIX
Choosing appropriate visualization types
Apply Sorting
Apply Slicing & Filtering
Read Data Modeling Modeling from Microsoft Learn
Designing a data model that uses star schema
Visualizing reports from Normalized data models
Define a relationship’s cardinality & cross filter direction
Select a Storage Mode
Resolve Data import errors
Shape & Transform Tables 2
Choose between continuous and categorical axes
Format & Configure Visuals 2
Week 6 Assignment
Mid Term Assignment
Apply and customize a theme
Use Grouping & Binning
Use AI visuals
Use the Forecast feature
Create reference lines
Edit and configure interactions between visuals
Create bookmarks
Create custom tool tips
Configure navigation
Configure Sync Slicers
Week 5 Assignment
Introduction to DAX
Create common date table
Create Calculated Tables/Columns
Create hierarchies
Implement role level security roles
Create basic measures
Relace implicit measures with explicit measures
Use CALCULATE to manipulate filters
Configure subscriptions and data alerts
Week 7 Class Files
Configure and update a workspace
Assign workspace roles
Publish, import or update assets in a workspace
Configure row level security membership
Provide access to datasets
Identify when a gateway is required
Introduction to Transact SQL
Understanding basic concept of RDBMS
Using a query to write and execute queries
Write SELECT statement for data retrieval
Understanding basic SQL Data Types and Usages
Understanding SQL Nulls
Writing queries with Scalar functions
Using aggregate functions
Using GROUP BY to combine data into groups based on common column value
Filtering groups with HAVING
Sorting Query Results with ORDER BY
Using TOP clause to limit returned rows
Using WHERE clause to filter returned rows
Using DISTINCT to eliminate duplicate rows from results
Querying multiple tables with JOINS operations
Understanding INNER JOIN, OUTER JOINS and CROSS JOIN
Writing Subqueries with SELECT statement
Inserting data into an existing table
Modifying data with UPDATE statement
Deleting data with DELETE statement
Appending data with UNION
Power BI Developer Career Talk
Sample Power BI Developer CVs
