Join us for industry experts Nerds – Power BI to Excel, a course designed to help you understand the basics of using Power BI and Excel together. In this course, you’ll learn how to bring data into Power BI, create simple visualizations, and then use Excel’s tools to further organize, analyze, and present that information. We’ll cover essential topics such as connecting to data sources, building easy-to-read dashboards, and enhancing your reports with interactive features in Excel. By the end of this course, you’ll feel more confident in your ability to handle data and share insights using both Power BI and Excel—no advanced technical skills required!
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 1m
Skills Learned
After completing this online training course, students will be able to:
Build ETL packages using SQL Server Integration Services
Design data transformation workflows and control flows
Deploy and schedule SSIS packages for production
Data Engineers, Database Administrators, Data Analysts
None
01. SSIS - What you need to get started
02. Getting Started
03. SQL Server Integration Services Overview
04. Introduction to the Development Environment (Introduction to SQL Server Data Tools)
05. Introduction to the Development Environment (Connection Managers)
06. Introduction to the Development Environment (Precedence Contraints and Control Flow Tasks)
07. Loading Data with the Data Flow (Common Sources)
08. Loading Data with the Data Flow (Common Transforms)
09. Loading Data with the Data Flow (Common Destinations)
10. Using Variables, Parameters and Expressions (Using Variable and Parameters)
11. Using Variables, Parameters and Expressions (SSIS Expression Language and Parameterized Objects)
12. Using Containers (Grouping, Sequence and For Loop Container)
13. Using Containers (For Each Loop Container)
14. Troubleshooting SSIS
15. Loading a Dimension (Designing a Data Warehouse)
16. Loading a Dimension (Loading Dimension Tables)
17. Loading a Fact Table
18. Deploying SSIS Packages
19. Configuring SSIS Packages for Portability
20. SSIS Server Executions
21. Setting Up Auditing and Notification
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build ETL packages using SQL Server Integration Services
Design data transformation workflows and control flows
Deploy and schedule SSIS packages for production
WHO SHOULD ATTEND
Data Engineers, Database Administrators, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. SSIS - What you need to get started
02. Getting Started
03. SQL Server Integration Services Overview
04. Introduction to the Development Environment (Introduction to SQL Server Data Tools)
05. Introduction to the Development Environment (Connection Managers)
06. Introduction to the Development Environment (Precedence Contraints and Control Flow Tasks)
07. Loading Data with the Data Flow (Common Sources)
08. Loading Data with the Data Flow (Common Transforms)
09. Loading Data with the Data Flow (Common Destinations)
10. Using Variables, Parameters and Expressions (Using Variable and Parameters)
11. Using Variables, Parameters and Expressions (SSIS Expression Language and Parameterized Objects)
12. Using Containers (Grouping, Sequence and For Loop Container)
13. Using Containers (For Each Loop Container)
14. Troubleshooting SSIS
15. Loading a Dimension (Designing a Data Warehouse)
16. Loading a Dimension (Loading Dimension Tables)
17. Loading a Fact Table
18. Deploying SSIS Packages
19. Configuring SSIS Packages for Portability
20. SSIS Server Executions
21. Setting Up Auditing and Notification
