Exploratory Data Analysis With Excel - Part 7- Treemap Charts

Learn to create treemap 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, box plots, bar charts, scatter plots, and treemap 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: www.buymeacoff...
★★★ My online data analysis courses ▶ school.daveond...
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
📗 Get the Excel workbooks 📗
All the Excel workbooks used in this series are available here:
github.com/Dav...
📺 Part 1 of the Series - Basic Numerics: • Exploratory Data Analy...
📺 Part 2 of the Series - Basic Categoricals: • Exploratory Data Analy...
📺 Part 3 of the Series - Histograms: • Exploratory Data Analy...
📺 Part 4 of the Series - Box Plots: • Exploratory Data Analy...
📺 Part 5 of the Series - Bar Charts: • Exploratory Data Analy...
📺 Part 6 of the Series - Scatter Plots: • Exploratory Data Analy...
-----------------------------------------------------------------------------------------------------------------------
❓ 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 Busine...
🤖 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 TH-cam video to learn more:
• From Excel to Machine ...
Stay healthy and happy data sleuthing!
#ExploratoryDataAnalysis #ExploratoryDataAnalysisWithExcel #EDA #EDAwithExcel #TreemapCharts #Treemaps #TreemapChartsInExcel

[@DaveOnData]

💥 Learning R programming is easy for Excel users! 💥
th-cam.com/video/MNpsyjSuR20/w-d-xo.html
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:
📺 th-cam.com/video/xIXymabyFIM/w-d-xo.html

[@-Hussainnn]

The most useful thing I learned in this video is the way you managed to change the pivot table format, I didn't know you can do that! This will be useful for me

[@DaveOnData]

@-Hussainnn - Glad to hear it! Excel is a huge platform these days. There's always something new to learn.

[@pedroluisalcazar9285]

Great Series!!! thanks, love your way of teaching and personallity. Very usefull course. Best Regards from Bolivia

[@DaveOnData]

Wow! Thank you so much for the kind words.

[@Data_Mom]

Thank you @David Langer for creating "EDA with Excel" series, enjoyed all the sessions.

[@DaveOnData]

Thank you, Pooja! Glad you found the tutorial series useful.

[@mojazi7679]

You are really a good teacher! I watched all seven videos to explore data in Excel. All of them were quite informative and educational even though I had previously learned how to create these charts. I am definitely going to watch the R course and machine learning video.

[@malwalsabino519]

I have just finished all series on EDA in Excel. Simply awesome!
Excellent technique and clear explanation. Thank you so much

[@carolina.data.analyst]

I just watched all the series, thank you very much, all the information has been very usefull, i'm trying to analyze food prices by category and subcategory.

[@vivalancsweert9913]

The best tutorial as usually THANK YOU!!!!!

[@DaveOnData]

Thank you for the feedback, very much appreciated!
Glad you found the content useful.

[@Knowledge_Nuggies]

@7:57 and my last #outofcontext comment ;) thx for the gr8 video series

[@joeltochukwu4199]

Thanks. Your videos are very resourceful.

[@rhugvedsatardekar9229]

The tree maps are much more advanced in Power Bi. That is why we clean and transform the dataset in excel and use power bi for data modelling and visualization.

[@DaveOnData]

Thank you for sharing your workflow! Interestingly, you use Excel for data wrangling and not Power BI. Any particular reason?

[@randomlee7126]

ya when u look at the treemap and all you could hear is 'femaaaale' and 'maaale'

[@ChatGPT1111]

Maybe we should make one on who has to sign up for Selective Service