Month: July 2022

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

Learn Excel From Mr Excel: SmartRoster Doesn’t Work, Microsoft Blocks Macros

Posted on by Annie D

Episode 2491 – While using SmartRoster software, you try to export a report to Word. The export does not start and you get a message that says, “Microsoft Word Security Notice. Microsoft Office has identified a potential security concern. Microsoft has blocked macros from running because the source of this file is untrusted.”

I recently posted episode 2485 that attempted to allow macros by using the Unblock checkbox in the workbook properties. That method won’t work here. Instead, you can temporarily set up a trusted location. This video shows you how.

Table of Contents
(0:00) Microsoft is blocking macros from running.
(0:53) Continue reading “Learn Excel From Mr Excel: SmartRoster Doesn’t Work, Microsoft Blocks Macros” →

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

M 365 Excel Worksheet Formulas & Models – Everything You Ever Wanted To Know – 365 MECS 03

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/03-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/03-M365ExcelClass.pdf
Topics in video:
1. (00:00) Introduction
2. (01:12) List of Formula Elements
3. (01:54) Discuss Different Formula Types
4. (05:16) Examples of Modes of Formula Editing
5. (07:35) Examples of the five Calculation Formula Types
6. (08:43) Type #1: Relative and Absolute Cell References in Single Input-Output Formula
7. (12:40) When you must use ROUND function
8. (15:34) Use General Number Format as eraser to remove Number Formatting
9. (16:56) Type #2: Dynamic Spilled Array Formulas
10. (19:35) Spilled Range Operator for Dynamic Spilled Array Formulas
11. (20:07) Type #3: Excel Table Formulas
12. (25:47) Summary about SIOF, DSAF Continue reading “M 365 Excel Worksheet Formulas & Models – Everything You Ever Wanted To Know – 365 MECS 03” →

🔴 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