NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to SSAS Multidimensional

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • To develop a data warehouse for your company
  • To develop a repeatable methodology for a successful SSAS project
  • To create and configure a cube and dimensions
  • To write MDX (the querying language for cubes)
  • To define calculations, Key Performance Indicators (KPIs) and perspectives, and implementing dynamic security
  • To administer and deploy SSAS, defining actions, implementing data mining
  • To build office-based BI applications and dashboards, and administering SSAS
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

In this course, you’ll learn how to use SSAS in your enterprise. This training takes you from the ground up, teaching you the fundamental skills needed to develop and deploy SSAS solutions and present this new data to your end users.

 

Click here for a downloadable PDF

Outline

 

Module 01 | Dimension Modeling
46m 02s total

 

Module 01A | Dimension Modeling
46m 02s

 

Module 02 | SSAS Overview
53m 20s total

 

Module 02A | SSAS Overview
53m 20s

 

Module 03 | Cube Design and Browsing
26m 51s total

 

Module 03A | Cube Design and Browsing
26m 51s

 

Module 04 | Dimension and Cube Designers
106m 50s total

 

Module 04A | Dimension and Cube Designers
106m 50s

 

Module 05 | Adding New Facts and Dimensions
48m 43s total

 

Module 05A | Adding New Facts and Dimensions
48m 43s

 

Module 06 | MDX and Calculations
142m 68s total

 

Module 06A | MDX Basics
104m 42s

 

Module 06B | Creating Calculations
38m 26s

 

Module 07 | Data Mining Basics
56m 24s total

 

Module 07A | Data Mining Basics
56m 24s

 

Module 08 | Actions and KPIs
21m 15s total

 

Module 08A | Actions and KPIs
21m 15s

 

Module 09 | Reporting Services with SSAS
57m 41s total

 

Module 09A | Reporting Services with SSAS
57m 41s

 

Module 10 | Using Excel to Build Cube Interfaces
23m 00s total

 

Module 10A | Using Excel to Build Cube Interfaces
23m 00s

 

Module 11 | Administration
97m 23s total

 

Module 11A | Partitions
18m 25s

 

Module 11B | Aggregations
23m 55s

 

Module 11C | Perspectives
05m 57s

 

Module 11D | Security
18m 30s

 

Module 11E | Deployment
31m 56s

Instructor

DEVIN KNIGHT

Pragmatic Works President
Devin Knight is a Microsoft Data Platform MVP, Microsoft Certified Trainer, and President of Pragmatic Works Training. He focuses on driving adoption of technology through learning. He is an author of nine Power Platform, Business Intelligence, and SQL Server books. He has been selected as a speaker for conferences like Power Platform Summit, PASS Summit, SQLSaturdays, and Code Camps for many years. Making his home in Jacksonville, FL Devin is a contributing member to several local user groups.

 

Click Here To Learn More About Devin And See Certifications And Reviews

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, 2008, 2012, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance

What to Know Before Class

This class assumes that you have no previous knowledge of OLAP or Analysis Services. Technical knowledge of basic database design concepts is assumed. It is required that you already know how to navigate around SQL Server 2005/2008/2012/2014 and how to query a SQL Server.

REVIEWS

It is a great course. Thank you.

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required