OVERVIEW
Go beyond the basics and master data analysis with Microsoft Excel and Power BI in this three day, hands-on course. Microsoft Excel has been the standard tool for performing data analysis and visualization for over 30 years. It has a rich
set of features that include data storage, calculations and formulas, logical operators, interactive charts and graphs, and statistical and optimization functions. Microsoft Power BI is one of the most popular business analytics applications
today. It combines interactive visualizations and business intelligence capabilities with a simple drag-and-drop interface that allows users to easily create their own reports and dashboards. In this course, you will learn how to use both of these applications to manipulate and analyze data, generate interactive visualizations, and discover valuable insights.
WHAT YOU WILL LEARN
- How to work with large data sets,
- Clean and combine data sets,
- Work with pivot tables and slicers
- conduct statistical and sensitivity analysis, and
- create dashboards that communicate actionable business results.