SQL Server SSAS (Multidimensional MDX) - an Introduction (Udemy.com)
Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool). Exam 70-768
Created by: Phillip Burton
Produced in 2021
What you will learn
- Create cubes in SSAS, based on fact and dimension tables.
- Process the cubes, and analyse them in Excel, SSRS, and access them in SSMS.
- Learn some of the more advanced items, such as translations.
Quality Score
Overall Score : 90 / 100
Course Description
"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 thats 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 didnt have to bother with SQL queries, and could use something a bit more hands-on, although retaining something more advanced for advanced users. Thats 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 Multidimensionalcubes, or someone who wants to refresh their memory. Well create a cube to start with from an ordinary database, and then Ill ask you to create one from a special database known as a Data Warehouse. Well export our cube in SQL Server Management Studio, and into SSRS and well even have a bit of a look at the more advanced way of querying that is MDX.
It will assist withthe "Design a multidimensional business intelligence (BI)semantic model" sectionof Microsoftexam 70-768"Developing SQLData 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.
Instructor Details
- 4.5 Rating
207 Reviews
Phillip Burton
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.
More courses by Phillip Burton
70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)
Provider: Udemy
Time: 29.5h
$11.99
SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)
- Provider: Udemy
- Time: 9.5h
$11.99
Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)
- Provider: Udemy
- Time: 6h
$11.99
70-778, DA-100: Analyzing and Visualizing Data with Power BI (2021)
4.5 (224 Reviews)
- Provider: Udemy
- Time: 24h
$11.99
SQL Server Essentials in an hour: The SELECT statement (2021)
4.5 (183 Reviews)
- Provider: Udemy
- Time: 1h
$11.99
More sql courses
SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)
- Provider: Udemy
- Time: 5h
$11.99
Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)
- Provider: Udemy
- Time: 20h
$11.99
Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)
- Provider: Coursera
- Time: 3h
Free
Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)
- Provider: Udemy
- Time: 12.5h
$11.99
Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Reviews
- Video Duration:
8h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
