Category: Power BI

How To Create Your Perfect Power BI Template

Posted on by Annie D

In this tutorial, Brian is going to show how you can create your perfect Power BI template file. Creating such templates is definitely going to be a handy time-saver every time you start out a new Power BI report, and just as importantly it’s going to make Power BI work exactly the way you want it to based on your preferences and settings.

***** Video Details *****
00:00 Introduction
00:49 Color theme
01:41 Key measures table
02:02 Date table
07:40 Options
08:18 External tools
10:01 Data visualization pane
11:42 Blank button
13:32 Save file
14:55 JSON or Conductor Pro
15:39 Create icon

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide Continue reading “How To Create Your Perfect Power BI Template” →

How To Make Key Influencers And Linear Regression With Python

Posted on by Annie D

In this video, Gaelim is going to show how you can use a regression model to mimic some of the Power BI key influencers. Essentially, we want to use all odd variables to be able to describe what’s changing in another variable.

***** Video Details *****
00:00 Introduction
00:43 Overview
02:27 Libraries
04:16 Data set
04:35 Variable df
05:25 Dummy variables
07:11 x and y variables
07:29 Train and test set
07:47 Fit data to model
08:01 Influence/coefficients
09:34 XG boost model
11:20 Running in 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 – Ultimate Beginners Guide To Continue reading “How To Make Key Influencers And Linear Regression With Python” →

Enterprise DNA Power Tools – Quick Measures Pro Pt.2

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

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

Discovering data within Power BI and quickly EXPORT!

Posted on by Annie D

Sometimes you just don’t know what data is out there in Power BI. Patrick shows you how you can discover data available to you and also how to quickly export that data! Even with just a Pro account!

Data discovery using the data hub
https://docs.microsoft.com/power-bi/connect-data/service-data-hub?tabs=datasets

Create exportable formatted data tables in the Power BI service
https://docs.microsoft.com/power-bi/paginated-reports/paginated-formatted-table

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

How To Split Columns By Delimiters In Power BI Using DAX

Posted on by Annie D

In this tutorial, Brian is going to show how you can split columns by delimiters using DAX. This is something you’d probably know how to do easily using Power Query, and that’s generally the best route to do it. But there will be instances where you’re going to want to do it in DAX due the dynamic nature of the problem and specific considerations within the data model.

***** Video Details *****
00:00 Introduction
01:55 The problem
02:53 Data set
05:29 Film Path
06:48 Max Path Index
07:34 Top Word
08:37 DAX Query

***** Related Links *****
DAX Guide – https://dax.guide/

***** Learning Power BI? *****
FREE Continue reading “How To Split Columns By Delimiters In Power BI Using DAX” →

FAST – Billions of rows with Azure Data Explorer (ADX)

Posted on by Annie D

Have you tried Azure Data Explorer? We look at how ADX can support large amounts of data and query at blazing fast speeds. it truly is BANANAS! And you can try it for FREE!

Connect with Tzvia:
https://www.linkedin.com/in/tzvia/
https://twitter.com/tzvia

What is Azure Data Explorer?
https://docs.microsoft.com/azure/data-explorer/data-explorer-overview

Create a free Azure Data Explorer cluster
https://docs.microsoft.com/azure/data-explorer/start-for-free-web-ui

Azure Data Explorer (ADX) free cluster with Upgrade option
https://techcommunity.microsoft.com/t5/azure-data-explorer-blog/azure-data-explorer-adx-free-cluster-with-upgrade-option/ba-p/3576347

📢 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 Continue reading “FAST – Billions of rows with Azure Data Explorer (ADX)” →

How To Use Emojis In Power BI

Posted on by Annie D

In this video, Gaelim is going to demonstrate how you can leverage a Python package to analyze emojis and type this information into Power BI.

***** Video Details *****
00:00 Introduction
00:53 Importing libraries
01:56 Data set
02:40 Preprocessing
06:09 Creating function
07:13 Importing in Power BI
11:11 Demojize
13:06 Organizing emoji

***** 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 – 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 Continue reading “How To Use Emojis In Power BI” →

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

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