About this course
Data analysts enable businesses to maximize the value of their data assets by using Microsoft Power BI. As subject matter experts, data analysts are responsible for designing and building scalable data models, cleaning and transforming data, and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. Data analysts also collaborate with key stakeholders across verticals to deliver relevant insights based on identified business requirements.
The data analyst should have a fundamental understanding of data repositories and data processing both on-premises and in the cloud.
Course Objectives
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Prepare the data (20-25%)
- Model the data (25-30%)
- Visualize the data (20-25%)
- Analyze the data (10-15%)
- Deploy and maintain deliverables (10-15%)
-
Module 1: Introduction to Data Warehousing
-
Module 2: Planning Data Warehouse Infrastructure
-
Module 3: Designing and Implementing a Data Warehouse
-
Module 4: Columnstore Indexes
-
Module 5: Implementing an Azure SQL Data Warehouse
-
Module 6: Creating an ETL Solution
-
Module 7: Implementing Control Flow in an SSIS Package
-
Module 8: Debugging and Troubleshooting SSIS Packages
-
Module 9: Implementing a Data Extraction Solution
-
Module 10: Enforcing Data Quality
-
Module 11: Using Master Data Services
-
Module 12: Extending SQL Server Integration Services (SSIS)
-
Module 13: Deploying and Configuring SSIS Packages
-
Module 14: Consuming Data in a Data Warehouse