Month: November 2022

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

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

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

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

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

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

Excel Max Minus Min In A Pivot Table – 2529

Posted on by Annie D

Kelly wants to display a Delta in a Pivot Table. Unfortunately, Calculated Fields in a Pivot Table look at each individual row, so the MAX(B2)-MIN(B2) will always be zero.
In this video, a DAX Measure solves the problem. But to unlock DAX, you need to choose Add This Data To The Data Model.

Table of Contents
(0:00) Need Max minus Min in pivot table
(0:31) MIN and MAX are easy
(0:51) Calculated Field fails
(1:51) Add to Data Model
(2:51) New Measure
(4:25) Wrap-up

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

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

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

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

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