programming-background-with-person-working-with-codes-computer.jpg

Microsoft Business Intelligence Stack

Why?
Microsoft BI course is designed to provide insights on different tools in Microsoft Suite (SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services). It also gives the practical knowledge on DW concepts and how these tools help in developing a robust end-to-end BI solution.

Microsoft provides a complete set of Business Intelligence tools as part of Microsoft SQL Server. The Microsoft BI stack includes products for data integration

(SSIS), analytics (SSAS) and business intelligence (SSRS), and visualization.

This course is designed for IT Professionals who are interested in learning how to implement Business Intelligence solutions on the Microsoft BI Stack.

The course will focus on teaching IT Professionals the best practices and skills required to successfully design and build and operate a business intelligencesolution using SQL Server Integration Services, Analysis Services and Reporting Services

Recommended Prerequisites: Basic knowledge of Business Intelligence and relational database systems

SSIS Basics

solution and projects Two ways to run packages

Data Flow Task

Connection managers source and destinations Excel, OLEDB and flat files

Data transformations

sorting and aggregating Fully and Partially blocking Sampling Data

Data Views

Attaching data viewers Using dead-end destinations

Variables

The row count transform System variables changing scope System variables Changing scope

Scripting

Script tasks Script components The variable dispenser

Fore-each loops

Looping over files Looping over records Other for each loops

Expressions

Expression Syntax Data types and casting Conditional split transform Derived column transform

Controlling flow

Precedence and Constraints Event Handling

Managing Errors

Redirecting and ignoring errors Dealing with truncations SSAS Getting started

Multidimensional vs tabular

Separate names instances The development environment

Connecting to a data model

Hiding from client tools Renaming tables/columns

Relationships

Diagram view Creating Relationships Multi-column relationships Basket analysis

Excel Pivot tables

Analyzing data in Excel Connecting from Excel using excel pivot tables

Introduction to SSRS
BID and Report manager
Solution and projects
The 4 main visual studio windows
Gauges Creating and formatting gauges gauge panels pointers, scales and ranges Maps
Indicators Creating indicators Changing the symbols displayed Stopping indicators
Using Report Manager moving and deleting reports creating folders using report manager
Subscriptions How subscriptions work creating a new subscription Managing subscriptions

Charts The areas of a chat formatting charts creating charts
Tables Structure of a table Formatting tables Inserting rows Interactive sorting
Grouping Tables using the grouping panes Row and column groups Displaying subtotals Outlining
Lists creating and formatting lists Grouping using lists using rectangles in lists

Creating a Master-Detail Linking
Adding Performance Tile to an Analysis
Adding a Simple Trellis to an Analysis
Working with Other View Types
Creating a Narrative View
Creating Column Selector and View Selector Views
Building Dashboards
Exploring and Editing My Dashboard
Creating a Dashboard
Editing a Dashboard
Saving a Customized Dashboard and Setting Preferences
Exporting the Dashboard to Excel Spreadsheet
Prompting to Filter Analysis
Creating a Named Dashboard Prompt
Creating a Column prompt