Who Are The Lost Customers – Advanced Analytics With Power BI & DAX


When implementing churn analytics inside a Power BI, sometimes you can want to take the analysis even further. In this tutorial, I run through how you can not only work out how many customers are considered lost but also who are these particular lost customers.

This is really powerful stuff if you are looking to make sure your sales resources and marketing efforts are going to the right areas. Where you feel you can generate the best returns.

There’s plenty of great practical applications to this technique. Good luck getting these ideas into your own models.

Sam

*****Video Details*****
0:18 – Introduction
2:25 – How To Create Attrition Analysis Report
4:10 – Using CALCULATETABLE
6:00 – Using The EXCEPT Function
6:26 – Showing Lost Revenue From Lost Customers
9:21 – Conclusion

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Discover How Many Sales Can Be Attributed To New Customers – Advanced Power BI Insights
https://blog.enterprisedna.co/2018/11/06/discover-how-many-sales-can-be-attributed-to-new-customers-advanced-power-bi-insights/
New vs Existing Customers – Advanced Analytics w/DAX
https://blog.enterprisedna.co/2018/01/24/new-vs-existing-customers-advanced-analytics-w-dax/
Counting Customers Over Time – DAX Example in Power BI
https://blog.enterprisedna.co/2017/11/27/counting-customers-over-time-dax-example-in-power-bi/

***** Related Course Modules *****
Advanced Analytics
http://portal.enterprisedna.co/p/advanced-analytics
Business Analytics
http://portal.enterprisedna.co/p/business-analytics-series
Unique Analytical Scenarios
http://portal.enterprisedna.co/p/unique-analytical-scenarios

***** Related Support Forums *****
Lost Customers Measure
https://forum.enterprisedna.co/t/lost-customers-measure/1039
Lost Customers Calculation
https://forum.enterprisedna.co/t/lost-customers-calculation/1345
Lost/New Customers Each Year-Month
https://forum.enterprisedna.co/t/lost-new-customers-each-year-month/2864
For more attrition analysis queries to review see here…..
https://forum.enterprisedna.co/search?q=lost%20customers