In this particular tutorial, we're going to dive into some advanced segmentation techniques. I love showcasing these ideas in power bi because it really is high-quality analysis. This example will showcase how particular customers can move from one grouping into another after a certain time-frame.
This is really great analysis because you are able to see the customers that are trending up or the customers who are trending down. This can create certain decisions inside businesses that can make a difference.
Obviously, you want to know which customers are trending highers (are moving into better groups) so that you can replicate the performance across other customers.
Within this example, I run through some advances DAX calculations. These are important to understand and start utilizing in your reports if you also want to complete some advanced analysis just like this.
Sam
*****Video Details*****
0:18 - Introduction
2:47 - Customer Group This Year Versus Last Year
4:03 - Creating The Customer Group
4:47 - DAX Formula To Show Movement Within Customer Group
8:26 - Conclusion
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Segmentation Example Using Advanced DAX in Power BI
blog.enterprisedna.co/advanced-segmentation-example-using-dax-in-power-bi/
Use DAX To Segment & Group Data In Power BI
blog.enterprisedna.co/use-dax-to-group-segment-your-data/
Group Customers Dynamically By Their Ranking w/RANKX In Power BI
blog.enterprisedna.co/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/
***** Related Course Modules *****
Advanced DAX Combinations
portal.enterprisedna.co/p/advanced-dax-combinations
Learning Summit Series
portal.enterprisedna.co/p/learning-summit-series
Advanced Analytics In Power BI
portal.enterprisedna.co/p/advanced-analytics
***** Related Support Forums *****
Customer Segmentation Not Showing Top Group
forum.enterprisedna.co/t/customer-segmentation-not-showing-top-group/1341
Customer Segmentation Pattern
forum.enterprisedna.co/t/customer-segmentation-pattern/2427
Displaying Segment Groups
forum.enterprisedna.co/t/displaying-segment-groups/2367
For more customer segmentation queries to review see here…..
forum.enterprisedna.co/search?q=customer%20segmentation
- Showcase Movement Within Custom Segments Through Time - Advanced Power BI & DAX ( Download)
- Dynamically Showcase Ranked Groups Visually Over Time In Power BI ( Download)
- Grouping Results Based On Performance vs Benchmarks - Power BI & DAX Tutorial ( Download)
- Customer Segmentation in Power BI: Top Customers and Other customers PART-2 ( Download)
- Dynamic Segmentation With Dynamic Parameters - Advanced Power BI & DAX Technique ( Download)
- How To Segment Your Data Based On Any Measure In Power BI Using DAX ( Download)
- Showcase Unique Insights Using Conditional Formatting Within Charts - Power BI Visual Tips ( Download)
- How We Built A Dynamic Learning Map Recommendation Application In Power BI ( Download)
- Examples Of Advanced DAX - (1.20) Ultimate Beginners Guide to DAX 2020 ( Download)
- Create a SHOWCASE DASHBOARD in POWER BI by following these simple and tested DESIGN PRINCIPLES! ( Download)
- Key Concepts For Iterating Functions In Power BI ( Download)
- 'What If' Parameter Feature Review - Power BI & DAX ( Download)
- Who Are The Lost Customers - Advanced Analytics With Power BI & DAX ( Download)
- Module 21 - Advanced Time Slicer ( Download)
- Where To Next - (1.21) Ultimate Beginners Guide to DAX 2020 ( Download)