Exploratory Data Analysis With Excel - Part 1 - Basic Numerics

David Langer
David Langer
59.2 هزار بار بازدید - 3 سال پیش - My full tutorial on exploratory
My full tutorial on exploratory data analysis (EDA) with Microsoft Excel. In this series I will introduce you to some of the most useful data analysis techniques in business analytics using trusty old Excel.

Throughout the series I will show you how to use the best that Excel has to offer for EDA:

1 - The mighty Data Analysis ToolPak
2 - Data visualizations like histograms, boxplots, and bar charts.
3 - Pivot tables
4 - Pivot charts

These are the same techniques that I've used in my hands-on analytics work (e.g., as part of my EDA for building machine learning models).


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


★★★ My online data analysis courses ▶ https://school.daveondata.com


-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
📗 Get the Excel workbooks 📗
All the Excel workbooks used in this series are available here:
https://github.com/DaveOnData/Explora...


📺 Part 2 of the Series - Basic Categoricals: Exploratory Data Analysis With Excel ...
📺 Part 3 of the Series - Histograms: Exploratory Data Analysis With Excel ...
📺 Part 4 of the Series - Box Plots: Exploratory Data Analysis With Excel ...
📺 Part 5 of the Series - Bar Charts: Exploratory Data Analysis With Excel ...
📺 Part 6 of the Series - Scatter Plots: Exploratory Data Analysis With Excel ...
📺 Part 7 of the Series - TreemapCharts: Exploratory Data Analysis With Excel ...


-----------------------------------------------------------------------------------------------------------------------
❓ Want to up-level your data analysis skills?
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 Introduction to Business Analysis wit...


🤖 From Excel to Machine Learning. No, Really! 🤖
Yes, you read that correctly. ANY professional can move from Excel pivot tables to analyzing data using machine learning. 💥

Check out the following YouTube video to learn more:
From Excel to Machine Learning. No, R...


Stay healthy and happy data sleuthing!

#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel
3 سال پیش در تاریخ 1400/02/01 منتشر شده است.
59,247 بـار بازدید شده
... بیشتر