Month: April 2022

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

SQL For Power BI And DAX For SQL Users — Upcoming New Courses

Posted on by Annie D

Access the course here: https://portal.enterprisedna.co/p/sql-for-power-bi-users

A lot of reports we build in Power BI are based on SQL sources. Not only does SQL improve efficiency and refresh timings, it also allows us to improve the designs of our data models when we import the data in the format or shape we want through SQL.

In our upcoming new SQL courses developed by Enterprise DNA Experts, Hafiz Zubair and Antriksh Sharma, Power BI users can have a more thorough understanding of SQL, and the same for SQL users with DAX. Watch as Brian, Hafiz and Antriksh discuss the importance of Continue reading “SQL For Power BI And DAX For SQL Users — Upcoming New Courses” →

Nothing selected in Power BI Slicer? Then don’t show data!

Posted on by Annie D

Answering one of your Power BI questions about how to prevent data in a visual if nothing is selected in a slicer! Challenge accepted!

Do’s and Don’t with cascading slicers in Power BI
https://www.youtube.com/watch?v=1yv5srlqgmI

📢 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 Continue reading “Nothing selected in Power BI Slicer? Then don’t show data!” →

Find Next True And The Matching Records Above And Below – 2480

Posted on by Annie D

Michele has 46000 rows of data. Each ID has several records in a row. Many records are marked as “Changed”. When there is a change, Michele needs to check the record marked, plus the matching IDs just above and below.

In this video, I try Find All and 2 Advanced Filters. I bet you have something better.

Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch05-ESA.pdf
Learn about:
Topics:
1. (00:00) Introduction
2. (00:29) First look at binomial probability math formula.
3. (01:12) Requirements for a Binomial Experiment.
4. (04:46) Why the Binomial Probability Math Formula works. Look at Samples Points and AND Logical Test and the OR Logical Test. Learn about the reason the math formula is valid.
5. (10:06) BINOM.DIST and ) BINOM.DIST.RANGE Excel Built-in Functions.
6. (11:08) Meand and Standard Deviation formulas for a Binomial Experiment.
7. (11:38) Example with Excel formulas to calculate a Binomial Probability with 1) Sample Point Method, 2) Math Formula Method, 3) BINOM.DIST.RANGE Continue reading “Excel Statistical Analysis 27: Binomial Probability Distributions. BINOM.DIST.RANGE Function & Chart” →

Composite models in Power BI and Storage modes – what to pick???

Posted on by Annie D

When using composite models in Power BI, you have a choice for how to store your tables. Storage mode gives you options, but why would I pick one versus the other for my dimension tables? Adam has you covered!

Use composite models in Power BI Desktop
https://docs.microsoft.com/power-bi/transform-model/desktop-composite-models

DirectQuery model guidance in Power BI Desktop
https://docs.microsoft.com/power-bi/guidance/directquery-model-guidance

📢 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
— Continue reading “Composite models in Power BI and Storage modes – what to pick???” →

How To Execute And Interpret Paired Samples T-test In Excel

Posted on by Annie D

Comparing data sets can be a tedious and time-consuming task. Paired Samples T-test are commonly used to compare two variables for the same subject that are often separated by time. In this video, George will demonstrate how to efficiently execute and interpret a pair samples t-test in Excel.

***** Video Details *****
00:00 Introduction
01:36 Data set
02:45 Data analysis
03:06 Setting ranges
04:09 P value
05:03 Results
05:41 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 – Power BI Resources – <a href="http://enterprisedna.co/power-bi-resources" Continue reading “How To Execute And Interpret Paired Samples T-test In Excel” →

Excel Statistical Analysis 26: Accounting & Finance Discrete Probability Distribution Examples

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch05-ESA.xlsm
See two examples of how to use a Discrete Probability Distribution Accounting & Finance. See a cash flow example in Accounting and a Stock Return Example in Finance.
Topics:
1. (00:00) Introduction
2. (00:22) Accounting Example using Expected Value and Standard Deviation to estimate cash flows for a sales situation.
3. (03:51) Finance Example using Expected Value and Standard Deviation to estimate stock returns and risk of the stock.
4. (09:04) Summary of video
5. (09:17) Closing and Video Links

How To Automatically Send Emails By Linking Power BI And Power Automate

Posted on by Annie D

Have you ever wanted to link your Power BI reports to Power Automate? Have you ever wanted to execute a Power Automate workflow recursively to a list of user-selected records from a Power BI report? In this video, Tim and Henry show you how to connect Power BI and Power Automate. They first go through the simple example of sending emails to specific records, and then go through some bonus features (thresholds, etc.) that you can add to your Power BI reports to ensure your users don’t accidentally send thousands of emails.  

***** Video Details *****
00:00 Introduction
02:25 Data set
04:08 Potential issues
05:41 Continue reading “How To Automatically Send Emails By Linking Power BI And Power Automate” →

TOCOL & IF Functions to Convert Frequency Distribution into Original Column Of Data. EMT 1789

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1788-1789.xlsx
Learn how to convert frequency distribution into original column of data using the functions: SEQUENCE, IF and TOCOL. Lean about array operations of arrays with different dimensions.
Topics:
1. (00:00) Introduction
2. (00:28) Formula to convert frequency distribution into original column of data. See the functions SEQUENCE, MAX, IF, and TOCOL.
3. (02:56) Old Scholl way with Power Query
4. (03:13) Summary, Closing, Video Links

Excel Version History Improvements Thanks To Show Changes – 2479

Posted on by Annie D

A cool new feature from the MVP Summit: I previously mentioned how Show Changes debuted 9 months ago. Somewhere in the last nine months, the obscure Version History feature (found under File, Info) has gotten much better.
Save your document Continue reading “Excel Version History Improvements Thanks To Show Changes – 2479” →

DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row.

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1788-1789.xlsx
Learn how to create a formula Frequency Distribution Report with Total Row and learn how the DROP and TAKE Array Functions can be helpful in dynamic spilled array formula reports..
Topics:
1. (00:00) Introduction
2. (00:20) Continue reading “DROP, TAKE & VSTACK: How They Are Useful! Spilled Frequency Distribution with Total Row.” →