Category: Power BI

Retail Sales Cases | Industries Analytics & Applications Summit Session 5

Posted on by Annie D

Session 5: Retail Sales Cases

When is it?
November 15th – 9pm Los Angeles (PST)
November 16th – 12am New York (EST), 5am London (GMT), 4pm Sydney (AEDT), 6pm 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 Ilgar Zarbaliyev – Founder of ExcelWorld

During This Free Event, You Will:

• Forecast sales seasonality using analytical tools and data
• Learn to determine seasonality in sales with Microsoft Power BI
• Apply correlation technique to identify seasonal items Use dynamic sales forecasting techniques to generate more accurate revenue gains and losses
• Test Continue reading “Retail Sales Cases | Industries Analytics & Applications Summit Session 5” →

Detecting Outliers w/ Python | Industries Analytics & Applications Summit Session 4

Posted on by Annie D

Session 4: Detecting Outliers w/ Python

When is it?
November 15th – 5pm Los Angeles (PST), 8pm New York (EST)
November 16th – 1am London (GMT), 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 Event, You Will:

• Discover how to build outlier function effectively
• Know a helpful way of detecting outliers by using visualizing outliers w/ Python
• In-depth understanding of outlier algorithms in Python
• Examine the residuals of the cases in the analysis to check Continue reading “Detecting Outliers w/ Python | Industries Analytics & Applications Summit Session 4” →

Financial Modelling In The Banking Industry | Industries Analytics & Applications Summit Session 3

Posted on by Annie D

Session 3: Financial Modelling In The Banking Industry

When is it?
November 15th – 10am Los Angeles (PST), 1pm New York (EST), 6pm London (GMT)
November 16th – 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 Rishi Sapra, MVP – Group Manager, Avanade

During This Free Event, You Will:

• Take industry Income Statement/Balance Sheet data for 4 Banks (Barclays, Citi, HSBC, Lloyds) and turn it into a financial reporting solution in Power BI
• Create an interactive benchmarking report comparing the financial performance of the Continue reading “Financial Modelling In The Banking Industry | Industries Analytics & Applications Summit Session 3” →

How To Perform Conditional Full and Partial Text Replacements In Power Query

Posted on by Annie D

In this tutorial, Melissa is going to demonstrate how to perform a combination of conditional full and partial text replacements in Power Query all in one simple step.

***** Video Details *****
00:00 Introduction
00:26 Data set
00:31 Replacements list
00:54 Replacing values

***** 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 – https://www.enterprisedna.co/membership Continue reading “How To Perform Conditional Full and Partial Text Replacements In Power Query” →

🔴 Power BI tips from the Pros – LIVE (Nov 19, 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 19, 2022) (Member Chat 2nd Half)” →

How To Create Dynamic Chart Titles In Power BI

Posted on by Annie D

In this tutorial, Brian delves into his approach to a query that came up in a recent Accelerator event that involves taking selections from a slicer of a visual and incorporate that into a dynamic chart title.

***** Video Details *****
00:00 Introduction
00:40 Sample execution
01:14 Bar chart formatting
01:36 Dynamic Title measure
03:42 CF Title Color measure

***** 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 Continue reading “How To Create Dynamic Chart Titles In Power BI” →

Understanding Anomalies In Power BI With DAX – Analytical Technique [2022 Update]

Posted on by Annie D

In this video, Sam will showcase how you can really quickly and effectively understand anomalies in your data sets by combining many Power BI techniques around DAX.

***** Video Details *****
00:00 Introduction
01:40 Showcasing Anomalies In Your Data Set
03:38 Understanding Anomalies In Power BI
04:57 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 – 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 “Understanding Anomalies In Power BI With DAX – Analytical Technique [2022 Update]” →

Add a measure without Power BI Desktop (Premium)

Posted on by Annie D

Need to add a measure to your Power BI dataset? Can’t download it back in Power BI Desktop? Patrick shows you how you can still add that measure even though you can’t use Power BI Desktop!

Tabular Editor 2
https://github.com/TabularEditor/TabularEditor

Tabular Editor 3
https://tabulareditor.com/

📢 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
— rel=”nofollow”>http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #DAX #GuyInACube

🔴 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