Category: Business

ChatGPT blew my mind with this Power BI scenario

Posted on by Annie D

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

Excel – Best Way For Running Totals – Episode 2590

Posted on by Annie D

Microsoft Excel how-to video about Running Totals in Excel.
In one of my Bing Shorts, I showed two different ways to do Running Totals in Excel.
And then, an interesting comment from Carlo in Italy with a running total formula that I’ve never seen before.

To download the data from today, go here: https://www.mrexcel.com/youtube/TnkyqfGGV9g/

I had to bring that formula to Excel to visualize how it was working. It was cool that it used a colon next to INDEX. But is there a simpler way?

In the video, I then compare four different Running Total Formulas. Which are easiest to enter? Which Continue reading “Excel – Best Way For Running Totals – Episode 2590” →

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

Posted on by Annie D

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

Posted on by Annie D

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

Posted on by Annie D

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

Excel Count By Week – Episode 2589

Posted on by Annie D

Microsoft Excel tutorial on how to count records by week.
This video includes three methods:
Using Group Field in a pivot table to roll up to weeks.
Using a formula of Data minus WEEKNUM(,3) to back the date to Monday.
Using ISOWEEKNUM plus the year along with SORT, UNIQUE, and COUNTIF.

To download the data, visit: https://www.mrexcel.com/youtube/GLkEsvirk9Y/

Table of Contents
(0:00) Count by Week in Excel pivot table
(0:43) Pivot convert dates to weeks
(1:33) Using date minus WEEKDAY(,3)
(2:19) Sort, Unique, COUNTIF
(2:53) Using ISOWEEKNUM in Excel
(3:30) Excel formula for Year and Week Number

Handling Weekday vs Weekend Dates In Power BI Using DAX

Posted on by Annie D

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

How To Validate Data Against Online Lists Using M

Posted on by Annie D

Most data problems in Power Query can be solved using the UI, and even more can be resolved by slightly editing the M code generated by the UI. Thus, if your data is not excessively messy and your transformations aren’t too intricate, you may not require extensive M knowledge. However, if you invest time in learning M, you can unlock incredible possibilities!

Learning M language is going to be advantageous for anyone who works with data and wants to efficiently manipulate, clean and transform large and complex data sets. In this video, Brian is going to demonstrate exactly why that is Continue reading “How To Validate Data Against Online Lists Using M” →

SUMIF Function Trick: Single Cell Dynamic Range! #Short Excel Magic Trick 12

Posted on by Annie D

Learn how to use a single cell in the Sum Range argument of the SUMIF function rather than an entire column.
Download Excel File: https://excelisfun.net/files/SEMT0008-12.xlsx

#excel #excelisfun #analytics #microsoftexcel #microsoftmvp, #short #shorts #excelmvp #excelformulas #excelfunctions #excelformulaforjobinterview #excelforbegginers #excelshorts #exceltutorial #exceltips #exceltipstricks #freeclass #freecourse #freeclasses #freeexcelcourse #freeexcel #shortsyoutube #shorts #short

#sumif #sumifs #sumifactsshorts #sumifacts #dynamicarrays #dynamicrange

🔴 Power BI tips from the Pros – LIVE (April 15, 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 (April 15, 2023) (Member Chat 2nd Half)” →

How To Quickly Changing Multiple Measures At Once In Power BI

Posted on by Annie D

Measures are an essential part of creating meaningful data visualizations in Power BI, as they allow analysts to define calculations and metrics based on their data. However, making changes to measures can be a tedious process, especially if the data model is complex or the calculations involve multiple steps.

When changing the formula for a measure, you may need to modify multiple components of the data model and visualization to ensure the changes are reflected accurately. This can involve navigating through multiple menus and interfaces in Power BI, which can be time-consuming and error-prone. In this video, Brian will show how Continue reading “How To Quickly Changing Multiple Measures At Once In Power BI” →

Minimize diagnostics steps by just using the VPAX file!

Posted on by Annie D

Getting a VPAX and BIM or PBIT file is key to helping optimize your Power BI dataset. We look at them all the time. Patrick shows how you can simplify this by just using the VPAX file!

DAX Studio:
https://daxstudio.org

Tabular Editor:
https://tabulareditor.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: 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 “Minimize diagnostics steps by just using the VPAX file!” →