Course Overview
This course focuses on using Microsoft Excel for analyzing and visualizing Data. This course will expose you to the advanced analytical capabilities of Excel for modeling, analyzing and visualizing big data that will enable you to generate forward-looking insights from raw data.
You’ll learn how to import data from multiple sources and prepare data for analysis using Power Query. After connecting and preparing the data, you will also learn the techniques for modeling the data to optimize performance and perform advanced business calculations using DAX.
You’ll also gain hands-on experience on Dashboard design and principles.
By the end of this course, you'll be able to:
- Gather and transform data from multiple sources
- Perform advanced business calculations using DAX
- Create and model relationship among multiple tables
- Perform ETL (Extract, Transform and Load) operation in Excel
- Design Dashboards and reports using Pivot charts and slicers
Get Data
You'll learn how to connect, transform and load data from multiple sources include databases, pdf, csv and data from the web.
Data analysis
You'll learn how to analyze large datasets using Microsoft Excel formulas and PivotTables
Data Modeling
You'll acquire hands-on skills on how to connect, model and perform advanced calculations using PowerPivot and DAX
Data visualization
You'll learn how to visualize data using the advanced visualization capabilities of Microsoft Excel including Pivot charts, sparklines, conditional formatting. You will also learn how to build interactive dashboard using PivotTables, charts and slicers.
Course Content
Other On-Demand Courses
Stand out today with our Premium self-paced Online Courses