Month: November 2022

Can you do Page-Level Security in Power BI?

Posted on by Annie D

What’s up with page-level security in Power BI? We keep getting questions from people about how to do this. I’ve got bad news and I’ve got… well, just watch the video!

Row-Level Security and Object-Level Security together in Power BI??? Yup!
https://www.youtube.com/watch?v=ZYO7wGKVM0Y

Did you know you can now selectively show report pages for specific users in Power BI?
https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-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: rel=”nofollow”>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/

#PowerBI #pagelevelsecurity #GuyInACube

How To Create Parallel Coordinate Plots With Python

Posted on by Annie D

In this video, Gaelim is going to show how to create multi-variate coordinate plots aka Parallel Coordinate Plots using Python, which are used to show the relationship between multiple variables that share the same numerical data.

***** Video Details *****
00:00 Introduction
01:04 Plot overview
01:50 Data set
04:03 Importing data
05:12 Python code
10:06 Plot styles
10:56 Color map

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Continue reading “How To Create Parallel Coordinate Plots With Python” →

Azure Synapse Serverless vs Dedicated SQL Pool

Posted on by Annie D

Not sure on whether to choose Serverless versus SQL Dedicated Pools with Azure Synapse Analytics? Brad Schacht joins Patrick to talk about how to make the choice and get going with your data!

Serverless SQL Pool
https://learn.microsoft.com/azure/synapse-analytics/sql/on-demand-workspace-overview

Dedicated SQL Pool
https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is

Brad Schacht:
Twitter: https://twitter.com/BradleySchacht
LinkedIn: https://www.linkedin.com/in/bradleyschacht/
Blog: https://bradleyschacht.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
— <a Continue reading “Azure Synapse Serverless vs Dedicated SQL Pool” →

The Most Powerful Function Call in Power BI | Power BI Tutorial

Posted on by Annie D

In this video, I demonstrate perhaps my favorite feature within Power BI – a single, simple function call that lets you radically expand the analytical capabilities of the program, literally putting hundreds of thousands of additional functions right at your fingertips from within Power Query.

***** Video Details *****
00:13 Intro to the function call in Power BI
02:10 Excel BI Nightly challenge
02:18 changing data type
02:43 creating a list
05:10 R prime number package
06:32 inserting the R prime package into Power BI
10:21 filtering the prime numbers
10:50 GROUPBY

***** Related Links *****
Linkedin Post:
https://www.linkedin.com/posts/brianjuliusdc_dataanalytics-powerbiprotips-r-activity-6996019482087333888-GxtW?utm_source=share&utm_medium=member_desktop

Excel BI Nightly Challenge:
https://excelbianalytics.com/wp/category/challenge/

***** Learning Power Continue reading “The Most Powerful Function Call in Power BI | Power BI Tutorial” →

UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1805.xlsx
Learn how to convert a cross tabulated table with row header and column header conditions back into a proper data set using Dynamic Spilled Array Formulas and Power Query.
Topics:
1. (00:00) Introduction
2. (00:16) Old School History Formula
3. (00:54) Three Dynamic Spilled Array Formula using IFNA and TOCOL functions
4. (03:55) One Dynamic Spilled Array Formula using HSTACK, IFNA and TOCOL functions
5. (04:53) One Dynamic Spilled Array Formula using LET, HSTACK, IFNA and TOCOL functions
6. (05:54) Power Query
7. (07:49) Summary, Closing, Video Links

Integrated Financial Reporting – Power BI Techniques For Accounting & Finance [2022 Update]

Posted on by Annie D

Many times your financial information sits in different data locations and is not summarized as you need. This is especially true for P&L statements where your sales/revenues will usually sit with a transaction table and all your expenses will sit in other tables. In this video, Sam walks through how you can combine these data sources and create integrated financial statements which are entirely automated.

***** Video Details *****
00:00 Introduction
03:23 Using SUMX
03:34 Using Query Editor
06:09 Using SUMMARIZE
07:44 Using UNION

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Continue reading “Integrated Financial Reporting – Power BI Techniques For Accounting & Finance [2022 Update]” →

