Month: September 2022

🔴 Power BI tips from the Pros – LIVE w/ Kasper de Jonge (Oct 1, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI! With special guest, Kasper de Jonge!

Connect with Kasper:
Website: https://www.kasperonbi.com/
YouTube: https://www.youtube.com/channel/UC40_DLjKbvxkhMc7N4UevkA
Twitter: https://twitter.com/kjonge

📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE w/ Kasper de Jonge (Oct 1, 2022) (Member Chat 2nd Half)” →

Layering Multiple ‘What If’ Scenarios In Power BI – Advanced DAX Concepts [2022 Update]

Posted on by Annie D

In this video, Sam showcases a technique that demonstrates the immense analytical power of Power BI and specifically DAX. Here, he shows how to generate multiple ‘what if’ scenarios layered on top of each other. There are many ways that this technique can be of use in various business function or industry that makes this a handy skill in your toolkit.

***** Video Details *****
00:00 Introduction
01:32 Working with three scenarios
03:07 Using HASONEVALUE
04:00 Scenario profits using SUMX
07:06 Arriving at cumulative results

***** 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

Do you even need to use Power Query Functions?

Posted on by Annie D

You can do amazing things in Power Query! Maybe you think to create a function. But do you really need a function for that? Or is it over complicating things?

📢 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***
🛠 Check out my Tools page – <a Continue reading “Do you even need to use Power Query Functions?” →

How To Guarantee Sort Order In DAX — Yes You Can!

Posted on by Annie D

In this tutorial, Greg is going to demonstrate how you can achieve a guaranteed sort order in DAX. You might encounter numerous claims that DAX cannot do such a thing, but Greg will show you otherwise in a fairly simple approach.

***** Video Details *****
00:00 Introduction
01:00 Data model
01:36 Walkthrough of Measure 3
03:45 Walkthrough of Measure 2

***** 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 Continue reading “How To Guarantee Sort Order In DAX — Yes You Can!” →

Rounding out the lakehouse with the GOLD layer in Azure Synapse

Posted on by Annie D

We are completing the journey of our lakehouse with our GOLD layer in Azure Synapse. This gives you the table structures you need to start building those amazing reports in Power BI!

Stijn Wynants
https://twitter.com/SQLStijn

📢 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***
🛠 Check Continue reading “Rounding out the lakehouse with the GOLD layer in Azure Synapse” →

Complex ‘What If’ Analysis Example In Power BI Using DAX [2022 Update]

Posted on by Annie D

In this video, Sam showcases a few things that you can learn from a complex ‘What If’ analysis scenario. Sam covers a range of DAX and Power BI techniques, and shows you how you can layer scenarios on top of each other to see the outcome of numerous ‘What If’ that could occur in the real world.

***** Video Details *****
00:00 Introduction
02:33 Isolating products
03:22 Selected scenario sales
04:56 Non-selected scenario sales
06:00 Scenario performance

***** 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 Continue reading “Complex ‘What If’ Analysis Example In Power BI Using DAX [2022 Update]” →

Introducing The Extended Date Table 2.0 – Power Query M Function

Posted on by Annie D

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

Posted on by Annie D

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” →

Excel Habit Tracker Count Current Streak – 2517

Posted on by Annie D

How to calculate the current streak in a habit tracker.
Amreen is building a habit tracker in Excel. For each goal, he wants to report the current streak.
I show how to use XMATCH to solve this problem.

Table of Contents()
(0:00) The goal
(0:40) XMATCH formula for last 1
(1:08) Last zero
(1:29) No streak?
(1:45) How long is streak?
(2:30) Episode 735 for longest streak
(3:05) Converting to checkmarks
(4:32) Colors in Excel number format

Busn 218 – Advanced Excel – Fall 2022 Quarter Introductory Video

Posted on by Annie D

Busn 218, Advanced Excel class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in fall quarter, 2022.
To watch at YouTube here is the playlist:
https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

Excel Statistical Analysis for Business – Busn 210 – Fall 2022 Quarter Introductory Video

Posted on by Annie D

Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in fall quarter, 2022.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

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

Posted on by Annie D

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” →