Category: Power BI

Want a BEAUTIFUL Power BI Report? Start here!

Posted on by Annie D

If you are like us, creating beautiful Power BI reports doesn’t come easy. Mara Pereira joins us to show us where to start to get amazing and beautiful Power BI reports even with no designer background.

Dribbble
https://dribbble.com/

Freepik
https://www.freepik.com/

Figma
https://www.figma.com/

Adobe Color
https://color.adobe.com/create/color-wheel

Coolors
https://coolors.co/

Connect with Mara Pereira:
https://www.datapears.com/
https://www.youtube.com/@datapears
https://twitter.com/datapears
https://www.linkedin.com/in/marapereira/

📢 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 Continue reading “Want a BEAUTIFUL Power BI Report? Start here!” →

How To Create Detail Map Layers With Python Folium

Posted on by Annie D

Detail maps are used to visualize data by showing the geographic distribution of a particular attribute. They highlight patterns, trends, and relationships between variables, making it easy to identify areas with high or low values, clusters, and outliers. They are commonly used in fields such as demographics, geology, meteorology, and ecology to display data. In this video, Gaelim is going to show how to create detail map layers with Python Folium.

*****Video Details*****
00:00 Introduction
01:15 Installing Folium
01:47 Loading in the libraries
02:10 Creating a basic map
04:04 Adding a tile layer and location
04:24 Multiple layer controls
06:19 Using plugins
07:36 Adding your own data

***** Learning Power Continue reading “How To Create Detail Map Layers With Python Folium” →

Why is there a limited relationship when using the same data source?

Posted on by Annie D

Using Power BI Desktop and notice that you have some limited relationships in your model? Patrick discovered an interesting issue that threw him off at first. Learn how he solved it!

Model relationships in Power BI Desktop
https://learn.microsoft.com/power-bi/transform-model/desktop-relationships-understand

Regular and limited relationships in Power BI (SQLBI)
https://www.sqlbi.com/articles/strong-and-weak-relationships-in-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
— Continue reading “Why is there a limited relationship when using the same data source?” →

Dealing With Seasonal Budget Allocations in Power BI [2023 Update]

Posted on by Annie D

It is essential to have a good understanding of variables and the data model. Variables allow you to store and manipulate data in Power BI, while the data model is the backbone of any Power BI report, representing the relationships between your data tables. This is crucial when it comes to analyzing seasonal trends in your budget information, as you will need to be able to filter and aggregate data by specific time periods. In this video, Sam showcases working with seasonal budget allocations in Power BI.

*****Video Details*****
00:00 Introduction
03:10 Budget allocation
04:43 Budget allocation with weightings
05:54 Total budget
06:37 Continue reading “Dealing With Seasonal Budget Allocations in Power BI [2023 Update]” →

Controlling cost with Azure Synapse Serverless Pools

Posted on by Annie D

Curious how to save cost when using Azure Synapse Serverless Pools? Any way to minimize the amount of data you are processing? Patrick shows you how and has a script for you!

Cost management for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/data-processed

Azure Synapse Toolbox
https://github.com/microsoft/Azure_Synapse_Toolbox

Sample Query: https://pastebin.com/iRKagQHR

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

#AzureSynapse #Serverless #GuyInACube

How To Calculate Percent Profit Margins In Power BI [2023 Update]

Posted on by Annie D

Percent profit margins can be used in an organization to measure the profitability of its products or services. It is calculated by dividing the profit by revenue and multiplying by 100. This metric can help data analysts identify which products or services are more profitable and which ones need improvement.

By tracking changes in profit margins over time, analysts can also monitor the effectiveness of cost-cutting measures or pricing strategies. In this video, Sam will show how you can calculate percent profit margins in Power BI using DAX.

*****Video Details*****
00:00 Introduction
00:40 Data model
01:56 Total sales
02:20 Total costs using iterating function
03:14 Total Continue reading “How To Calculate Percent Profit Margins In Power BI [2023 Update]” →

Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update]

Posted on by Annie D

The CALCULATE and TOPN combination is a powerful technique in data analysis that allows users to easily and efficiently discover insights within large datasets. By utilizing this technique, analysts can automate the process of identifying patterns and trends in their data, which historically would have required extensive manual effort and time investment.

This technique is particularly useful for data analysts who need to identify key trends and patterns in large data sets quickly and efficiently, making it a valuable tool in business decision-making scenarios where time is of the essence. In this tutorial, Sam will demonstrate how you can apply Continue reading “Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update]” →

REPLAY Power BI tips from the Pros – LIVE (April 1, 2023)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (April 1, 2023)” →

Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers

Posted on by Annie D

Today’s episode features Gilbert Quevauvilliers, an expert in the field of Business Intelligence and Data Analytics. He has been in the industry since 2009 and has been an early adopter of Power BI, which he has been using for many years in his consulting and various engagements. His expertise spans across the data stack, from multidimensional cubes to the tabular model, and he has continuously kept himself up-to-date with the latest technologies.

Starting off in a large company in Durban, South Africa, he has decided to specialize in the Microsoft ecosystem and has built a wealth of knowledge and experience Continue reading “Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers” →

Integrating Power BI With Power Platform – New Course!

Posted on by Annie D

Learning to integrate Power BI with Power Platform allows data analysts to leverage the combined power of multiple tools for more efficient and effective data analysis. By integrating Power BI with Power Automate and Power Apps, analysts can streamline their workflows, automate data processing, and create interactive visualizations, making it easier to gain insights and communicate findings.

We are ecstatic to officially launch our new course “Integrating Power BI with the Power Platform” developed by Tim Weinzapfel! In this video, join Komal and Tim as they give an insight on what you can expect from this new course, and how data Continue reading “Integrating Power BI With Power Platform – New Course!” →

🔴 Power BI tips from the Pros – LIVE (May 6, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (May 6, 2023) (Member Chat 2nd Half)” →

Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]

Posted on by Annie D

The ALLEXCEPT function is a DAX formula in Power BI that allows you to remove filters from a table or column while keeping other filters on the same table or column. Cumulative totals are a common calculation in Power BI where a running total is displayed over time.

However, when a date selection is made, the cumulative total may reset to zero, and this is where the ALLEXCEPT function can be used to stop this from happening. By using the ALLEXCEPT function, you can ensure that your cumulative totals continue to show accurate data, even when a date selection is Continue reading “Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]” →