Category: Power BI

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

How To Take Over Data Gateways In Power BI

Posted on by Annie D

An on-premise data gateway is a tool in Power BI that allows users to securely connect their on-premise data sources to Power BI’s cloud-based services. The gateway acts as a bridge between the cloud-based Power BI service and the on-premise data sources, allowing data to flow securely and reliably between the two.

The benefits of using an on-premise data gateway include the ability to access and analyze on-premise data in real-time without having to move it to the cloud, as well as the ability to securely share that data with others within the organization. In this video, Greg is going to Continue reading “How To Take Over Data Gateways In Power BI” →

How do THIN reports work with Power BI Deployment Pipelines?

Posted on by Annie D

Using Power BI Deployment Pipelines and curious what happens when the report and dataset are in different workspaces? How does it work when you promote to another pipeline? Kevin Arnold shows us!

Kevin Arnold:
https://twitter.com/kevarnold
https://www.linkedin.com/in/kevarnold/

📢 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 “How do THIN reports work with Power BI Deployment Pipelines?” →

How To Track Sales Trends Through Time In Power BI Using DAX [2023 Update]

Posted on by Annie D

Understanding how to track sales trends through time in Power BI is crucial for businesses as it helps them make data-driven decisions and identify opportunities for growth. By creating clear and intuitive visualizations, users can analyze sales trends and patterns more effectively.

Mastering this skill in Power BI can enable businesses to optimize their performance and maximize profitability. In this tutorial, Sam is going to showcase how you can track sales trends through time in Power BI using DAX.

*****Video Details*****
00:00 Introduction
02:10 Quarterly sales growth
03:35 Product growth
04:31 Conditional formatting
05:45 Monthly tracking
07:03 Other applications

***** Learning Power BI? *****
FREE COURSE – Ultimate Continue reading “How To Track Sales Trends Through Time In Power BI Using DAX [2023 Update]” →

Art of the Possible with Power Platform and Azure Synapse

Posted on by Annie D

What happens when you combine Power BI, Power Apps and Azure Synapse Analytics? MAGIC! Join Gaston Cruz as he shows a way to bring the Power Platform together with Azure Synapse!

Gaston Cruz
https://twitter.com/GastonFCruz
https://www.linkedin.com/in/gastoncruz/

📢 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/
— rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube

Evaluating New Customer Sales – Advanced Analytics in Power BI [2023 Update]

Posted on by Annie D

Understanding the sales breakdown between new and steady customers is crucial to gain valuable insights into your business’s performance. It helps you identify which customer segment is driving revenue growth and which needs attention.

By utilizing advanced Power BI analytics, you can achieve this breakdown and unleash endless analysis potential to optimize your business strategy and maximize profitability. In this tutorial, Sam will show how you can effectively and dynamically evaluate new customer sales.

*****Video Details*****
00:00 Introduction
00:54 The objectives
02:24 Identifying new customers
04:20 New customer sales
07:44 Percentage of new customer sales

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “Evaluating New Customer Sales – Advanced Analytics in Power BI [2023 Update]” →

How To Use A Decision Tree To Predict Classes In Power BI Using Python

Posted on by Annie D

A decision tree is a data mining technique used in Power BI to visualize a sequence of decisions and its possible outcomes. It helps users understand the factors that affect a specific outcome and identify the most effective decision path.

By learning how to use decision trees in Power BI, users can make more informed and data-driven decisions that lead to better business outcomes. In this video, Gaelim is going to demonstrate how to use a decision tree classifier to help distinguish between 2-3 types of classes.

*****Video Details*****
00:00 Introduction
00:33 Case scenario
03:54 Data set
04:38 Bringing in data
05:35 Decision tree
06:58 Python script

***** Continue reading “How To Use A Decision Tree To Predict Classes In Power BI Using Python” →

How To Use Conditional Formatting Based On Strings Fields – Power BI February 2023 Updates

Posted on by Annie D

In this video, Brian is going to share one of the new features in the Power BI February 2023 Updates — the Conditional Formatting Based On String Fields. This new feature has been added to allow users to set conditional formatting rules based on string fields, which was highly requested. This new capability can be accessed through the formatting pane dialog, allowing for conditional formatting of column chart colors, among other things. Watch as Brian demo this new feature.

*****Video Details*****
00:00 Introduction
01:06 Data set
01:34 Conditional formatting
02:35 Field value
03:34 Advantages in using SWITCH TRUE
05:29 Text operators
05:58 Complex conditions
06:23 Dynamic highlighting of outliers
08:04 Continue reading “How To Use Conditional Formatting Based On Strings Fields – Power BI February 2023 Updates” →