Category: Power BI

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

Call Center Data Reporting: Power BI Challenge Winner # 19 – Best Practices

Posted on by Annie D

When is it?
July 14th – 10pm New York (EDT), 1pm Los Angeles (PDT), 6pm London (GMT)
July 15th – 3am Sydney (AEST), 5am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Abu Bakar N. Alvi, Enterprise DNA Expert & Power BI Challenge # 19 Winner

During This Free Training, You Will Learn:

• Learn the core areas of the winning entry around the 4 pillars of Power BI report development
• Develop a consistent storytelling for all the report pages and focus in showing the results
• Know how Continue reading “Call Center Data Reporting: Power BI Challenge Winner # 19 – Best Practices” →

How To Avoid Errors When Integrating Python Scripts In Power BI

Posted on by Annie D

In this video, Gaelim is going to demonstrate how you can avoid and solve errors when integrating Python scripts in your Power BI reports that are usually caused by some discrepancies in the Python environment and Power BI.

***** Video Details *****
00:00 Introduction
00:51 Options
01:13 Anaconda prompt
01:27 Python environment
02:00 Activating an environment
03:35 Creating a new environment
05:05 Installed packages
06:11 Installing a package
07:06 Launching an instance

***** 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 – <a Continue reading “How To Avoid Errors When Integrating Python Scripts In Power BI” →

Enterprise DNA Challenge 20 – Judging Of Entries

Posted on by Annie D

Another edition of the Enterprise DNA Challenge has just wrapped up, and we’re so amazed by the sheer number of brilliant entries we have received! What a remarkable Challenge 20 it has been:

✓ Over 1,000 members in EDNA Challenges group in LinkedIn
✓ 47 final entries
✓ Over 211 analysis pages
✓ More than 600+ DAX measures
✓ Over 400+ navigation buttons, bookmarks, and tooltips

In this video, watch as our panel of judges consisted by Enterprise DNA Experts Brian Julius, Federico Pastor, Tim Weinzapfel and Paul Gerber go through and share their insights on the top 3 nominees per category as well as the Continue reading “Enterprise DNA Challenge 20 – Judging Of Entries” →