Report Developers must hold unique traits to set themselves and their work apart from others. This class is designed to take you to the next level in your understanding of SQL Server 2016/2017 Reporting Services (SSRS). We use a variety of lab exercises to ensure lecture sessions are backed up by hands on experience. With the hands-on labs, you will learn how to create complex reports that use Analysis Services as a data source and custom code assemblies.
Overview
COURSE DIFFICULTY
COURSE DURATION
8h 25m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Embed Power BI reports in applications
Develop analytical models with SQL Server Analysis Services
BI Developers, Data Analysts, Database Administrators
Foundational SQL Server knowledge
01. Class Introduction
02. Report Design Patterns
03. Using SSAS as a Data Source (Designing a Basic Report - Multidimensional)
04. Using SSAS as a Data Source (Designing a Basic Report - Tabular)
05. Using SSAS as a Data Source (Building a Dynamic Report)
06. Using SSAS as a Data Source (Tips and Tricks)
07. .Net Integration (Why Use Custom Code)
08. .Net Integration (Embedded Custom Code)
09. .Net Integration (External Assemblies)
10. Advanced SSRS Expressions (Advanced Functions)
11. Advanced SSRS Expressions (Launch Office Tools From Your Reports)
12. Advanced SSRS Expressions (Launching Bing Maps)
13. Report Manager (Linked Reports)
14. Report Manager (Object Visibility)
15. Report Manager (My Reports)
16. Report Builder (Train the Trainer)
17. Report Builder (Using Report Parts)
18. SSRS Configuration (Setting up your SSRS Server)
19. Report Utilization (Setting up the Solution)
20. Report Utilization (Usage Reports)
21. Security (Assigning Report Server Permissions)
22. Security (Creating Custom Security Roles)
23. Performance Tuning (Report Snapshots)
24. Performance Tuning (Report Caching)
25. Performance Tuning (SSRS Performance Counters)
26. Planning a Web Farm Architecture
27. Data Driven Subscriptions (Building a Basic Subscription)
28. Data Drive Subscriptions (Using Data Driven Subscriptions)
29. Accessing Your Report Server Remotely
30. Miscellaneous (Creating Report Templates)
31. Miscellaneous (Using Document Maps)
32. Miscellaneous (Reporting On Recursive Data)
33. Miscellaneous (Refreshing Report Data From Word, PowerPoint, Etc.)
34. Miscellaneous (Using Reports to Start SQL Agent Jobs)
35. Power BI Integration (Deploying SSRS Report Visuals to Power BI)
36. Power BI Integration (Power BI Report Server)
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Publish and share reports through Power BI Service
Embed Power BI reports in applications
Develop analytical models with SQL Server Analysis Services
WHO SHOULD ATTEND
BI Developers, Data Analysts, Database Administrators
PREREQUISITES
Foundational SQL Server knowledge
COURSE OUTLINE
01. Class Introduction
02. Report Design Patterns
03. Using SSAS as a Data Source (Designing a Basic Report - Multidimensional)
04. Using SSAS as a Data Source (Designing a Basic Report - Tabular)
05. Using SSAS as a Data Source (Building a Dynamic Report)
06. Using SSAS as a Data Source (Tips and Tricks)
07. .Net Integration (Why Use Custom Code)
08. .Net Integration (Embedded Custom Code)
09. .Net Integration (External Assemblies)
10. Advanced SSRS Expressions (Advanced Functions)
11. Advanced SSRS Expressions (Launch Office Tools From Your Reports)
12. Advanced SSRS Expressions (Launching Bing Maps)
13. Report Manager (Linked Reports)
14. Report Manager (Object Visibility)
15. Report Manager (My Reports)
16. Report Builder (Train the Trainer)
17. Report Builder (Using Report Parts)
18. SSRS Configuration (Setting up your SSRS Server)
19. Report Utilization (Setting up the Solution)
20. Report Utilization (Usage Reports)
21. Security (Assigning Report Server Permissions)
22. Security (Creating Custom Security Roles)
23. Performance Tuning (Report Snapshots)
24. Performance Tuning (Report Caching)
25. Performance Tuning (SSRS Performance Counters)
26. Planning a Web Farm Architecture
27. Data Driven Subscriptions (Building a Basic Subscription)
28. Data Drive Subscriptions (Using Data Driven Subscriptions)
29. Accessing Your Report Server Remotely
30. Miscellaneous (Creating Report Templates)
31. Miscellaneous (Using Document Maps)
32. Miscellaneous (Reporting On Recursive Data)
33. Miscellaneous (Refreshing Report Data From Word, PowerPoint, Etc.)
34. Miscellaneous (Using Reports to Start SQL Agent Jobs)
35. Power BI Integration (Deploying SSRS Report Visuals to Power BI)
36. Power BI Integration (Power BI Report Server)
