Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about how to use measures of variations to make decisions. Learn about variation visually, then learn how to calculate these measures of variation: Range, Variance, Standard Deviation, Coefficient of Variation.
Topics:
1. (00:00) Introduction
2. (00:51) Continue reading “Excel Statistical Analysis 13: Range, Variance, Standard Deviation, Coefficient of Variation”
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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (Jan 15, 2022)”
Download Excel File: https://excelisfun.net/files/EMT1772.xlsx
Learn how to perform Case Sensitive Lookup in Excel.
1. (00:00) Introduction
2. (00:05) Microsoft 365 Method with FILTER and EXACT functions.
3. (01:04) Any of the older versions of Excel: See Five Different formulas, including LOOKUP Continue reading “Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772”
We’re back with another installment to our Power BI Challenges. For this challenge, we’re going to work with OEE Manufacturing data. OEE is the gold standard for measuring manufacturing productivity. What this challenge will encourage you to do is to Continue reading “OEE Manufacturing Report – Power BI Challenge 18 Intro”
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
January 13th 2022, 5pm New York (ET), 2pm Los Angeles (PT) , 10pm London (GMT)
January 14th 2022, 9am Sydney (AEDT), 11am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where Continue reading “Power BI For Excel Users – Kick Start Your Analytics Journey”
Download Excel File: https://excelisfun.net/files/ETM1771-Ch03-ESA.xlsm
Learn how calculate the Mode in the First Quartile of Data. Then see a formula to calculate the Mode for each quartile of data. Learn about the functions: FILTER, QUARTILE.INC, MODE.MULT, TRANSPOSE and LET.
Learn Continue reading “FILTER, LET, TRANSPOSE and Other Excel Functions: Mode Calculation for each Quartile. EMT 1771”
Tired of having to wait for the next refresh to see current data in your Power BI Report? Hybrid Tables is here to help you! Patrick looks at how you can use this feature to have an imported table that Continue reading “Combining refresh and real time with Hybrid Tables in Power BI”
It is a little-known feature that you can automatically break the text in an Excel Textbox into multiple columns. Here is how to find the setting.
Download Excel File: https://excelisfun.net/files/Ch03-ESA.xlsm
Learn about calculating percentiles, quartiles, percentile rank and rank. Lean about two different algorithms for the percentile calculation. Learn about how to use eight different Excel built-in functions: ROWS, PERCENTILE.EXC, PERCENTILE.INC, MEDIAN, QUARTILE.EXC, QUARTILE.INC, Continue reading “Excel Statistical Analysis 12: Percentile, Quartile, Percentile Rank and Rank Functions & Algorithms”
Have you checked out sparklines in Power BI? Patrick explores how to set them up and also how you can be creative with them to add additional context to your reports!
KPI Video:
https://www.youtube.com/watch?v=zHzSBNES6jE
📢 Become a member: <a href="https://guyinacu.be/membership" Continue reading “Add a little info to your Sparkline in Power BI”
For today’s video, Brian will discuss one of his favorite techniques that uses custom icons in a dynamic way in Power BI visuals. This video is inspired by an entry over at the Enterprise DNA forum, wherein one of our Continue reading “How To Incorporate Dynamic Custom Icons Into Power BI”
If you type a date with a two digit year, Excel treats anything up to 29 as being 2029. Once you get to 30, though, they assume you mean 1930. With 2030 only eight years away, it might be time Continue reading “Excel Fix 2029 Rule for 2-Digit Year – 2458”