sql server business intelligence training

#SQL SERVER BUSINESS INTELLIGENCE TRAINING HOW TO#
#SQL SERVER BUSINESS INTELLIGENCE TRAINING FREE#

Students will become familiar with report deployment to the new Reporting Service Web Portal (replaced Report Manager) and learn how to use portal the management tools to configure report caches, snapshots and subscriptions. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps.Ĭonsuming data from relational, multi-dimensional and the new tabular data sources will be incorporated into report designs. Reports utilizing the newly designed charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine and exciting new report design enhancements.Īll reports are developed utilizing SQL Server Data Tools (SSDT), however the new 2016 Report Designer is also introduced.

Deploying, securing and accessing data in SSAS cubes.

Deploying and scheduling SSIS packages and projects.

General design overview of SSIS ETL package development.

Creating SSIS and SSAS projects using SQL Server Data Tools.

Configuring report snapshots, caches and subscriptions.

Deploying reports to the new Reporting Services Web Portal.

Creating calculated fields and custom report formatting.

Linking to parameterized child reports via hyperlinks or sub-reports.

Configuring report interactivity, including drill-downs, report maps and book marks.

Including report parameterization enabling filtering by users.

Adding images, page headers and footers and report metadata.

Using visualization objects to create Charts, Spark Lines, Data Bars and Tree Maps.

#SQL SERVER BUSINESS INTELLIGENCE TRAINING FREE#

Using the Tablix object to display information in Tables, Matrix (pivot tables) and free form Lists.

Creating multi-dimensional, two-dimensional and tabular data sources and sets.

Designing reports using SQL Server Data Tools (SSDT).

Installing and configuring SQL Server Reporting Services.

Sql server business intelligence training