When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 5 modules in 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.
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.
A Message from our Chief People Officer at PwC•1 minute
Overview of the first assignment•3 minutes
6 readings•Total 61 minutes
Course Overview and Syllabus•5 minutes
Meet the PwC Instructors and Content Developers•4 minutes
Electric Growers Dataset•20 minutes
Prior courses' resources•2 minutes
Experiencing challenges with the outcomes expected for this week? - Week 1•10 minutes
Electric Growers Simulation - Ask questions to understand the business problem•20 minutes
2 assignments•Total 60 minutes
Week 1 - Understanding the Business Problem•30 minutes
Electric Growers Simulation Quiz•30 minutes
2 discussion prompts•Total 20 minutes
Introduce yourselves and share your goals for this course•10 minutes
What questions do you have?•10 minutes
Analyzing the Business Problem
Module 2•3 hours to complete
Module details
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.
Week 2 - Overview of the second assignment•1 minute
2 readings•Total 25 minutes
Prior courses' resources•10 minutes
Experiencing challenges with the outcomes expected for this week? - Week 2•15 minutes
1 assignment•Total 30 minutes
Week 2 - Analyzing the business problem•30 minutes
1 peer review•Total 120 minutes
Peer review assignment 2•120 minutes
1 discussion prompt•Total 10 minutes
Alternative tools to solve business problems•10 minutes
Creating a visual representation of your analysis results
Module 3•3 hours to complete
Module details
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.
Week 3 - Overview of the third assignment•1 minute
2 readings•Total 25 minutes
Prior courses' resources•10 minutes
Experiencing challenges with the outcomes expected for this week? - Week 3•15 minutes
1 assignment•Total 30 minutes
Week 3: Creating a visual representation of your analysis results•30 minutes
1 peer review•Total 120 minutes
Peer review assignment 3•120 minutes
1 discussion prompt•Total 10 minutes
Share tips and best practices•10 minutes
Building a presentation for the client meeting
Module 4•3 hours to complete
Module details
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.
Week 4 - Overview of the fourth assignment•1 minute
2 readings•Total 25 minutes
Prior courses' resources•10 minutes
Experiencing challenges with the outcomes expected for this week? - Week 4•15 minutes
1 assignment•Total 30 minutes
Week 4 - Building a presentation for the client meeting•30 minutes
1 peer review•Total 120 minutes
Peer review assignment 4•120 minutes
1 discussion prompt•Total 10 minutes
What challenges did you face?•10 minutes
Presenting your results to the client
Module 5•3 hours to complete
Module details
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.
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.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.