If you want to acquire solid skills pertaining to SQL Server Analysis Services and data mining, then you are in the right place! This video course includes every bit of information you must know to use SSAS confidently and advance in data science. This tutorial will be suitable for you even if you possess little experience in data mining.

With a total of 58 video lessons, you will be able to learn data mining and analytics from scratch and translate this knowledge into modern and effective database solutions. The tutorial includes the following subjects:

• Introduction to SSAS and MDX: why do you need them?
• An overview of Business Intelligence (BI) solution components
• Dimensional model, BI semantic model, SSAS, and multidimensional expressions
• How to configure and install SQL Server Analysis Services?
• Working with data warehouse
• Using Cube wizard for Cube development and design
• About practical code development and multidimensional expressions
• OLAP database, subcubes, KPIs, SSRS & MDX
• Administration: restore and backup, synchronizing and scripting, logging, and more
• How to maintain SSAS Security?
• Advanced skills: how to support multiple languages?
• How to intercept and analyze queries? Performance optimization
• Data mining: basic concepts and application. Algorithms for data mining
• Using SSAS and SQL Server to develop data mining models
• How to install and setup tabular SSAS
• Designing and developing SSAS tabular data model. Hierarchies, relationships, tables, calculated columns, and more

The course is complemented with practice questions and hands-on tasks. Good luck on your way to mastering data mining!