Training Schedule Training Schedule

(6557) Implementing Data Models & Reports MS SQL Server 2014
Code: 6557 v12/19/2018
Type: null
Tuition (USD): $3095
Length: 5 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 01/28/2019
Live Virtual, US 03/25/2019
Live Virtual, US 05/20/2019
Live Virtual, US 06/24/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

Skills Gained:
Components, architecture and nature of a BI solution Implement dimensions in a cube Implement measures and measure groups in a cube Multidimensional Expressions (MDX) syntax Cube customization Implement tabular data model in SQL Server Analysis Services Enhance a tabular model using DAX Reporting services Report enhancement using charts and parameters Report execution and delivery management Implement a dashboard in SharePoint Server with PerformancePoint Services Predictive analysis using data mining
Who Should Attend?
Database professionals who fulfill a BI developer role Database professionals who create analysis and reporting solutions whose responsibilities include: Implementing analytical data models, such as OLAP cubes Implementing reports and managing report delivery Creating business performance dashboards Support data mining and predictive analysis
Prerequisites:
  • Minimum two years experience with relational databases
  • Knowledge and skills that include:
  • Normalized database design
  • Creating tables and relationships
  • Querying with Transact-SQL
  • Data warehouse schema topology, including Star and Snowflake schemas
  • Basic pr
What You Will Learn:
  • COURSE OUTLINE
  • 1. Introduction to Business Intelligence and Data Modeling
  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Plan an Enterprise BI Project
  • 2. Create Multidimensional Databases
  • Multidimensional Analysis
  • Create Data Sources and Data Source Views
  • Create a Cube
  • Cube Security
  • 3. Work with Cubes and Dimensions
  • Configure Dimensions
  • Attribute Hierarchies
  • Sorting and Grouping Hierarchies
  • 4. Work with Measures and Measure Groups
  • Define Fact Tables
  • Associate Dimensions with Measures
  • 5. Multidimensional Expressions (MDX)
  • MDX Fundamentals
  • Add Calculations to a Cube
  • Using MDX to Query a Cube
  • 6. Enhance a Cube
  • Implement Key Performance Indicators (KPIs)
  • Implement Actions, Perspectives, and Translations
  • 7. Implement an Analysis Services Tabular Data Model
  • Analysis Services Tabular Data Models
  • Create a Tabular Data Model
  • Analysis Services Tabular Data Models in the Enterprise
  • 8. Data Analysis Expression (DAX)
  • DAX Fundamentals
  • Enhance a Tabular Data Model with DAX
  • 9. Implement Reports with SQL Server Reporting Services
  • Reporting Services
  • Create a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publish and View a Report
  • 10. Enhance Reports with SQL Server Reporting Services
  • Show Data Graphically
  • Filter Reports Using Parameters
  • Visualizing Data with Power View
  • 11. Manage Report Execution and Delivery
  • Manage Report Security
  • Manage Report Execution
  • Subscriptions and Data Alert
  • Troubleshoot Reporting Services
  • 12. Deliver BI with SharePoint PerformancePoint Services
  • SharePoint Server as a BI Platform and PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards
  • 13. Perform Predictive Analysis with Data Mining
  • Data Mining
  • Create a Data Mining Solution
  • Validate a Data Model
  • Consume Data Mining Data
  • Lab 1: Explore BI Solutions
  • Lab 2: Create a Multidimensional Database
  • Create a Data Source
  • Create and Modify a Data Source View and Cube
  • Add a Dimension
  • Lab 3: Define Dimensions
  • Configure Dimensions and Attributes
  • Create Hierarchies
  • Create a Hierarchy with Attribute Relationships and a Ragged Hierarchy
  • Browse Dimensions and Hierarchies in a Cube
  • Lab 4: Configure Measures and Measure Groups
  • Configure Measures and Measure Group Storage
  • Regular Relationship
  • Lab 5: Use MDX
  • Create Calculated Members
  • Query a Cube using MDX
  • Lab 6: Customize a Cube
  • Implement an Action, Perspectives and a Translation
  • Lab 7: Implement an Analysis Services Tabular Data Model
  • Configure Columns and Relationships
  • Deploy an Analysis Services Tabular Data Model
  • Lab 8: Enhance a Tabular Data Model using DAX
  • Create Calculated Columns, Measures, and KPI
  • Implement a Parent-Child Hierarchy
  • Lab 9: Create a Report with Report Designer
  • Lab 10: Enhance a Report
  • Add a Chart and Parameters to a Report
  • Use Data Bars, Sparklines, and a Map
  • Lab 11: Configure Report Execution and Delivery
  • Implement a Standard and a Data-Driven Subscription
  • Lab 12: Implement a SharePoint Server BI Solution
  • Create a SharePoint Server Site for BI
  • Configure PerformancePoint Data Access
  • Create PerformancePoint Reports, Scorecards and Dashboards
  • Lab 13: Use Data Mining to Support a Marketing Campaign
  • Table Analysis Tools
  • Create a Data Mining Structure
  • Add a Data Mining Model to a Data Mining Structure
  • Validate a Data Mining Model and Use in a Report
Course Info:
In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions. You will learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services, and Data Analysis Expressions (DAX). You will then learn how to create and publish reports using reporting services, report execution and delivery, SharePoint PerformancePoint Services, and data mining.

This course is designed for those interested in learning SQL Server 2012 or 2014 and covers the new features in SQL Server 2014 as well as the important capabilities across the SQL Server data platform.

This course incorporates material from the Official Microsoft Learning Product 20466: Implementing Data Models and Reports with Microsoft SQL Server. It covers the skills and knowledge measured by Exam 70-466 and along with on-the-job experience, helps you prepare for the exam.

RELATED CERTIFICATIONS:
MCSE: Data Management and Analytics

Follow-On Courses:
Designing Business Intelligence Solutions with Microsoft SQL Server 2014 (M20467)

Training Exclusives

This course comes with 12 months access to the following benefits:

Practice Labs
24x7 Mentoring
Indexed Class Recordings
Unlimited Retakes
Digital Courseware
* Terms and conditions may apply. Learn more about our Microsoft training exclusives by contacting training@dunnsolutions.com

Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.

Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.

Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.

Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.

VIRTUAL CLASSROOM FIT
Benefit from live, interactive online training that fits your schedule

For maximum flexibility without sacrificing the benefits of live, instructor-led training, Virtual Classroom Fit is designed for those who can't commit a full day, much less a full week, to training. Virtual Classroom Fit delivers live online training from our expert instructors in only six hours per week, combining the benefits of instructor-led sessions and self-directed activities. With hands-on labs and indexed class recordings available 24/7, you can get our award-winning training at your convenience.

Live Virtual:
Get engaging and impactful live, instructor-led training, regardless of your location.

Our Virtual Classroom Live online training format combines premium skills development technologies and our industry-leading instructors, content, exercises and peer collaboration to ensure that you get the highest quality professional development experience possible. Gain the skills and expertise that matter from the convenience of your home, work or wherever you have an Internet connection.

Engage with your instructor and fellow students via a learning platform and course material designed to ensure a stimulating and productive skills development experience.

Choose from sessions across a variety of time zones for training options that suit your schedule. Save time, money and effort without sacrificing learning quality by accessing our expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

Attend from your PC, Mac or any iOS/Android tablet or smartphone. Connect with the class through your device audio or via toll-free phone number†, depending on available technologies and your interaction preferences.
Learn to build analysis and reporting solutions with SQL Server 2012 or 2014.