Category: Power BI

The Next-level KPIs Table In Power BI

Posted on by Annie D

A table visual is a fundamental and probably the most common visual you’ll work with in Power BI. In this tutorial, Tim is going to show how you can take an ordinary table visual to the next level and transform it into something more dynamic and interesting.

***** Video Details *****
00:00 Introduction
00:28 Standard table visual
01:10 New format overview
04:24 Gridlines
05:15 Info icon
07:20 Spark line tooltip
10:55 Warning icon

***** 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 Continue reading “The Next-level KPIs Table In Power BI” →

The most UNDERUSED feature in Power BI???

Posted on by Annie D

What would you say is the most UNDERUSED feature of Power BI? Adam gives you his opinion and talks about why he thinks that is. Do you agree?

Page intentionally left blank
https://www.youtube.com/watch?v=M_nS1Liey-w

Review Performance Analyzer in this Power BI Report from Smart Power BI
https://www.youtube.com/watch?v=Z-J4n9uymQ0

Use Performance Analyzer to examine report element performance
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

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

— rel=”nofollow”>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 #GuyInACube

Inside Microsoft Modern Workplace Intelligence With Kristian Bubalo

Posted on by Annie D

Ever wonder what it’s like to work in Microsoft Modern Workplace Intelligence ? In this episode of the Analytic Mind, Sam McKay spoke with Kristian Bubalo previously a Technical Specialist Intelligence and now a Cloud Solution Architect in Microsoft Switzerland.

Dive in and discover his role within Microsoft. An insider update about the latest and greatest trends in Power BI. And most especially his role in the recently concluded Power BI Championship – Switzerland.

Kristian Bubalo is working for Microsoft Switzerland as a Technical Specialist Modern Workplace Intelligence, in Wallisellen, Switzerland. Their goal is to empower every organization and every person Continue reading “Inside Microsoft Modern Workplace Intelligence With Kristian Bubalo” →

A new approach for dynamic Power BI visuals?

Posted on by Annie D

Want to give report users a way to control Power BI visuals dynamically? Don’t want to use the personalize visual feature? Interesting!!! Patrick has an approach that may fit the need!

Dynamic X and Y Axis in Power BI visuals? Yes please!
https://www.youtube.com/watch?v=1eurc0EY2Xg

A different perspective with Power BI Personalized Visuals
https://www.youtube.com/watch?v=20HwiEhIShc

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

How To Create Enhanced Box Plots In Power BI Using Python

Posted on by Annie D

Box plots help visualize the distribution of quantitative values in a field and allow us to see a number of different things in the data series more deeply. They are also valuable for comparisons across different categorical variables or identifying outliers, clusters of data points, different volume of data points between series and similar insights that we might not get from a summary statistics. In this video, Gaelim is going to demonstrate how you can make enhanced box plots in Power BI using Python code.

***** Video Details *****
00:00 Introduction
00:48 Importing packages
02:13 Data set
02:47 Box plot
04:17 Seaborn box plot
06:59 Swarm plot
11:12 Boxenplot
12:27 Continue reading “How To Create Enhanced Box Plots In Power BI Using Python” →

Intro to aggregates in T-SQL

Posted on by Annie D

Getting started with T-SQL? Patrick looks at using aggregate functions within your statements to help get the right results. If you are just starting with T-SQL in either Azure SQL Database or Azure Synapse Analytics, this is for you!

Transact-SQL Reference (Database Engine)
https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

Aggregate Functions (Transact-SQL)
https://docs.microsoft.com/sql/t-sql/functions/aggregate-functions-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
— rel=”nofollow”>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 #AzureSynapse #GuyInACube

How To Easily Fix Incorrect Measure Totals In Power BI

Posted on by Annie D

You might encounter issues with Measures in Power BI Table visualizations with a Total row. The usual complaint is that the “Total” row is “incorrect” for the measure. Usually, the total row is correct for the measure, it’s just not what most people expect. In this video, Greg is going to take us through this common problem with Measure Totals and how to solve it.

***** Video Details *****
00:00 Introduction
00:51 Dump filters measure
01:50 Tooltip page
03:03 Incorrect total
06:27 Correct total

***** 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 Continue reading “How To Easily Fix Incorrect Measure Totals In Power BI” →

How To Calculate Ranking In A Hierarchical Form

Posted on by Annie D

Ranking is a great way to see the best or worst performing variables in a given data set. In this video, Harsh is going to show how you can calculate ranking when all the different sets of fields are combined together in a single set of hierarchy in Power BI.

***** Video Details *****
00:00 Introduction
01:43 Levels of hierarchy
03:20 Ranking – wrong measure
09:07 Ranking – right measure
09:27 Virtual table
09:50 Virtual column
11:30 Variables
14:25 Replacing reference of dimension tables

***** Related Links *****
How To Calculate Percentages In A Hierarchical Form – https://youtu.be/wbIkcRBlOao

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Continue reading “How To Calculate Ranking In A Hierarchical Form” →

Is it a KNOWN ISSUE in Power BI?

Posted on by Annie D

Hitting issues with Power BI can be frustrating. Having to call support can be even more frustrating! What if there was a way to see if it was a known issue in Power BI???

Power BI Support page and awareness
https://support.powerbi.com

Power BI Known Issues documentation
https://aka.ms/powerbiknownissues

📢 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 “Is it a KNOWN ISSUE in Power BI?” →

Business Intelligence as a Service Solution with Erik Svensen

Posted on by Annie D

A business intelligence (BI) service facilitates the use of structured data in order to enable data-driven decision-making across the organization. It is an end-to-end service that handles the extraction, organization, and maintenance of data.

So if you’re a small business with limited IT resources or someone who’s interested in exploring this service model using Power BI, this episode’s for you. There’s more to Power BI than building a consulting business.

Erik Svensen, a Microsoft Business Intelligence specialist, and Microsoft MVP data platform. He is also the founder of CatMan Solution, a Power BI consulting company based in Northern Europe, and a Continue reading “Business Intelligence as a Service Solution with Erik Svensen” →

Select All items for Parameters in Power BI Paginated reports

Posted on by Annie D

Ever struggled with trying to get a parameter to select all items by default in a Power BI Paginated report? Patrick walks you through how to get this working!

Create parameters for paginated reports in the Power BI service
https://docs.microsoft.com/power-bi/paginated-reports/paginated-reports-parameters

📢 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
— rel=”nofollow”>https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Paginated #GuyInACube

How To Visualize Missing Data With ggmice In R

Posted on by Annie D

When you’re analyzing data, it’s not uncommon to find missing data or values. So what should you do if that happens? As with most things in Analytics, it depends on the scenario. In this video, George is going to share some general rules of thumb on how you can visualize missing data using ggmice in R.

***** Video Details *****
00:00 Introduction
00:45 Patterns
02:45 Importing packages
03:55 is.na
04:05 colSums
04:50 ggmice
05:30 Plot pattern
08:50 Plot predictor matrix

***** 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 – <a Continue reading “How To Visualize Missing Data With ggmice In R” →