Month: July 2022

Prevent Excel From Changing Numbers On Import – 2494

Posted on by Annie D

I love this feature so much, I turned it off!
For decades, Excel has been performing default data conversions:
Remove leading zeroes
Keep first 15 digits of long numbers and convert to scientific notation
Convert digits surrounding an E to scientific notation.

New in Insiders beta, Excel will ask if you want to do all three of those things. The first time, I was happy to click Don’t Convert.
But I think the real solution is to embrace all three options and turn all three of them off! They have been annoying us for so long. Why would you want Microsoft to ask, “Hey, should we Continue reading “Prevent Excel From Changing Numbers On Import – 2494” →

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

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