Implementing Data Models and Reports

Microsoft Course - 20466

The focus of this instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.

Microsoft Imagine Academy - Implementing Data
Models and Reports Exam Courses Certification Training in Mississauga, Brampton, Toronto, Scarborough

NEXT COURSE START DATES

START DATE END DATE DAY TIMING CAMPUS STATUS REGISTER
View All Schedules
Contact us directly for other start dates
Seats Available
Limited Seats
Class Full

PRE-REQUISITES:

2 years' experience of working with relational databases, including:

  • Designing a normalized database
  • Creating tables and relationships
  • Querying with Transact-SQL
  • Basic knowledge of data warehouse schema topology (star, snowflake schemas)
  • Some exposure to basic programming constructs (looping, branching)
  • Awareness of key business priorities such as revenue, profitability, financial accounting

COURSE OUTLINE

  • Introduction to Business Intelligence and Data Modeling
  • Creating Multidimensional Databases
  • Creating Multidimensional Databases
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customizing Cube Functionality
  • Implementing an Analysis Services Tabular Data Model
  • Introduction to Data Analysis Expression (DAX)
  • Implementing Reports with SQL Server Reporting Services
  • Automating Report Execution and Delivery
  • Delivering BI with SharePoint PerformancePoint Services
  • Performing Predictive Analysis with Data Mining
This course prepares students for

EXAM 70-466

Ask about our diploma programs for job oriented studies


  • facebook icon
  • facebook icon
  • twitter icon
Duration 40 Hours
Course Fees Contact Us
Faculty IT
Course Level Beginner
Features In Class, Lab, Hands-on Training
Language English

Quick Application Form









Call Now
CIMT College - Mississauga, Brampton, Toronto, Scarborough - Celebrating 20 Years

Careers Start At Cimt College - Mississauga, Brampton, Toronto

AFFILIATED PARTNERS

Our Affiliated Partners