Good Stuff Overall!!! In my opinion, the instructor did great with the How–tos which helped for sure in grasping the whole concept of how to create cubes, set up data source and source views, dimensions, add attributes etc. Lakeside David–Debo
A fantastic course which gets you rolling very quickly and comfortably, thanks for the short and condensed knowledge delivery. Thanks, Phillip you made SSAS very simple for me. – Anup Kale
This is really the perfect course for beginners! Easy to learn and very inspirational for further investigations in SSAS. Thank you very much, Phillip! – Marina Barinova
Welcome to this course on SQL Server SSAS and MDX Cubes an Introduction.
You may have become experienced with creating SQL statements in SQL Server Management Studio. Building databases is ideal when you want to quickly add data that s why they are called OLTP Online Transaction Processing they are designed for speed for adding transactions.
But what if you want to get to get information about? OLTP databases are not based designed for this. What you need instead is a process whereby data is pre–aggregated in other words, a lot of the calculations you may write have been calculated before you ask for them. It saves a lot of time. It would also be useful if the end user didn t have to bother with SQL queries, and could use something a bit more hands–on, although retaining something more advanced for advanced users. That s where cubes come in, full of pre–aggregated data, and SQL Server Analytical Services or SSAS (Online Analytical Processing) allows you to make these cubes.
Courses : 7
Specification: SQL Server SSAS (Multidimensional MDX) – an Introduction
13 reviews for SQL Server SSAS (Multidimensional MDX) – an Introduction