Analytics Bootcamp

Enhance your data analytics skills with our Analytics Bootcamp, designed for data analysts aiming to master data modeling, visualization, and Excel-based reporting.

Course Thumbnail

Essential Skills Gained

Checkmark

Acquire skills in data source integration and transformation.

Checkmark

Design data models for optimal performance.

Checkmark

Visualize data using advanced Excel features.

Checkmark

Implement dashboards for insightful data reporting.

Format

  • Instructor-led
  • 5 days with lectures and hands-on labs.

Audience

  • Data Analysts
  • Excel Power Users
  • Business Intelligence Professionals
  • Data Visualization Experts

Description

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.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Modelling the Data

  1. Getting, Leaning, Transforming, and Loading Data from Different Data Sources

  2. Designing and Developing Data Models

  3. Creating Measures by Using DAX

  4. Optimizing Model Performance

Module 2: Visualizing and Optimizing Data Models

  1. Creating Reports and Dashboards

  2. Enhancing Reports to Expose Insights

  3. Performing Advanced Analysis

Module 3: Visualizing and Analysing Data with Excel

  1. Data Analysis Scenarios and Tools

  2. Excel Charts

  3. Formulas and Functions

  4. Analysing Data with Data Validation, Forms, and Controls

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

  1. Visualizing Data with Pivot Charts

  2. Filtering Data Using Slicers

  3. Creating Dashboards in Excel

  4. Creating Map Charts in Excel

  5. Formatting and Customizing Map Charts in Excel

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

  1. Creating and Analysing Pivot Table Data

  2. Creating and Analysing Power Pivots

  3. Analysing Pivot Table Data

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.