Category: Power BI

Dueling Tooltips In Power BI

Posted on by Annie D

In today’s video, Greg is going to show how you can have multiple tooltip pages for a single visualization in your Power BI report, as well as show different tooltips depending where you are in a hierarchy or field parameter you’ve chosen.

***** Video Details *****
00:00 Introduction
00:49 Data set
01:22 Measure
01:34 Measure 2
01:45 Overview of report
02:27 Setup
05:16 How it works
06:02 Dueling 1
06:14 Dueling 2
09:01 Dueling 3
09:23 Dueling 4

***** 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 Continue reading “Dueling Tooltips In Power BI” →

When To Use The CALCULATETABLE Function – DAX Function Techniques [2022 Update]

Posted on by Annie D

CALCULATETABLE can be a mind-bender when you’re just starting out with Power BI. In this tutorial, Sam shares what he thinks are the best ways and purposes to use this function, and how to get the most out of it in Power BI.

***** Video Details *****
00:00 Introduction
04:17 Calculating new customers
06:20 Evaluating a customer set
06:51 Adding a FILTER function
08:27 Calculating lost customers
08:43 Adding the EXCEPT function

***** 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 – Continue reading “When To Use The CALCULATETABLE Function – DAX Function Techniques [2022 Update]” →

Taking On Excel BI’s Conditional Win Streak Challenge – Conditional Logic In Power Query

Posted on by Annie D

In this video, Melissa shares her approach in solving Excel BI’s Conditional Win Streak Challenge. The task is to return consecutive win streaks dates for at least 3 times within a period of 180 days.

Excel BI’s Conditional Win Streak Challenge: https://bit.ly/3AnYj7L

***** Video Details *****
00:00 Introduction
00:50 Group By
01:31 GroupKind
02:44 The code
09:36 Filtering rows

***** 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 Continue reading “Taking On Excel BI’s Conditional Win Streak Challenge – Conditional Logic In Power Query” →

Exploring Microsoft Purview for data governance

Posted on by Annie D

You’ve probably heard of Microsoft Purview somewhere. Buck Woody joins Patrick to highlight how Microsoft Purview can help you with data governance. From cataloging to lineage, Purview is a key component for your data strategy!

Connect with Buck:
https://twitter.com/BuckWoodyMSFT
https://www.linkedin.com/in/buckwoody/

Microsoft Purview:
https://learn.microsoft.com/en-us/purview/purview
https://learn.microsoft.com/en-us/microsoft-365/compliance/?view=o365-worldwide
https://learn.microsoft.com/en-us/azure/purview/

📢 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
— Continue reading “Exploring Microsoft Purview for data governance” →

Creating P&L Statements In Power BI – Financial Reporting Example [2022 Update]

Posted on by Annie D

Power BI is an amazing reporting tool for financial reporting. In this video, Sam demonstrates how you can create tables and a matrix that can showcase financial reporting data very effectively.

***** Video Details *****
00:00 Introduction
03:48 Setting up the matrix
04:22 Building the matrix
06:29 Adjusting the P&L statement

***** 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/ Continue reading “Creating P&L Statements In Power BI – Financial Reporting Example [2022 Update]” →

How To Create A Forecast Model In Power BI With Python

Posted on by Annie D

In this tutorial, Gaelim is going to show how you can make a forecast model in Power BI using Python. You can utilize the Power BI forecasting feature, which allows you to visually forecast the data you have to as specific day but it will have its limitations. With Python, you can optimize the model a bit more by changing the additive nature of the trend and seasonality, and add predictions into the data set.

***** Video Details *****
00:00 Introduction
00:28 Forecasting samples
00:49 Power BI limitations
01:30 Trend analysis
02:18 Python code
07:22 Power BI implementation
08:10 Python script

***** Learning Power BI? *****
FREE COURSE Continue reading “How To Create A Forecast Model In Power BI With Python” →

Impossible Totals | Industries Analytics & Applications Summit Session 17

Posted on by Annie D

Session 17: Impossible Totals

When is it?
November 17th – 12pm Los Angeles (PST), 3pm New York (EST), 8pm London (GMT)
November 18th – 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 Greg Deckler (MVP) – Vice President at Fusion Alliance

During This Free Event, You Will:

• Self-service visualization creates extremely challenging issues for measures and particularly measure totals
• Know some things that are impossible to do in Power BI
• While you can’t solve impossible problems, there are things you can do to help Continue reading “Impossible Totals | Industries Analytics & Applications Summit Session 17” →

Data Modelling – The 3 Steps Methodology | Industries Analytics & Applications Summit Session 16

Posted on by Annie D

Session 16: Data Modelling – The 3 Steps Methodology

When is it?
November 17th – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
November 18th – 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 Federico Pastor – Head of Platform Experience, Enterprise DNA

During This Free Event, You Will:

• Understand in-depth data modelling techniques through well established procedures
• Achieve ultimate flexibility for expansion of data points and better insights
• Generate different versions of analytics workflows with a single dataset
• Encapsulate the Continue reading “Data Modelling – The 3 Steps Methodology | Industries Analytics & Applications Summit Session 16” →

Visualizing Future Energy Transition Trends | Industries Analytics & Applications Summit Session 20

Posted on by Annie D

Session 20: Visualizing Future Energy Transition Trends

When is it?
November 17th – 5pm Los Angeles (PST), 8pm New York (EST)
November 18th – 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 Gerard Duggan – Associate Project Manager at KBR, Inc.

During This Free Event, You Will:

• Identify key markets and opportunities in the energy and resource sectors
• Monitor and report trends from various aspects related with energy and resource projects
• Achieve more efficiency in energy operations by leveraging Power Continue reading “Visualizing Future Energy Transition Trends | Industries Analytics & Applications Summit Session 20” →

Practical RPA For Shared Services Using Power Automate | Industries Analytics & Applications Summit

Posted on by Annie D

Session 19: Practical RPA For Shared Services Using Power Automate

When is it?
November 17th – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
November 18th – 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 Daniel Harley – BI Ninja & FP&A Professional

During This Free Event, You Will:

• Identify the right processes to automate with Power Automate
• Create efficiency in your business processes through the specific components of Power Automate Flows
• Discover Excel instance and how to run Continue reading “Practical RPA For Shared Services Using Power Automate | Industries Analytics & Applications Summit” →

Solve Problems w/ Power Query | Industries Analytics & Applications Summit Session 18

Posted on by Annie D

Session 18: Solve Problems w/ Power Query

When is it?
November 17th – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
November 18th – 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 Chris Aragao – Program Analyst (Data Analytics) at U.S. EPA Office of Inspector General

During This Free Event, You Will:

• Apply the Power Query best practices on your data model
• Learn how query folding and training resources power up data manipulation and data shaping to run smoothly
• Understand how Continue reading “Solve Problems w/ Power Query | Industries Analytics & Applications Summit Session 18” →

Maximising DAX Formula Patterns | Industries Analytics & Applications Summit Session 21

Posted on by Annie D

Session 21: Maximising DAX Formula Patterns

When is it?
November 17th – 6pm Los Angeles (PST), 9pm New York (EST)
November 18th – 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:

• Learn how to use patterns of formulas to quickly find insights
• Patterns are data neutral, learn how to re-use them over and over again
• Advanced insights are not difficult when using code repositories. Check out how Continue reading “Maximising DAX Formula Patterns | Industries Analytics & Applications Summit Session 21” →