Category: Power BI

How To Tune Up Your Power BI Data Model With The Best Practice Analyzer

Posted on by Annie D

Analyzing the performance of your Power BI data model is crucial to identify potential bottlenecks and optimize the model for faster data processing. It also helps to improve the user experience by reducing the query response time and increasing the overall efficiency of the Power BI reports.

How do you challenge yourself to determine if you’ve developed a good enough data model? The first thing that starts with Power BI is whether or not you built a good Star Schema. But even within the context of a Star Schema, there are better and worse ways to do things. In this video, Continue reading “How To Tune Up Your Power BI Data Model With The Best Practice Analyzer” →

How To Integrate ChatGPT With Microsoft Outlook Using Power Automate

Posted on by Annie D

In recent months, the popularity of AI tools has risen significantly, and ChatGPT is one of them. These tools offer a range of benefits, including the ability to automate repetitive tasks, analyze data, and provide personalized recommendations. By leveraging the power of AI, organizations can streamline workflows and improve productivity.

Furthermore, AI tools can help identify patterns and insights that would be difficult for humans to detect, leading to more informed decision-making. In this tutorial, Henry is going to demonstrate how you can integrate ChatGPT with Microsoft Outlook using Power Automate.

*****Video Details*****
00:00 Introduction
00:25 Use case
02:57 How the API works
05:53 Power Continue reading “How To Integrate ChatGPT With Microsoft Outlook Using Power Automate” →

Switch a Power BI Report’s dataset without needing Premium!

Posted on by Annie D

Want a dev and production environment in Power BI but don’t have Power BI Premium? Patrick shows you a way to switch a report from Dev to Production without Premium or without APIs.

📢 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 Tools Continue reading “Switch a Power BI Report’s dataset without needing Premium!” →

How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]

Posted on by Annie D

Knowing how to detect outliers in datasets and how to visualize them is important for data analysts because it helps them identify potential errors or anomalies in data that can skew statistical analyses and modeling results.

Outliers can also provide valuable insights into unusual or unexpected patterns in the data that may be indicative of underlying trends or issues, facilitating more effective data-driven decision-making. In this video, Sam is going to demonstrate how you can detect and visualize outliers using DAX in Power BI.

*****Video Details*****
00:00 Introduction
01:13 Determining the logic
03:44 Doing logic in a dynamic way
04:00 Criteria for outliers
05:22 Outlier detection logic
08:10 Continue reading “How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]” →

How To Create Fully Dynamic Image Slicers In Power BI

Posted on by Annie D

Learning how to create dynamic picture slices in Power BI allows you to provide a more interactive and engaging experience for your audience. With dynamic picture slices, users can easily filter data and explore relationships visually, leading to better insights and decision-making. In this tutorial, Brian shows how you can spruce up your standard Power BI slicer into a fully dynamic image slicer.

*****Video Details*****
00:00 Introduction
00:44 Image source
01:52 Standardizing the image background
03:28 Chiclet slicer
05:00 Image hosting
06:40 Linking new table to customers table
09:50 Configuring the buttons
10:23 Formatting the image

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI Continue reading “How To Create Fully Dynamic Image Slicers In Power BI” →

How To Test And Develop Color-blind Friendly Themes For Your Power BI Report

Posted on by Annie D

Using color-blind safe visuals in Power BI is important because around 5-10% of the population has some form of color blindness, which can make it difficult or impossible for them to distinguish certain colors. Failing to use color-blind safe visuals can lead to confusion and misinterpretation of data for people with color blindness, and ultimately lead to poor decision-making.

By using color-blind safe visuals, you can ensure that your data is accessible and understandable to a wider audience, including those with color vision deficiencies. In this tutorial, Brian shares a quick and easy way to check how color-blind friendly is your Continue reading “How To Test And Develop Color-blind Friendly Themes For Your Power BI Report” →

Visually see where you BROKE the fold in Power Query

Posted on by Annie D

Rule #1 – DON’T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I’m guessing you didn’t even know it was there! Adam shows you where to go.

Query plan for Power Query (Preview)
https://learn.microsoft.com/power-query/query-plan

📢 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 #PowerQuery #GuyInACube

Checking out the new Power BI RLS Editor

Posted on by Annie D

Take a look at the new Row-Level Security (RLS) editor within Power BI Desktop! Patrick explores how it works and what to look out for in the Preview.

Power BI February 2023 Feature Summary
https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/

Documentation
https://learn.microsoft.com/power-bi/enterprise/service-admin-rls#define-roles-and-rules-in-power-bi-desktop-using-enhanced-row-level-security-editor-preview

📢 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/
— <a href="https://guyinacube.com" Continue reading “Checking out the new Power BI RLS Editor” →

How To Convert Continuous Data Into Categorical In Power BI Using Python

Posted on by Annie D

Knowing how to convert continuous data into categorical data in Power BI using Python is important because it allows for better visualization and analysis of data through grouping and summarizing data by categories, providing more meaningful insights and enabling better decision-making. It also helps to simplify complex data and makes it easier to communicate insights to stakeholders.

In this tutorial, Gaelim is going to explore several ways on how you can convert continuous data into categorical data using some Python code that you can easily apply in Power BI.

*****Video Details*****
00:00 Introduction
00:43 Overview of the different methods
01:50 Dataset
02:35 Source
03:12 Categorizing the Continue reading “How To Convert Continuous Data Into Categorical In Power BI Using Python” →

What’s a Junk Dimension and when should you use it?

Posted on by Annie D

Maybe you’ve heard of the concept of a junk dimension but what exactly is it and when should you use it? Patrick breaks down this dimensional modeling concept.

Junk Dimensions
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/junk-dimension/

Design Tip #113 Creating, Using, and Maintaining Junk Dimensions
https://www.kimballgroup.com/2009/06/design-tip-113-creating-using-and-maintaining-junk-dimensions/

Sample Script:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230321%20-%20Junk%20Dimension.sql

📢 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
— <a href="http://www.facebook.com/guyinacube" Continue reading “What’s a Junk Dimension and when should you use it?” →

How To Know What Are Causing The Changes In Your Data Using DAX [2023 Update]

Posted on by Annie D

DAX is a powerful formula language used in Power BI that allows you to create complex calculations and custom measures. It enables you to analyze data at a more granular level and gain deeper insights into your business operations.

Additionally, the ability to identify and understand the root cause of changes in your data can help you make more informed decisions and take proactive steps to address any issues. In this tutorial, Sam demonstrates how you can combine a number of DAX formulas, and how to calculate and find out why and what are causing certain changes in your data.

*****Video Continue reading “How To Know What Are Causing The Changes In Your Data Using DAX [2023 Update]” →

How To Identify And Optimize Slow Power BI Visuals

Posted on by Annie D

It’s crucial to pinpoint slow visuals in Power BI as slow performance can lead to a poor user experience, frustration, and potentially missed opportunities. Slow visuals can result from various factors, such as the data source, the complexity of the query, or the visualization type.

By identifying and addressing slow visuals in Power BI, users can optimize the performance of their reports and dashboards, improving the user experience and ensuring accurate and timely decision-making. In this video, Brian demonstrates how you can identify slow Power BI visuals and optimize it. It sounds pretty simple but there’s more to it that Continue reading “How To Identify And Optimize Slow Power BI Visuals” →