|
Data Visualization Workout 006 - Bookmarks & bookmark navigator
|
|
34
|
3253
|
February 2, 2024
|
|
Data Visualization Workout 007 - Revenue analysis - various functionalities
|
|
53
|
3729
|
March 22, 2024
|
|
Data Visualization Workout 008 - Financial KPIs - line chart
|
|
54
|
4056
|
March 25, 2024
|
|
NOTE: Changes in Workout Frequency
|
|
12
|
831
|
June 14, 2023
|
|
Power Query Workout 09 - Extract Part Number
|
|
16
|
1164
|
June 28, 2023
|
|
New book: The Definitive Guide to Power Query (M)
|
|
10
|
470
|
April 8, 2024
|
|
Power Query Workout 10 - Eliminate Returns
|
|
18
|
1704
|
June 8, 2023
|
|
Data Visualization Workout 012 - Scatter chart - Quadrant highlighting
|
|
43
|
2791
|
September 17, 2023
|
|
Data Visualization Workout 009 - KPIs & Targets
|
|
38
|
3748
|
March 31, 2024
|
|
Data Modelling Workout 04 - Stage-Reference-Key-Hide
|
|
19
|
1754
|
October 11, 2023
|
|
Power Query Workout 13 - Find Correct Department
|
|
12
|
902
|
June 27, 2023
|
|
Power Query Workout 08 - Irregular Data Format
|
|
10
|
1085
|
December 17, 2023
|
|
Data Visualization Workout 013 - Grouping: Top / bottom & others
|
|
37
|
3003
|
March 12, 2024
|
|
Data Visualization Workout 011 - Cost Analysis - Scenario comparision
|
|
21
|
2766
|
August 18, 2023
|
|
Power Query Workout 12 - Supplier Invoices
|
|
11
|
1212
|
June 19, 2023
|
|
DAX Workout 012 - Scatter Plot Highlighted Value
|
|
21
|
1462
|
May 30, 2023
|
|
Power Query Workout 11 - Define Segments
|
|
15
|
940
|
June 12, 2023
|
|
Data Modelling Workout 05 - Many-to-Many (Part I)
|
|
10
|
1626
|
October 11, 2023
|
|
Data Modelling Workout 06 - Many-to-Many Part II
|
|
12
|
1357
|
October 11, 2023
|
|
Power Query Workout 07 - Month - Year Forecast
|
|
13
|
1156
|
June 19, 2023
|
|
Data Visualization Workout 010 - Cost Analysis - Small Multiples
|
|
21
|
2298
|
August 14, 2023
|
|
DAX Workout 014 - Lost Customers
|
|
15
|
1311
|
May 19, 2023
|
|
Power BI Desktop July 2023 Released
|
|
13
|
1781
|
July 17, 2023
|
|
DAX Workout 015 - Calculated Counts by Time and Group
|
|
20
|
1899
|
May 23, 2023
|
|
Power Query Workout 06 - Filter Relevant Lines
|
|
10
|
1237
|
May 26, 2023
|
|
DAX Workout 013 - Calculating Processing Time in Business Days
|
|
11
|
1468
|
May 18, 2023
|
|
Excel Workout 17 - If Function!
|
|
14
|
1195
|
February 17, 2024
|
|
Deneb Workout 10 - Line Chart with Hover Highlight
|
|
19
|
1553
|
August 26, 2023
|
|
Excel Workout 21 - Index Function!
|
|
11
|
1035
|
July 15, 2023
|
|
DAX Workout 018 - Challenge: Cleaning up a Line Graph
|
|
17
|
1478
|
December 8, 2023
|
|
On duplicate rows of first column move data in other columns leaving only unique values in first column
|
|
22
|
881
|
August 1, 2023
|
|
Cannot Reply to Some Topics - Yet Again!
|
|
21
|
1062
|
November 22, 2023
|
|
Regex workout not getting 50 xp still not working (june 13) (updated on June 27)
|
|
19
|
729
|
July 14, 2023
|
|
Excel Workout 24 - Filter, Unique & Xlookup Functions (Recipe Cost Calculator)!
|
|
16
|
1325
|
August 6, 2023
|
|
DAX Workout 020 - Dynamic Titles and Subtitles
|
|
15
|
1205
|
May 30, 2023
|
|
Pivot Table in Excel to PowerBI
|
|
10
|
709
|
November 29, 2023
|
|
Excel BI Power Query Challenge Workout 077
|
|
30
|
1331
|
April 24, 2024
|
|
DAX Workout #24 - Highlighted Value in a Line Chart
|
|
10
|
1869
|
March 27, 2024
|
|
RegEx Workout 003 - Tokenization
|
|
13
|
557
|
June 8, 2023
|
|
Excel Workout 16 - Ifs, Sumif/s, Countif, Averageif & Round Functions!
|
|
15
|
1559
|
November 19, 2023
|
|
RegEx Workout 002 - Character classes and alternatives
|
|
12
|
564
|
June 8, 2023
|
|
Improve visual in report
|
|
19
|
683
|
May 25, 2023
|
|
DAX Workout 017 - Calculating Sales for a Specific Time Period
|
|
12
|
1485
|
March 18, 2024
|
|
Visual like teams calendar in Power BI
|
|
9
|
393
|
February 6, 2024
|
|
Excel Workout 13 - Vlookup & Left Functions!
|
|
15
|
1266
|
January 25, 2024
|
|
Excel Workout 15 - Vlookup Function!
|
|
16
|
1237
|
November 20, 2023
|
|
Excel Workout 23 - INDEX Function (CEV EuroVolley Challenge)!
|
|
20
|
1307
|
August 6, 2023
|
|
Excel Workout 10 - Pivot Table 2
|
|
12
|
1248
|
August 3, 2023
|
|
Count of employees with several conditions
|
|
12
|
651
|
July 17, 2023
|
|
Excel Workout 22 - IFERROR & VLOOKUP Functions!
|
|
14
|
1013
|
January 16, 2024
|