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!
Curriculum
21 Sections
0 Lessons
1 Hour
Expand all sectionsCollapse all sections
01. SSIS - What you need to get started
0
02. Getting Started
0
03. SQL Server Integration Services Overview
0
04. Introduction to the Development Environment (Introduction to SQL Server Data Tools)
0
05. Introduction to the Development Environment (Connection Managers)
0
06. Introduction to the Development Environment (Precedence Contraints and Control Flow Tasks)
0
07. Loading Data with the Data Flow (Common Sources)
0
08. Loading Data with the Data Flow (Common Transforms)
0
09. Loading Data with the Data Flow (Common Destinations)
0
10. Using Variables, Parameters and Expressions (Using Variable and Parameters)
0
11. Using Variables, Parameters and Expressions (SSIS Expression Language and Parameterized Objects)
0
12. Using Containers (Grouping, Sequence and For Loop Container)
0
13. Using Containers (For Each Loop Container)
0
14. Troubleshooting SSIS
0
15. Loading a Dimension (Designing a Data Warehouse)
0
16. Loading a Dimension (Loading Dimension Tables)