Implementing Data Models and Reports with SQL Server 2012 [MOC 10778]

På dette kursus lærer du, at understøtte information workers med self-service analyser og rapportering i SQL Server 2012. Du lærer at implementere PowerPivot og tabulare datamodeller, oprette arbejdsopgaver for visualisering af data med Power View og SQL Server Reporting Services samt få indblik i forretningen ved brug af data mining.


Indhold:
Introduction to Business Intelligence and Data Modeling

• Introduction to Business Intelligence
• The Microsoft Business Intelligence Platform

Implementing Reports with Reporting Services

• Introduction to Reporting Services
• Creating a Report with Report Designer
• Grouping and Aggregating Data in a Report
• Showing Data Graphically
• Filtering Reports Using Parameters

Supporting Self-Service Reporting

• Introduction to Report Builder
• Creating Reusable Report Items

Managing a Reporting Infrastructure

• Managing Security
• Managing Report Execution
• Delivering Reports with Subscriptions
• Troubleshooting Reporting Services

Creating Multidimensional Databases

• Introduction to Multidimensional Analysis
• Creating Data Sources and Data Source Views
• Creating a Cube
• Overview of Cube Security

Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attributes

Working with Measures and Measure Groups

• Working With Measures
• Working with Measure Groups

Introduction to MDX

• MDX Fundamentals
• Adding Calculations to a Cube
• Using MDX To Query a Cube

Customizing Cube Functionality

• Implementing Key Performance Indicators
• Implementing Actions
• Implementing Perspectives
• Implementing Translations

Implementing a Tabular Data Model by Using 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

Introduction to Data Analysis Expression (DAX)

• DAX Fundamentals
• Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

Implementing an Analysis Services Tabular Data Model

• Introduction to Analysis Services Tabular Data Model Projects
• Implementing an Analysis Services Tabular Data Model in Business Intelligence Development Studio

Creating Data Visualizations With Power View

• Introduction to Power View
• Visualizing Data with Power View

Performing Predictive Analysis with Data Mining

• Overview of Data Mining
• Using the Data Mining Add-In for Excel
• Creating a Custom Data Mining Solution
• Validating a Data Mining Model
• Connecting to a and Consuming a Data-Mining Model

Forudsætninger

Du forudsættes at være databaseudvikler samt have viden svarende til kurset Writing Queries with Microsoft SQL Server Transact-SQL [MOC 10774] (87214).

Kurset henvender sig til

Kurset henvender sig primært til databaseudviklere, der som BI udviklere skal have ansvaret for at oprette analysis og rapporteringsløsninger. Dine ansvarsområder vil typisk være:

• Implementering af rapporteringsløsninger ved brug af SQL Server Reporting Services
• Implementering af multidimensionelle databaser ved brug af SQL Server Analysis Services
• Oprette tabulare semantiske datamodeller til analyser ved brug af SQL Server Analysis Services
• Oprette visualisering af data ved brug af Power View