With his financial background and data modeling expertise, Chris Barber, a Microsoft MVP, explores the irony of his journey to discover the optimal data model, a task that requires both technical knowledge and a judgement call, to uncover the key to his clients’ successful decision-making.
Chris Barber is a Microsoft MVP and chartered accountant with a Masters in analytics. He has presented at Microsoft Reactor and the London Business Analysts Group, and runs the website Starchema.co.uk, which has over 1000 people taking his finance course. He specializes in large scale data modeling and financial reporting.
Chris Barber was always interested in Power Continue reading “Uncovering the Power of Enterprise Data Modeling with Chris Barber” →

In this tutorial, Sam will run through how to use the GROUPBY function in Power BI with a few examples. This is a similar table function to the likes of SUMMARIZE and SUMMARIZECOLUMNS, but it has some unique nuances to it that are interesting and worth diving into more deeply.

*****Video Details*****
00:00 Introduction
01:55 Creating tables using GROUPBY
03:58 Using the CURRENTGROUP function
05:28 Working out GROUPBY inside a variable
06:33 Return results using MAXX function
06:54 Checking out a specific customer

***** 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 Use The GROUPBY Function In Power BI” →

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

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