Data Analysis Techniques, Modeling and Strategies

Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool. In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data.

CONTENT

• Introduction to Reporting in Excel
• Excel Tables
• Basic Pivot Tables
• Dashboards
• Profitability Analysis and Finding Anomalies
• Comparing Year over Year in Pivot Tables
• Reporting Hierarchical Data
• Introduction to multi-table pivot tables and the data modeling

TRAINING METHODOLOGY

The training methodology combines lectures, discussions, group exercises and illustrations. Participants will gain both theoretical and practical knowledge of the topics. The emphasis is on the practical application of the topics and as a result participant will go back to the workplace with both the ability and the confidence to apply the techniques learned to their duties.