1 - The Who, What, and Why (67.61 MB)
2 - Course outline (16.08 MB)
3 - Install Power BI Desktop (40.7 MB)
4 - First look at Power BI (22.96 MB)
5 - Get course material (22.52 MB)
1 - Context modifier - ALL (74.81 MB)
10 - Solution for TRY IT - Mutual Fund Sales (93.66 MB)
11 - DAX variables (55.5 MB)
12 - DAX Variables in Calculated Columns (73.6 MB)
2 - Context modifier - ALLEXCEPT (51.7 MB)
3 - Context modifier - REMOVEFILTERS (36.54 MB)
4 - Get filter context with SELECTEDVALUE (26.91 MB)
5 - Concatenate Texts (33.6 MB)
6 - Split Texts (82.37 MB)
7 - Replace Texts (23.05 MB)
8 - Text Transformation - UPPER, LOWER, TRIM (46.5 MB)
9 - TRY IT - Mutual Fund Sales (21.15 MB)
1 - To offer a real life experience (18.69 MB)
10 - Let there be styles (339.86 MB)
11 - Look on my work, ye mighty (94.21 MB)
2 - More, we want more! (14.58 MB)
3 - Planning the dashboard (59.2 MB)
4 - Import data (147.87 MB)
5 - First we work on the summaries (154.18 MB)
6 - Make spendings shine (153.79 MB)
7 - Time series spending and income (47.77 MB)
8 - Then we praise the income (112.11 MB)
9 - There shall be details (103.93 MB)
1 - Combo charts (Bar + Line) (46.31 MB)
10 - Advanced Bookmarks (95.57 MB)
11 - Understand visual interactions (86.72 MB)
12 - Edit visual interactions (86.14 MB)
13 - Third-party visuals (45.14 MB)
14 - Using a third-party visual (64.84 MB)
2 - Pivot Tables (36.78 MB)
3 - Advanced Pivot Tables (101.1 MB)
4 - Treemaps (37.65 MB)
5 - Advanced Treemaps (61.03 MB)
6 - Waterfall charts (27.17 MB)
7 - Resize Canvas (56.37 MB)
8 - Slicers and how to use them (78.55 MB)
9 - Bookmarks for state control (36.39 MB)
1 - A song of context filters (114.27 MB)
10 - Time intelligence functions (127.98 MB)
11 - Time Intelligence - Dynamic Time Periods (131.74 MB)
12 - DAX formatter (24.34 MB)
13 - Running totalsgroup totals (68.53 MB)
2 - CALCULATE filters in-depth (67.18 MB)
3 - Handle missing values (36.25 MB)
4 - Handle error values (47.38 MB)
5 - Handle row counting (21.62 MB)
6 - Master aggregation with SUMMARIZE (144 MB)
7 - Time intelligence - YTD, MTD (88.86 MB)
8 - Time intelligence - year-over-year calculations (88.17 MB)
9 - Time Intelligence with a Date Table (69.59 MB)
1 - Project introduction (18.72 MB)
10 - Add breakdown charts (175.94 MB)
11 - Oh no! Redesign the cards (252.56 MB)
12 - Add breakdown charts (74.08 MB)
13 - OMG, everything is on fire! (145.07 MB)
2 - The request (21.94 MB)
3 - Plan the dashboard (49.55 MB)
4 - Establish Data Model (68.38 MB)
5 - Build Time-intelligence measures (180.91 MB)
6 - All-in on summary cards (154.16 MB)
7 - Ring chart, map, and bar charts (82.03 MB)
8 - Dynamic measures sales, withdrawals, net sales (159.66 MB)
9 - Wealth page title and cards (112.19 MB)
1 - Overview (4.55 MB)
2 - Introduction to PowerBI Table View (70.69 MB)
3 - Enter data (21.72 MB)
4 - Read Excel (28.22 MB)
5 - Read CSV (25.95 MB)
6 - TRY IT (4.52 MB)
7 - TRY IT - solution (51.45 MB)
1 - Introduction (26.31 MB)
2 - Numbers (66.32 MB)
3 - Texts (43.42 MB)
4 - Dates (57.66 MB)
5 - Booleans and blanks (41.21 MB)
1 - Overview of visuals (56.5 MB)
10 - TRY IT fun with visuals (13.85 MB)
11 - Solution for TRY IT fun with visuals (144.33 MB)
2 - Visual editor interface (60.3 MB)
3 - Bar chart (59.12 MB)
4 - Line chart (101.34 MB)
5 - Pie chart (67.25 MB)
6 - Understand chart data (38.39 MB)
7 - Filter chart data (49.88 MB)
8 - Card visual (32.85 MB)
9 - Table visual (71.37 MB)
1 - (Optional) download your own spending data (88.86 MB)
2 - Visualize the expenditures (148.49 MB)
3 - Analyze insights from the data (160.26 MB)
1 - Overview of DAX (31.02 MB)
10 - Aggregate dates (41.81 MB)
11 - Conditional functions - if, else (36.69 MB)
12 - Conditional functions - switch (77.06 MB)
13 - Compare values (30.73 MB)
14 - CALCULATE syntax (38.04 MB)
15 - CALCULATE with filters (45.37 MB)
16 - Understand more about CALCULATE (49.57 MB)
17 - Implicit contexts in visuals (29.22 MB)
2 - Try your first DAX (37.32 MB)
3 - Define measures (70.49 MB)
4 - Calculation context (38.64 MB)
5 - Understand DAX in visuals (40.47 MB)
6 - Rename and delete measures and columns (45.51 MB)
7 - Aggregate values (10.25 MB)
8 - Aggregate numbers - sum, mean (32.21 MB)
9 - Aggregate texts - min, max, count (62.3 MB)
1 - Put power in your queries (38.41 MB)
10 - Filter rows, but tricky (89.02 MB)
11 - TRY Clean data with filter and remove (19.91 MB)
12 - SOLUTION Clean data with filter and remove (47 MB)
13 - Convert data types (66.68 MB)
14 - Fix common errors in Power Query (114.27 MB)
15 - Best practice do it in Power Query or DAX (39.6 MB)
16 - TRY Transform the perosnal finance data (29.96 MB)
17 - SOLUTION Transform the perosnal finance data (81.43 MB)
2 - Overview of Power Query editor (31.74 MB)
3 - Remove rows overview (24.87 MB)
4 - Remove top rows (47.99 MB)
5 - Remove bottom alternate and empty rows (39.85 MB)
6 - Remove duplicated rows (46.84 MB)
7 - Remove & rename columns (17.6 MB)
8 - Replace values (41.99 MB)
9 - Filter rows (54.09 MB)
1 - You got a new request! (33.64 MB)
2 - Let's plan the dashboard (19.23 MB)
3 - Import data (47.34 MB)
4 - Build visuals (236.85 MB)
5 - Validate data (61.15 MB)
6 - Style the visuals (95.24 MB)
1 - Why do we need data models (25.95 MB)
10 - Master relationships with RELATED (41.56 MB)
11 - Master relationships with USERELATION (62.77 MB)
12 - Master relationships with CROSSFILTER (71.2 MB)
13 - TRY IT - Connect the tables (13.12 MB)
14 - Solution for TRY IT - Connect the tables (58.27 MB)
2 - Relationship as filters (39.31 MB)
3 - Directional relationship (35.56 MB)
4 - One-one, one-many, many-many (14.45 MB)
5 - Active and inactive relationships (31.76 MB)
6 - Configure relationships (65.46 MB)
7 - Organize data as One Big Table (34.56 MB)
8 - Organize table as Star Schema (53.79 MB)
9 - Best Practices in using One Big Table vs Star Schema (20.29 MB)