Introducing The Extended Date Table 2.0 – Power Query M Function

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”

An eDNA Tools Lifecycle Approach To DAX Coding | Innovation Labs #2 Session 8

REPLAYS & RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/innovation-lab/

Session 8: An eDNA Tools Lifecycle Approach To DAX Coding

When is it?
August 3rd – 2pm Los Angeles (PDT), 5pm New York (EDT), 10pm London (BST)
August 4th – 7am Sydney (AEST), 9am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Brian Julius – Chief Content Officer, Enterprise DNA

During This Member-Only Training, You Will Learn:

• Use the Pareto Principle effectively to accelerate and simplify your DAX learning
• Leverage the eDNA Community to speed your DAX coding
• Templatize your Continue reading “An eDNA Tools Lifecycle Approach To DAX Coding | Innovation Labs #2 Session 8”

Enterprise DNA Challenge 22 Judging Of Entries – Hotel Revenue Management Data Analysis

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”

Answering your questions about the new App Experience!

So many questions about the new Power BI App experience! Going through a few of the themes that came out of last week’s video to get you some answers! What other questions do you have that weren’t covered?

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Apps #GuyInACube

Design Psychology in Data Visualization with Thomas Watkins

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”

Storytelling with Power BI and PowerPoint

Give up those static images of your reports in PowerPoint! Learn how to integrate your Power BI report to help tell your story directly within PowerPoint!

Tell a story with your data. Announcing the all-new Power BI integration for PowerPoint
https://powerbi.microsoft.com/blog/tell-a-story-with-your-data-announcing-the-all-new-power-bi-integration-for-powerpoint/

About Power BI in PowerPoint
https://docs.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-about

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
Continue reading “Storytelling with Power BI and PowerPoint”

How To Create Complex Visuals In Power BI With A Single Line Of Code Using R

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”

Talking DATA end to end with Buck Woody

Where does your data come from? What do you need to consider with your data? Buck Woody explored the world of data and how services like Azure Synapse Analytics and Power BI can help you in your journey!

Connect with Buck:
https://twitter.com/BuckWoodyMSFT
https://www.linkedin.com/in/buckwoody/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
rel=”nofollow”>http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#AzureSynapse #PowerBI #GuyInACube

The DATEADD Function – The Best and Most Versatile Time Intelligence Function In DAX [2022 Update]

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

Why We Love Dataflows In Power BI And Why You Should To

In this video, Sam is going to talk about something that he thinks has become a key feature in a successful organisation-wide implementation of Power BI — dataflows.

***** Video Details *****
00:00 Introduction
00:55 What is a dataflow
02:37 Creating dates table
05:14 Queries
08:14 Connecting dataflows to workspaces
08:54 Dedicated workspaces

***** 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 – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – rel=”nofollow”>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

🔴 Power Platform Conference LIVE!!! (Sept 21, 2022)

Join us live as we talk Power BI from the Power Platform Conference in Orlando, Florida! We are bound to have a special guest or two and hopefully a live audience.

Power Platform Conference: https://powerplatformconf.com

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

http://twitter.com/guyinacube
http://twitter.com/awsaxton
http://twitter.com/patrickdba
http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Continue reading “🔴 Power Platform Conference LIVE!!! (Sept 21, 2022)”

🔴 Power BI tips from the Pros – LIVE (Sept 17, 2022) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (Sept 17, 2022) (Member Chat 2nd Half)”