Learn to create scatter plots in Excel for powerful exploratory data analysis (EDA). In this full tutorial 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, box plots, bar charts, and scatter plots.
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: www.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
📗 Get the Excel workbooks 📗
All the Excel workbooks used in this series are available here:
github.com/DaveOnData/ExploratoryDataAnalysisWithExcel
📺 Part 1 of the Series - Basic Numerics: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1zEFJHbG0aE.html
📺 Part 2 of the Series - Basic Categoricals: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cHk81hqBv_I.html
📺 Part 3 of the Series - Histograms: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7QHcyrOOuZU.html
📺 Part 4 of the Series - Box Plots: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oc3vvwLxCls.html
📺 Part 5 of the Series - Bar Charts: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pNN1-IfsOF0.html
📺 Part 7 of the Series - TreemapCharts: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-cHk81hqBv_I.html
-----------------------------------------------------------------------------------------------------------------------
❓ Want to up-level your data analysis skills?
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xIXymabyFIM.html
🤖 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 RU-vid video to learn more:
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-b6hiyLEFA_M.html
Stay healthy and happy data sleuthing!
#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel #ScatterPlots #ScatterPlotsInExcel
14 май 2021