Online Course – PwC Certified Professional Internship in Data Analysis and Presentation Skills

Make smarter business decisions with data analytics. Understand data, use data analysis tools, and create smart and effective business presentations.

Suggested by: Coursera (What is Coursera?)

Start your Coursera.com free trial today
קורס אונליין - התמחות מקצועית מוסמכת במיומנויות ניתוח נתונים והצגתן של PwC

Professional Certificate

Beginners

No prior knowledge required

Time to complete the course

7-day free trial

No unnecessary risks

Skills you will acquire in the course

  • Understanding basic programming concepts
  • Ability to write code in Python
  • Solving problems logically
  • Working with variables and data
  • Using libraries and plugins
  • Performing basic data analysis
  • Building simple programming projects
  • Writing and understanding algorithms
  • Understanding of different programming paradigms
  • Ability to work with version control systems

What you will learn in the course

Courses for which the course is suitable

  • Data Analyst
  • Systems Analyst
  • Project Manager
  • Excel expert
  • Data analysis specialist
  • Business Presentation Manager
  • Business consultant
  • Business Insights Analyst

Internship – Series of 5 courses

If you work at PwC, you can access further training and free courses with the guidance in Vantage. This training will help you work practically with data analysis, turning business insights into actionable results.

We’ll look at how a combination of better understanding, filtering, and applying data can help you solve problems faster – leading to smarter, more effective decisions.

  • You will learn how to use Microsoft Excel, PowerPoint, and other common tools for data analysis and communication.
  • We will teach you how to present data to others so that they are excited about your story and motivated to take action.

Please note: If you would like to review the courses in this specialization, you will need to register for each course separately and then you will see the distinction option.

This specialization was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Hands-on Learning Project

This internship will have a project at the end of each module and a final project at the end of the internship. Each project will give you the opportunity to apply the skills from the class.

  • In the first module, plan an approach to analysis.
  • In the second and third modules, you will analyze data sets using the Excel skills you have learned.
  • In the fourth module, you will prepare a business presentation.

In the final project, you will apply the skills you have acquired by working on a business problem for an imaginary client. You will analyze a data set, explore business insights. You will then create and present your findings, before recording a video to present your recommendations to the client.

Details of the courses that make up the specialization

Data-driven decision making course

  • Course 1 • 8 hours • 4.6 (6,098 ratings)

Course Details

What you’ll learn
  • Welcome to the Data-Driven Decision Making course. In this course, you will learn about data analysis and its role in business decision making.
  • You will learn why data is important and how it evolved.
  • Be aware of “metadata” and how it is used.
  • You will receive a framework for performing data analysis and become familiar with common tools and techniques.
  • Upon completion, you will be able to apply your knowledge in a simulated business setting.

This course was created by PricewaterhouseCoopers LLP, located at 300 Madison Avenue, New York, NY 10017.

Skills you will acquire
  • Category: Data-driven decision making
  • Category: Metadata
  • Category: Data Analysis
  • Category: Data Design

Troubleshooting with Excel

  • Course 2 • 20 hours • 4.7 (5,364 ratings)

Course Details

What you’ll learn
  • This course explores Excel as a tool for solving business problems.
  • In the course, you will learn the basic functions of Excel through guided demonstration.
  • Each week you will build on your Excel skills and have the opportunity to practice what you have learned.
  • Finally, you will have a chance to submit a final project.

Please note that the content in this course was developed using the Windows version of Excel 2013.

This course was created by PricewaterhouseCoopers LLP, located at 300 Madison Avenue, New York, NY 10017.

Data visualization with advanced Excel

  • Course 3 • 15 hours • 4.8 (2,965 ratings)

Course Details

What you’ll learn
  • In this course, you will receive practical guidance on advanced functions in Excel 2013.
  • You will learn to use PowerPivot to build databases and data models.
  • We will learn how to perform different types of scenario analyses and simulations.
  • You will have the opportunity to practice these skills using Excel’s built-in tools such as Solver, Data Tables, Script Manager, and Queries.
  • In the second half of the course, we will learn how to visualize data, tell a story, and examine data by reviewing the core principles of data visualization and dynamic reports.

Please note: Participants will need PowerPivot to complete some of the exercises. Please use MS Excel 2013. If you have other versions of MS Excel or MAC, you may not be able to complete all tasks.

This course was created by PricewaterhouseCoopers LLP, located at 300 Madison Avenue, New York, NY 10017.

Skills you will acquire
  • Category: Business Dashboard
  • Category: Microsoft Excel
  • Category: Data Virtualization
  • Category: Data Visualization

Effective business presentations with PowerPoint

  • Course 4 • 10 hours • 4.5 (1,070 ratings)

Course Details

What you’ll learn
  • This course is about presenting the story of data, using PowerPoint.
  • You will learn how to build a presentation, include insights and supporting data.
  • You will also learn some design principles for effective visuals and slides.
  • You will acquire skills for communicating with customers – including public speaking, managerial presence, and persuasive storytelling.
  • Finally, you will be given a customer profile, a business problem, and a set of basic Excel charts, which you will need to turn into a presentation – which you will present with peer feedback.

This course was created by PricewaterhouseCoopers LLP, located at 300 Madison Avenue, New York, NY 10017.

Skills you will acquire
  • Category: Data Analysis
  • Category: Microsoft Excel
  • Category: Pivot Table
  • Category: Data Cleanup

Analysis and Presentation Skills: The PwC Approach – Final Project

  • Course 5 • 10 hours • 4.7 (249 ratings)

Course Details

What you’ll learn
  • In the final project, you will integrate all the new skills and insights you learned in the four courses.
  • You will be given a ‘mock’ customer problem and a data set.
  • You will need to analyze the data to generate business insights, research the customer’s field, and create recommendations.
  • You will then need to present the data in a presentation to the client.
  • Bring it all together in a recorded video presentation.

This course was created by PricewaterhouseCoopers LLP, located at 300 Madison Avenue, New York, NY 10017.

Skills you will acquire
  • Category: Data Analysis
  • Category: Communication
  • Category: Presentation Design
  • Category: Show

Related products