This class builds on the concepts taught in the Power BI Beginner class. This class follows a similar process of walking through the Power BI Lifecycle. We start and go more in-depth on the M language. Next, we move into the desktop for data modeling and DAX before going into more advanced visuals and interactive report setup. We then cover aspects of using the Power BI Service that were not covered in the Beginner Power BI class.
Overview
COURSE DIFFICULTY
COURSE DURATION
9h 16m
Skills Learned
After completing this online training course, students will be able to:
Build ETL packages using SQL Server Integration Services
Develop analytical models with SQL Server Analysis Services
Create paginated reports using SQL Server Reporting Services
Write T-SQL queries for data retrieval and manipulation
Data Engineers, Database Administrators
None
01. DBA Fundamentals - What you need to get started
02. SQL Server Installation Options
03. Post-Install Configuration
04. Hardware and Virtualization Considerations
05. SQL Server On-Premises and in the Cloud
06. SQL Server and Database Security
07. Backups and Recoveries
08. Management Tools
09. Querying SQL Server
10. High Availability and Disaster Recovery Basics
11. Maintaining SQL Server and Maintenance Plans
12. Understanding SQL Server Agent
13. Baselines and Monitoring
14. Extended Events
15. Basic Troubleshooting and DMVs
16. Business Intelligence Administration (SSIS)
17. Business Intelligence Administration (SSAS)
18. Business Intelligence Administration (SSRS)
19. Class Survey
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build ETL packages using SQL Server Integration Services
Develop analytical models with SQL Server Analysis Services
Create paginated reports using SQL Server Reporting Services
Write T-SQL queries for data retrieval and manipulation
WHO SHOULD ATTEND
Data Engineers, Database Administrators
PREREQUISITES
None
COURSE OUTLINE
01. DBA Fundamentals - What you need to get started
02. SQL Server Installation Options
03. Post-Install Configuration
04. Hardware and Virtualization Considerations
05. SQL Server On-Premises and in the Cloud
06. SQL Server and Database Security
07. Backups and Recoveries
08. Management Tools
09. Querying SQL Server
10. High Availability and Disaster Recovery Basics
11. Maintaining SQL Server and Maintenance Plans
12. Understanding SQL Server Agent
13. Baselines and Monitoring
14. Extended Events
15. Basic Troubleshooting and DMVs
16. Business Intelligence Administration (SSIS)
17. Business Intelligence Administration (SSAS)
18. Business Intelligence Administration (SSRS)
19. Class Survey
