Month: November 2022

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

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

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

Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx
Learn how to use LAMBDA, BYROW and MAP functions to build a custom function to spill a column of commission amounts for each sales rep. Learn how to deal with different sized iterating arrays in single formula by using two LAMBDA functions.
Topics:
1. (00:00) Introduction
2. (00:10) Single Cell formula to spill commission amounts for each sales rep using the functions: LAMBDA, MAP, XLOOKUP, BYROW, and SUM
3. (04:38) Summary, Closing, Video Links

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Continue reading “Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803” →

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

LAMBDA & MAP Functions to Lookup Different Product Commission Rates for each Sales Rep. EMT 1803

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1801-1804.xlsx
Learn how to use LAMBDA, BYROW and MAP functions to build a custom function to spill a column of commission amounts for each sales rep. Learn how to deal with different sized iterating arrays in single formula by using two LAMBDA functions.
Topics:
1. (00:00) Introduction
2. (00:10) Single Cell formula to spill commission amounts for each sales rep using the functions: LAMBDA, MAP, XLOOKUP, BYROW, and SUM
3. (04:38) Summary, Closing, Video Links

FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
SUMIFS & XLOOKUP to Lookup Different Product Commission Rates for Continue reading “LAMBDA & MAP Functions to Lookup Different Product Commission Rates for each Sales Rep. EMT 1803” →

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