Torrent details for "Udemy - SQL Server SSAS (Multidimensional MDX) – an Introduction"    Log in to bookmark

wide
Torrent details
Cover
Download
Torrent rating (0 rated)
Controls:
Category:
Language:
English English
Total Size:
3.38 GB
Info Hash:
b3720903165770fb2f9f1ca74264c8585f20a06f
Added By:
Added:  
14-06-2019 16:46
Views:
1,018
Health:
Seeds:
3
Leechers:
0
Completed:
81
wide




Description
wide
Image error
Description

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.

This course is designed for the complete beginner in Multidimensional cubes, or someone who wants to refresh their memory. We’ll create a cube to start with from an ordinary database, and then I’ll ask you to create one from a special database known as a Data Warehouse. We’ll export our cube in SQL Server Management Studio, and into SSRS – and we’ll even have a bit of a look at the more advanced way of querying that is MDX.

It will assist with the “Design a multidimensional business intelligence (BI) semantic model” section of Microsoft exam 70-768 “Developing SQL Data Models”.
Who this course is for:

   This is for you if you want to learn about SQL Server Analysis Services.
   No previous experience using SSAS is necessary.
   It would be useful if you have previously used SQL Server (T-SQL), but far from essential.

Requirements

   You don’t need to know or do anything before starting this course.
   I’ll show you have to download the Developer Edition of SQL Server 2017 for FREE. Previous versions cost $100.

Last updated 5/2019

  User comments    Sort newest first

No comments have been posted yet.



Post anonymous comment
  • Comments need intelligible text (not only emojis or meaningless drivel).
  • No upload requests, visit the forum or message the uploader for this.
  • Use common sense and try to stay on topic.

  • :) :( :D :P :-) B) 8o :? 8) ;) :-* :-( :| O:-D Party Pirates Yuk Facepalm :-@ :o) Pacman Shit Alien eyes Ass Warn Help Bad Love Joystick Boom Eggplant Floppy TV Ghost Note Msg


    CAPTCHA Image 

    Anonymous comments have a moderation delay and show up after 15 minutes