Category: Power BI

How To Showcase Deviations Effectively In Power BI [2023 Update]

Posted on by Annie D

Showcasing deviations effectively in Power BI is essential for data analysts to communicate insights to stakeholders. Power BI provides a powerful data visualization tool for creating interactive and visually appealing dashboards. Deviation analysis helps to identify and analyze the differences between actual and expected results, making it a critical technique for understanding business or process performance.

In this video, Sam will demonstrate how you can showcase and utilize differentials within your Power BI reports and models, and to highlight deviations on forecasts and budgets.

***** Video Details *****
00:00 Introduction
02:34 Measure branching
03:30 Deviation between budgets
04:41 Importance of visualizations
05:37 Small elements matter

***** Learning Continue reading “How To Showcase Deviations Effectively In Power BI [2023 Update]” →

How To Use The Performance Analyzer Tool In Power BI To Debug DAX

Posted on by Annie D

The Performance Analyzer tool in Power BI is an essential feature for anyone working with DAX formulas. It provides a range of powerful tools and features that can help you debug, optimize, and fine-tune your formulas to improve their performance.

With the Performance Analyzer tool, you can identify performance bottlenecks, debug DAX formulas, optimize calculations, and monitor query execution. You can use it to step through your formula line by line, identify areas that need optimization, and monitor the performance of your queries in real-time.

In this tutorial, Brian is going to demo how you can use the Performance Analyzer tool to Continue reading “How To Use The Performance Analyzer Tool In Power BI To Debug DAX” →

Different ways to work with Microsoft Excel in Power BI (2023)

Posted on by Annie D

Using Excel? Of course, you are! How can you take advantage of Power BI? Adam shows you the different ways you can leverage Excel with Power BI to get the most out of it!

📢 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 “Different ways to work with Microsoft Excel in Power BI (2023)” →

ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit

Posted on by Annie D

Session 25: ChatGPT & The Future Of Learning Data Skills

When is it?
February 23rd – 3pm Los Angeles (PST), 6pm New York (EST), 11pm London (GMT)
February 24th – 10am Sydney (AEDT), 12pm 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 & Brian Julius

During This Free Event, You Will:

• Learn what we think about ChatGPT
• See how it can compliment your learning journey
• How can you use AI tools right now!
• What’s the future of ChatGPT and its integration with MS tools

If Continue reading “ChatGPT & The Future Of Learning Data Skills | Innovations In Power BI & Power Platform Summit” →

DAX Is Easy, CALCULATE Makes It Hard | Innovations In Power BI & Power Platform Summit Session 24

Posted on by Annie D

Session 24: DAX Is Easy, CALCULATE Makes It Hard

When is it?
February 23rd – 2pm Los Angeles (PST), 5pm New York (EST), 10pm London (GMT)
February 24th – 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 Brian Julius & Greg Deckler (MVP)

During This Free Event, You Will:

• Understand the Challenges of Working with CALCULATE in DAX
• Examples of how to write DAX measures Without using CALCULATE
• Techniques for Visualizing Intermediate Tables in Data Analysis
• Discover methods for automating intermediate table measures Continue reading “DAX Is Easy, CALCULATE Makes It Hard | Innovations In Power BI & Power Platform Summit Session 24” →

Using Power Automate To Email Power BI Data As A CSV File

Posted on by Annie D

Session 23: Using Power Automate To Email Power BI Data As A CSV File

When is it?
February 23rd – 1pm Los Angeles (PST), 4pm New York (EST), 9pm London (GMT)
February 24th – 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 Jarrett Moore – Enterprise DNA Expert

During This Free Event, You Will:

• Learn how to setup and schedule a Power Automate flow using data from your Power BI Reports
• Know how to get DAX Query data from Power BI Desktop without Continue reading “Using Power Automate To Email Power BI Data As A CSV File” →

Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22

Posted on by Annie D

Session 22: Advanced SQL Skills For Data Analysts

When is it?
February 23rd – 11am Los Angeles (PST), 2pm New York (EST), 7pm London (GMT)
February 24th – 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 Kedeisha Bryan – Co-founder & Community Leader at Data in Motion LLC

During This Free Event, You Will:

• Simplify complex queries, break down complex calculations, or perform recursive queries using Common Table Expressions (CTEs)
• Perform calculations across a set of rows in a query result, without Continue reading “Advanced SQL Skills For Data Analysts | Innovations In Power BI & Power Platform Summit Session 22” →

Harnessing The Power Of Dataverse – A Practical CRM Example

Posted on by Annie D

Session 15: Harnessing The Power Of Dataverse – A Practical CRM Example

When is it?
February 22nd – 8pm Los Angeles (PST), 11pm New York (EST)
February 23rd – 4am London (GMT), 3pm Sydney (AEDT), 5pm 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 Ben Clist – Business Analytics and Applications Manager, Napier Port

During This Free Event, You Will:

• Learn how you can utilise out of the box Dataverse functionality to quickly develop a CRM solution
• Ideal for small teams without the budget for Dynamics 365, Continue reading “Harnessing The Power Of Dataverse – A Practical CRM Example” →

How to get a CLOCK in your Power BI Report

Posted on by Annie D

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen!

Vega Clock Sample
https://vega.github.io/vega/examples/clock/

HTML Content Custom Visual Limitations
https://www.html-content.com/reference/limitations

Kerry Kolosko
https://kerrykolosko.com/exploring-deneb-for-power-bi/

📢 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
— <a Continue reading “How to get a CLOCK in your Power BI Report” →

Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX

Posted on by Annie D

Session 11: Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX

When is it?
February 22nd – 7am Los Angeles (PST), 10am New York (EST), 3pm London (GMT)
February 23rd – 2am Sydney (AEDT), 4am 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 Gustaw Dudek – Enterprise DNA Expert

During This Free Event, You Will:

• Implement selected design techniques and chat formatting options to enhance overall user experience (UX)
• Choose strategic DAX applications to effectively communicate data insights through compelling data storytelling

If Continue reading “Methods Of Improving UX & Data Storytelling Through Combination Of Design Components & DAX” →

5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

Posted on by Annie D

Session 12: 5 Report Design Tricks That Will Make Any Power BI Report Look Awesome

When is it?
February 22nd – 8am Los Angeles (PST), 11am New York (EST), 4pm London (GMT)
February 23rd – 3am Sydney (AEDT), 5am 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 Mara Periera – Founder & Principal Power BI Architect, Data Pears

During This Free Event, You Will:

• Understand the main factors that can influence the design and user experience of your Power BI reports
• Learn how Data Visualization techniques Continue reading “5 Report Design Tricks That Will Make Any Power BI Report Look Awesome” →

Collection Of Custom Visuals & Niche Techniques In Power BI

Posted on by Annie D

Session 16: Collection Of Custom Visuals & Niche Techniques In Power BI

When is it?
February 23rd – 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 Injae Park – Senior Business Intelligence Developer, Objectivity

During This Free Event, You Will:

• Embed HTML, CSS, and JavaScript code directly into your report using HTML visuals
• Explore a wide range of options for customizing the appearance of your data visualizations with 1400+ Fonts Continue reading “Collection Of Custom Visuals & Niche Techniques In Power BI” →