Category: Power BI

How To Create 3D Scatter Plots In Power BI Using Python

Posted on by Annie D

3D scatter plots are mainly used to plot data points in three axes with the objective of showing the relationship between three variables. In this video, Gaelim is going to demonstrate how you can make a 3D scatter plot on Power BI using Python code.

***** Video Details *****
00:00 Introduction
00:44 Data set
01:03 Importing packages
02:06 Loading seaborn data set
02:45 Dimensions & metrics
03:05 Setting x, y, z variables
03:38 Creating a figure
05:44 Creating plots
08:00 Setting axes names
09:09 Interactivity
10:10 Altering viewpoint
11:10 Bringing into Power BI

***** 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 “How To Create 3D Scatter Plots In Power BI Using Python” →

What’s up with the different JOINS in Azure SQL and Azure Synapse?

Posted on by Annie D

Not sure what the different JOINs mean in Azure Synapse Analytics and Azure SQL Database? Patrick walks you through the different types to get you on the right path!

Joins (SQL Server)
https://docs.microsoft.com/sql/relational-databases/performance/joins?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
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Continue reading “What’s up with the different JOINS in Azure SQL and Azure Synapse?” →

Forecasting Analysis in Power BI

Posted on by Annie D

When is it?
June 28th – 6pm Los Angeles (PDT), 9pm New York (EDT)
June 29th – 2am London (BST), 11am Sydney (AEST), 1pm 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 Gaelim Holland, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Master complex data model techniques especially when running forecasting analysis
• Learn how to develop entire reporting solutions and models
• Compare trends and results through time effectively

If you have questions regarding this training, please send Continue reading “Forecasting Analysis in Power BI” →

The Best Data Type For Calendar Tables In Power BI

Posted on by Annie D

Using a Calendar Table in Power BI can allow you to filter your reports by time intelligence attributes like Year, Quarter, Month, and any other time aggregation by non-standard columns that your organization might need. In this video, Reid is going to talk about some considerations related to the calendar table, more specifically on what data types are best to be set when displaying certain things on various visual axis.

***** Video Details *****
00:00 Introduction
00:49 Creating custom column
01:45 Text data
01:57 Date data
03:49 Noisy axis
04:19 Self-contain

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>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/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial

Why can’t Power BI connect to my cloud source???

Posted on by Annie D

You have a cloud data source like Azure SQL Database. Why can’t Power BI connect to it? They are both in the cloud! Adam shows you some things to consider and options you have!

What is an on-premises data gateway?
https://docs.microsoft.com/data-integration/gateway/service-gateway-onprem

What is a virtual network (VNet) data gateway?
https://docs.microsoft.com/data-integration/vnet/overview

📢 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
— <a Continue reading “Why can’t Power BI connect to my cloud source???” →

Hiring in Analytics and Improving Data Literacy with Tim Freestone

Posted on by Annie D

A company’s success directly correlates with its people which is why employers and HR/talent acquisition personnel are constantly improving how they find, hire, and retain the best candidates. Data analytics plays a major role in this process.

In this episode of The Analytic Mind Podcast, Sam McKay is joined by Tim Freestone, founder of Alooba, to talk about hiring in analytics and data literacy.
From the big issues with CVs, and interviews, where companies typically go wrong to future trends in hiring and improving data literacy.

Tim Freestone has spent his career in analytics, starting initially as a financial analyst. Throughout his career, Continue reading “Hiring in Analytics and Improving Data Literacy with Tim Freestone” →

How To Visualize A Variable’s Distribution Alternatives With Seaborn

Posted on by Annie D

When working with a data set that comprises of multiple variables, it’s best to be able to make sense how these differ and interact with each other. In this tutorial, George is going to demonstrate how you can use the Seaborn function in Python to visualize alternatives of a variable’s distribution.

***** Video Details *****
00:00 Introduction
00:30 Data set
01:19 Histogram
03:46 Boxplot
05:12 Violinplot
06:20 Swarmplot
07:17 Stripplot

***** 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 Visualize A Variable’s Distribution Alternatives With Seaborn” →

From Decomposition Tree to Details in Power BI!!!

Posted on by Annie D

The Decomposition Tree is an amazing visual but how can we get to the details. Where’s my drill through? Patrick walks you through how you can set this up in Power BI Desktop!

Create and view decomposition tree visuals in Power BI
https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-decomposition-tree

Set up drillthrough in Power BI reports
https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough

Wyn Hopkins
https://twitter.com/wynhopkins

📢 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
— Continue reading “From Decomposition Tree to Details in Power BI!!!” →

Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!

Posted on by Annie D

Trying to get started with a Modern Data Lakehouse? There are so many options today. Where do you even begin? Patrick and Stijn help you get a handle on it with Azure Synapse Analytics!

Stijn Wynants
https://twitter.com/SQLStijn

Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake
https://sql-stijn.com/2022/06/14/building-a-modern-lakehouse-data-warehouse-with-azure-synapse-analytics-moving-your-database-to-the-lake/

Pipelines and activities in Azure Data Factory and Azure Synapse Analytics
https://docs.microsoft.com/azure/data-factory/concepts-pipelines-activities

Integrate with pipelines
https://docs.microsoft.com/azure/synapse-analytics/get-started-pipelines

📢 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 Continue reading “Modern Data Lakehouse? Where do you even start??? Azure Synapse of course!” →

How To Create Dynamic Temporal Scale In Power BI Pt.2

Posted on by Annie D

Every so often we’ll be needing the availability of a custom visual of a bar chart or line chart that gives an option to plot the chart either weekly, monthly, quarterly, or yearly. In this video, Greg is going to demonstrate how you can create dynamic temporal scale using a disconnected table in Power BI that can let you change the level of granularity depending on your date or time basis.

***** Video Details *****
00:00 Introduction
00:47 What is a dynamic temporal scale
00:50 Overview of Part 1
02:09 R10a_Table
05:23 The measure

***** Related Links *****
How To Create Dynamic Temporal Scale In Power BI Pt.1 – Continue reading “How To Create Dynamic Temporal Scale In Power BI Pt.2” →

Enterprise DNA Power Tools – Quick Measures Pro Pt.1

Posted on by Annie D

At Enterprise DNA, our goal is to help organizations turn data into insights so they can make better data-driven decisions. So we’re continuously updating our Power Tools so that you’ll have everything you need to create faster reports — all from one convenient location.

Power Tools is our suite of external tools designed by Microsoft MVP, Greg Deckler, to help you create faster reports and dashboards. In this video, Brian is going to do a deep dive into Quick Measures Pro, which is probably the most complex of the 5 available tools but is definitely well worth to learn as it’ll give Continue reading “Enterprise DNA Power Tools – Quick Measures Pro Pt.1” →

Practical Power Query Solutions – Nested Structured Values (Part 2)

Posted on by Annie D

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 16th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 17th – 5am Sydney (AEST), 7am 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 Melissa de Korte, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions – Nested Structured Values (Part 2)” →