Microsoft SQL Server Analysis Services Demystified [Video]

More Information
  • Process, delete, and manage Analysis Services in Management Studio
  • Analyze data in a cube and write queries in MDX
  • Navigate around SQL Server Data Tools (SSDT) in order to build cubes and tabular models
  • Create multidimensional model Key Performance Indicators
  • Enrich your existing business data using DAX language to implement business rules using calculations
  • Improve the user experience by creating attributes within a dimension
  • Understand the difference between DAX and MDX in order to help you to determine the accuracy of the formula
  • Process and deploy the cube so that it optimally meets users needs

Microsoft SQL Server is an enterprise database server with a multitude of technologies within it. SQL Server 2012 Analysis Services is one of those technologies that empowers users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success.

This practical video course teaches you how to make design decisions, manage multidimensional and tabular models, and finally visualize data to successfully deliver a business intelligence project.

Microsoft SQL Server Analysis Services Demystified gives viewers an insight into the best practices for designing and building Microsoft Analysis Services 2012 cubes.

Packed with real world tasks, this video course starts by helping you make design decisions, recognizing that this maximizes the successful delivery of a business intelligence project. You then get a walkthrough of the key concepts and terms that are common to both the multidimensional and tabular models of Analysis Services. Next, you will move onto key technical implementations of Analysis Services cubes, such as hierarchies, natural and unnatural relationships, and essential MDX expressions. Finally, you will learn about visualizing the data in DAX and MDX in order to expose the data accurately using Excel, Reporting Services, and Power View.

This video course is an invaluable tutorial for anyone who is planning to use Microsoft Analysis Services 2012 in a business intelligence project.

  • Learn how to make the correct design choice between multidimensional and tabular models according to your project requirements
  • Learn the key implementation features of Analysis Services cubes and how to visualize data
  • An essential two hour course to get you familiar and productive with the basics of data analysis
Course Length 2 hours 17 minutes
ISBN 9781849689304
Date Of Publication 26 Jun 2013


Jen Stirrup

Jen Stirrup is a data strategist and technologist, a Microsoft Most Valuable Professional (MVP), and a Microsoft Regional Director, a tech community advocate, a public speaker and blogger, a published author, and a keynote speaker. Jen is the founder of a boutique consultancy based in the UK, Data Relish, which focuses on delivering successful business intelligence and artificial intelligence solutions that add real value to customers worldwide. She has featured on the BBC as a guest expert on topics relating to data.