AZA-BC: Analytics Bootcamp
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