Month: February 2023

How To Bring In Summary Statistics and Correlation Tables In Power BI Using Python

Posted on by Annie D

Power BI is a powerful tool in its own, but there are even more potential that are not possible to do with only its built-in capabilities In this tutorial, Gaelim is going to show how you can bring in descriptive statistics and correlations into Power BI as tables using some easy Python code. This will help data analysts perform more advanced statistical analyses and build more complex visualizations for deeper insights and improved communication in Power BI.

*****Video Details*****
00:00 Introduction
00:40 The data set
01:27 Descriptive statistics overview
02:10 Correlations overview
03:20 Python script
05:12 Not resetting the index
06:46 Unpivot data
08:29 Correlations
11:50 The outcome
12:18 Formatting visualizations

***** Continue reading “How To Bring In Summary Statistics and Correlation Tables In Power BI Using Python” →

Excel Map Chart – Only Regions With Data And Macro – 2375

Posted on by Annie D

Ozveri is wondering why the Excel Filled Map Chart shows the entire world when he has just a few countries around the Mediterranean Sea. It is an annoying part of Excel Filled Map Charts. But there is a solution. It is buried where you will never find it.
Format the data series in Excel and choose Only Regions with Data.
Also in this video, I show you how to create a tiny macro in your personal macro workbook that will quickly change this setting.

The macro from 3:00 minute mark:
Sub ShowOnlyRegionsWithData()
‘ ShowOnlyRegionsWithData Macro
ActiveChart.FullSeriesCollection(1).GeoMappingLevel = xlGeoMappingLevelDataOnly
ActiveChart.FullSeriesCollection(1).RegionLabelOption Continue reading “Excel Map Chart – Only Regions With Data And Macro – 2375” →

Dataset permissions required for App report in Power BI? What am I missing???

Posted on by Annie D

Struggling with Power BI App permissions when using shared datasets? Adam looks at how this works. Even for PRO users!!!

Composit model permission blog (Older information):
https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/

📢 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 #Permissions #GuyInACube

Detect Abnormal Patterns In Behaviour Using DAX In Power BI [2023 Update]

Posted on by Annie D

With the powerful capabilities of Power BI, you can unlock some truly remarkable insights! In this video, Sam demonstrates one fascinating example that showcases the great potential of Power BI — by skillfully combining a range of advanced DAX formulas and techniques, you can uncover any unusual patterns or anomalies lurking within your datasets.

*****Video Details*****
00:00 Introduction
02:45 Unique products bought
03:33 Ave. products bought in a quarter
04:01 Ave. products bought in all quarters

***** 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 Continue reading “Detect Abnormal Patterns In Behaviour Using DAX In Power BI [2023 Update]” →

Excel Calculate The Selection – 2374

Posted on by Annie D

In Excel, can you calculate just the selected cells?

Jennifer has a huge spreadsheet that takes forever to calculate. After calculating the entire workbook, the totals on SheetA have not updated. This short VBA macro will allow her to calculate only the selected range.

Table of Contents
(0:00) Problem: Entire workbook does not recalc
(0:55) Add Manual & Automatic Calculation to QAT
(1:12) Explanation of Manual Calculation Mode
(1:56) Open VBA Editor add use Selection.Calculate
(2:35) Saving Personal.XSLB
(2:47) Adding Macro to QAT in Excel
(3:20) Calculating selection in Excel
(3:50) Broken Workbooks
(5:00) Wrap up with Wally & Nancy

Excel Why IMAGE Function Changes To CONNECT Error

Posted on by Annie D

Carl Pepperseed, on assignment in the Burmese Jungle, reports that his =IMAGE() function in Excel suddenly started returning a #CONNECT! error. While we all feel bad for Carl, maybe that means that IMAGE is now Dynamic? If we could just figure out what Carl did to bring that #CONNECT! error!
How about F9? No.
How about Ctrl+Alt+F9? No.
How about F2 / Enter? No.
Replace the URL and then Undo? The image is still there.
Copy the sheet within the workbook? No.
How about Copy the Sheet to a new Workbook? That seems to be it.
Which is bad news for the people hoping for Dynamic Continue reading “Excel Why IMAGE Function Changes To CONNECT Error” →

Publish/Migrate your RDL files from Power BI Report Server to the service

Posted on by Annie D

Using on-premises Power BI Report Server? You can now migrate your paginated RDL reports to the Power BI service from within the portal. Patrick shows you how!

Plan to migrate .rdl reports to Power BI
https://learn.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi

Blog Announcement:
https://powerbi.microsoft.com/blog/power-bi-report-server-january-2023-feature-summary/#post-21998-_Toc121395751

Public RDL files to Power BI
https://learn.microsoft.com/power-bi/guidance/publish-reporting-services-power-bi-service?tabs=powerbi-report-server

📢 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
— Continue reading “Publish/Migrate your RDL files from Power BI Report Server to the service” →

Uncovering the Power of Enterprise Data Modeling with Chris Barber

Posted on by Annie D

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

Excel Create A Personal Macro Workbook – 2373

Posted on by Annie D

How to Create a Personal Macro Workbook in Excel.

I have a lot of other videos where I want you to put a few lines of VBA into your Personal Macro Workbook. I am always thinking that many people won’t have a Personal Macro Workbook. My goal with this video is that any time a future video mentions the Personal Macro Workbook, I can ask you to watch this video to create a Personal Macro Workbook and then you can go back to the other video for the VBA code for that particular task.

Table of Contents
(0:00) Excel Create a Personal Macro Continue reading “Excel Create A Personal Macro Workbook – 2373” →

Provide data lake access with Azure Synapse Analytics

Posted on by Annie D

Using a lake database with Azure Synapse Analytics and struggling to figure out permissions needed for your data readers? Patrick and Adam show you what’s missing!

Azure Synapse Access Control
https://learn.microsoft.com/azure/synapse-analytics/security/synapse-workspace-access-control-overview

How to set up access control for your Azure Synapse workspace
https://learn.microsoft.com/azure/synapse-analytics/security/how-to-set-up-access-control

Control storage account access for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=user-identity

📢 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!
*******************

— <a href="http://twitter.com/guyinacube" Continue reading “Provide data lake access with Azure Synapse Analytics” →

How To Use The GROUPBY Function In Power BI

Posted on by Annie D

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