How This Course Is Organised
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.
The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.
Business Intelligence Developer
Business Intelligence Architects
Hands-on experience working with relational databases
Basic knowledge of the Microsoft Windows operating system and its core functionality
Understanding the Microsoft BI Project Planning and Scoping Activities
Capture Requirements for your BI Environment
Understand the creation of Report Application and 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
Supported SQL-Server Versions: SQL Server 2008, 2012, 2014, 2016
This is a 6 Months course and Includes a Free eBook and six months access to a personal Tutor for support on-line.