Month: May 2022

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

Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch07-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch07-ESA.pdf
Learn about one of the most power rules in statistics: the Central Limit Theorem by building a Sampling Distribution of Sample Means (Xbar). Learn how to calculate the Mean and Standard Deviation (Standard Error) for the Sampling Distribution of Sample Means (Xbar). Then see how the Central Limit Theorem is used to make business decisions using Hypothesis Testing, Confidence Intervals and the Excel worksheet functions NORM.DIST, NORM.S.DIST, NORM.S.INV and T.INV. Learn about the z distribution and the t distribution as models to represent the Sampling Distribution Continue reading “Excel Statistical Analysis 37: Learn Central Limit Theorem by Building Sampling Distribution of Xbar” →

Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar)

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch07-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch07-ESA.pdf
Learn about Sampling & Sampling Distribution of Sample Means (Xbar).
Topics:
1. (00:00) Introduction
2. (24:36) Chapter 7 Content
3. (00:58) Where we have come from, this chapter and next chapter
4. (02:13) Population, Sample and Sample Error, First Look
5. (03:22) Sampling Distribution of Xbar is model to help determine is an Xbar is reasonable
6. (04:06) Why do we take and need Samples?
7. (06:17) Sampled Population and Target Population
8. (09:15) What is a Frame?
9. (11:12) Sampling Methods: Simple Random Sampling and Random Sampling
10. (13:33) Definition of Simple Random Sampling
11. (14:13) Excel: Continue reading “Excel Statistical Analysis 36: Sampling & Sampling Distribution of Sample Means (Xbar)” →

Busn 135 – Business Math – Spring 2022 Introduction Video

Posted on by Annie D

Highline College Class. Busn 135 – Business Math – Spring 2022: Introduction Video. Class taught my Michael excelisfun Girvin at Highline College.
Highline web site for this class for matriculating students: https://people.highline.edu/mgirvin/AllClasses/135NoTextBook/135/135NoTextBookClass.htm
Free YouTube Class for this class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0kMy6GdNvsecPSOP5Tc_ydL

Excel Statistical Analysis for Business – Busn 210 – Spring 2022 Quarter Introductory Video

Posted on by Annie D

Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in spring quarter, 2022.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
The videos for this class will be released each week over the next few months.

Highline web site for this class: https://people.highline.edu/mgirvin/AllClasses/B210/M365ESA.htm
Free YouTube Class for this class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

BI 348 – Microsoft Power Tools – Highline College Spring 2022: Introduction Video

Posted on by Annie D

BI 348 – Microsoft Power Tools – Spring 2022: Introduction Video
Free YouTube Classes for this topic:
Data Analysis basics: https://www.youtube.com/playlist?list=PLrRPvpgDmw0lPPRiJO5dCUratRGpGx3aT
Data Analysis Advanced: https://www.youtube.com/playlist?app=desktop&list=PLrRPvpgDmw0ks5W7U5NmDCU2ydSnNZA_1
Highline College class web site for matriculating students: https://people.highline.edu/mgirvin/AllClasses/348/348/Spring2021BI348.htm

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