Category: Power BI

Taking On Excel BI’s Stacked To Ordered Power Query Challenge

Posted on by Annie D

In this video, Melissa demonstrates her approach in solving Excel BI’s Stacked To Ordered Power Query Challenge. The objective for this challenge is transform a stacked data into a tabular format with the results showcased in a descending order.

Excel BI’s Stacked To Ordered Challenge: https://bit.ly/3SRptdB

***** Video Details *****
00:00 Introduction
00:51 Creating lists
01:18 Drill-down
01:27 Splitting lists
02:04 Assigning field names
02:47 Transforming into tabular format
03:16 Table.AddRankColumn
04:44 Reordering columns

***** 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 Continue reading “Taking On Excel BI’s Stacked To Ordered Power Query Challenge” →

How To Export All DAX Measures Into A Single File

Posted on by Annie D

In this tutorial, Brian is going to run through how you can export all of your DAX measures into a single file. This is a cool technique that you may find useful for documentation and education purposes.

***** Video Details *****
00:00 Introduction
01:14 Blanket formatting
02:08 Results
02:14 DMV
02:35 Exporting file

***** 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 #DAX #DAXTutorial

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

Posted on by Annie D

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 (Nov 5, 2022) (Member Chat 2nd Half)” →

Bring Power BI and Excel together

Posted on by Annie D

STOP defaulting to exporting your Power BI data to Excel! Adam shows you options you can use within Power BI to still work with your data in Excel if that’s what you are comfortable with.

📢 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 Continue reading “Bring Power BI and Excel together” →

In-Depth Customer Churning Examples In Power BI Using DAX [2022 Update]

Posted on by Annie D

In this tutorial, Sam takes a look at some customer churning, lost customers and new customers examples with DAX. This is not the easiest task and you need to understand a lot of concepts before you get to this point. By using a combination of many DAX functions, you can achieve amazing things and here is one example that really showcases that.

***** Video Details *****
00:00 Introduction
02:44 Lost Customers
05:40 New Customers
07:08 Returning Customers
09:02 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 “In-Depth Customer Churning Examples In Power BI Using DAX [2022 Update]” →

The PERFECT Power BI dataflows use case

Posted on by Annie D

We get a lot of questions about Power BI dataflows and when to use them. Patrick explores a use case that screams for using dataflows! Are you taking this approach?

📢 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 “The PERFECT Power BI dataflows use case” →

Enterprise DNA Challenge 23 Judging Of Entries & Winners – Substance Abuse Data Analysis

Posted on by Annie D

Enterprise DNA Challenge 23 has officially closed! We’ve received a record-breaking 154 entries. Congratulations and a big thanks to all winners and participants of this challenge!

The participants were asked to work on a substance abuse dataset. Substance abuse is one aspect of healthcare analytics that haven’t been fully explored. Healthcare providers can leverage the data on their hands to fight substance addiction.

In this video, watch as our panel of judges consisting of Enterprise DNA Experts Brian Julius and Federico Pastor, Microsoft MVP, Greg Deckler, and Founder of Data Ideas, Dustin Schimek, share their insights and the key factors in choosing Continue reading “Enterprise DNA Challenge 23 Judging Of Entries & Winners – Substance Abuse Data Analysis” →

Explaining what a Lakehouse is!

Posted on by Annie D

You’ve probably heard the term lakehouse with various services like Azure Synapse Analytics. But what actually is a lakehouse? And why is it different from a data warehouse?

📢 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 – rel=”nofollow”>https://guyinacube.com/tools/

#PowerBI #GuyInACube

How To Use Natural Language Query (Q&A) In Power BI – Detailed Review [2022 Update]

Posted on by Annie D

The Natural Language Query (Q&A) feature is an incredible evolution in data analytics and its functionality within Power BI is amazing.

In this video, Sam showcases what you can achieve and how you can practically use Q&A within your organizations. The Q&A feature is the real deal and is not just some marketing hype. All it takes is developing great Power BI models and then knowing how to effectively use it.

***** Video Details *****
00:00 Introduction
04:12 Working with measure tables
05:15 Using selections in combination with Q&A
06:20 Recreating reports with advanced DAX formulas
08:57 Using Q&A to get information quickly

***** Learning Power BI? ***** Continue reading “How To Use Natural Language Query (Q&A) In Power BI – Detailed Review [2022 Update]” →

How To Add Comments To A Power Automate Desktop Flow

Posted on by Annie D

In today’s tutorial, Jarrett shows how you can add comments to a Power Automate Desktop flow. It might be a simple concept but here is a little bit of a process in order to do this because there’s no feature in how Power Automate is currently setup that enables you to add comments to your flow steps. This technique is going to come in handy when you need to leave an audit trail for a smooth onboarding or transition in case you need to turnover the flow to someone else in your organization.

***** Video Details *****
00:00 Introduction
01:23 Example scenarios
03:30 Flow Continue reading “How To Add Comments To A Power Automate Desktop Flow” →

Taking On Excel BI’s Alphabets To Columns Power Query Challenge

Posted on by Annie D

In this video, Melissa shares her solution for the Excel BI’s Alphabets to Columns Challenge. The task is to turn the single column table into a table where each letter has its own column, and is repeated as many times as it’s present in the source table as well.

Excel BI Power Query Challenge 3: https://bit.ly/3NeKw8y

***** Video Details *****
00:00 Introduction
01:33 Creating variables
05:15 Bill’s solution

***** 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 – Continue reading “Taking On Excel BI’s Alphabets To Columns Power Query Challenge” →

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

Posted on by Annie D

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 (Oct 29, 2022) (Member Chat 2nd Half)” →