DAY 30: FINAL PROJECT & COMPREHENSIVE ASSESSMENT

Guru Charan Pathalla

DAY 30: FINAL PROJECT & COMPREHENSIVE ASSESSMENT

Learning Objectives: - Complete end-to-end analytics project - Demonstrate all learned skills - Create comprehensive deliverable - Document analysis process - Present insights effectively

Topics Covered (60 min):

1. Project Requirements - Choose business scenario (Sales, HR, Finance, Operations) - Define business questions to answer - Identify data sources needed - Plan analysis approach - Determine deliverables

2. SQL Component - Data extraction queries - Complex aggregations and calculations - Window functions and CTEs - Views and stored procedures - Query optimization

3. Excel Component - Data import and transformation - Power Query and Power Pivot - Advanced formulas and calculations - Interactive dashboard - Professional formatting

4. Final Deliverable - Executive dashboard - Supporting analysis sheets - Documentation of methodology - Key insights and recommendations - Presentation-ready format

Video Resources:

  1. Optimizing ETL on SQL Server Side (5:10)
    https://www.youtube.com/watch?v=EPiCbUDWHvU

  2. SQL Best Practices - Designing An ETL (7:50)
    https://www.youtube.com/watch?v=sLhInuwdwcc

AI Learning Prompts (Concept Understanding Only):

Planning Final Project:

I'm planning my final analytics project. Please help:

1. What makes a strong data analytics portfolio project?
2. How do I choose a business problem to analyze?
3. What structure should my analysis follow?
4. How do I document my methodology?
5. What should I include in my deliverables?

Provide guidance for creating impressive project.

Presenting Insights:

Help me present data insights effectively:

1. How do I structure my findings (executive summary, details, recommendations)?
2. What visualizations best communicate different insights?
3. How do I tailor presentation to different audiences?
4. Show me how to create actionable recommendations
5. Provide examples of strong data storytelling

Explain best practices for communication.

Guided Practice (60 min):

📝 How to approach Guided Practice:

  • Follow step-by-step: Work through each exercise in order
  • Use provided resources: Reference the video tutorials and AI prompts if you get stuck
  • Verify your work: Check your results match expected outcomes
  • Take notes: Document key learnings and shortcuts you discover
  • Ask for help: Use AI assistants to clarify concepts you don't understand

FINAL PROJECT: Comprehensive Data Analysis & Dashboard

Goal: Demonstrate mastery of both SQL and Excel by completing an end-to-end analytics project.

Project Components:

  1. SQL Analysis (Choose one scenario): - E-Commerce: Sales performance, customer behavior, product trends, cohort analysis, RFM segmentation - HR Analytics: Employee retention, turnover analysis, performance metrics, headcount planning - Financial: Revenue/cost analysis, profitability by segment, budget vs actual, forecasting
  2. Required SQL Deliverables: - 10+ advanced queries demonstrating JOINs, CTEs, window functions, aggregations - At least 2 views for repeated reporting - Cohort/retention OR RFM analysis - Time-based analysis (YoY, MoM growth) - Complex business calculations with clear documentation
  3. Excel Dashboard: - Connect to SQL data via Power Query - Build Power Pivot data model with relationships - Create 8-10 KPIs with trend indicators - Design 5+ professional visualizations - Add interactive slicers and filters - Apply professional formatting and layout
  4. Documentation: - Brief business context and objectives - Key assumptions and methodology - Insights and recommendations - Instructions for refreshing data

🎓 Final Project Data Sandbox

To help you complete the SQL component of your final project, we have initialized a Universal Database containing data for all three scenarios (E-Commerce, HR, and Finance). You can use this sandbox to write and test your 10+ required queries.

📊 Available Tables:
  • Employees (HR)
  • Departments (HR)
  • Products (Sales)
  • Orders (Sales)
  • OrderDetails (Sales)
  • Customers (Sales)
  • Budget (Finance)

💡 Success Criteria:

  • Demonstrates technical mastery: Uses advanced SQL and Excel techniques appropriately
  • Provides business value: Delivers actionable insights, not just data
  • Professional quality: Clean, well-organized, production-ready
  • Complete solution: End-to-end from data to insights
  • Shows growth: Incorporates skills from across all 30 days

✅ Expected Outcome: Portfolio-ready project demonstrating comprehensive SQL and Excel skills for professional advancement

🔄 Congratulations! You've completed the 30-day SQL and Excel training program!

Independent Practice (60 min):

💡 Hints for Independent Practice:

  • Start simple: Begin with basic variations before attempting complex modifications
  • Break it down: Divide complex problems into smaller, manageable steps
  • Test incrementally: Verify each step works before moving to the next
  • Use documentation: Refer to official docs or tutorials when needed
  • Experiment: Try different approaches to find what works best

Apply the concepts learned to different datasets and scenarios.

Daily Assignment (60 min):

Assignment:

FINAL COMPREHENSIVE PROJECT:

Choose ONE scenario:

Required Components:

SQL Analysis:

Excel Dashboard:

Documentation:

Comprehensive Assessment:

- 60-minute test covering all 30 days

- Mix of Excel and SQL questions

- Practical problems to solve

- Upload final project + take assessment

Congratulations on completing the 30-Day Excel & SQL Training Program!

Expected Outcomes:

📝 Day 30 Quick Quiz - Test Your Knowledge!

Q1. As you near the end of the program, what does Day 30 emphasize?

Q2. How should you approach Day 30 exercises?

Q3. What makes Day 30 content valuable for your career?

Q4. By Day 30, what should you be comfortable with?

Q5. What's the best mindset for Day 30?

Have feedback or questions?