Category: Power BI

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

REPLAY Power BI Adoption and More Q&A with Melissa Coates and Matthew Roche!

Posted on by Annie D

Join us live as we answer your questions about Power BI Adoption and more with special guests, Melissa Coates and Matthew Roche!

📢 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

The Hitchhiker’s Guide to Adopting Power BI in Your Organization
https://CoatesDS.com/Hitchhikers-Guide

Power BI Adoption Roadmap: https://aka.ms/PowerBIAdoptionRoadmap
Power BI Implementation Planning: https://aka.ms/PowerBIImplementationPlanning

Connect with Melissa:
Power BI Deployment & Continue reading “REPLAY Power BI Adoption and More Q&A with Melissa Coates and Matthew Roche!” →

The Power of Practice: Enterprise DNA’s New Initiative Workouts for Data Analysts with Brian Julius

Posted on by Annie D

In this episode, Sam McKay and Brian Julius discuss their latest initiative from Enterprise DNA, called Workouts. The aim of Workouts is to help users improve their skills in a more time-efficient and accessible way. They dive into how Workouts provide users with the opportunity to accelerate their skills in data analysis through daily challenges and access to experts in various fields.

Brian shares his vision for Workouts as a gym-like setting where members and non-members can improve their job prospects by building their skill portfolios. He also believes that the rapid development of Artificial intelligence (AI), Robotic process automation (RPA), Continue reading “The Power of Practice: Enterprise DNA’s New Initiative Workouts for Data Analysts with Brian Julius” →

Three Ways To Avoid The Common Split By Delimiters Trap

Posted on by Annie D

Split by Delimiters is a valuable function in Power Query that enables users to split a single column of data into multiple columns based on specific delimiters or separators. This function is especially useful for data cleaning, as it allows users to quickly separate and organize data that may be improperly formatted or combined.

However, if not used correctly, Split by Delimiters can lead to inaccurate results that can undermine the quality of your data. In this video, Brian shares three quick and easy fixes to avoid the common Split by Delimiters trap.

*****Video Details*****
00:00 Introduction
00:47 Data set
01:14 Split rows by Continue reading “Three Ways To Avoid The Common Split By Delimiters Trap” →

Finding Similar Matches With Euclidean Distance Using Python In Power BI

Posted on by Annie D

Euclidean distance is a distance measure commonly used in machine learning to find the closest ideal match between two data points. This measure computes the straight-line distance between two points in a high-dimensional space.

With the integration of Python in Power BI, users can leverage Python’s machine learning capabilities, including the calculation of Euclidean distance, to enhance their data analysis. In this tutorial, Gaelim shows how you can find the similar matches between data points with Euclidean distance using Python.

*****Video Details*****
00:00 Introduction
00:36 Data set
00:54 Overview of example
02:49 Calculating the Euclidean distance
03:45 Python script
07:09 Categorical variables

***** Learning Power BI? *****
FREE Continue reading “Finding Similar Matches With Euclidean Distance Using Python In Power BI” →

Find Weekday & Weekend Day Numbers Within Months – Advanced DAX [2023 Update]

Posted on by Annie D

Time intelligence involves analyzing data with a focus on time-related factors. Comparing data from different time periods is an important aspect of time intelligence. “Like-for-like” comparisons involve comparing similar or identical time periods. Standard time intelligence functions do not always make “like-for-like” comparisons possible, so advanced logic and techniques may be necessary to achieve this. In this tutorial, Sam will demonstrate how you can find the weekday and weekend day numbers within months using DAX.

Enterprise DNA Forum Post – https://bit.ly/3Hc2wPk

*****Video Details*****
00:00 Introduction
01:16 Comparing like-for-like
01:59 Why time intelligence calculations won’t work
02:52 Weekday number
03:42 Using RANKX
04:40 Day of month
05:56 Continue reading “Find Weekday & Weekend Day Numbers Within Months – Advanced DAX [2023 Update]” →