SSAS - From Beginner to Pro - The practical Cube Tutorial
What you'll learn
- Concept and creation of your own Cubes (Dimension, Fact Tables) in SSAS
- Process the cubes, and analyse them in Excel and Power BI
- Advanced Usage of Features like Translations / Drill-Throughs in SSAS
- Build your own custom security guidance in SSAS
Requirements
- You don't need specific knowledge before starting this course.
- No prior knowledge of SSAS, MDX or Dimensional modeling is required.
- Know how basic tables are structured and how to install software
Description
This is the number 1 course for learning SSAS according to many successfull real life customer. Most times customers didn't know how to handle SSAS (Analysis Services) because they were missing the technical basis to develop their business intelligence solution.
Reviews:
"Very well structured. I learned so much about the fundamental cube structure in theory and also through the practical parts in SSAS. At the end I really like the Power BI cube access to achieve a concrete benefit of data analytics." - Julian Seiler
"Good sessions, excellent structure. Definitely approved my skills and knowledge in theory and practice. The Power BI cube access seems to be a good solution for the daily work with data. Would recommend this videos to everyone who's interested in SSAS, absolutely worth the time." - Manuel Rothenberger
"I really enjoyed this class. Very good instructions and easy to follow up. So for everyone that is exited to extend their data science knowledge and set the basis for the future." - Patrick Ebler
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Welcome to my practical Course on SSAS Cube Tutorial for non techies // Power BI // Practice:
You are looking for modern and meaningful Business Intelligence reports? So far, you're missing the experience and the confidence in your technical skills, to just get started?
Or are you about to make a big move into a highly trained job and therefore want to improve your data analytics skills? The business intelligence market is one of the fastest growing branches of business, according to relevant expert opinions. Increase your personal value for your current employer or future companies, by convincing them with your practical, custom-designed Know-How.
This tutorial is specially for people, who like to justify operational decisions on solid data with the help of SSAS, Excel and Power BI.
You are going to learn in this course how to integrate data in SQL Server, how to set up your own cubes in SSAS and at the end, how to retrieve the data through modern Front-end tools. Furthermore this is not an abstract high-level tutorial, but rather a self practicing course.
I will provide you with all the Files, scripts, software which you need in this course and going to show you step by step how to install SQL Server and it's components (SSAS, SSIS, SSRS). We will work with the newest SQL Server 2017 and Power BI version, that for training reasons are completely free of charge!
Don't hesitate to improve your knowledge and increase your business intelligence job chances. Learn to love SSAS and handle it like a pro.
Do the first step with this course and get insights to a whole new view inside the world of data analysis!
Note: In this course you'll also get downloadable source code.
Who this course is for:
- Technical / reporting users that want to extend their knowledge and want to create your own basis for reports
- This course is for those who want to start a career in analytics (Students)
- This course is specially designed for those working or who want to work in the role of MS BI Architect, MDX Developer, SSAS Administrator, SSAS Architect, SSAS Developer, Data Modeler, MS BI Developer, SSAS Performance Engineering Specialist and others
- CEO's that want to get better data insights
Instructor
- 3.9 Instructor Rating
- 466 Reviews
- 1,951 Students
- 2 Courses
I am working as a Business Intelligence Consultant providing expert services in the development of business analytics and reporting for several german and international customers. Since 2018 I am a Microsoft Certified Solution Expert in Data Management and Analytics for SQL Server.
Besides my work I really like to investigate data with the newest Microsoft developer stack, which helps me to stay up to date in the dynamic BI context.
During the last years i spent at lot of time giving customer trainings on topics like SSAS, SSRS, SSIS and especially Power BI. It gives me a great pleasure to spread my knowledge and see how you are able to build your own solutions directly after the course.
Currently I‘m hosting the courses in english and german. So feel free to choose the appropriate language.
———————————————————————————
Ich arbeite aktuell als Business Intelligence Consultant in einem Beratungsunternehmen und konnte mir in diesem Zusammenhang fundiertes Wissen zu den Themen Business Analytics und Reporting aufbauen. Darüber hinaus bin ich als Microsoft Certified Solution Experts (MCSE) - Data Management and Analytics für SQL Server ausgezeichnet.
Neben dem beruflichen Schwerpunkt beschäftige ich mich in meiner Freizeit gerne mit Datenanalysen und der Weiterentwicklung von bestehenden BI Systemen. Dieses Engagement hilft mir dabei, in diesem sehr dynamischen BI Umfeld „am Ball zu bleiben“.
Während der letzten Jahre habe ich viele Kunden-Schulungen zum Thema SSAS, SSRS, SSIS und Power BI gehalten. Es macht mir große Freude, das gesammelte Wissen an Sie in diesem Kurs weiterzugeben.
Abweichend zu den wenigen bestehenden SSAS (Cube) Tutorials ist das gesamte Lehrmaterial auf Deutsch gehalten. Ich möchte hier gezielt den deutschen Markt ansprechen und die Sprachbarriere als eventuelles Einstiegshindernis beseitigen.