Exploratory Data Analysis With Excel - Part 5 - Bar Charts
Learn to create bar charts 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, 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/ExploratoryDataAnalysisWithExcel
📺 Part 1 of the Series - Basic Numerics: https://youtu.be/1zEFJHbG0aE
📺 Part 2 of the Series - Basic Categoricals: https://youtu.be/cHk81hqBv_I
📺 Part 3 of the Series - Histograms: https://youtu.be/7QHcyrOOuZU
📺 Part 4 of the Series - Box Plots: https://youtu.be/oc3vvwLxCls
📺 Part 6 of the Series - Scatter Plots: https://youtu.be/yUraF0Yk46o
📺 Part 7 of the Series - TreemapCharts: https://youtu.be/cHk81hqBv_I
-----------------------------------------------------------------------------------------------------------------------
❓ Want to up-level your data analysis skills?
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 https://youtu.be/xIXymabyFIM
🤖 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:
https://youtu.be/b6hiyLEFA_M
Stay healthy and happy data sleuthing!
#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel #BarCharts #BarChartsInExcel
Видео Exploratory Data Analysis With Excel - Part 5 - Bar Charts канала David Langer
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/ExploratoryDataAnalysisWithExcel
📺 Part 1 of the Series - Basic Numerics: https://youtu.be/1zEFJHbG0aE
📺 Part 2 of the Series - Basic Categoricals: https://youtu.be/cHk81hqBv_I
📺 Part 3 of the Series - Histograms: https://youtu.be/7QHcyrOOuZU
📺 Part 4 of the Series - Box Plots: https://youtu.be/oc3vvwLxCls
📺 Part 6 of the Series - Scatter Plots: https://youtu.be/yUraF0Yk46o
📺 Part 7 of the Series - TreemapCharts: https://youtu.be/cHk81hqBv_I
-----------------------------------------------------------------------------------------------------------------------
❓ Want to up-level your data analysis skills?
-----------------------------------------------------------------------------------------------------------------------
👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 https://youtu.be/xIXymabyFIM
🤖 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:
https://youtu.be/b6hiyLEFA_M
Stay healthy and happy data sleuthing!
#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel #BarCharts #BarChartsInExcel
Видео Exploratory Data Analysis With Excel - Part 5 - Bar Charts канала David Langer
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Python Crash Course: Part 13 - Using Lambdas](https://i.ytimg.com/vi/2YyrgxmDnv0/default.jpg)
![Machine Learning With Random Forests: Python in Excel Tutorial (Free Files)](https://i.ytimg.com/vi/QlfGkaNO9R8/default.jpg)
![Summary Statistics and Correlation Analysis in Excel Analysis ToolPak](https://i.ytimg.com/vi/NY6th5_WHuM/default.jpg)
![Excel Users: Do This to WOW Your Leaders!](https://i.ytimg.com/vi/O479uWMe_F0/default.jpg)
![Python Crash Course: Part 3 - Using Jupyter Notebooks](https://i.ytimg.com/vi/5wibG8wOXB8/default.jpg)
![Naive Bayes Classifiers for Text Documents: Python in Excel Tutorial (Free File)](https://i.ytimg.com/vi/p9TwKr5CY4w/default.jpg)
![Topic Modeling Text Documents With LDA: Python in Excel Tutorial (Free Files)](https://i.ytimg.com/vi/b91ohJvEst4/default.jpg)
![Introduction to SQL Programming for Excel Users Part 17 - JOIN Filtering](https://i.ytimg.com/vi/g-Kx0A4b9sk/default.jpg)
![Analyzing Data Scientist Jobs at Facebook](https://i.ytimg.com/vi/t3sz8X-kdMQ/default.jpg)
![Introduction to SQL Programming for Excel Users Part 11 - More CTEs & Windows](https://i.ytimg.com/vi/RcwX1Rel270/default.jpg)
![Python Crash Course: Part 5 - Python Lists Revealed!](https://i.ytimg.com/vi/XFBM4je9NgU/default.jpg)
![Introduction to SQL Programming for Excel Users Part 18 - Basic CASE WHEN](https://i.ytimg.com/vi/zxWREjAjTlo/default.jpg)
![Does Python in Excel Replace Excel Charts?](https://i.ytimg.com/vi/J7QjOqNSmVI/default.jpg)
![Introduction to SQL Programming for Excel Users Part 10 - Basic CTEs](https://i.ytimg.com/vi/sx3l7b9PMB0/default.jpg)
![Analytics Superpowers - Linear Regression](https://i.ytimg.com/vi/mqZ4GNQhEps/default.jpg)
![Python Crash Course: Part 15 - Data Visualization with plotnine](https://i.ytimg.com/vi/-VelTapncDs/default.jpg)
![What is Data Analysis? My Answer Based on 10 Years of Experience.](https://i.ytimg.com/vi/uiMIQ5sFBss/default.jpg)
![Introduction to SQL Programming for Excel Users Part 6 - More Feature Engineering](https://i.ytimg.com/vi/LGPtH3wm2xo/default.jpg)
![Python Crash Course: Installing Python on Windows](https://i.ytimg.com/vi/BFTEA9Jt7hI/default.jpg)
![Python Crash Course: Part 8 - Slicing Data](https://i.ytimg.com/vi/abkPCYHCUX4/default.jpg)