Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Course
Microsoft Official Curriculum Course Number: 10778
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 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
Lab : Reporting and Analyzing Data
|
| | 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
Lab : Creating a Report with Report Designer
Lab : Enhancing and Publishing a Report
| | Lesson 3: Supporting Self Service Reporting | Introduction to Self Service Reporting
Shared Data Sources and Datasets
Report Parts
Lab : Implementing Self Service Reporting
| | Lesson 4: Managing Report Execution and Delivery | Managing Report Security
Managing Report Execution
Subscriptions and Data Alert
Troubleshooting Reporting Services
Lab : Configuring Report Execution and Delivery
| | Lesson 5: Creating Multidimensional Databases | Introduction to Multidimensional Analysis
Creating Data Sources and Data Source Views
Creating a Cube
Overview of Cube Security
Lab : Creating a Multidimensional Database
|
| | Lesson 6: Working with Dimensions | Configuring Dimensions
Defining Attribute Hierarchies
Sorting and Grouping Attributes
Lab : Defining Dimensions
| | Lesson 7: Working with Measures and Measure Groups | Working with Measures
Working with Measure Groups
Lab : Configuring Measures and Measure Groups
| | Lesson 8: Introduction to MDX | MDX Fundamentals
Adding Calculations to a Cube
Using MDX to Query a Cube
Lab : Using MDX
| | Lesson 9: Customizing Cube Functionality | Working with Key Performance Indicators
Working with Actions
Working with Perspectives
Working with Translations
Lab : Customizing a Cube
|
| | 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
Lab : Using PowerPivot for Excel
| | Lesson 11: Introduction to DAX | DAX Fundamentals
Using DAX to Create Calculated Column and Measures in a Tabular Data Model
Lab : Creating Calculated Columns and Measures by Using DAX
| | 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
Lab : Working with an Analysis Services Tabular Data Model
| | Lesson 13: Creating Data Visualizations with Power View | Introduction to Power View
Visualizing Data with Power View
Lab : Creating Data Visualizations 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
Lab : Using Data Mining to Support a Marketing Campaign
| | |
*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.
Current User's Login:
Fill out the information as a first time user:
|
|
Live Instructor-led Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Dates
|
Filter By...
| Providers: |
|
Location: |
|
| Date Range: |
|
| Provider |
Location |
Date |
Type |
Duration |
Price |
0 course(s) |
|
Online Self-Paced Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Options
|
No online results
|