A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer
Niche
SQL Server 2012

Implementing Data Models and Reports with Microsoft SQL Server 2012
(Microsoft Training Course: 10778) - 5 days - £1850 exc VAT

Save up to 50% of the cost of some courses: check our Certification Packages or buy F1 Training Vouchers


> Target Audience
This course describes how to empower information workers through self-service analytics and reporting. The primary audience for this course are database professionals who need to fulfill BI Developer role to create analysis and reporting solutions.
> Course outline
  1. Introduction to Business Intelligence and Data Modeling
  2. Implementing Reports with Reporting Services
  3. Supporting Self-Service Reporting
  4. Managing Report Execution and Delivery
  5. Creating Multidimensional Databases
  6. Working with Dimensions
  7. Working with Measures and Measure Groups
  8. Introduction to MDX
  9. Customizing Cube Functionality
  10. Implementing a Tabular Data Model by Using Microsoft PowerPivot
  11. Introduction to Data Analysis Expression (DAX)
  12. Implementing an Analysis Services Tabular Data Model
  13. Creating Data Visualizations With Power View
  14. Performing Predictive Analysis with Data Mining
Module 1: Introduction to Business Intelligence and Data Modeling
  • Introduction to Business Intelligence
  • The Microsoft Business Intelligence Platform
  • Lab: Reporting and Analyzing Data
  • Exploring a Reporting Services Repot
  • Exploring a PowerPivot Workbook
  • Exploring a Power View Report
Skills
  • Describe common BI scenarios and current BI trends
  • Describe the main technologies that make up the Microsoft BI platform
top
Module 2: 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
  • Publishing and Viewing a Report
  • Lab: Implementing Reports with Reporting Services
  • Creating a Report
  • Grouping and Aggregating Data in a Report
  • Lab : Enhancing and Publishing a Report
  • Adding a Chart to a Report
  • Adding Parameters to a Report
  • Publishing a Report
Skills
  • Describe the key features of Reporting Services
  • Use Report Designer to create a report
  • Group and aggregate data in a report
  • Use charts and other visualizations to show data graphically in a report
  • Use parameters to filter data in a report
  • Publish and view a report
top
Module 3: Supporting Self-Service Reporting
  • Introduction to Report Builder
  • Creating Reusable Report Items
  • Report Parts
  • Lab: Supporting Self-Service Reporting
  • Using Report Builder
  • Simplifying Data Access for Business Users
  • Using Report Parts
Skills
  • Support self-service reporting with Report Builder
  • Create shared data sources and datasets for self-service reporting scenarios
  • Use report parts as reusable report elements
top
Module 4: Managing Report Execution and Delivery
  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alerts
  • Troubleshooting Reporting Services
  • Lab : Configuring Report Execution and Delivery
  • Configuring Report Execution
  • Implementing a Standard Subscription
  • Implementing a Data-Driven Subscription
Skills
  • Configure security settings for a report server
  • Configure report execution settings to optimize performance
  • Use subscriptions and alerts to automate report and data delivery
  • Troubleshoot reporting issues
top
Module 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
  • Creating a Data Source
  • Creating and Modifying a Data Source View
  • Creating and Modifying a Cube
Skills
  • Describe the considerations for a multidimensional database
  • Create data sources and data source views
  • Create a cube
  • Implement security in a multidimensional database
top
Module 6: Working with Dimensions
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
  • Lab: Defining Dimensions
  • Configuring Dimensions
  • Defining Relationships and Hierarchies
  • Sorting and Grouping Dimensions Attributes
Skills
  • Configure dimensions
  • Define attribute hierarchies
  • Sort and group attributes
top
Module 7: Working with Measures and Measure Groups
  • Working With Measures
  • Working with Measure Groups
  • Lab: Configuring Measures and Measure Groups
  • Configuring Measures
  • Defining Dimension Usage and Relationships
  • Configuring Measure Group Storage
Skills
  • Describe measures and measure groups
top
Module 8: Introduction to MDX
  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX To Query a Cube
  • Lab: Using MDX
  • Querying a Cube by Using MDX
  • Creating a Calculated Member
Skills
  • Describe MDX
  • Add calculations to a cube
  • Describe how to use MDX in client applications
top
Module 9: Customizing Cube Functionality
  • Working with Key Performance Indicators
  • Working with Actions
  • Working with Perspectives
  • Working with Translations
  • Lab: Customizing a Cube
  • Implementing an Action
  • Implementing a Perspective
  • Implementing a Translation
Skills
  • Describe Key Performance Indicators
  • Implement Actions
  • Explain Perspectives
  • Describe Translations
top
Module 10: 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
  • Lab: Using PowerPivot for Excel
  • Creating a Tabular Data Model by Using PowerPivot for Excel
  • Using a Tabular Data Model in Excel
  • Sharing a PowerPivot Workbook to PowerPivot Gallery
  • Using a PowerPivot Workbook as a Data Source
Skills
  • Describe the key features and benefits of tabular data models and PowerPivot technologies
  • Create a PowerPivot for Excel workbook
  • Share a PowerPivot for Excel workbook to PowerPivot Gallery and use a PowerPivot for Excel workbook as a data source
top
Module 11: Introduction to Data Analysis Expression (DAX)
  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
  • Lab: Creating Calculated Columns and Measures by Using DAX
  • Creating Calculated Columns & Measures
  • Using Time Intelligence
  • Creating a Dynamic Measure
Skills
  • Describe the fundamentals of DAX
  • Use DAX to create calculated columns and measures
top
Module 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
  • Creating an Analysis Services Tabular Data Model Project from a PowerPivot Workbook
  • Implementing a Perspective
  • Implementing Partitions
  • Deploying an Analysis Services Tabular Data Model
  • Enabling Access to a Tabular Data Model
  • Configuring DirectQuery Storage Mode
  • Implementing Security in a Tabular Data Model
Skills
  • Describe Analysis Services tabular data model Projects
  • Implement an Analysis Services tabular data model by Using SQL Server Data Tools
top
Module 13: Creating Data Visualizations With Power View
  • Introduction to Power View
  • Visualizing Data with Power View
  • Lab: Creating Interactive Reports with Power
  • View
  • Modify the Tabular Data Model
  • Create a Simple Power View Report
  • Interactive Visualizations
  • Create a Scatter Chart and a Play Axis
Skills
  • Describe the Power View and its place in the BI ecosystem
  • Create data visualizations by using Power View
top
Module 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
  • Using Table Analysis Tools
  • Creating a Data Mining Model
  • Using the Data Mining Add-in for Excel
  • Validating Data Mining Models
  • Using a Data Mining Model in a Report
Skills
  • Describe the key data mining concepts and use the Data Mining Add-ins for Excel
  • Create a Data Mining solution
  • Validate data mining models
  • Use data mining data in a report
top
> Pre-Requisites
Before attending this course students 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.
> Purpose
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 a reporting infrastructure; 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 Power View to create interactive data visualizations; use Data Mining for predictive analysis.