Data Analysis and Presentation Skills: the PwC Approach Specialization Course Syllabus

Overview (80-120 words) describing structure and time commitment.

Module 1: Data-driven Decision Making

Estimated time: 8 hours

• Understand the importance and role of data in business decisions
• Learn the evolution of big data
• Explore key analytical concepts
• Apply data thinking to real-world business scenarios

Module 2: Problem Solving with Excel

Estimated time: 8 hours

• Practice essential Excel functions for business analysis
• Use formulas to manipulate and analyze datasets
• Apply pivot tables for summarizing data
• Develop structured problem-solving approaches using Excel tools

Module 3: Data Visualization with Advanced Excel

Estimated time: 8 hours

• Build interactive dashboards using PowerPivot
• Create advanced data models in Excel
• Design visual reports for decision support
• Present findings clearly through charts and tables

Module 4: Effective Business Presentations with PowerPoint

Estimated time: 8 hours

• Structure impactful business presentations
• Design slides for clarity and professionalism
• Use storytelling techniques to communicate insights
• Deliver data-driven narratives effectively

Module 5: Capstone Project

Estimated time: 8 hours

• Solve a mock client business challenge
• Apply end-to-end data analysis workflow
• Create a final presentation using Excel and PowerPoint

Prerequisites

• No prior data analysis experience required
• Basic familiarity with Microsoft Office recommended
• Access to Microsoft Excel and PowerPoint (any recent version)

What You'll Be Able to Do After

• Develop practical data analysis skills using Microsoft Excel
• Create compelling data visualizations and dashboards
• Enhance problem-solving abilities through data-driven decision-making
• Build dashboards, create visualizations, and deliver impactful presentations
• Present data insights effectively to business stakeholders