AZA-BC: Analytics Bootcamp

Become an EPIC Affiliate

To view the class schedule you need to become an Affiliate

  • Largest “Guaranteed To Run” public technical training schedules available
  • Easy to become an Affiliate – no charge or fee
Become an EPIC Affiliate

already an Affiliate?  Login

About this Course

During this class, students will acquire skills and knowledge related to data functionalities such as data sources & models, best practices of transformation & visualization, usage of Excel as reporting tool, and spatial visualization using advanced Excel features.

Audience Profile

The Data Analyst should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.

At Course Completion

Outline

Module 1: Modelling the Data

Lessons

  • Getting, Leaning, Transforming, and Loading the Data from Different Data Sources
  • Designing and Developing Data Models
  • Creating Measures by Using DAX
  • Optimizing Model Performance

Module 2: Visualizing and Optimizing Data Models

Lessons

  • Creating Reports and Dashboards
  • Enhancing Reports to Expose Insights
  • Performing Advanced Analysis

Module 3: Visualizing and Analysing Data with Excel

Lessons

  • Data Analysis Scenarios and Tools
  • Excel Charts
  • Formulas and Functions
  • Analysing Data with Data Validation, Forms, and Controls

 

Module 4 – Part 1: Presenting Visual Insights with Dashboards and Geospatial Visualizations in Excel

Lessons

  • Visualizing Data with Pivot Charts
  • Filtering Data Using Slicers
  • Creating Dashboards in Excel
  • Creating Map Charts in Excel
  • Formatting and Customizing Map Charts in Excel

 

Module 4 – Part 2: Modelling and Analysing Data with Pivot Tables and Power Pivot

Lessons

  • Creating and Analysing Pivot Table Data
  • Creating and Analysing Power Pivots
  • Analysing Pivot Table Data

Prerequisites

This is a level 200 course; students should be familiar with:

 

  • Advanced Understanding of Excel Solutions
  • On-Premises Data Repositories
  • Understanding of Data Types
  • Advanced Understanding of Reporting Tools and Dashboards