Category: Power BI

🔴 Power BI tips from the Pros – LIVE w/ Matthew Roche (Nov 12, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI! With special guest, Matthew Roche!

Connect with Matthew:
Twitter: https://twitter.com/SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/

💥 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 Continue reading “🔴 Power BI tips from the Pros – LIVE w/ Matthew Roche (Nov 12, 2022) (Member Chat 2nd Half)” →

How To Use Isolation Forest Machine Learning Algorithm For Outlier Detection Using Python

Posted on by Annie D

In this tutorial, Gaelim is going to show how to use the Isolation Forest machine learning algorithm to find outliers in your data, and how to fine tune this algorithm and compare to traditional ways of outlier detection.

***** Video Details *****
00:00 Introduction
00:33 Isolation Forest method vs Box Plot method
02:03 Data set
02:51 Applied steps
03:14 Python code
07:02 Traditional outlier vs Anomaly detection
08:58 Optimizing the algorithm

***** 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 – Continue reading “How To Use Isolation Forest Machine Learning Algorithm For Outlier Detection Using Python” →

Have you seen the SQL Admin Pack for Azure Data Studio?

Posted on by Annie D

Working with Azure SQL Database or Azure Synapse Analytics? Want to use Azure Data Studio but missing all of the tools you used to use? Patrick looks at the SQL Admin Pack and how that can help you.

Azure Data Studio GitHub Repo
https://github.com/Microsoft/azuredatastudio

Admin Pack for SQL Server
https://github.com/microsoft/azuredatastudio/tree/main/extensions/admin-pack

📢 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
— <a Continue reading “Have you seen the SQL Admin Pack for Azure Data Studio?” →

How To Show Percentage Sales Per Custom Group Each Year In Power BI – Advanced DAX [2022 Update]

Posted on by Annie D

Ever wanted to see the percentage of how many sales can be attributed to a certain grouping or variable of say, customers, products or regions? In this video, Sam will demonstrate a great technique using DAX that will do exactly this advanced analysis.

***** Video Details *****
00:00 Introduction
01:20 Determine ranking per customer group
03:48 Determine percentage of customer group
05:14 Visualizing the data

***** 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 – rel=”nofollow”>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

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