Business Intelligence with SSAS Training Course

Course Code

ssas

Duration

14 hours (usually 2 days including breaks)

Requirements

  • An understanding of data analysis
  • Experience with Microsoft SQL Server

Overview

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.

By the end of this training, participants will be able to:

  • Install and configure SSAS
  • Understand the relationship between SSAS, SSIS, and SSRS
  • Apply multidimensional data modeling to extract business insights from data
  • Design OLAP (Online Analytical Processing) cubes 
  • Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
  • Deploy real-world BI solutions using SSAS

Audience

  • BI (Business Intelligence) professionals
  • Data Analysts
  • Database and data warehousing professionals

 
Format of the Course

  • Interactive lecture and discussion
  • Lots of exercises and practice
  • Hands-on implementation in a live-lab environment

Course Customization Options

  • This training is based on the latest version of Microsoft SQL Server and SSAS.
  • To request a customized training for this course, please contact us to arrange.

Course Outline

Introduction

Installing and Configuring SSAS

Overview of SSAS Features and Architecture

Data Insight and Business Intelligence

Operational Analytics

New functionality Column store Index

Querying Data in SSAS Tabular

Querying Multidimensional Data

Enhanced SSIS

Enhanced MDS

Troubleshooting

Summary and Conclusion

Testimonials

★★★★★
★★★★★

Related Categories

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Finland!

As a Business Development Manager you will:

  • expand business in Finland
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!