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

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

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

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

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]

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

How To Use The Dynamic Format Strings Feature – Power BI April 2023 Updates

One of the latest updates for Power BI in April 2023 introduces a new capability called Dynamic Format Strings, which provides an interactive means for users to control the presentation of data in visuals. In this video, Brian demonstrates how you can setup and utilize of this feature.

Although the current example focuses on modifying the format of a singular visual with Dynamic Format Strings, this technique can be readily extended to multiple visuals on a single page or even to the entire suite of visuals spanning several pages by utilizing synch slicers.

*****Video Details*****
00:00 Introduction
01:00 Setting up a helper table
01:49 Continue reading “How To Use The Dynamic Format Strings Feature – Power BI April 2023 Updates”

How To Calculate Year To Date Sales For Non-Standard Calendar Tables Using DAX

Using DAX for time intelligence calculations in Power BI provides several advantages, such as the ability to perform complex calculations, create custom date ranges, and dynamically adjust calculations based on user selections.

However, when using custom calendars in Power BI, it is important to ensure that the calendar is set up correctly and that all time intelligence calculations are based on the correct date column. Additionally, it is essential to consider any differences in the length of periods, such as weeks or months, as this can impact the accuracy of time intelligence calculations.

In this tutorial, Sam is going to Continue reading “How To Calculate Year To Date Sales For Non-Standard Calendar Tables Using DAX”

ChatGPT blew my mind with this Power BI scenario

Our minds were blown by this ChatGPT example for Power BI from our friends Stephanie Bruno and Shannon Lindsay! Use ChatGPT to help get you pointed in the right direction and with a faster solution.

Power BI datasets CI/CD (the easy-ish way)
https://data-witches.com/2023/03/31/power-bi-datasets-ci-cd-the-easy-ish-way/

Stephanie Bruno
https://twitter.com/StephTBruno
https://www.linkedin.com/in/brunostephanie/
https://data-witches.com

Shannon Lindsay
https://twitter.com/shan_gsd
https://www.linkedin.com/in/shannonrlindsay/
https://data-witches.com

📢 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: <a href="https://guyinacu.be/courses" Continue reading “ChatGPT blew my mind with this Power BI scenario”

3 tips for the new On-Object editing of a Power BI visual

Have you started using the new on-object editing for Power BI visuals? Adam found some hidden gems that you may not be aware of when using it! You need to be aware of these!

Use on-object interaction with visuals in your report (preview)
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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
Continue reading “3 tips for the new On-Object editing of a Power BI visual”

How To Calculate Due Dates Within Working Days In Power BI

Power BI is an exceptional tool for time intelligence as it allows for easy visualization and analysis of time-based data. Its built-in time intelligence functions enable users to quickly calculate common time-based metrics like year-to-date or month-over-month comparisons.

Isolating certain dates in Power BI can be tedious when dealing with large datasets or complex date ranges. This can require using filters, slicers, or other advanced features to extract the desired data. In this video, Greg is going to demonstrate how you can calculate due dates within working days in Power BI using DAX and Power Query.

*****Video Details*****
00:00 Introduction
01:23 DAX solution
05:13 Power Continue reading “How To Calculate Due Dates Within Working Days In Power BI”

Loop through a list using pySpark for your Azure Synapse Pipelines

Curious how to loop through files using pySpark? Patrick walks through how he did it for use within his Azure Synapse Analytics Pipelines and 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 – https://guyinacube.com/tools/

#AzureSynapse #pySpark #GuyInACube

Handling Weekday vs Weekend Dates In Power BI Using DAX

Efficient data analysis often requires calculating results for specific days within a week. For instance, when sales inputs are available only on weekdays, it becomes necessary to isolate those days for analysis.

In this tutorial, Sam showcases how you can use DAX to solve this issue, along with some slight adjustments to the date table in the data model. By following these steps, you can streamline your analysis process and gain valuable insights without unnecessary data points.

*****Video Details*****
00:00 Introduction
01:22 Date table
02:33 Sales Weekdays
03:25 Sales Weekends
04:10 Measure branching

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “Handling Weekday vs Weekend Dates In Power BI Using DAX”