Month: June 2022

Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/Ch14-ESA.xlsm Download 2 PDF note files: https://excelisfun.net/files/Ch14-ESA.pdf, Download Deductive Proof 1 PDF: https://excelisfun.net/files/Linear%20Regression%20Slope%20Deductive%20Proof.pdf Download Deductive Proof 2 PDF (short version): https://excelisfun.net/files/Linear%20Regression%20Slope%20Deductive%20Proof-Shorter.pdf

Learn about the 12 important calculations for Linear Regression: Covariance, Correlation, Slope, Y Intercept, Sum of Squares Total = SST, Sum of Squares Regression = SSR, Sum of Squares Error (Residual) = SSE, R Squared = Coefficient of Determination, Mean Square Error, Standard Error of Estimate, p-value for F. See many diagrams, pictures and animations to help make the complicated math easy to understand.

Learn Continue reading “Linear Regression Made Easy! The Epic Full Story with all Details. Excel Statistical Analysis 50” →

How To Explore Datasets In Pandas With ProfileReport()

Posted on by Annie D

One of the most common questions you’ll encounter as a data analyst is how is the best way to explore a given data set. This is an important consideration primarily if you wan to put all the data together in a report that’s going to be easy to interpret by yourself or your team. In this tutorial, George is going to demonstrate how you can efficiently explore a dataset in Pandas using ProfileReport().

***** Video Details *****
00:00 Introduction
04:03 Overview of data set
04:33 Variables
06:06 Interactions
06:37 Correlations
07:17 Missing values
08:48 Sample
09:12 Example
10:50 Recap

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “How To Explore Datasets In Pandas With ProfileReport()” →

Answering your datamart questions

Posted on by Annie D

You’ve got a LOT of questions about datamarts in Power BI! Adam answers a few that we’ve seen popping up. Giving his thoughts on these questions.

Introduction to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Comparing dataflows to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts

When to use dataflows
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Answering your datamart questions” →

Leveraging the Power of Business Intelligence with Pascal Kiefer

Posted on by Annie D

There’s no question that it is important for companies to understand their data. The challenge most businesses face, however, is that they lack the time and manpower to gather, analyze, and report all of their relevant data. Moreover, big data has made it even more difficult for business owners to make decisions based on information spread out across multiple systems. How can businesses find solutions that will allow them to slice and dice data in many ways so that they can understand how different areas of the business perform?

Pascal Kiefer is a Business Intelligence enthusiast and the founder of K Continue reading “Leveraging the Power of Business Intelligence with Pascal Kiefer” →

Power BI dataflows vs datamarts: What’s the difference???

Posted on by Annie D

Are you excited about datamart in Power BI? What about dataflows? Should you even use dataflows anymore? Do we just datamart all the things? Let’s have a look!

Introduction to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Comparing dataflows to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts

When to use dataflows
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

Dataflows with benefits
https://ssbipolar.com/2022/05/25/dataflows-with-benefits/

📢 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
— rel=”nofollow”>http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

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

#PowerBI #datamart #GuyInACube

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

Enterprise DNA Challenge 7 Remake – Judging Of Entries

Posted on by Annie D

After Data Challenge 19, our data challenge community had grown up to 750+ members within 45 days. 52 posts had been viewed over 30k times and commented 500 times. Moreover, we were pleased to accept 55 final entries with 200+ analysis pages and 150+ navigation buttons. However, everyone wants to enjoy more! So we launched a one-week data challenge to remake/redesign Challenge 7 “Purchase, Inventory and Sales” .

The report that needed to be redesigned, was created by Enterprise DNA Expert, Mudassir Ali, back in September 2020. Participants needed to rethink, reimagine, reanalyze, and redesign the report. In this video, Federico, Brian and Mudassir, showcase the winning Continue reading “Enterprise DNA Challenge 7 Remake – Judging Of Entries” →