Category: Power BI

Sampling Techniques With Python | Power Platform Innovation Labs Session 4

Posted on by Annie D

Session 4: Sampling Techniques With Python

When is it?
October 4th – 6pm Los Angeles (PDT), 9pm New York (EDT)
October 5th – 12pm Sydney (AEDT), 2pm Auckland (NZDT)

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 Gaelim Holland, Enterprise DNA Expert

During This Free Training, You Will Learn:

• Understand the concept of Population and Sample with Python
• Know the different types of Sampling in Python
• Discover the Probability Sampling Techniques within your data using Python
• Learn more about the use of Probability Vs. Non-Probability Sampling

If you have questions regarding Continue reading “Sampling Techniques With Python | Power Platform Innovation Labs Session 4” →

How To Reference Tables In Power Query For Improved Refresh Time & Data Performance

Posted on by Annie D

In this tutorial, Jarrett is going to show how you can reference tables in Power Query to improve your refresh time as well as data performance inside your model.

***** Video Details *****
00:00 Introduction
01:07 Data tables
04:30 Referencing tables
05:40 JobMGMT
06:10 Log Notes
06:44 GLBalanceByDay
07:18 Disabling load
08:24 Performance before and after

***** 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 – <a href="https://www.enterprisedna.co/dax-formula-reference-guide-download/" Continue reading “How To Reference Tables In Power Query For Improved Refresh Time & Data Performance” →

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

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

Answering your questions about the new App Experience!

Posted on by Annie D

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