Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Course
Microsoft Official Curriculum Course Number: 10778
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.
|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.|
|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
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
Online Self-Paced Implementing Data Models and Reports with Microsoft® SQL Server® 2012 Training Options
No online results