In this video, Melissa introduces the updated code for Extended Date Table. The first version of this code was released back in 2020, and there have been lots of requests and updates since. Watch as Melissa showcases the latest version of this code in action.

Extended Date Table (Power Query M function) – https://bit.ly/3BNrjp4
Analyst Hub M Code Repository – https://bit.ly/3C8NJmi

***** Video Details *****
00:00 Introduction
00:46 Where to get the code
02:57 Demo of code
03:44 Parameters

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE Continue reading “Introducing The Extended Date Table 2.0 – Power Query M Function” →

Enterprise DNA Challenge 22 has officially closed! Congratulations to all winners and participants, you have done excellently well! We at Enterprise DNA thank you for your efforts and dedication.

The participants were asked to prepare a deep-dive analysis on a hotel revenue management dataset to provide insights that can be utilized to make better decisions in regards to pricing, marketing, and distribution strategies.

In this video, watch as our panel of judges consisting of Enterprise DNA Experts Brian Julius, Federico Pastor, Jarrett Moore and Heather Rowe share their insights and the key factors in choosing the winning entries.

Check out more of the Continue reading “Enterprise DNA Challenge 22 Judging Of Entries – Hotel Revenue Management Data Analysis” →

Do you know what design psychology is? Thomas Watkins describes it as taking what we know about psychology and applying it to technology. Incorporating our knowledge of sensory perception and cognition into the product in order to ensure that it resonates with users.

In this episode of the podcast, Sam McKay speaks with Thomas Watkins about design psychology and how it can be incorporated into techniques and frameworks in Power BI.

Thomas Watkins is a thought leader, speaker, and industry practitioner located in Houston TX. He is a life-long learner who has a passion for bringing greater clarity to the Continue reading “Design Psychology in Data Visualization with Thomas Watkins” →

In today’s video, Brian continues his discussion of “speed build” techniques for creating great-looking custom visuals incredibly quickly.

While the first video focused on SVG visuals, the technique discussed today involves the use of R visuals, specifically the GGPUBR package, which can be used to create complex visuals difficult to do in any other way, using just a single simple line of R code.

***** Video Details *****
00:00 Introduction
02:29 R packages
04:41 Data set
06:25 Box plot 1
11:18 Box plot 2
11:58 Histogram 1
13:20 Histogram 2
13:57 Histogram 23
14:44 Q-Q plot

***** Related Links *****
How To Quickly Add Dynamic SVG Visuals To Your Power BI Continue reading “How To Create Complex Visuals In Power BI With A Single Line Of Code Using R” →

In this tutorial, Sam demonstrates how you can use the DATEADD function — likely the most versatile time intelligence function in DAX. See how you can apply this to complete a huge range of time related calculations in your analysis.

***** Video Details *****
00:00 Introduction
00:54 Creating A Table With Total Sales Measure
01:36 Comparing Current Sales With Sales Last Year Using DATEADD Function
03:21 Other Time Periods That Can Be Used For Comparison
04:15 Calculating The Difference In Sales
05:24 Other Calculations To Branch Into Using DATEADD Function

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>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 – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #TimeIntelligence