课程大纲

Overview:

Students will learn how to implement self-service analytics and reporting, to implement multidimensional analysis solutions, create PowerPivot and tabular data models, and deliver rich data visualizations with PowerView and SQL Server Reporting Services.

Who Should Attend:

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions.

Primary responsibilities include:

Implementing reporting solutions by using SQL Server Reporting Services.

Implementing multidimensional databases by using SQL Server Analysis Services.

Creating tabular semantic data models for analysis by using SQL Server Analysis Services. - Create visualizations of data by using PowerView.

Create data mining solutions by using SQL Server Analysis Services.

At Course Completion:

After completing this course, students will be able to:

Describe the components, architecture, and nature of a BI solution.

Create reports with Reporting Services.

Create reusable report items that simplify self-service reporting.

Manage report execution and delivery.

Create a multidimensional database with Analysis Services.

Implement dimensions in a cube.

Implement measures and measure groups in a cube.

Use MDX Syntax.

Customize a cube.

Implement a Tabular Data Model in PowerPivot.

Use DAX to query a tabular model.

Implement a Tabular Database.

Use PowerView to create interactive data visualizations.

Use Data Mining for Predictive Analysis. 

Prerequisite(s) or equivalent knowledge:

10774 Querying Microsoft SQL Server 2012

Prerequisite Comments:

Before attending this course, the student should have:

At least 2 years’ experience of working with relational databases, including: Designing a normalized database.

Creating tables and relationships.

Querying with Transact-SQL.

Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).

Some exposure to basic programming constructs (such as looping and branching).

An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Outline: 

Lesson 1: Introduction to Business Intelligence and Data Modeling

Introduction to Business Intelligence

The Microsoft Business Intelligence Platform

Lesson 2: Implementing Reports with SQL Server Reporting Services 

Introduction to Reporting Services

Creating a Report with Report Designer

Grouping and Aggregating Data in a Report

Showing Data Graphically

Filtering Reports by Using Parameters

Publishing and Viewing a Report

Lesson 3: Supporting Self Service Reporting 

Introduction to Self Service Reporting

Shared Data Sources and Datasets

Report Parts

Lesson 4: Managing Report Execution and Delivery 

Managing Report Security

Managing Report Execution

Subscriptions and Data Alert

Troubleshooting Reporting Services

Lesson 5: Creating Multidimensional Databases 

Introduction to Multidimensional Analysis

Creating Data Sources and Data Source Views

Creating a Cube

Overview of Cube Security

Lesson 6: Working with Dimensions 

Configuring Dimensions

Defining Attribute Hierarchies

Sorting and Grouping Attributes

Lesson 7: Working with Measures and Measure Groups 

Working with Measures

Working with Measure Groups

Lesson 8: Introduction to MDX 

MDX Fundamentals

Adding Calculations to a Cube

Using MDX to Query a Cube

Lesson 9: Customizing Cube Functionality

Working with Key Performance Indicators

Working with Actions

Working with Perspectives

Working with Translations

Lesson 10: Implementing a Tabular Data Model with Microsoft PowerPivot

Introduction to Tabular Data Models and PowerPivot Technologies

Creating a Tabular Data Model by Using PowerPivot for Excel

Sharing a PowerPivot Workbook and Using PowerPivot Gallery

Lesson 11: Introduction to DAX

DAX Fundamentals

Using DAX to Create Calculated Column and Measures in a Tabular Data Model

Lesson 12: Implementing an Analysis Services Tabular Data Model

Introduction to Analysis Services Tabular Data Model Projects

Developing an Analysis Services Tabular Data Model in SQL Server Data Tools

Lesson 13: Creating Data Visualizations with Power View

Introduction to Power View

Visualizing Data with Power View

Lesson 14: Performing Predictive Analysis with Data Mining

Overview of Data Mining

Creating a Data Mining Solution

Validating a Data Mining Solution

Consuming a Data Mining Solution