Build Voice Of Customer Tool By Power Platform | Industries Analytics & Applications Summit

Session 10: Build Voice Of Customer Tool By Power Platform

When is it?
November 16th – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
November 17th – 8am Sydney (AEDT), 10am 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 Solar Zhu – Enterprise DNA Ambassador

During This Free Event, You Will:

• Identify business pain points through the Voice of the Customer Analytics in Power BI
• Leverage the Power Platform toolbox to glean insights and track metrics
• Explore the appropriate tools for your Customer Service Analytics Continue reading “Build Voice Of Customer Tool By Power Platform | Industries Analytics & Applications Summit”

Automate Processes Using Power Automate Desktop | Industries Analytics & Applications Summit

Session 9: Automate Processes Using Power Automate Desktop

When is it?
November 16th – 12pm Los Angeles (PST), 3pm New York (EST), 8pm London (GMT)
November 17th – 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 Jarrett Moore – Enterprise DNA Expert

During This Free Event, You Will:

• Discover how to use Power Automate to streamline and automate simple to complex tasks and business processes for the Restoration Industry
• Showcase real-scenario examples that can be useful for any industry
• Boost your productivity and magnify Continue reading “Automate Processes Using Power Automate Desktop | Industries Analytics & Applications Summit”

How To Calculate Days Since Last Purchase Using DAX In Power BI

In this video, Sam is going to show how you can calculate the days since a customer’s last purchase using DAX in Power BI. Based on this, we can get actionable insights to encourage retention among our customers. Lots of great actions can be initiated from such an insight.

***** Video Details *****
00:00 Introduction
01:22 Finding out the date of last purchase
02:25 Working out the last purchase date
03:19 Determining the days since last purchase
05:58 Using a threshold

***** 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 “How To Calculate Days Since Last Purchase Using DAX In Power BI”

Power BI Metrics: Make Productive Organization Goals | Industries Analytics & Applications Summit

Session 6: Power BI Metrics: Make Productive Organization Goals

When is it?
November 16th – 12am Los Angeles (PST), 3am New York (EST), 8am London (GMT), 7pm Sydney (AEDT), 9pm 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 Dhruvin Shah (MVP), Power Platform Practice Lead, Prometix

During This Free Event, You Will:

• Get to know the different metrics in Power BI
• Learn how to create manual metrics and connected metrics in Power BI
• Improve productivity by using Power BI metrics to create maintenance KPIs
• Understand what metric-level Continue reading “Power BI Metrics: Make Productive Organization Goals | Industries Analytics & Applications Summit”

Retail Sales Cases | Industries Analytics & Applications Summit Session 5

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

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

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

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)

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

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]

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)

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