Implementing OLAP Cubes & Reporting Solutions

collapse

Course Details

About this Course


In this course, you’ll take the planning strategies you learned in the second course and use them to successfully complete a BI project. You'll build OLAP Cubes on various data warehouses, add key performance indicators (KPIs) and actions, and then create SQL- and MDX-based reports based on those data warehouses and cubes. You'll also learn to mine the data models using various data mining algorithms available in Microsoft’s SQL Server Analysis Services (SSAS). We’ll also focus on using SSAS for developing and managing cubes and SQL Server Reporting Services (SSRS) for reports.

What You’ll Learn

  • MDX programming
  • How to build, tune and deploy OLAP Cubes
  • Techniques for multidimensional modeling
  • Analysis and reporting with SSRS and Excel
  • Report management, building and design

Get Hands-On Experience

You'll create reports using Microsoft Excel, SSRS, Report Builder and Power BI.