Month: May 2022

Excel Statistical Analysis 44: Hypothesis Testing with Z Distribution, 1 Tail Lower (Left) Test

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, Ch09-ESA-JustFormulas.pdf
Learn about One Tail Hypothesis Test to the Left with z Distribution. Learn about the Excel worksheet functions NORM.S.DIST and NORM.S.INV.
Topics:
1. (00:00) Introduction
2. (00:26) One Tail Test to the Left (Lower Test) with z Distribution from point of view of consumer group concerned with product consistency
3. (07:17) Calculate p-value using the NORM.S.DIST function
4. (08:50) Calculate critical value using the NORM.S.INV function
5. (10:36) Summary of video
6. (19:46) Closing, Next Video and Video Links

Excel Statistical Analysis 45: Hypothesis Testing with Z Distribution, Two Tail Test Example

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, Ch09-ESA-JustFormulas.pdf
Learn about Two Tail Hypothesis Test with z Distribution. Learn about the Excel worksheet functions NORM.S.DIST and NORM.S.INV

Topics:
1. (00:00) Introduction
2. (00:22) Two Tail Test with z Distribution from point of view of a manufacturer concerned with filling machine accuracy
3. (05:17) Calculate p-value using the NORM.S.DIST function
4. (07:39) Calculate critical value using the NORM.S.INV function
5. (09:31) Summary of video
6. (09:43) Closing, Next Video and Video Links

Enhanced Visualisation Frameworks for Power BI | Reporting & Data Visualization Summit Session 1

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit-free/

Session 1: Enhanced Visualisation Frameworks for Power BI

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

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

Who’s doing it?
Presented by Sam McKay, CFA – Founder, Enterprise DNA

During This Free Training, You Will Learn:

• Learn how to take a blank canvas to a compelling power BI report
• See how with some planning and a strong framework you can speed up your development 5x
• Create Power Continue reading “Enhanced Visualisation Frameworks for Power BI | Reporting & Data Visualization Summit Session 1” →

A new way to manage gateways in Power BI!!!

Posted on by Annie D

We now have a new way to manage gateways within Power BI and it is a much-welcomed update! Adam walks you through the experience to get you ready for it!

New data source and gateway management experience
https://powerbi.microsoft.com/blog/new-data-source-and-gateway-management-experience/

📢 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/
— <a href="https://guyinacube.com" Continue reading “A new way to manage gateways in Power BI!!!” →

The Importance Of Utilizing Unstructured Data With Kirk Marple

Posted on by Annie D

Data are not all created equal. There are structured (machine-generated) and unstructured (human-generated) data, and each requires a different approach. As a result of the increased use of digital applications and services, unstructured information is growing rapidly. It is estimated that 80-90% of company data is unstructured, and the amount of unstructured data continues to grow at an alarming rate per year.

In this episode of The Analytic Mind Podcast, Sam McKay speaks with Kirk Marple, the founder, and CEO of Unstruk Data. Hear about the hidden value in unstructured data and how it impacts the future of data and analytics.

The Continue reading “The Importance Of Utilizing Unstructured Data With Kirk Marple” →

Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch09-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch09-ESA.pdf, Ch09-ESA-JustFormulas.pdf
Learn about the 5 steps in hypothesis testing. Learn how to run a hypothesis test in Excel.
Topics:
1. (00:00) Introduction
2. (00:39) What is a Hypothesis and what is Hypothesis testing?
3. (07:07) 5 steps in Hypothesis Testing
4. (08:23) Variables for Hypothesis Testing
5. (10:40) One Tail Upper (Right) Example for Mean Salary of Realtors
6. (11:22) Step 1: Null and Alternative Hypothesis
7. (17:58) Step 2: Determine Alpha, Type 1 Error Risk. What is Type 1, Alpha, Risk?
8. (23:00) Step 3: Collect Data, Compute Test Statistic
9. Continue reading “Excel Statistical Analysis 43: Hypothesis Testing: P-value & Critical Value Methods: 1 Tail Upper” →

Another 30-Day Query Folding challenge!!!

Posted on by Annie D

Here is another 30-day Query Folding challenge video for you. Patrick takes on Day 7 and ramps up his Power Query knowledge! Will Power BI Desktop get the best of him???

GitHub Repot: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY

📢 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 “Another 30-Day Query Folding challenge!!!” →

Excel XLOOKUP Return Non Adjacent Columns – 2488

Posted on by Annie D

Another question from the UCF Accounting Conference. JoAnne asks… XLOOKUP can return multiple columns. What if you want to return several non-adjacent columns, for example, January, April, July, October?
There are three solutions presented here.
Table of Contents
(0:00) XLOOKUP return non-adjacent columns
(0:30) XLOOKUP with FILTER
(2:39) Using HSTACK
(3:17) VLOOKUP with Ctrl+Shift+Enter
(4:40) How would you solve it?

What Visual Filter Type To Use In Your Power BI Report

Posted on by Annie D

In this video, Reid talks about the types of interactions that visuals and other objects in a Power BI report page can have between each other, and the ways that they can cross-filter each other. He’ll also share some use cases as to why you might want to apply one type vs another, or even disable it entirely.

***** Video Details *****
00:00 Introduction
00:33 Default interactions
01:18 Cross-highlighting
01:42 Disabling
02:00 Cross-filtering
03:01 Report settings

***** 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 Continue reading “What Visual Filter Type To Use In Your Power BI Report” →

Excel Statistical Analysis 42: Confidence Interval for Proportions (Binomial Experiments)

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch08-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch08-ESA.pdf
Learn about how to build Confidence Interval for Proportions using Excel Formulas.
Topics:
1. (00:00) Introduction
2. (00:20) Confidence Internals for Proportions theory and formulas
3. (01:18) Employee Survey Example
4. (07:20) Furniture Company New Product example
5. (10:05) Summary of video
6. (10:14) Closing, Next Video and Video Links

Are you following best practices with Azure Synapse Analytics?

Posted on by Annie D

How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It’s a great way to get an understanding where your database is at!

Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance
https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-analyzer-report-to-monitor-and-improve-azure/ba-p/3276960

Download Location:
https://github.com/microsoft/synapse-analyzer/tree/main/Synapse%20BPA%20Report

Maximizing rowgroup quality for columnstore indexes in dedicated SQL pool
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-memory-optimizations-for-columnstore-compression

📢 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.

🎓 Continue reading “Are you following best practices with Azure Synapse Analytics?” →

Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch08-ESA.xlsm PDF notes file: https://excelisfun.net/files/Ch08-ESA.pdf
Learn about how to create Confidence Interval to estimate a population Mean when Sigma (Population Standard Deviation) is NOT Known using the t Distribution and the Excel worksheet functions: T.INV, CONFIDENCE.T and also the Data Analysis tool.
Topics:
1. (00:00) Introduction
2. (00:27) t Distributions: Characteristics
3. (04:20) t Distribution Confidence Interval Formula
4. (04:48) Excel T Functions
5. (05:26) How t Curve changes as the Sample Size, n, changes
6. (06:34) Printer Cartridge Example With formulas to calculate sample statistics
7. (08:55) Method #1: T.INV function
8. (09:54) Method #2: CONFIDENCE.T function
9. (11:15) Method Continue reading “Excel Statistical Analysis 41: Confidence Interval for t Distribution, use when Sigma NOT Known” →