Skip to main content
SQL Server
Sign in
United States (English)
Home 2012 2008 R2 2008 Previous Versions Library Forums

SQL Server Analysis Services (SSAS) "How Do I?" Videos

Watch short videos that show you how to complete specific tasks in SQL Server Analysis Services (SSAS). Subscribe to the SQL Server Analysis Services (SSAS) videos RSS feed to see new monthly content.

In this video, you will learn how to build a simple tabular model and then deploy it in DirectQuery mode. You will learn how to create a connection file in SharePoint, and use the model to create reports in Project Crescent. The demo is based on the CTP3 release of SQL Server 2012.

How Do I: DirectQuery in Tabular Models
(08:05)

This video demonstrates how to modify the measures, attributes and hierarchies in a cube.

How Do I: Modifying Measures, Attributes and Hierarchies?
(13:16)

This video demonstrates how to define and deploy an OLAP cube using Analysis Services.

How Do I: Defining and Deploying a Cube?
(08:08)

 

This video demonstrates how to create an Analysis Services project, define a data source, and define a data source view. You will also learn how to change the value of the FriendlyName property for objects in the data source view to increase the user-friendliness of their names.

How Do I: Creating an Analysis Services Project?
(04:53)

In this video, Jacques Victor explains how to Design High Performance Cubes in SQL Server 2008 Analysis Services.

How Do I: Design High Performance Cubes in SQL Server 2008 Analysis Services?
(33:31)

In this video, Jacques Victor explains how to monitor SQL Server Analysis Services performance with SQL Server Profiler which can be used as a performance optimization and monitoring tool for Analysis Services.

How Do I: Monitor SQL Server Analysis Services Performance?
(15:00)

 

Aggregations are the key to getting the best performance out of your cube. MVP Chris Webb demonstrates the steps he takes to design effective aggregations.

How Do I: Creating Effective Aggregations - Technical Article
(41:52)

This video shows how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008 This demo shows how to: Use BIDS to create a data model project Create Data Sources, Data Views, Dimenions, & Cubes Deploy the project to SSAS 2208.

How Do I: Create and Publish a Data Cube for SQL Server Analysis Services 2008
(07:53)

 

 

More Videos

  • Data Mining
  • Data Quality Services
  • Integration Services
  • Master Data Services
  • PowerPivot
  • Report Builder
  • Reporting Services
  • SQL Server

© 2013 Microsoft
  • Manage Your Profile
  • Newsletter
  • Contact Us
  • Privacy Statement
  • Terms of Use
  • Trademarks
  • | Site Feedback
  • TechNet
  • Products
  • IT Resources
  • Downloads
  • Training
  • Support
Products
  • Windows
  • Windows
    Server
  • System
    Center
  • Internet
    Explorer
 
  • Office
  • Office 365
  • Exchange
    Server
 
  • SQL Server
  • SharePoint
    Products
  • Lync
  • See all products »
Resources
  • Evaluation Center
  • Learning Resources
  • Microsoft IT Camps
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • Script Center
  • Server and Tools Blogs
  • Solution Accelerators
  • TechNet Blogs
 
  • TechNet Flash Newsletter
  • TechNet Gallery
  • TechNet Library
  • TechNet Magazine
  • TechNet Subscriptions
  • TechNet Video
  • TechNet Wiki
  • Windows Sysinternals
  • Virtual Labs
Solutions
  • Networking
  • Cloud and Datacenter
  • Security
  • Virtualization
Updates
  • Service Packs
  • Security Bulletins
  • Microsoft Update
Trials
  • Windows Server 2012
  • System Center 2012 SP1
  • Microsoft SQL Server 2012 SP1
  • Windows 8 Enterprise
  • See all trials »
Related Sites
  • Microsoft Download Center
  • TechNet Evaluation Center
  • Drivers
  • Compatability & Converters
  • Windows Sysinternals
  • TechNet Gallery
Training
  • Training Catalog
  • Class Locator
  • Microsoft Virtual Academy
  • Free Windows Server 2012 courses
  • Free Windows 8 courses
  • SQL Server training
  • e-Learning overview
Certifications
  • Certification overview
  • MCSA: Windows 8
  • Windows Server Certification (MCSE)
  • Private Cloud Certification (MCSE)
  • SQL Server Certification (MCSE)
Other resources
  • TechNet Events
  • Second shot for certification
  • Born To Learn blog
  • IT Camps
Support by product
  • Exchange Server
  • Forefront Server
  • Forefront Edge Security
  • Forefront Server Security
  • Internet Explorer
  • Office
  • SharePoint
 
  • SQL Server
  • System Center
  • Windows Server
  • Windows XP
  • Windows Vista
  • Windows 7
  • Windows 8
Other support links
  • Microsoft Premier Online
  • Microsoft Fix It Center
  • TechNet Forums
  • MSDN Forums
  • Security Bulletins & Advisories
  • International support solutions
  • Log a support ticket
  • Look up event IDs and error codes
Not an IT pro?
  • Microsoft Customer Support
  • Microsoft Community Forums