Category: Power BI

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

The HEART of Power BI

Posted on by Annie D

Remember Analysis Services? Maybe not for some of you. What exactly powers Power BI? What’s inside that makes the data go? Adam reveals the mystery and takes a trip down memory lane.

📢 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 page Continue reading “The HEART of Power BI” →

Calculating Averages Per Transaction Using DAX In Power BI [2023 Update]

Posted on by Annie D

One valuable insight that can be discovered in Power BI is the average amounts per transaction, which can provide useful information for businesses. This insight can be used to compare transaction amounts across different time frames or dimensions in the dataset.

By analyzing this information, businesses can identify patterns and trends, make data-driven decisions, and improve their operations. In this video, Sam will demonstrate how you can calculate averages per transaction in Power BI using DAX.

*****Video Details*****
00:00 Introduction
01:00 Data set
02:12 Average sales per transaction
03:11 Using data bars
03:35 Average profits per transaction
04:30 Average margins per transaction Continue reading “Calculating Averages Per Transaction Using DAX In Power BI [2023 Update]” →

RLS in the source? How does this work with DirectQuery and Import in Power BI?

Posted on by Annie D

What happens in Power BI when you have row-level security (RLS) in the source? And, is it different between DirectQuery and Import? Of course it depends! Patrick explains…

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

#PowerBI #GuyInACube

Grouping Bookmarks by Report Page In Power BI [2023 Update]

Posted on by Annie D

Bookmarks in Power BI are useful for saving and restoring specific views or states of a report. They allow users to easily navigate between different sections or pages of a report and can be used to create interactive experiences for viewers.

Grouping bookmarks can improve workflow by organizing related bookmarks together, making it easier to find and apply them as needed. This can save time and help ensure consistency in the report design. In this tutorial, Jarrett shows how to group bookmarks by report page in Power BI.

*****Video Details*****
00:00 Introduction
0:53 Inspiration for the tutorial
02:55 Creating bookmarks
06:33 Grouping the bookmarks

***** Related Continue reading “Grouping Bookmarks by Report Page In Power BI [2023 Update]” →

How to SCHEDULE your notebooks to run with Azure Synapse

Posted on by Annie D

Taking advantage of Notebooks in Azure Synapse Analytics? How do you automate that great work you did? Patrick shows you some options to schedule the run of your notebooks.

📢 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 page – <a href="https://guyinacube.com/tools/" Continue reading “How to SCHEDULE your notebooks to run with Azure Synapse” →

Calculating Average Monthly Purchases In Power BI Using DAX

Posted on by Annie D

Power BI is a powerful tool that can be used to track expenses and sales for businesses or organizations. It provides a user-friendly interface that allows users to create interactive visualizations and reports using data from various sources.

By using Power BI, businesses can easily monitor their financial performance in real-time, as the tool allows for the tracking of expenses and sales data over time. This data can be used to identify trends, patterns, and areas of improvement, enabling businesses to make data-driven decisions and optimize their financial performance. In this video, Sam shows how you can compare your average monthly Continue reading “Calculating Average Monthly Purchases In Power BI Using DAX” →

How To Transform and Code Addresses In Python

Posted on by Annie D

Transforming and coding addresses using Python involves cleaning and standardizing addresses to prepare them for geocoding. This process typically involves removing unnecessary characters, standardizing street suffixes, and normalizing capitalization and formatting. There are several Python libraries that can assist with these tasks. In this tutorial, Gaelim is going to demonstrate how to transform and code addresses using GeoPy in Python.

*****Video Details*****
00:00 Introduction
00:45 Libraries to import
01:16 Data set
01:39 Initializing the geolocator
03:18 User-defined function
04:45 Converting location to addresses

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE Continue reading “How To Transform and Code Addresses In Python” →