Data Analysis and Presentation Skills: the PwC Approach Final Project

About this course: In this Capstone Project, you'll bring together all the new skills and insights you've learned through the four courses. You'll be given a 'mock' client problem and a data set. You'll need to analyze the data to gain business insights, research the client's domain area, and create recommendations. You'll then need to visualize the data in a client-facing presentation. You'll bring it all together in a recorded video presentation. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Created by:  PwC

• Taught by:  Alex Mannella, Alumni / Former Principal

Basic Info Course 5 of 5 in the Data Analysis and Presentation Skills: the PwC Approach Specialization Level Beginner Language English How To Pass Pass all graded assignments to complete the course. User Ratings 4.8 stars Average User Rating 4.8See what learners said Coursework

Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.

Help from your peers

Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.

Certificates

Earn official recognition for your work, and share your success with friends, colleagues, and employers.

PwC With offices in 157 countries and more than 208,000 people, PwC is among the leading professional services networks in the world. Our purpose is to build trust in society and solve important problems. We help organisations and individuals create the value they’re looking for, by delivering quality in assurance, tax and advisory services.

Syllabus


WEEK 1


Understanding the Business Problem



In this course, you will be using the skills you’ve been developing throughout the series of PwC courses to create and present a deliverable for a client.You’re going to determine your approach for analysis, use the information provided by the client to conduct an analysis, determine the best way to show your findings and then develop a plan to deliver your results and recommendations to the client in a video presentation.In this course, you will be acting as a consultant interacting with a client, Electric Growers. The client needs your strong data analytics and Excel skills to analyze data and help them make smart decisions to enable the company’s move into the security devices and services market. Each week, the client, represented by Michele Tran, a Vice President of Operations from Electric Growers, and the management team, will ask you to use and analyze the data, provided by the client, to answer a series of questions that will help them make decisions.You’ll receive peer feedback that you can use to enhance future presentations. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.


3 videos, 6 readings, 1 practice quiz expand

1. Video: Welcome to Course 5
2. Reading: Course Overview and Syllabus
3. Reading: Meet the PwC Instructors and Content Developers
4. Discussion Prompt: Introduce yourselves and share your goals for this course
5. Video: A Message from our Chief People Officer at PwC
6. Video: Overview of the first assignment
7. Reading: Electric Growers Dataset
8. Reading: Prior courses' resources
9. Practice Quiz: Week 1 - Understanding the Business Problem
10. Reading: Experiencing challenges with the outcomes expected for this week? - Week 1
11. Reading: Electric Growers Simulation - Ask questions to understand the business problem
12. Discussion Prompt: What questions do you have?

Graded: Electric Growers Simulation Quiz

WEEK 2


Analyzing the Business Problem



This week, you will be using the results of last week’s analysis to come up with some hypotheses. You will be answering questions such as: Who are the ideal customers that should be targeted? How should they be approached to maximize the sales of the client’s new home security systems? Using the data, figure out the attributes of the customer who wants to install an advanced, hi-tech security system and the attributes of a person who would switch security system providers. Continue to use the knowledge you’ve acquired in the other courses that you’ve taken in this series.


1 video, 2 readings, 1 practice quiz expand

1. Video: Week 2 - Overview of the second assignment
2. Reading: Prior courses' resources
3. Practice Quiz: Week 2 - Analyzing the business problem
4. Reading: Experiencing challenges with the outcomes expected for this week? - Week 2
5. Discussion Prompt: Alternative tools to solve business problems

Graded: Peer review assignment 2

WEEK 3


Creating a visual representation of your analysis results



This week, the client has more questions for you to answer to further develop the profile of potential customers. This includes finding which cities to target and how to evaluate them. You will have access to crime rates, population, housing growth city wide data and segmentation distribution dumps to help in your analysis.


1 video, 2 readings, 1 practice quiz expand

1. Video: Week 3 - Overview of the third assignment
2. Reading: Prior courses' resources
3. Practice Quiz: Week 3: Creating a visual representation of your analysis results
4. Reading: Experiencing challenges with the outcomes expected for this week? - Week 3
5. Discussion Prompt: Share tips and best practices

Graded: Peer review assignment 3

WEEK 4


Building a presentation for the client meeting



This week, you will be taking your findings and detailed analysis on plans to launch the new home security system and put them into a PowerPoint presentation deck for Michele Tran and the management team. The presentation should be about 10 slides and should follow the guidelines and best practices of presenting to a client that were covered in the earlier courses within this specialization. Ms. Tran wants to review it and give you feedback, if needed, before having it presented to the management team.This is a chance to use what you learned about creating a presentation, using PowerPoint tools, creating charts and other methods of enhancing a presentation.


1 video, 2 readings, 1 practice quiz expand

1. Video: Week 4 - Overview of the fourth assignment
2. Reading: Prior courses' resources
3. Practice Quiz: Week 4 - Building a presentation for the client meeting
4. Reading: Experiencing challenges with the outcomes expected for this week? - Week 4
5. Discussion Prompt: What challenges did you face?

Graded: Peer review assignment 4

WEEK 5


Presenting your results to the client



This week, Ms. Tran has reviewed your draft presentation so it is now time to refine and make changes or additions to enhance the presentation before presenting it to the management team via video. Once you’ve finalized your presentation, you will present it in a video using your smartphone or computer. When you’re satisfied with the PowerPoint presentation and video, you will be submitting both for peer review. You can use this feedback for current and future presentations that you will make during your career.


5 videos, 2 readings, 1 practice quiz expand

1. Video: Week 5 - Overview of the fifth assignment
2. Reading: Prior courses' resources
3. Practice Quiz: Week 5: Presenting your results to the client
4. Reading: Best tips for recording your own video
5. Discussion Prompt: Personal or professional application of your new skills
6. Video: Course closing - Outcomes from Electric Growers
7. Video: Course closing & Thank you
8. Video: Specialization closing
9. Video: Get Personal with Alex Mannella Podcast - Day in the Life

Graded: Peer review assignment 5: Deliver a virtual presentation