This course is intended for developers wish to use Microsoft SQL Server Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions.
In this course, you will learn how to use Microsoft SQL Server Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel, Office Visio Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server Integrated Services and Reporting Services.
Upon successful completion of this course, the student will be able to:
- Learn to define what Business Intelligence is and how it applies to a database
- Understand how the cube structure works for viewing data information
- View cubes using Excel and SQL Reporting Services
- See how to create cube models using SQL Server Business Intelligence Development Studio (BIDS)
- Create Data Source, Data Source Views and then create cubes with the Cube Wizard
- Learn how to create key performance indicators (KPIs)
- Work with changing and advanced dimension types
- Use relational and SSAS partitions
- Understand how to use MDX syntax for queries, functions and tasks
- Learn data mining concepts and mining structure processing.
- Implement security, XMLA scripts, backups and restores for SSAS
This course does not require any prior experience with Analysis Server. It is assumed that students have working experience with SQL Server; basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel; and SharePoint Server.