|
|
01. Course Overview-.mp4
|
MP4
|
3.7 MB
|
|
|
02. A Structured Approach to Power Bi Design-.mp4
|
MP4
|
8 MB
|
|
|
03. Building a Foundation-Snorgared-SAnet.st.mp4
|
MP4
|
5.2 MB
|
|
|
04. What Is a Dimensional Model-Snorgared-SAnet.st.mp4
|
MP4
|
3.9 MB
|
|
|
05. What Does a Dimensional Model Do-Snorgared-SAnet.st.mp4
|
MP4
|
11.5 MB
|
|
|
06. The Dimensional Modelling Process-Snorgared-SAnet.st.mp4
|
MP4
|
9.6 MB
|
|
|
07. Exploring the Data-Snorgared-SAnet.st.mp4
|
MP4
|
20.4 MB
|
|
|
08. Designing the Data Model-Snorgared-SAnet.st.mp4
|
MP4
|
5 MB
|
|
|
09. Creating Dimension Tables with GROUPBY-Snorgared-SAnet.st.mp4
|
MP4
|
20.8 MB
|
|
|
10. Creating a Fact Table with SUMMARIZECOLUMNS-Snorgared-SAnet.st.mp4
|
MP4
|
14.5 MB
|
|
|
11. Creating Data Star with the Model Tool-Snorgared-SAnet.st.mp4
|
MP4
|
8.4 MB
|
|
|
12. Creating Text Columns for Data Analysis-.mp4
|
MP4
|
1.5 MB
|
|
|
13. Create Useful Columns for Analysis-Snorgared-SAnet.st.mp4
|
MP4
|
7.4 MB
|
|
|
14. Replace a String with SUBSTITUTE-Snorgared-SAnet.st.mp4
|
MP4
|
15.2 MB
|
|
|
15. Identify Text Positions with SEARCH FIND-Snorgared-SAnet.st.mp4
|
MP4
|
13.4 MB
|
|
|
16. Cut Out Text Parts with LEFT MID RIGHT-Snorgared-SAnet.st.mp4
|
MP4
|
16.6 MB
|
|
|
17. Data Cleansing with SUBSTITUTE.mp4
|
MP4
|
6.4 MB
|
|
|
18. Lookup Values with RELATED and RELATEDTABLE-Snorgared-SAnet.st.mp4
|
MP4
|
10.5 MB
|
|
|
19. Create an Aggregated Column with RELATEDTABLE-Snorgared-SAnet.st.mp4
|
MP4
|
11 MB
|
|
|
20. Join Text Strings with COMBINEVALUES-Snorgared-SAnet.st.mp4
|
MP4
|
5.4 MB
|
|
|
21. Capitalizing Text with UPPER and REPLACE-Snorgared-SAnet.st.mp4
|
MP4
|
7.3 MB
|
|
|
22. Creating Text Columns Summary-Snorgared-SAnet.st.mp4
|
MP4
|
739.5 KB
|
|
|
23. Create a Year and Month Column with FORMAT-.mp4
|
MP4
|
12.7 MB
|
|
|
24. Create Last Date in Month Columns with EOMONTH-Snorgared-SAnet.st.mp4
|
MP4
|
15.6 MB
|
|
|
25. Create the First Day of the Month with DATE-Snorgared-SAnet.st.mp4
|
MP4
|
5.8 MB
|
|
|
26. Create the First Day in the Last and Next Month with DATEADD.mp4
|
MP4
|
9 MB
|
|
|
27. Comparing American and European Options with WEEKNUM-Snorgared-SAnet.st.mp4
|
MP4
|
10 MB
|
|
|
28. Create Week Number Columns with WEEKNUM-Snorgared-SAnet.st.mp4
|
MP4
|
11 MB
|
|
|
29. Create the Last Date in a Week Column with WEEKDAY-Snorgared-SAnet.st.mp4
|
MP4
|
6.7 MB
|
|
|
30. Create the First Date in a Week Column with WEEKDAY-Snorgared-SAnet.st.mp4
|
MP4
|
5 MB
|
|
|
31. Using Calendar Columns in Data Analysis-Snorgared-SAnet.st.mp4
|
MP4
|
12.3 MB
|
|
|
32. Creating Measures with Aggregation Functions-.mp4
|
MP4
|
7.5 MB
|
|
|
33. Introducing Aggregation Functions-Snorgared-SAnet.st.mp4
|
MP4
|
12 MB
|
|
|
34. Visualizing Measures and the Filter Context-Snorgared-SAnet.st.mp4
|
MP4
|
20.8 MB
|
|
|
35. Counting Sales with SUM and COUNTROWS-Snorgared-SAnet.st.mp4
|
MP4
|
4.7 MB
|
|
|
36. Creating Measures with AVERAGE MEDIAN MIN MAX and DISTINCTCOUNT.mp4
|
MP4
|
4.9 MB
|
|
|
37. Filter Context Deep Dive-Snorgared-SAnet.st.mp4
|
MP4
|
9.7 MB
|
|
|
38. Calculate the Last Sales Date Column with an Aggregation Function.mp4
|
MP4
|
8 MB
|
|
|
39. Creating Groups Bands and Hierarchies with Conditional Values.mp4
|
MP4
|
12.1 MB
|
|
|
40. Creating Conditional Statements with SWITCH TRUE and IN.mp4
|
MP4
|
14.8 MB
|
|
|
41. Implement Business Logic with AND OR NOT.mp4
|
MP4
|
4.8 MB
|
|
|
42. Create Conditional SWITCH Statements with AND OR NOT.mp4
|
MP4
|
18.3 MB
|
|
|
43. Creating Bands and Sorting Columns-Snorgared-SAnet.st.mp4
|
MP4
|
9 MB
|
|
|
44. Introducing Expression Variables with VAR.mp4
|
MP4
|
6 MB
|
|
|
45. Ranking Products with FILTER VAR and COUNTROWS.mp4
|
MP4
|
11.4 MB
|
|
|
46. Creating Intelligent Measures with Iterating X Functions.mp4
|
MP4
|
8.1 MB
|
|
|
47. Calculating Total product Sales with SUMX and RELATEDTABLE .mp4
|
MP4
|
10.5 MB
|
|
|
48. Static Ranking with RANKX-Snorgared-SAnet.st.mp4
|
MP4
|
6.4 MB
|
|
|
49. Creating a Ranking Measure with RANKX and ALL .mp4
|
MP4
|
12.6 MB
|
|
|
50. Dynamic Ranking with RANKX and ALLSELECTED .mp4
|
MP4
|
10.7 MB
|
|
|
51. Creating a Mobile Sales Measure with SUMX and FILTER.mp4
|
MP4
|
10.3 MB
|
|
|
52. Creating a Red Product Sales Measure with VAR FILTER RELATED and SUMX.mp4
|
MP4
|
3.2 MB
|
|
|
53. Calculating Multi Item Sales with VAR FILTER and SUMX.mp4
|
MP4
|
1.7 MB
|
|
|
54. Calculating First and Latest Dates with MINX and MAXX.mp4
|
MP4
|
2.2 MB
|
|
|
55. Calculating the Sales Value Percent with ALL and DIVIDE.mp4
|
MP4
|
8.5 MB
|
|
|
56. Taking Control of the Evaluation Context with CALCULATE.mp4
|
MP4
|
5 MB
|
|
|
57. Comparing the Inner Workings of Two Expressions.mp4
|
MP4
|
5.4 MB
|
|
|
58. Introducing Calculate and Context Transition .mp4
|
MP4
|
4.1 MB
|
|
|
59. Context Transition in Action-Snorgared-SAnet.st.mp4
|
MP4
|
6.1 MB
|
|
|
60. Creating a Semi Additive Measure with CALCULATE .mp4
|
MP4
|
10.5 MB
|
|
|
61. Three Ways to Filter Semi Additive Measures with CALCULATE and FILTER.mp4
|
MP4
|
13 MB
|
|
|
62. Filtering Measures with Time Intelligence Functions.mp4
|
MP4
|
10 MB
|
|
|
63. Cumulative Year Analysis with TOTALYD and SAMEPERIODLASTYEAR.mp4
|
MP4
|
10.9 MB
|
|
|
64. Analyse Promotion Activity over Time with DATEADD.mp4
|
MP4
|
12.6 MB
|
|
|
65. Analyse Promotion Activity by Nesting DATEADD.mp4
|
MP4
|
4.7 MB
|
|
|
66. Calculate Monthly Percentage Change with PREVIOUSMONTH.mp4
|
MP4
|
9.3 MB
|
|
|
67. Calculate Moving Annual Totals with DATESINPERIOD and LASTDATE.mp4
|
MP4
|
12.2 MB
|
|
|
68. Create a Key Performance Indicator with DATESINPERIOD and LASTDATE.mp4
|
MP4
|
9.9 MB
|
|
|
69. Create Complex Attributes for RFM Analysis.mp4
|
MP4
|
4.5 MB
|
|
|
70. Calculating Seniority with CALCULATE DATEADD DATEDIFF MINX and MAXX.mp4
|
MP4
|
20 MB
|
|
|
71. Calculate Recency with CALCULATE and DATEDIFF.mp4
|
MP4
|
12.7 MB
|
|
|
72. Calculating Frequency with CALCULATE and DISTINCTCOUNT.mp4
|
MP4
|
8.6 MB
|
|
|
73. Customer Activity Measures and Multiple Filters.mp4
|
MP4
|
13.4 MB
|
|
|
74. Demo-Recency Activity and Sales Value-Snorgared-SAnet.st.mp4
|
MP4
|
7 MB
|
|
|
75. Customer Activity Measures-Snorgared-SAnet.st.mp4
|
MP4
|
21.8 MB
|
|
|
76. Module and Course Summary-Snorgared-SAnet.st.mp4
|
MP4
|
1.1 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
DAX Module 02.pbix
|
PBIX
|
3.3 MB
|
|
|
DAX Module 03 Excercises.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 04.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 05.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 06.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 07.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 08.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 09.pbix
|
PBIX
|
1.2 MB
|
|
|
DAX Module 10 Final.pbix
|
PBIX
|
1.5 MB
|
|
|
DAX Module 10.pbix
|
PBIX
|
1.1 MB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Passw0rd.png
|
PNG
|
146.2 KB
|
|
|
a-structured-approach-to-power-bi-design-slides.pdf
|
PDF
|
1.3 MB
|
|
|
create-complex-measures-for-rfm-analysis-with-calculate-slides.pdf
|
PDF
|
501.4 KB
|
|
|
creating-calendar-columns-for-data-analysis-slides.pdf
|
PDF
|
679.4 KB
|
|
|
creating-groups-bands-and-hierarchies-with-conditional-values-slides.pdf
|
PDF
|
853.9 KB
|
|
|
creating-intelligent-measures-with-iterating-x-functions-slides.pdf
|
PDF
|
1.1 MB
|
|
|
creating-measures-with-aggregation-functions-slides.pdf
|
PDF
|
638.2 KB
|
|
|
creating-text-columns-for-data-analysis-slides.pdf
|
PDF
|
1.2 MB
|
|
|
filtering-measures-with-time-intelligence-functions-slides.pdf
|
PDF
|
516.7 KB
|
|
|
m2 Dimensional Design Template.xlsx
|
XLSX
|
11.7 KB
|
|
|
taking-control-of-the-evaluation-context-with-calculate-slides.pdf
|
PDF
|
655.6 KB
|
![[ FreeCourseWeb ] Common DAX Expressions and Scenarios Power BI Playbook Tutorial](/static/img/no-torrent-image.png "[ FreeCourseWeb ] Common DAX Expressions and Scenarios Power BI Playbook Tutorial")
