Category: Power BI

‘What If’ Sensitivity Analysis In Power BI Using DAX – Advanced Technique [2022 Update]

Posted on by Annie D

In this video, Sam how you can runs a scenario analysis not just to find binary outcomes, but running advanced sensitivity analysis across all potential ’What If’ outcomes. There are seriously so many ways this can be implemented and execute across a range of data scenarios. Watch and learn to see how you can apply this.

***** Video Details *****
00:00 Introduction
01:22 Optimising Scenarios
04:01 Running Sensitivity Analysis
06:46 Other Elements For Further Analysis
07:48 Conclusion

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

A Power Query feature you may not know about!

Posted on by Annie D

We thought everyone knew about this Power Query capability! At the Power Platform Conference, we found that many did not. Well, we want to help make sure everyone is aware so that you can reuse your awesome Power Query work in Power BI or Excel!

📢 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
— Continue reading “A Power Query feature you may not know about!” →

How To Use COALESCE In Power Query / M

Posted on by Annie D

In this video, Melissa will demonstrate how to implement the Power Query/M Language operator, COALESCE, by examining two practical problems. The goal is to filter our all strings that don’t consist of two words.

***** Video Details *****
00:00 Introduction
01:27 Example 1
04:00 Example 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 DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – Continue reading “How To Use COALESCE In Power Query / M” →

Where do you add that new column in any analytics tool?

Posted on by Annie D

You need to add a new column in Power BI – or any business analytics tool. Where do you add the column? Is there a cost to that? Matthew Roche explains his thoughts on his maxim that has everyone talking!

Connect with Matthew Roche
Twitter: https://twitter.com/SQLAllFather
LinkedIn: https://www.linkedin.com/in/matthewroche/
Blog: https://ssbipolar.com/

Roche’s Maxim of Data Transformation
https://ssbipolar.com/2021/05/31/roches-maxim/

Matthew’s career journey:
The Unplanned Career – 25 years in tech without a 3-year plan
https://www.youtube.com/watch?v=CKOAIp9TTvQ

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

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

Want to take your Power BI skills to the next level? We have training courses Continue reading “Where do you add that new column in any analytics tool?” →

Enterprise DNA Challenge Speed Build | Power Platform Innovation Labs Session 8

Posted on by Annie D

Session 8: Enterprise DNA Challenge Speed Build

When is it?
October 5th – 7pm Los Angeles (PDT), 10pm New York (EDT)
October 6th – 1pm Sydney (AEDT), 3pm 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 Sam McKay, CEO & Founder of Enterprise DNA

During This Free Training, You Will Learn:

• Watch live as we work through a real world challenge submission
• Learn speed techniques for Power BI development
• Learn how to use templates for every part of your Power BI report building workflow
• Create compelling Power BI Continue reading “Enterprise DNA Challenge Speed Build | Power Platform Innovation Labs Session 8” →

The Oft-Overlooked Pillar Of Effective Power BI Reporting | Power Platform Innovation Labs Session 7

Posted on by Annie D

Session 7: The Oft-Overlooked Pillar Of Effective Power BI Reporting

When is it?
October 5th – 2pm Los Angeles (PDT), 5pm New York (EDT),
10pm London (BST)
October 6th – 8am Sydney (AEDT), 10am 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 Brian Julius – Chief Content Officer, Enterprise DNA

During This Free Training, You Will Learn:

• What is a Data Analysis Plan?

• Where does it fit in the Power BI development framework?

• What are the benefits of Exploratory Data Analysis and Analysis Planning?

• How do we effectively Continue reading “The Oft-Overlooked Pillar Of Effective Power BI Reporting | Power Platform Innovation Labs Session 7” →

Report Winners – Tips & Tricks | Power Platform Innovation Labs Session 6

Posted on by Annie D

Session 6: Report Winners – Tips & Tricks

When is it?
October 5th – 11am Los Angeles (PDT), 2pm New York (EDT), 7pm London (BST)
October 6th – 5am Sydney (AEDT), 7am 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 Federico Pastor – Head of Data Challenges, Enterprise DNA and the Challenge 22 Winners

During This Free Training, You Will Learn:

• Real-world focused techniques will be showcased by the best talents in eDNA Challenges
• Learn the core areas of the winning entries around the Power BI report development
• Continue reading “Report Winners – Tips & Tricks | Power Platform Innovation Labs Session 6” →

Save early, save often in Azure Synapse Studio

Posted on by Annie D

We’ve all been there. You are in your zone and working hard. Then something happens and you lose everything! Patrick talks about ways to maintain your hard work in Azure Synapse Studio.

📢 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 Continue reading “Save early, save often in Azure Synapse Studio” →

How To Create External Tools For Power BI (Part 3) | Power Platform Innovation Labs Session 3

Posted on by Annie D

Session 3: How To Create External Tools For Power BI (Part 3)

When is it?
October 4th – 4pm Los Angeles (PDT), 7pm New York (EDT), 11pm London (BST)
October 5th – 10am Sydney (AEDT), 12pm 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 Greg Deckler (MVP) – VP at Fusion Alliance, MVP & Author of 4 Power BI Books

During This Free Training, You Will Learn:

• Learn the external tools to generate the Enterprise DNA extended date table such as Holidays, Intelligence Measures, & Set Sort By
• Continue reading “How To Create External Tools For Power BI (Part 3) | Power Platform Innovation Labs Session 3” →

Elevate Your Power Apps Design | Power Platform Innovation Labs Session 2

Posted on by Annie D

Session 2: Elevate Your Power Apps Design

When is it?
October 4th – 3pm Los Angeles (PDT), 6pm New York (EDT)
October 5th – 9am Sydney (AEDT), 11am 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 Mudassir Ali – Enterprise DNA Lead for Special Projects

During This Free Training, You Will Learn:

• Learn how to integrate Power Apps with Figma
• Know the limitations of Figma in Power Apps
• Explore how HTML & CSS is being used for dynamic styling

If you have questions regarding this training, please send it Continue reading “Elevate Your Power Apps Design | Power Platform Innovation Labs Session 2” →

Complete Power BI Architecture Overview | Power Platform Innovation Labs Session 1

Posted on by Annie D

Session 1: Complete Power BI Architecture Overview

When is it?
October 4th – 1pm Los Angeles (PDT), 4pm New York (EDT), 9pm London (BST)
October 5th – 7am Sydney (AEDT), 9am 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 Sam McKay, CEO & Founder of Enterprise DNA

During This Free Training, You Will Learn:

• How to architect your Power BI workspaces
• Using Dataflows to the max to scale your data pipeline
• How to decide what should go into different reports and datasets
• How to optimize for scale Continue reading “Complete Power BI Architecture Overview | Power Platform Innovation Labs Session 1” →

Building Simple Enterprise Applications | Power Platform Innovation Labs Session 5

Posted on by Annie D

Session 5: Building Simple Enterprise Applications

When is it?
October 4th – 7pm Los Angeles (PDT), 10pm New York (EDT)
October 5th – 1pm Sydney (AEDT), 3pm 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 Sam McKay, CEO & Founder of Enterprise DNA

During This Free Training, You Will Learn:

• How to use Sharepoint to build very quick Power Apps
• How to build Power BI reports around your Power Apps
• Introducing Power Automate into your development to remove manual processes
• How to plan out your enterprise applications before Continue reading “Building Simple Enterprise Applications | Power Platform Innovation Labs Session 5” →