Category: Power BI

Guy in a Cube answers the web’s most searched questions on Power BI

Posted on by Annie D

Let’s see what the most asked questions are on the web about Power BI! Adam looks at google for the questions and then responds. You heard that right! He went to Google.

Power BI forecasting
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane#apply-forecasting

Describing the forecasting models in Power View
https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/

Power BI on a Mac?
https://www.youtube.com/watch?v=qUpqtWEOG40

Understand star schema and the importance for Power BI
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

📢 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 “Guy in a Cube answers the web’s most searched questions on Power BI” →

Unpack the Impact of AI on Business, Jobs, and Education with Brian Julius

Posted on by Annie D

The rapid advancements in artificial intelligence (AI) technology have been nothing short of groundbreaking. The implications for businesses, jobs, and education are profound, and it can be both awe-inspiring and intimidating to consider what the future may bring. Brian and Sam discuss AI’s impact on coding, and how it has already begun to shift the way we do things. With a $20 billion investment from Microsoft and AI being embedded in parts of Azure, it is clear that the technology is advancing at an alarming rate. How will we use AI to our advantage, and how can it be used Continue reading “Unpack the Impact of AI on Business, Jobs, and Education with Brian Julius” →

Time to look at the new INDEX function in DAX and Power BI

Posted on by Annie D

The latest DAX functions in Power BI can be very “power”ful! Patrick starts by looking at the INDEX function to solve a customer problem!

Blog announcement:
https://powerbi.microsoft.com/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731

INDEX function (DAX)
https://learn.microsoft.com/dax/index-function-dax

WINDOW function (DAX)
https://learn.microsoft.com/dax/window-function-dax

Chris Webb’s Blog
https://blog.crossjoin.co.uk/2023/01/02/why-dax-window-functions-are-important-for-performance-in-power-bi-directquery-mode/

Jeffrey Wang’s Blogs on Window Function

https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/

https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/

📢 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/

#PowerBI #GuyInACube

How To Automatically Delete Unused Columns And Measures In Power BI

Posted on by Annie D

A good practice to have before finalizing your Power BI reports is to delete the unused columns and measures, and this will greatly help to optimize and to further emphasize the important aspects of your report. But this can be a very laborious task in itself. In today’s video, Brian is going to show how you can easily identify and automatically delete unused columns and measures in Power BI using the Measure Killer.

*****Video Details*****
00:00 Introduction
00:45 Measure killer
01:59 Deleting unused columns
04:16 Deleting unused measures

***** Related Links *****
Measure Killer by Brunner BI – https://en.brunner.bi/measurekiller

***** Learning Power BI? ***** Continue reading “How To Automatically Delete Unused Columns And Measures In Power BI” →

Continuing the T-SQL journey with OVER and RANK

Posted on by Annie D

Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics.

RANK (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/functions/rank-transact-sql?view=sql-server-ver16

SELECT – OVER Clause (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-ver16

WITH common_table_expression (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16

📢 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 “Continuing the T-SQL journey with OVER and RANK” →

Time Based Cohort Analysis – How To Setup Your Data Model In Power BI

Posted on by Annie D

In this tutorial, Sam is going to demonstrate how you can create time based cohort insights within Power BI. You can use this strategy for whatever cohort you’re trying to devise. Cohort Analysis has been popularized by SAS applications. So, you should group your customers based on when they’re churning. You can create incredible analysis in Power BI using this technique.

*****Video Details*****
00:00 Introduction
01:02 Review on cohort analysis
02:06 Creating cohorts
04:58 Cohort Months table
07:39 Cohort analysis insights
10:14 Churning formulas and examples

***** 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 Continue reading “Time Based Cohort Analysis – How To Setup Your Data Model In Power BI” →

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

Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX

Posted on by Annie D

Are you trying to work out trends in customer behaviour or would like to target marketing campaigns more specifically to relevant customers? In this video, Sam demonstrates how you can calculate the difference in days between purchases or events in Power BI using DAX formulas. He is going to use some advanced logic using the FILTER and CALCULATE functions.

*****Video Details*****
00:00 Introduction
02:20 Data set
03:17 Last date of purchase
05:01 Difference between purchases
09:22 Conclusion

***** 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 – Power BI Resources Continue reading “Calculate The Difference In Days Between Purchases Or Events In Power BI Using DAX” →

Let’s see if ChatGPT knows what’s coming next for Power BI…

Posted on by Annie D

Everyone is making videos on ChatGPT and trying to solve problems. What about telling the future? Let’s see if ChatGPT can tell us what’s coming next for 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
— 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 “Let’s see if ChatGPT knows what’s coming next for Power BI…” →

Building an Inclusive Data Culture with Chris Wagner

Posted on by Annie D

Are you struggling to create a data culture in your organization that can support everyone inside the company, not just the executive? Chris Wagner, a director of data solutions at Baker Tilly, is here to help. With over two decades of experience in the data analytics space, Chris has worked with large organizations to create modernized data and analytical strategies. He will provide actionable ideas on how to build a data culture that can help individuals take their next step forward in their data career. This article will cover three focus areas of data engineering, analytics and data science, and Continue reading “Building an Inclusive Data Culture with Chris Wagner” →

Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!

Posted on by Annie D

Have you wanted to use a Stored Procedure with Incremental Refresh? Patrick has a way that you can do just that!

Sandeep’s blog:
https://pawarbi.github.io/blog/power%20bi/powerquery/queryfolding/m/optimization/2022/01/25/parameter-valuenativequery-query-folding-where-clause-in-powerbi.html

Stored Procedures: https://learn.microsoft.com/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver16

Sample:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2023/20230201%20-%20IR%20with%20SP.zip

📢 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 Continue reading “Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!” →

How To Bulk Copy Measures From Different Reports In Power BI

Posted on by Annie D

You’ll most probably encounter having to reuse the same measure when working with multiple Power BI reports. In this video, Brian shares a handy trick for copying measures from one report to another. There is no direct way to do this in Power BI but this is something you can achieve using the Tabular Editor.

*****Video Details*****
00:00 Introduction
00:27 Case scenario
00:45 DAX Offsets table
01:22 Copying measures

***** 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 – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Continue reading “How To Bulk Copy Measures From Different Reports In Power BI” →