Data Analysis and Presentation Skills: the PwC Approach

Make Smarter Business Decisions With Data Analysis

Understand data, apply data analytics tools and create effective business intelligence presentations

About This Specialization

If you are a PwC Employee, gain access to the PwC Specialization and Courses for free using the instructions on the PwC L&D Spark page or simply search "Coursera" on PwC Spark. This Specialization will help you get practical with data analysis, turning business intelligence into real-world outcomes. We'll explore how a combination of better understanding, filtering, and application of data can help you solve problems faster - leading to smarter and more effective decision-making. You’ll learn how to use Microsoft Excel, PowerPoint, and other common data analysis and communication tools, and perhaps most importantly, we'll help you to present data to others in a way that gets them engaged in your story and motivated to act. What's more, should you enroll in these courses, you will be invited to join PwC's talent network. Those who opt into this talent network will receive information about PwC career opportunities, thought leadership, and happenings in the PwC global network. Please note: If you'd like to audit the courses in this Specialization, you'll need to enroll in each course separately and then you will see the audit option. This specialization was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Created by:

5 courses

Follow the suggested order or choose your own.

Projects

Designed to help you practice and apply the skills you learn.

Certificates

Highlight your new skills on your resume or LinkedIn.

Projects Overview

This specialization will include a project at the end of each module and a capstone project at the end of the specialization. Each project will provide you the chance to apply the skills of that lesson. In the first module you'll plan an analysis approach, in the second and third modules you will analyze sets of data using the Excel skills you learn. In the fourth module you will prepare a business presentation.

In the final Capstone Project, you'll apply the skills you’ve learned by working through a mock client business problem. You'll analyze a set of data, looking for the business insights. Then you'll create and visualize your findings, before recording a video to present your recommendations to the client.

Courses

Beginner Specialization.: No prior experience required.

COURSE 1
Data-driven Decision Making
Current session: Sep 18 — Oct 23.
Subtitles
English, Japanese
About the Course
Welcome to Data-driven Decision Making. In this course you'll get an introduction to Data Analytics and its role in business decisions. You'll learn why data is important and how it has evolved. You'll be introduced to “Big Data” and how it is used. You'll also be introduced to a framework for conducting Data Analysis and what tools and techniques are commonly used. Finally, you'll have a chance to put your knowledge to work in a simulated business setting. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
You can choose to take this course only. Learn more.
COURSE 2
Problem Solving with Excel
Upcoming session: Sep 25 — Oct 30.
Commitment
Approximately 4 weeks to complete. Expect to spend 3 hours a week completing the course content.
Subtitles
English
About the Course
This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project. Please note, the content in this course was developed using a Windows version of Excel 2013. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
You can choose to take this course only. Learn more.
COURSE 3
Data Visualization with Advanced Excel
Upcoming session: Sep 25 — Oct 30.
Commitment
4 weeks of study, 3-4 hours per week
Subtitles
English
About the Course
In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. You’ll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards. Note: Learners will need PowerPivot to complete some of the exercises. Please use MS Excel 2013 version. If you have other MS Excel versions or a MAC you might not be able to complete all assignments. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
You can choose to take this course only. Learn more.
COURSE 4
Effective Business Presentations with Powerpoint
Upcoming session: Sep 25 — Oct 30.
Commitment
4 weeks of study, 3-4 hours a week
Subtitles
English
About the Course
This course is all about presenting the story of the data, using PowerPoint. You'll learn how to structure a presentation, to include insights and supporting data. You'll also learn some design principles for effective visuals and slides. You'll gain skills for client-facing communication - including public speaking, executive presence and compelling storytelling. Finally, you'll be given a client profile, a business problem, and a set of basic Excel charts, which you'll need to turn into a presentation - which you'll deliver with iterative peer feedback. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.
You can choose to take this course only. Learn more.
COURSE 5
Data Analysis and Presentation Skills: the PwC Approach Final Project
Upcoming session: Nov 6 — Dec 18.
Subtitles
English
About the Capstone Project
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.
You can choose to take this course only. Learn more.

Creators

PwC works with clients all over the world, from the biggest global enterprises to small local businesses. Effective data analysis helps us develop solutions for the toughest problems our clients face. Our team is proud to bring the the latest and best strategic thinking, practical insight, and real-world experience to every project, and we are excited to share our proven methods with Coursera learners.
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.

Alex Mannella
Alumni / Former Principal

FAQs

More questions? Visit the Learner Help Center.