DAY 5 | Data visualization (part 1) | 30 Day Excel Challenge | #dataanalysis #datascience #exceltips
Practice Excel for 30 Days with Stephen. In Day 5, we cover data visualization basics - why visualisation matters, good vs bad chart design, choosing the right chart type, building column, bar and line charts, adding a trend line, building and formatting a pie chart, and treemap charts. Timestamps: 0:00 - Intro: Why data visualization? 1:00 - Good vs bad chart design 3:00 - Choosing the right chart type 3:30 - Column chart: Monthly Sales 5:00 - Bar chart: comparing products 6:30 - Line chart intro 7:30 - Building a line chart (Profit Over Time) 9:30 - Adding a trend line 10:00 - Pie chart intro 11:00 - Building and formatting a pie chart 15:00 - Treemap chart 19:00 - Key takeaway Code + datasets: https://github.com/sdw-online/30-Day-Excel-Challenge Playlist: https://www.youtube.com/playlist?list=PL92LwdfbhlXG4E-u5i7ZnLq2HeQYLVnbM Join the waitlist: Free community - https://data100x.carrd.co/ Private community - https://data100.carrd.co/ Become a data analyst: Analyst Builder - https://www.analystbuilder.com/?via=stephen-david-williams Socials: LinkedIn - https://www.linkedin.com/in/stephen-david-williams-860428123/ GitHub - https://github.com/sdw-online TikTok - https://www.tiktok.com/@sdw.online Instagram - https://instagram.com/sdw.online Twitter/X - https://twitter.com/sdw_online #excel #dataanalysis #dataanalytics #excelchallenge #dataviz #charts
Download
0 formatsNo download links available.