In this tutorial, Sam is going to demonstrate how you can create time based cohort insights within Power BI. You can use this strategy for whatever cohort you’re trying to devise. Cohort Analysis has been popularized by SAS applications. So, you should group your customers based on when they’re churning. You can create incredible analysis in Power BI using this technique.

*****Video Details*****
00:00 Introduction
01:02 Review on cohort analysis
02:06 Creating cohorts
04:58 Cohort Months table
07:39 Cohort analysis insights
10:14 Churning formulas and examples

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To Continue reading “Time Based Cohort Analysis – How To Setup Your Data Model In Power BI” →

Are you trying to work out trends in customer behaviour or would like to target marketing campaigns more specifically to relevant customers? In this video, Sam demonstrates how you can calculate the difference in days between purchases or events in Power BI using DAX formulas. He is going to use some advanced logic using the FILTER and CALCULATE functions.

*****Video Details*****
00:00 Introduction
02:20 Data set
03:17 Last date of purchase
05:01 Difference between purchases
09:22 Conclusion

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources Continue reading “Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX” →

Are you struggling to create a data culture in your organization that can support everyone inside the company, not just the executive? Chris Wagner, a director of data solutions at Baker Tilly, is here to help. With over two decades of experience in the data analytics space, Chris has worked with large organizations to create modernized data and analytical strategies. He will provide actionable ideas on how to build a data culture that can help individuals take their next step forward in their data career. This article will cover three focus areas of data engineering, analytics and data science, and Continue reading “Building an Inclusive Data Culture with Chris Wagner” →

You’ll most probably encounter having to reuse the same measure when working with multiple Power BI reports. In this video, Brian shares a handy trick for copying measures from one report to another. There is no direct way to do this in Power BI but this is something you can achieve using the Tabular Editor.

*****Video Details*****
00:00 Introduction
00:27 Case scenario
00:45 DAX Offsets table
01:22 Copying measures

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Continue reading “How To Bulk Copy Measures From Different Reports In Power BI” →

Running Totals is one of the most common analytical insight required when building reports or dashboards within most, if not all, organizations. In this video, Sam is going to show the simple logic required in DAX to develop visualization of this type of analysis.

*****Video Details*****
00:00 Introduction
01:42 Running total in 30 days
03:58 Running total in 90 days
04:30 DATESINPERIOD
06:17 Turning it into a visualization

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Continue reading “How To Calculate Running Totals In Power BI Using DAX” →

Dark backgrounds with light font colors make your visuals really pop, but there are a few things to consider when implementing this design format. In this video, Sam details out what to watch out for and what you need to implement to make sure your reports still stay effective.

*****Video Details*****
00:00 Introduction
01:06 Why Use Dark Backgrounds For Visuals
03:58 Conclusion

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events Continue reading “Considerations For Dark Backgrounds In Power BI Reports [2023 Update]” →