Consulting Training Blog Careers About Us Contact Us

Business Intelligence Training

See All Scheduled Courses

Students in our SQL Server Business Intelligence training course begin by exploring the definition of a business intelligence solution and then quickly move on to interviewing and identifying data planning the BI solution, creating a data warehouse, ETL process, cubes and reports, testing and tuning the solution and more. See more details on our training lower on this page or select a course from the Course Selector below.

Testimonials

Sparked my interest on learning more about design patterns. This will help me with improving design decisions at work.

Arbindra B

We reached out to Intertech for help with a mobile barcoding project to help our users manage their warehouses more efficiently. We had a need for mobile development expertise which we did not have in-house. Intertech provided the right resource at the right time for our project. They have listened to our needs every step of the way, been more than flexible, and the consultant is a perfect resource for our team. I cannot recommend their services enough.

Benjamin S

Very good class. Labs were very helpful in learning about APP-V. Material was well organized, as well as easy to follow and understand. Facilities were nice as well. A variety of snacks were provided free of charge to help keep is alert throughout the day.

Dave S

Effective training with a very knowledgeable trainer. Fast paced and very in depth. Would do it again!

Teresa H

In depth training on advanced concepts in SSAS. Excellent coursework and instruction. Nice training facility.

Archana N

Course Finder

Return To Top
Filter Options
close

Training Category

  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See All Categories
  • See more Adobe Categories
  • See more Agile | Scrum Categories
  • See more Agile | Scrum Categories
  • See more Business Categories
  • See more Citrix Categories
  • See more CompTIA Categories
  • See more EC Council Categories
  • See more IBM Categories
  • See more IBM Categories
  • See more ITIL Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Java Categories
  • See more Linux Categories
  • See more Linux Categories
  • See more Machine Learning Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Microsoft Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Mobile Categories
  • See more Network Categories
  • See more Network Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Open Source Categories
  • See more Oracle Categories
  • See more Oracle Categories
  • See more Programming Categories
  • See more Programming Categories
  • See more Software Testing Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more VMware Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more Web Development Categories
  • See more XML Categories

Scheduled Classes

Guaranteed To Run


Date

  • X
  • X
  • Please ensure that the End Date is greater than or equal to the Start Date.
  • Please ensure that the End Date is greater than the present Date.

Delivery

Location

- of results

Free Resources

Free On-Demand Videos: SSRS Report Builder Tips

Free eBook: Multidimensional Expressions (MDX)

Free Tutorial: Writing Transact-SQL Statements

MORE ON BUSINESS INTELLIGENCE TRAINING

It all begins with planning, which is why our SQL Server Business Intelligence training spends considerable time on each step in the planning process: interviewing, documenting the requirements, locating data, defining the roles and team, determining the schedule and more. 

SQL Server Business Intelligence training at Intertech teaches students to design a data warehouse and a data mart, starting with a typical OLTP database design – including normalized tables, table relationships, many-to-many tables, one-to-many tables and parent-child one-to-many tables. Their exploration of a typical data warehouse database design covers measures, the fact table and dimensions, before moving onto to stars and snowflakes, dimensional patterns, conformed dimensions, adding surrogate keys and slowing changing dimensions.
 
Creating a data warehouse comprises a major component of our SQL Server Business Intelligence training. Students review SQL Server management studio, configuration manager, management studio windows, creating a data warehouse database, creating tables and a date dimension table. A review of ETL processing with SQL is included: performing the ETL programming, deciding on full or incremental loading, isolating the data to be extracted, identifying transformation logic, programming transformation logic and so on.
 
Students in our SQL Server BI training learn about beginning the ETL process with SSIS, including starting an SSIS project and adding a project to an existing solution. They cover renaming an SSIS package, the anatomy of an SSIS package (control flow tab, data flow tab, using sequence containers, using precedence constraint arrows, SSIS variables and outing the ETL process), data connections, executing SQL tasks, progress/execution results tabs and resetting the destination database.
 
As Intertech’s SQL Server BI training progresses, students gain an understanding of concluding the ETL process with SSIS and then move on to the SSAS project. They look at SQL Server vs. analysis server databases, data sources, source views and dimensions (dimension wizards). Also covered is configuring dimensions with SSAS and creating and configuring SSAS cubes: browser tabs, cube structure tabs, dimension usage tabs, the calculation tab and much more. In addition, they explore additional cube and dimension configurations: actions, partitions, aggregations, perspectives, translations and browser. 
 
Creating reports with SQL queries is a major topic area in our SQL Server Business Intelligence training. This includes identifying the data, joining table data, ordering results, formatting results using SQL functions, filtering results, etc. The course concludes with time spent on reporting with MDX queries, reporting with Microsoft Excel, creating and configuring reports with SSRS, testing and tuning BI solutions and the end of cycle process.
 
 

Looking for Different Training?