Microsoft Business Intelligence: Reporting and Analysis

The Microsoft Business Intelligence: Reporting and Analysis Boot Camp course provides step-by-step instructions on how to perform a variety of basic to intermediate Reporting and Analysis tasks using Microsoft SQL Server Business Intelligence Tools for activities based on real-life work scenarios. In this course, you will learn the tools needed to create managed enterprise business intelligence (BI) solutions.

You will learn about data modeling by creating multidimensional databases, cubes and dimensions, measures and measure groups, MDX fundamentals, analysis services, and Data Analysis Expressions (DAX). You will then learn how to create and publish reports using reporting services, report execution and delivery and data mining.

On successful Completion of this course you will be able to:

• Understanding the Microsoft BI Project Planning and Scoping Activities
• Capture Requirements for your BI Environment
• Understand the creation of Report ApplicationS
• Understand the creation of Technical Design Specification documents
• Components, architecture and nature of a BI solution
• Implement Dimensions in a cube
• Implement Measures and measure groups in a cube
• Understand Multidimensional Expressions (MDX) syntax
• Understand Cube customisation
• Implement tabular data model in SQL Server Analysis Services
• Enhance a tabular model using DAX
• Build queries in Microsoft BI Reporting Services
• Enhance Reports using charts and parameters
• Manage Report execution and Delivery