AI Academy

Preparing Data for Analysis with Microsoft Excel

Instructor: Microsoft Duration: Approx. 19 hours
Objective 1 NEW [optional] introduction to Generative AI
Data Cleansing
Excel Formulas
Microsoft Excel
Power BI
Spreadsheet Software
Data Management
Data analysis
Productivity Software
Data Manipulation

Harnessing the Power of Data with Power BI

Instructor: Microsoft Duration: 7 hours to complete
Objective 1 How to recognize and use the key data analysis components of Microsoft Power BI.
Objective 2 Understand a Power BI data analyst's skills, tasks, and tools.
Objective 3 Describe the different stages in the data analysis process that result in data-driven decisions.
Data Collection
Microsoft 365
Data-Driven Decision-Making
Analytical Skills
Power BI
Data Transformation
Data analysis
Data Visualization Software
Business Intelligence

Extract, Transform and Load Data in Power BI

Instructor: Microsoft Duration: 4 hours to complete
Objective 1 How to set up a data source and explain and configure storage modes in Power BI.
Objective 2 How to prepare for data modeling by cleaning and transforming data.
Objective 3 How to use profiling tools to identify data anomalies.
Objective 4 How to reference queries and dataflows and use the Advanced Editor to modify code.
Data Cleansing
Data Validation
Data Integration
Data Storage
Extract, Transform, Load
Data Transformation
Data Quality
Power BI
Business Intelligence
Data Storage Technologies
Data analysis

Data Modeling in Power BI

Instructor: Microsoft Duration: 4 hours to complete
Objective 1 How to form a model using a Star Schema.
Objective 2 How to write calculations DAX to create elements and analysis in Power BI.
Objective 3 How to optimize performance in a Power BI model.
Data Analysis Expressions (DAX)
Data Transformation
Data Modeling
Time Series Analysis and Forecasting
Star Schema
Performance Tuning
Power BI
Database Design

Data Analysis and Visualization with Power BI

Instructor: Microsoft Duration: Approx. 29 hours
Objective 1 How to add visualizations to reports and dashboards.
Objective 2 How to design accessible reports and dashboards.
Objective 3 How to use visualizations to perform data analysis.
Data analysis
Business Intelligence
Statistical Reporting
Interactive Data Visualization
Data Visualization Software
Advanced Analytics
Data Presentation
Power BI
Dashboard
Data Storytelling
Business Reporting
Key Performance Indicators (KPIs)
Web Content Accessibility Guidelines

Creative Designing in Power BI

Instructor: Microsoft Duration: 1 week at 10 hours a week
Objective 1 How to create compelling and cohesive reports and dashboards.
Objective 2 How to work in detail with specialist chart visualizations.
Objective 3 How to add elements such as videos, streaming data and QR codes to dashboards.
Interactive Data Visualization
Power BI
Data Storytelling
Geospatial Mapping
Data Security
Real Time Data
Data Visualization Software
Data Presentation
Creative Design
Dashboard
Statistical Visualization

Deploy and Maintain Power BI Assets and Capstone project

Instructor: Microsoft Duration: 7 hours to complete
Objective 1 How to create and publish an app in Power BI.
Objective 2 How to implement dynamic reports in Power BI.
Objective 3 How to implement security measures and alerting in a Power BI report or dashboard.
Data Modeling
Data Security
Data Management
Dashboard
Data Visualization Software
Microsoft SQL Servers
SQL
Power BI

Microsoft PL-300 Exam Preparation and Practice

Instructor: Microsoft Duration: 7 hours to complete
Objective 1 Prepare the data with Power BI.
Objective 2 Model, visualize, and analyze the data in Power BI.
Objective 3 How to deploy and maintain Power BI assets.
Objective 4 NEW [optional] Generative AI for Power BI.
Data Modeling
Extract, Transform, Load
Data Visualization Software
Data Transformation
Interactive Data Visualization
Microsoft Copilot
Data Security
Microsoft Power Platform
Data analysis
Power BI
Microsoft Azure
Data Cleansing
Data Storytelling