Data Analysis and Presentation Skills: the PwC Approach

Welcome to Data-driven Decision Making. This course provides an introduction to data analytics and its role in making business decisions. You will learn about the importance of data, its evolution, and how "Big Data" is utilized. Additionally, you will be introduced to a framework for conducting data analysis and the common tools and techniques used in the process.

Problem Solving with Excel explores Excel as a tool for solving business problems. You will learn the basic functions of Excel through guided demonstrations and practical exercises. The course progresses to more advanced Excel skills, culminating in a final project that allows you to apply your knowledge in a simulated business setting.

Data Visualization with Advanced Excel provides hands-on instruction of advanced Excel 2013 functions. You will learn to use PowerPivot to build databases and data models, perform scenario and simulation analysis, and visualize data by leveraging Excel's built-in tools. The course also covers core principles of data visualization and dashboarding, equipping you with the skills to create dynamic dashboards in Excel.

Effective Business Presentations with PowerPoint focuses on presenting data effectively using PowerPoint. You will acquire skills in structuring presentations, incorporating insights and supporting data, and employing design principles for effective visuals and slides. The course also emphasizes client-facing communication, public speaking, executive presence, and compelling storytelling.

The Data Analysis and Presentation Skills: the PwC Approach Final Project integrates all the acquired skills from the preceding courses. In this capstone project, you will analyze a 'mock' client problem, research the client's domain area, gain business insights, and create recommendations. You will then visualize the data in a client-facing presentation and deliver it in a recorded video presentation.