Category: Power BI

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

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