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.
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.
|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
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.
Virtual 10778 Implementing Data Models and Reports with Microsoft SQL Server 2012 Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet.
The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.
There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.
This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students.
You will hear and see your instructor as they teach the course and answer your questions via voice or text.
Choose the online live virtual training option and you can access the recorded version even after the class has finished.
The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.
Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.