Category: Power BI

How I learn things

Posted on by Annie D

People have asked how we know what we know about Power BI and other items like Video Editing or YouTube. In this video, I let you in on my process!

📢 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 Tools page – <a Continue reading “How I learn things” →

Power BI Self-service Implementation: What Is Required to Ensure Success With Lars Schreiber

Posted on by Annie D

If you are working in the BI & Analytics field, you may have heard of self-service business intelligence (BI). In fact, you might also have a strong interest in implementing Self-service BI into your organization.

Self-service BI systems like Power BI allow you to put your data models into the hands of many users and let them analyze their own data without the involvement of developers. While every organization is different, there are some general guidelines that can ensure a successful implementation.

Lars Schreiber is an independent consultant for Self-Service BI with Microsoft Power BI. He has more than 11 years Continue reading “Power BI Self-service Implementation: What Is Required to Ensure Success With Lars Schreiber” →

Dynamic X and Y Axis in Power BI visuals? Yes please!

Posted on by Annie D

Have you wanted both dynamic X and Y axis within a Power BI visual? Patrick shows you how you can use Field Parameters to accomplish it!

Let report readers use field parameters to change visuals
https://docs.microsoft.com/power-bi/create-reports/power-bi-field-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
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Continue reading “Dynamic X and Y Axis in Power BI visuals? Yes please!” →

🔴 Power BI tips from the Pros – LIVE (July 16, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 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 “🔴 Power BI tips from the Pros – LIVE (July 16, 2022) (Member Chat 2nd Half)” →

How To Put Thick Borders On Matrix Visualizations In Power BI

Posted on by Annie D

The matrix visual is a great data visualization technique when you need to to display categorical variables with text labels in your Power BI report, while being able to specify multiple variables in rows and columns. In this video, Greg is going to share some formatting tricks for matrix visualizations.

***** Video Details *****
00:00 Introduction
00:34 Data model
01:37 The dilemma
04:34 Customizing the visual

***** 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 href="http://www.enterprisedna.co/power-bi-resources" Continue reading “How To Put Thick Borders On Matrix Visualizations In Power BI” →

An Introduction to Deneb: Declarative Visualization In Power BI – New Course!

Posted on by Annie D

Deneb is a custom visual for Power BI, which allows the use of declarative JSON syntax of the Vega or Vega-Lite languages to build custom data visualizations, without having the need to learn web development. 

In this video, Brian chats with our resident Deneb expert, Greg Philps, as they introduce and give an overview on our newly released course titled “An Introduction to Deneb: Declarative Visualization in Power BI”. Watch to know what this new course is all about, how to make the best out of it, the major advantages of Deneb, and more!

Know more about the An Introduction to Deneb: Continue reading “An Introduction to Deneb: Declarative Visualization In Power BI – New Course!” →

🔴 Power BI tips from the Pros – LIVE (July 2, 2022) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 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 “🔴 Power BI tips from the Pros – LIVE (July 2, 2022) (Member Chat 2nd Half)” →

How To Integrate An Interactive Power BI Tile Into Power Apps

Posted on by Annie D

In this tutorial, Henry is going to show how you can integrate your Power BI reports into Power Apps including the ability to filter a variable or element in Power Apps while simultaneously being reflected in Power BI tiles as well.

***** Video Details *****
00:00 Introduction
00:43 Power BI dashboard
01:23 Creating a blank app
02:25 Adding a Power BI tile
03:35 Adding functionality
05:59 AllowNewAPI
07:06 Linking filter in Power Apps

***** 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 “How To Integrate An Interactive Power BI Tile Into Power Apps” →

Power Platform: Real World Experience and Applications with Henry Habib

Posted on by Annie D

Technology-based on no code enables effective “citizen development,” where business users can rapidly develop apps and virtual agents without extensive IT assistance. In order to meet this business need, Microsoft’s Power Platform combines the strengths of Power BI, Power Apps, Power Automate, and Power Virtual Agents.

Sam McKay interviews Enterprise DNA expert Henry Habib in this episode of The Analytic Mind Podcast. He talks about his real-world experiences as a Power Platform Consultant and his passion for teaching people how to succeed with no-code platforms.

Henry Habib is currently an engagement manager at a leading management consulting firm, where he advises F500 Continue reading “Power Platform: Real World Experience and Applications with Henry Habib” →

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