8. Project Planning and Design - Data Analysis and Visualization with Excel

Project Planning and Design This class session focuses on Project Planning and Design for a data analytics project using Excel. Here is a breakdown of the topics covered: 0:01 Introduction to the Session & Final Project Plan 1:40 Choosing the Right Chart for Data Visualization 3:00 PROJECT: Providence Police Case Logs Analysis 6:20 Collaborative Project Planning (Roles and Workflow) 9:00 Excel Pivot Table & Analysis Setup 16:15 Creating and Customizing Scatter Plots & Trend Lines 24:00 Structuring the Presentation (Title, Introduction, Conclusion) 42:30 Project Management Tips (Mock Interviews & Rehearsals) 49:15 Final Project Submission Process & Calendar/Scheduling In this class, we begin the project planning and design phase of the learning journey. This session helps learners apply the concepts and skills developed throughout the program to a practical data analytics project. The focus is on defining the project objective, identifying the data needed, planning the analysis, and designing an effective approach for presenting insights. This class is designed especially for ESL learners, with guided instruction and practical examples to help learners confidently plan and organize a data analytics project. 🎥 Recording: This is the live class Zoom recording. It is provided as a learning resource for students to review the session, revisit demonstrations, reinforce concepts, and continue working on their project after completing the program. 📚 Program: Data Analytics & Visualization with Excel and Tableau Public 🎓 Designed for: ESL learners, adult learners, career changers, and professionals developing practical data analytics skills #DataAnalytics #ProjectPlanning #DataVisualization #Excel #TableauPublic #DataAnalysis #ESLLearners #DataSkills