Category: Power BI

Writing some DAX while looking at Relationships

Posted on by Annie D

Ever struggle with writing DAX and having to flip between the report view and the model view in Power BI Desktop? The struggle was real! Patrick shows you a new update that overcomes this!

📢 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 Continue reading “Writing some DAX while looking at Relationships” →

Why Did We Develop Another Visual For AppSource | Industries Analytics & Applications Summit

Posted on by Annie D

Session 14: Why Did We Develop Another Visual For AppSource

When is it?
November 17th – 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 Alex Kolokolov – CEO & Founder, Institute of Business Intelligence

During This Free Event, You Will:

• KPI card and pain of visual perfectionists: paddings, alignment, subtitles, etc.
• Single reference label is not enough: customers require actual v/s target, v/s previous period, and v/s something else
• Development process timeline: Continue reading “Why Did We Develop Another Visual For AppSource | Industries Analytics & Applications Summit” →

Financial Markets Dashboard | Industries Analytics & Applications Summit Session 13

Posted on by Annie D

Session 13: Financial Markets Dashboard

When is it?
November 16th – 6pm Los Angeles (PST), 9pm New York (EST)
November 17th – 2am London (GMT), 1pm Sydney (AEDT), 3pm 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 Sam McKay, Founder & CEO of Enterprise DNA

During This Free Event, You Will:

• Showcase compelling markets dashboards (eg. stocks, currencies, crypto)
• Master modelling techniques for time related data
• Use DAX formula patterns to highlight trends and forecasts
• Create your own Bloomberg Terminal with just Power BI

If you have questions regarding Continue reading “Financial Markets Dashboard | Industries Analytics & Applications Summit Session 13” →

Using Power BI w/ Sharepoint Document Libraries | Industries Analytics & Applications Summit

Posted on by Annie D

Session 12: Using Power BI w/ Sharepoint Document Libraries

When is it?
November 16th – 4pm Los Angeles (PST), 7pm New York (EST)
November 17th – 12am London (GMT), 11am Sydney (AEDT), 1pm 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 Tim Weinzapfel – Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to connect Power BI with your SharePoint Document Library to gain access to the complete list of documents
• Embed URL links in your Power BI report to access SharePoint documents right from your Continue reading “Using Power BI w/ Sharepoint Document Libraries | Industries Analytics & Applications Summit” →

Integrating Microsoft 365 w/ Power Platform | Industries Analytics & Applications Summit Session 7

Posted on by Annie D

Session 7: Integrating Microsoft 365 w/ Power Platform

When is it?
November 16th – 10am Los Angeles (PST), 1pm New York (EST), 6pm London (GMT)
November 17th – 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 Cristian Angyal – Business Applications Manager, Flex

During This Free Event, You Will:

• Integrate Microsoft Forms with Power Automate to streamline data driven processes
• Integrate Power Apps and Power Automate with SharePoint
• Analyze data from SharePoint using Power BI
• Integrate the report with Teams to get a full Continue reading “Integrating Microsoft 365 w/ Power Platform | Industries Analytics & Applications Summit Session 7” →

How To Reorganize A Workspace Gone Awry | Industries Analytics & Applications Summit Session 8

Posted on by Annie D

Session 8: How To Reorganize A Workspace Gone Awry

When is it?
November 16th – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
November 17th – 6am Sydney (AEDT), 8am 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 Clay Cooper – Power BI Data Analyst at Blend360

During This Free Event, You Will:

• Identify the source of the knot and how it caused disarray in your workspace
• Unravel the knot through a well-devised plan
• Create a checklist for reorganizing your workspace
• Develop a Continue reading “How To Reorganize A Workspace Gone Awry | Industries Analytics & Applications Summit Session 8” →

Production Report For The Oil & Gas Industry | Industries Analytics & Applications Summit Session 11

Posted on by Annie D

Session 11: Production Report For The Oil & Gas Industry

When is it?
November 16th – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
November 17th – 9am Sydney (AEDT), 11am 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 “Production Report For The Oil & Gas Industry | Industries Analytics & Applications Summit Session 11” →

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

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