This class is designed to help you understand all aspects of SQL Server Reporting Services (SSRS), the reporting tool of choice for SQL Server developers. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and to prepare you to build your own real world applications using this SQL Server subsystem. This course will cover all the key concepts of Reporting Services from basic reporting, parameters, deploying, and scheduling.
Overview
COURSE DIFFICULTY
COURSE DURATION
9h 51m
Skills Learned
After completing this online training course, students will be able to:
Develop analytical models with SQL Server Analysis Services
Write MDX queries for multidimensional analysis
Write T-SQL queries for data retrieval and manipulation
Database Administrators, Data Analysts
None
01. Getting Started
02. Getting Started with MDX
03. Building MDX Queries (MDX Query Editor)
04. Building MDX Queries (Basic Queries and Syntax)
05. Defining Sets (Basics)
06. Defining Sets (Manipulating Sets)
07. Defining Sets (Working with Hierarchies)
08. Adding Calculations to a Query (Basics)
09. Adding Calculations to a Query (Time Intelligence)
10. Creating Calculations in a Cube (Calculated Measures and Custom Members)
11. Creating Calculations in a Cube (Creating Sets)
12. Creating Calculations in a Cube (Creating KPIs)
13. MDX Scripting (Basics)
14. MDX Scripting (Allocations)
15. Optimizing MDX Queries
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Develop analytical models with SQL Server Analysis Services
Write MDX queries for multidimensional analysis
Write T-SQL queries for data retrieval and manipulation
WHO SHOULD ATTEND
Database Administrators, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Getting Started
02. Getting Started with MDX
03. Building MDX Queries (MDX Query Editor)
04. Building MDX Queries (Basic Queries and Syntax)
05. Defining Sets (Basics)
06. Defining Sets (Manipulating Sets)
07. Defining Sets (Working with Hierarchies)
08. Adding Calculations to a Query (Basics)
09. Adding Calculations to a Query (Time Intelligence)
10. Creating Calculations in a Cube (Calculated Measures and Custom Members)
11. Creating Calculations in a Cube (Creating Sets)
12. Creating Calculations in a Cube (Creating KPIs)
13. MDX Scripting (Basics)
14. MDX Scripting (Allocations)
15. Optimizing MDX Queries