Dueling Tooltips In Power BI

Posted on by Annie D

In today’s video, Greg is going to show how you can have multiple tooltip pages for a single visualization in your Power BI report, as well as show different tooltips depending where you are in a hierarchy or field parameter you’ve chosen.

***** Video Details *****
00:00 Introduction
00:49 Data set
01:22 Measure
01:34 Measure 2
01:45 Overview of report
02:27 Setup
05:16 How it works
06:02 Dueling 1
06:14 Dueling 2
09:01 Dueling 3
09:23 Dueling 4

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power Continue reading “Dueling Tooltips In Power BI” →

World Cup Group Stage Tiebreaker Odds – 2531

Posted on by Annie D

The World Cup is now in group stage. Each group has four teams. The top two teams advance to the knockout stage. This video explains the 7 tiebreaker steps, and uses Microsoft Excel to analyze the 729 permutations that can happen in any one group. How likely is it that the tiebreaker will need to be used?

Table of Contents

(0:00) World Cup Group Stage Scoring
(1:00) Tiebreaker rules
(1:50) Odds of a tiebreaker
(2:20) Excel Model for one group
(2:50) TEXTSPLIT function
(3:22) Excel Trace Dependents
(3:45) Scoring & Sorting
(4:10) Detecting a Tie
(4:41) Why 729 permutations
(4:53) 28% tiebreaker chance
(5:46) Six draws leads to 12 points
(6:04) 18 points Continue reading “World Cup Group Stage Tiebreaker Odds – 2531” →

When To Use The CALCULATETABLE Function – DAX Function Techniques [2022 Update]

Posted on by Annie D

CALCULATETABLE can be a mind-bender when you’re just starting out with Power BI. In this tutorial, Sam shares what he thinks are the best ways and purposes to use this function, and how to get the most out of it in Power BI.

***** Video Details *****
00:00 Introduction
04:17 Calculating new customers
06:20 Evaluating a customer set
06:51 Adding a FILTER function
08:27 Calculating lost customers
08:43 Adding the EXCEPT function

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Continue reading “When To Use The CALCULATETABLE Function – DAX Function Techniques [2022 Update]” →

Taking On Excel BI’s Conditional Win Streak Challenge – Conditional Logic In Power Query

Posted on by Annie D

In this video, Melissa shares her approach in solving Excel BI’s Conditional Win Streak Challenge. The task is to return consecutive win streaks dates for at least 3 times within a period of 180 days.

Excel BI’s Conditional Win Streak Challenge: https://bit.ly/3AnYj7L

***** Video Details *****
00:00 Introduction
00:50 Group By
01:31 GroupKind
02:44 The code
09:36 Filtering rows

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page Continue reading “Taking On Excel BI’s Conditional Win Streak Challenge – Conditional Logic In Power Query” →

Exploring Microsoft Purview for data governance

Posted on by Annie D

You’ve probably heard of Microsoft Purview somewhere. Buck Woody joins Patrick to highlight how Microsoft Purview can help you with data governance. From cataloging to lineage, Purview is a key component for your data strategy!

Connect with Buck:
https://twitter.com/BuckWoodyMSFT
https://www.linkedin.com/in/buckwoody/

Microsoft Purview:
https://learn.microsoft.com/en-us/purview/purview
https://learn.microsoft.com/en-us/microsoft-365/compliance/?view=o365-worldwide
https://learn.microsoft.com/en-us/azure/purview/

📢 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
— Continue reading “Exploring Microsoft Purview for data governance” →

Creating P&L Statements In Power BI – Financial Reporting Example [2022 Update]

Posted on by Annie D

Power BI is an amazing reporting tool for financial reporting. In this video, Sam demonstrates how you can create tables and a matrix that can showcase financial reporting data very effectively.

***** Video Details *****
00:00 Introduction
03:48 Setting up the matrix
04:22 Building the matrix
06:29 Adjusting the P&L statement

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/ Continue reading “Creating P&L Statements In Power BI – Financial Reporting Example [2022 Update]” →