
Introduction to the course
A discussion of the datasets used in the course
A note about this course and a little overlap with another course we offer
An explanation about this Cohort Analysis lecture and the next lecture.
Part 1 of our discussion on Cohort Analysis
Part 2 of our discussion on Cohort Analysis
Have you ever purchased something on Amazon and Amazon tells you customers always purchased these other items? That is cross-selling. We explain how to do this type of analysis using the Adventure Works database.
Clustering analysis is a way to segment or partition your data based on patterns in your data. We explain how to do simple clustering analysis in this lecture.
In this lecture we talk about one of at least two ways to do ranking, static ranking.
In this lecture we get a bit more complex and show how to do dynamic ranking, which is based on the existing filter context
In this lecture we demonstrate how to show the top N products based on ranking and using the TOPN function
Time for some ranking analysis practice
Part 1 of our discussion on attrition analysis and specifically customer attrition analysis
Part 2 of our analysis of attrition analysis
Part 1 of our discussion on using R inside Power BI
Part 2 of our discussion on using R with Power BI
Part 3 of our discussion on R integration in Power BI
A discussion of percentile analysis
A chance for a little percentile analysis practice
Part 1 of our discussion on scenario / sensitivity analysis
Part 2 of our discussion on scenario / sensitivity analysis
Scenario / sensitivity analysis practice exercise
Part 2 of our discussion on market basket analysis
Part 3 of our discussion on market basket analysis
DAX and Power BI offer a wide range of data analysis techniques. In fact, as you probably know, data analysis is at the heart of working with tools like Power BI and DAX. This is why we have created a two-course series of data analysis techniques using DAX and Power BI.
In Part 1 of this course we spend over four hours covering a wide range of very interesting topics such as anomaly detection, Key Influencer analysis, forecasting analysis, Decomposition Tree analysis, Q & A analysis and much more.
You can continue to improve your analysis skills with this 4+ hour course. We cover at least 10 more different and interesting data analysis techniques including:
Cohort Analysis
Cross-selling Analysis
Pareto Analysis
Simple Clustering Analysis
Ranking Analysis
Attrition Analysis
R Integration
Percentile Analysis
Scenario / Sensitivity Analysis
After we cover each technique, or at least most of them, you will have the opportunity to do a little practice to test, and further enforce what you have learned. This course would also be valuable for study towards the DA-100 exam.
A common question will be "is there going to be a part 3 to this series?" We have no plans for a part 3. If you would like other areas of analysis covered, let us know and we will add it to either part 1 or part 2.