Month: May 2022

Enterprise DNA Challenge 19 Judging Of Entries – Winners Announcement

Posted on by Annie D

In this video, we’re revealing the winners of Enterprise DNA Challenge 19 and show how the judging process to our Data Challenges typically goes. Brian, Federico, Alex and Sam give a walkthrough of the five winning entries for Challenge 19 where they share the criteria they apply when judging, their thoughts on what they liked about the reports and what they think it can still improve on.

Check out the rest of Challenge 19 entries in the Enterprise DNA Forum: https://forum.enterprisedna.co/t/challenge-19-call-centres-data-reporting/23987/

***** Video Details *****
00:00 Introduction
04:10 Categories
05:41 Report #1
13:18 Report #2
19:27 Report #3
31:52 Report #4
35:00 Report #5

***** Learning Continue reading “Enterprise DNA Challenge 19 Judging Of Entries – Winners Announcement” →

Sorted Summary Report WIth Totals In Excel Without A Pivot Table – 2487

Posted on by Annie D

A question from Elijah at the UCF Accounting Conference. I was showing how to use the UNIQUE function to get a list of products. Elijah asked if I could then get the total sales for each product. Plus a heading row and a total row. With the items sorted high to low.
The final result uses several new Excel functions: UNIQUE, SUMIFS, HSTACK, SORT, VSTACK, and LET.
This lets you create something that is like a pivot table, but there is no need to refresh as the data changes.
Table of Contents
(0:00) Welcome
(0:16) Formulas to Values
(1:08) UNIQUE list of products
(1:35) SUMIFS by Continue reading “Sorted Summary Report WIth Totals In Excel Without A Pivot Table – 2487” →

Excel Statistical Analysis 40: Confidence Interval for z Distribution, use when Sigma 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 known using the z Distribution and the Excel worksheet functions: NORM.INV, NORM.S.INV and NORM.CONFIDENCE.
Topics:
1. (00:00) Introduction
2. (00:22) Build Confidence Interval when Sigma is Known using the z Distribution
3. (02:59) Method #1 using: NORM.INV function
4. (04:15) Method #2 using: NORM.S.INV function
5. (05:27) Method #3 using: NORM.CONFIDENCE function
6. (06:20) Reasonable Statements that can be made when construction Confidence Intevals
7. (07:37) Be careful because Confidence Intervals do not always contain population Continue reading “Excel Statistical Analysis 40: Confidence Interval for z Distribution, use when Sigma Known” →

Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter

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 theory for why and how we use Confidence Intervals to estimate Population Parameters
Topics:
1. (00:00) Introduction
2. (00:22) Compare what we did in Chapter 7 (Compare Sample Mean to Sampling Distribution Of Sample Means or Standard Normal Curve) and Chapter 8 (Build Confidence Interval to estimate Reasonable Range for Population Parameter)
3. (05:47) Pictorial Example of risk associated with estimating Population Mean with a Confidence Interval
4. (07:19) Examples when Population Mean cannot be calculated
5. (08:09) Define Confidence Intervals
6. (12:01) Excel Worksheet Functions to create Confidence Intervals
7. (13:53) Continue reading “Excel Statistical Analysis 39: Confidence Intervals: Theory for Estimating Population Parameter” →

🔴 Power BI tips from the Pros – LIVE (May 21, 2022) (Member Chat 2nd Half)

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 “🔴 Power BI tips from the Pros – LIVE (May 21, 2022) (Member Chat 2nd Half)” →

Excel Statistical Analysis 38: Normal Bell Curve to Estimate Range of Sample Proportions

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 using the Normal Bell Curve to estimate a reasonable range of Sample Proportions.
Topics:
1. (00:00) Introduction
2. (00:21) Formulas for using Normal Bell Curve to estimate a reasonable range of Sample Proportion Values.
3. (02:42) Proportion of Americans who balance checkbook example.
4. (07:08) Proportion of insurance policies that fall within a two standard deviation margin of error
5. (09:56) Summary of video
6. (10:09) Closing, Next Video and Video Links

VLOOKUP Into “Vendor – URL” With TEXTBEFORE – 2486

Posted on by Annie D

Today’s Excel question from Willie at the UCF Accounting Conference:
I am using a vlookup to get some information from a vendor info database that comes from the credit card website.
 
My issue is that the vendor name sometimes comes with additional info at the end like …. “Contoso – cadet.biz” and in the table where I do the lookup the name is just “Contoso”.
 
I was wondering if you think I can use the “TEXTBEFORE” function with the Vlookup formula to make the formula to look in the table only for the first word of the info coming from the credit Continue reading “VLOOKUP Into “Vendor – URL” With TEXTBEFORE – 2486″ →

DAX Editor Pro – NEW Addition To Enterprise DNA Power Tools!

Posted on by Annie D

We’re ecstatic to announce the release of a new addition to Enterprise DNA Power tools — the DAX Editor Pro! DAX Editor Pro is a full-featured, lightweight replacement for the featureless native Power BI DAX editor.

In line with this, Brian is initiating a new weekly series that will go in-depth into each of the five tools within this suite, demonstrating how he uses them in his real-world report and Data Challenge entry development to show how it can dramatically speed up the report development process and add key functionality that Power BI has been missing for years.

The Enterprise DNA Power Continue reading “DAX Editor Pro – NEW Addition To Enterprise DNA Power Tools!” →

How do you share your Power BI Dataset for someone to review?

Posted on by Annie D

Need to have someone review your Power BI dataset for best practices and approval? Don’t want to send them the full Power BI Desktop file and risk sharing data? Patrick walks you through some options that you have.

📢 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/
— rel=”nofollow”>https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #Dataset #GuyInACube

🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)

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 “🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)” →

Building an Automated Machine Learning Platform For Better Data Culture With Shashank Kalanithi

Posted on by Annie D

Data is among the most valuable resources in an organization, and data analysts extract insights from said data to make smart business decisions. Analysts, however, can only work so fast. To extend the capabilities of Shashank’s team of data analysts, they developed a proof-of-concept based on machine learning to automate the analytics process and significantly accelerate the generation of actionable insights.

Shashank Kalanithi is a Senior Data Analyst at Nordstrom in Seattle, Washington, United States. In this episode, you’ll hear about his journey to becoming a Data Analyst despite having a Chemistry degree, his role on the Nordstrom Strategic Analytics Continue reading “Building an Automated Machine Learning Platform For Better Data Culture With Shashank Kalanithi” →

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Posted on by Annie D

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion!

DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/

Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

📢 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
— Continue reading “Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???” →