Implementing Data Models and Reports with MS SQL Server is unfortunately unavailable

Thankfully we have 10 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.

Implementing Data Models and Reports with MS SQL Server

at ONLC Training Centers - Murray Hill

(5)
Course Details
Price:
$2,995
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Murray Hill, Manhattan
275 Madison Ave 14th Fl
At E 40th St
New York, New York 10016
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor
Purchase Options
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this sql server training:

The focus of this five-day 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.

Note: 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.

Audience Profile
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 analytical data models, such as OLAP cubes.
  • Implementing reports, and managing report delivery.
  • Creating business performance dashboards.
  • Supporting data mining and predictive analysis.
Prerequisites
This course requires that you meet the following prerequisites:
  • 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.
  • At Course Completion
  • After completing this course, students will be able to:
  • Describe the components, architecture, and nature of a BI solution.
  • 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 SQL Server Analysis Services.
  • Use DAX to enhance a tabular model.
  • Create reports with Reporting Services.
  • Enhance reports with charts and parameters.
  • Manage report execution and delivery.
  • Implement a dashboard in SharePoint Server with PerformancePoint Services.
  • Use Data Mining for Predictive Analysis.
Course Outline
  • Module 1: Introduction to Business Intelligence and Data Modeling
  • Module 2: Creating Multidimensional Databases
  • Module 3: Working with Cubes and Dimensions
  • Module 4: Working with Measures and Measure Groups
  • Module 5: Introduction to MDX
  • Module 6: Enhancing a Cube
  • Module 7: Implementing an Analysis Services Tabular Data Model
  • Module 8: Introduction to DAX
  • Module 9: Implementing Reports with SQL Server 
  • Module 10: Enhancing Reports with SQL Server Reporting Services
  • Module 11: Managing Report Execution and Delivery
  • Module 12: Delivering BI with SharePoint 
  • Module 13: Performing Predictive Analysis with Data Mining

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 29950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (2)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

10 Top Choices

Intermediate SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Intermediate SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep,...

Wednesday Oct 23rd, 9am - 5pm

Beginner SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Beginner SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. Learn to use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database in our beginner SQL training class. Our SQL courses are taught in our state-of-the-art...

Tuesday Oct 22nd, 9am - 5pm

Advanced SQL

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Advanced SQL Class Overview SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and...

Thursday Oct 24th, 9am - 5pm

SQL Training For Beginners

at General Assembly - Flatiron 10 E 21st St 3rd Fl, New York, New York 10010

Do you keep hearing the word ‘SQL’ buzzing around and want to find out more about it? This 3 hour workshop will provide an introduction to fundamental concepts in relational databases and using the query language SQL.  Participants will learn to how to work with data that is stored in a relational database. By the end of the workshop, you...

Monday Oct 21st, 6:30pm - 9:30pm

Querying Microsoft SQL Server 2012/14/16

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries.  Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which...

Monday Nov 4th, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

Designing and Deploying Microsoft Exchange Server 2016

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This course provides experienced Exchange Server administrators with the knowledge to design and implement an Exchange Server 2016 messaging environment. Students will learn how to design and configure advanced components in an Exchange Server 2016 deployment such as site resiliency, advanced security, compliance, archiving, and discovery solutions. ...

Monday Nov 4th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

Querying Data with Transact-SQL

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761. Audience profile: The main purpose of the course...

Monday Nov 11th, 10am - 6pm

  (5 sessions)
$2,975

5 sessions

MySQL Workbench: Data Modeling & Development

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to...

Monday Nov 11th, 10am - 5pm

  (4 sessions)
$2,280

4 sessions

Microsoft SQL Server 2012/14/16 Reporting Services

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

Full Course Name Microsoft SQL Server 2012/14/16 Reporting Services SSRS This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data...

Monday Dec 2nd, 10am - 5pm

  (5 sessions)
$2,925

5 sessions

Administering Microsoft SQL Server 2012/14/16 Databases

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

This course is intended for Database Professionals who perform installation, maintenance, and configuration tasks as their primary areas of responsibility. They will often set up database systems and are responsible for making sure those systems operate efficiently. They also make sure that the data they store is backed up regularly, stored effectively,...

Monday Dec 9th, 10am - 5pm

  (5 sessions)
$2,925

5 sessions