SQL Server 2014 BI: Integration and Analysis Services
- All levels
- 18 and older
- $2,795
- Earn 27,950 reward points
- (Exact location to be announced), New York, NY
- 40 hours over 5 sessions
Thankfully we have 6 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.
NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online
Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.
May 14th
6–9pm EDT
Meets 2 Times
May 28th
10am–5pm EDT
This class has 3 more dates.
Tap here to see more
Noble Desktop @ 185 Madison Ave, New York, NY & Virtually Online
Gain actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Take your data analysis skills to the next level at Noble Desktop.
May 14th
6–9pm EDT
Meets 6 Times
May 28th
10am–5pm EDT
Meets 3 Times
This class has 3 more dates.
Tap here to see more
NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online
Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.
May 21st
6–9pm EDT
Meets 2 Times
May 29th
10am–5pm EDT
This class has 3 more dates.
Tap here to see more
NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online
Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.
May 28th
6–9pm EDT
Meets 2 Times
May 30th
10am–5pm EDT
This class has 3 more dates.
Tap here to see more
NYC Career Centers @ 185 Madison Ave, New York, NY & Virtually Online
Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.
Apr 30th
10am–5pm EDT
Meets 3 Times
May 20th
10am–5pm EDT
Meets 3 Times
Jun 10th
10am–5pm EDT
Meets 3 Times
This class has 3 more dates.
Tap here to see more
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.
This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2014. Students will install and configure SQL Server 2014 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/SSAS.
Students work with complex SSIS data migration projects that import/export data between multiple formats including: Access, SQL Server, Oracle and other databases, XML files, Excel spreadsheets and flat files. Also demonstrated are SSIS tasks that can download from FTP Servers, copy/move files and folders, execute Win32 processes and .NET scripts, perform bulk imports, perform database maintenance, contact (via text or e-mail) administrators, and transfer database components between SQL Servers. Error handling options are also demonstrated with hands-on exercises, as well as how to use variables and input parameters in SSIS routines. The course provides thorough coverage of how to deploy, automate, secure and troubleshoot SSIS routines.
Students will learn how to use SSAS to design, build and populate data warehouses to stage data for use by data cubes, and will perform hands-on exercises to design and build a data warehouse. Advanced data warehouse concepts, such as surrogate keys and rapidly changing dimensions are also reviewed. Subsequent exercises use SSAS to create data cubes and analyze them. Cube customization options are demonstrated, including how to add Key Performance Indicators (KPIs), custom calculations, and actions that link to SSRS reports. Attendees also learn how to optimize cube performance by defining attribute relationships and custom aggregation levels.
The course also includes an overview of data mining and the tools available to do this in SSAS, supported by a hands-on exercise that walks through the process of defining a data mining structure to predict future sales. Administration topics related to data cubes are covered, including exercises that deploy and secure cubes, process and manage cubes.
Course Prerequisites:
Course Overview
Installing SQL Server Business Intelligence Tools
Integration Services Architecture
Common SSIS Tasks
Data Transformations
Advanced SSIS Tasks
Advanced Data Transformations
Migrating SQL Server 2000 DTS Packages
SSIS Administration and Automation
OLAP Design
Creating and Populating Data Warehouses
Creating and Managing Cubes
Customizing Cubes
Cube Deployment and Administration
Multidimensional (MDX) Essentials
MDX Functions
Understanding the Data Mining Process
Working with Data Mining Structures
People who viewed this class also viewed the following classes
Get quick answers from CourseHorse and past students.
HOTT delivers instructor-led technical training across the United States, Canada and the United Kingdom. Whether you attend in person, remote-live or on-demand, our classroom-based training philosophy zeroes in on your ability to work more productively and with higher quality results after training....
Read more about Hands On Technology Transfer, Inc.
This school has been carefully vetted by CourseHorse and is a verified NYC educator.
Hands On Technology Transfer, Inc.
Chelsea, Manhattan
(Exact location to be announced)
New York, New York Chelsea, Manhattan
(Exact location to be announced)
New York, New York
Booking this class for a group? Find great private group events
Or see all Professional Group Events
Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.
More in Microsoft Servers
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.