Category: Power BI

How To User Chat Functions In Power Automate

Posted on by Annie D

Did you know you can use Power Automate to create chat functions and bots within Teams? In this video, Henry shows you how you can mix Power Automate with Teams to create workflows that trigger every time a message is sent. If the message asks for specific information (like customer details), Power Automate returns those details for you – talk about Automation!  

***** Video Details *****
00:00 Introduction
00:42 Use case
03:35 Trigger
04:15 Message details
05:06 Parsing JSON object
09:12 Condition statement
09:33 Setting a variable

***** 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 User Chat Functions In Power Automate” →

How to make SQL Pools even faster in Azure Synapse Analytics

Posted on by Annie D

There are different ways you can get your SQL Pools to run faster in Azure Synapse Analytics. Patrick looks at a feature that can really take it to the next level! You seriously need to watch this if you are using Synapse dedicated SQL Pools.

Performance tuning with materialized views using dedicated SQL pool in Azure Synapse Analytics
https://docs.microsoft.com/azure/synapse-analytics/sql/develop-materialized-view-performance-tuning

📢 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!
*******************

— <a Continue reading “How to make SQL Pools even faster in Azure Synapse Analytics” →

A Visual Revolution Building a Scorecard Instantly w/ InfoRiver

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/a-visual-revolution-building-a-scorecard-instantly-with-inforiver-may-2022-registration/

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

When is it?
May 12th – 6pm New York (EDT), 3pm Los Angeles (PDT), 11pm London (BST)
May 13th – 8am Sydney (AEST), 10am Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Reid Havens (MVP), BI Evangelist & Instructor

During This Free Training, You Will Learn:

• Create everything from custom P&L reports to advanced scorecard dashboards with in-line visualizations in a matter of minutes using InfoRiver
• Discover the key points how to reduce development time from hours or days to minutes
• Showcase the newly Continue reading “A Visual Revolution Building a Scorecard Instantly w/ InfoRiver” →

How To Use MultiIndex In Pandas For Hierarchical Data

Posted on by Annie D

MultiIndex is a multi-level or hierarchical object for Pandas that allows you to select more than one row and column in your index. It also enables you to create sophisticated data analysis and manipulation, especially for working with higher dimensional data. In this video, George is going to explore the MultiIndex feature of Pandas.

***** Video Details *****
00:00 Introduction
00:22 Index hierarchy
00:46 Data set
01:44 Index 1
01:57 Index 2
02:34 Index 3
03:05 Index 4-5
03:43 Index 6
04:10 Index 7
04:50 Index 8
05:15 Index 9
05:46 Recap

***** 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 Use MultiIndex In Pandas For Hierarchical Data” →

REPLAY Power BI tips from the Pros – LIVE (May 7, 2022)

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 “REPLAY Power BI tips from the Pros – LIVE (May 7, 2022)” →

How To Correctly Count Slicer Selections In Power BI

Posted on by Annie D

In today’s tutorial, Brian works through a subtle issue with slicers that can trip you up if you’re not careful. As an added bonus, he has also included a sneak preview of a fantastic new external tool created exclusively for Enterprise DNA members by Microsoft MVP, Greg Deckler, that we will be rolling out next week.

***** Video Details *****
00:00 Introduction
01:44 DAX Editor Pro
02:00 Basic Count
03:20 The problem
04:45 Correct Count
05:06 ISFILTERED
12:50 Test run

***** Related Links *****
eDNA Power Tools – https://enterprisedna.co/tech/power-tools/

***** 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://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #DaxEditorPro

How to Create the Perfect Mobile Report Using HTML Custom Visuals

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/how-to-create-the-perfect-mobile-report-using-html-custom-visuals-may-2022-registration/

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

When is it?
May 5th – 2pm Los Angeles (PDT), 5pm New York (EDT), 10pm London (BST)
May 6th – 7am Sydney (AEST), 9am Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Pascal Kiefer – CEO & BI Consultant, K Team Solutions

During This Free Training, You Will Learn:

• Know the basics and considerations in creating mobile report
• Discover the key points how to scale the elements so they fit perfectly on a mobile screen
• Learn tips and tricks to design your very Continue reading “How to Create the Perfect Mobile Report Using HTML Custom Visuals” →

EFFICIENT approach in Microsoft Teams for Power BI questions!

Posted on by Annie D

Using Microsoft Teams? Have a central place for your Power BI folks in your organization? This efficient approach will help you to get your question to the right people! At the same time cutting down the noise for other folks.

Steve Campbell
https://twitter.com/PowerBISteve
https://www.linkedin.com/in/powerbisteve/

Power BI Support Channel: Microsoft Teams Tips
https://powerbi.tips/2022/04/power-bi-support-channel-in-teams/

Power BI adoption roadmap
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-adoption-roadmap-overview

Power BI implementation planning
https://docs.microsoft.com/en-us/power-bi/guidance/powerbi-implementation-planning-introduction

Manage tags in Microsoft Teams
https://docs.microsoft.com/en-us/microsoftteams/manage-tags

📢 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 Continue reading “EFFICIENT approach in Microsoft Teams for Power BI questions!” →

My Excel file is in the cloud! Why isn’t refresh working in Power BI???

Posted on by Annie D

Pulling data from an Excel document in the cloud? Is your Power BI dataset not refreshing? Adam looks at why this could be the case and how to get it working.

📢 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 – Continue reading “My Excel file is in the cloud! Why isn’t refresh working in Power BI???” →

How To Edit Data In R Using The DataEditR Package

Posted on by Annie D

DataEditR is an R package that will let you build dashboards and reports in R using a GUI, which is actually built using shiny, that makes it easy to interactively view, enter, filter and edit data. In this video, George is going to demonstrate how to do basic data editing and manipulation using DataEditR.

***** Video Details *****
00:00 Introduction
01:16 DataEditR
02:15 Ecdat
02:22 Data set
02:58 Data editor
04:25 Saving data
06:45 Saving selection
07:51 Recap

***** 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 Continue reading “How To Edit Data In R Using The DataEditR Package” →

Why you should look at Azure Synapse Analytics!

Posted on by Annie D

Have you heard about Azure Synapse Analytics! Is your data in Synapse? It’s so much more than SQL Server! Adam and Patrick look at why you should care about it!

What is Azure Synapse Analytics?
https://docs.microsoft.com/azure/synapse-analytics/overview-what-is

📢 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 “Why you should look at Azure Synapse Analytics!” →

How To Use Chi-square Test In Excel To Compare Variables

Posted on by Annie D

The chi-square test is a statistical non-parametric test used to compare two or more variables from randomly selected data. It helps find if there are any significant relationship between two or more categorical variables. In this video, George is going to teach how to use the chi-square test using Excel.

***** Video Details *****
00:00 Introduction
00:21 What is chi-square test?
01:40 Data set
01:52 PivotTable actual
02:42 Formula expected
05:07 85% significance level
05:40 Recap

***** 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 Continue reading “How To Use Chi-square Test In Excel To Compare Variables” →