Microsoft SQL Server Analysis Services Demystified

[xidau123 13]

Microsoft SQL Server Analysis Services Demystified

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | 517 MB

Genre: eLearning | Language: English

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.

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.