Rahul Chatterjee cleared his PMP Certification in his first attempt! Sumana Halder cleared her ITIL V3 Foundation exam with high marks! Monojit offered a job by Hindalco after completing his Oracle course! Subhamay placed with HP as an Oracle DBA

About MSBI                                         About Power BI

About Microsoft BI Tools Training

Microsoft has a robust set of BI Tools like MSBI with SSIS, SSAS, SSRS and the newer Power BI.

Palium offers training in all the products including SQL Server, SQL, t-SQL etc.

Power BI Training

Power BI is a newer version of business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator.

Mode: Classroom or Online

Duration: 32 hours

Pre-requisite: None - knowledge of MS SQL will be helpful

Course Outline

 

Introducing Power Pivot

o  Introduction

o  Why Use Power Pivot?

o  The xVelocity In-memory Analytics Engine

o  Enabling Power Pivot for Excel

o  Exploring the Data Model Manager Interface

o  Summary

 

Importing Data into Power Pivot

o  Introduction

o  Importing Data from Relational Databases

o  Importing Data from Text Files

o  Importing Data from a Data Feed

o  Importing Data from an OLAP Cube

o  Reusing Existing Connections to Update the Model

o  Summary

Creating the Data Model

o  Introduction

o  What Is a Data Model?

o  Creating Table Relations

o  Creating a Star Schema

o  Understanding When to Denormalize the Data

o  Creating Linked Tables

o  Creating Hierarchies

o  Making a User-Friendly Model

o  Summary

Creating Calculations with DAX

o  Introduction

o  What Is DAX?

o  Implementing DAX Operators

o  Working with Text Functions

o  Using DAX Date and Time Functions

o  Using Informational and Logical Functions

o  Getting Data from Related Tables

o  Using Math, Trig, and Statistical Functions

o  Tips for Creating Calculations in Power Pivot

o Summary

Creating Measures with DAX

o  Introduction

o  Measures Versus Attributes

o  Creating Common Aggregates

o  Mastering Data Context

o  Altering the Query Context

o  Using Filter Functions

o  Creating KPIs

o  Summary

Incorporating Time Intelligence

o  Introduction

o  Date-Based Analysis

o  Creating a Date Table

o  Time Period–Based Evaluations

o  Shifting the Date Context

o  Using Single Date Functions

o  Creating Semi-additive Measures

o  Summary

Data Analysis with Pivot Tables and Charts

o  Introduction

o  Pivot Table Fundamentals

o  Slicing the Data

o  Adding Visualizations to a Pivot Table

o  Working with Pivot Charts

o  Using Multiple Charts and Tables

o  Using Cube Functions

o  Summary

Optimizing Power Pivot Models for Power View

o  Introduction

o  Visualizing Data with Power View

o  Creating a Basic Report

o  Improving the Power View Experience

o  Summary

 

Creating Standard Visualizations with Power View

o  Introduction

o  Creating Tables and Matrices

o  Constructing Bar, Column, and Pie Charts

o  Building Line and Scatter Charts

o  Creating Map-Based Visualizations

o  Summary

Creating Interactive Dashboards with Power View

o  Introduction

o  Linking Visualizations in Power View

o  Using Tiles to Organize the Data

o  Filtering Groups and Views

o  Exposing the Dashboard

o  Summary

Data Discovery with Power Query

o  Introduction

o  Discovering and Importing Data

o  Transforming, Cleansing, and Filtering Data

o  Merging and Shaping Data

o  Grouping and Aggregating Data

o  Inserting Calculated Columns

o  Summary

Geospatial Analysis with Power Map

o  Introduction

o  Preparing Data for Mapping

o  Creating a Map-Based Graph

o  Creating Heat and Region Maps

o  Adding Multiple Layers to a Power Map

o  Analyzing Changes over Time

o  Creating a Tour

o  Summary

 

Mining Your Data with Excel

o  Introduction

o  Table Analysis Tools in Excel

o  Analyzing Key Influencers

o  Identifying Data Groups

o  Forecasting Future Trends

o  Using Shopping Basket Analysis

o Summary

Back to top

MSBI Training

Palium offersMSBI training in all 3 modules ie SSIS, SSAS, SSRS. It is recommended that the training be done in that order.  We also offer the modules individually. The focus of our training is on hands-on practice.

Duration of each module is 20 hours. However, if one does all 3 modules then the total will be around 52 hours.

Our Trainer is an IT Industry professional with many years of experience in this domain.

Course will cover the topics as well –

SSIS: Integration Services

 

Introduction to SQL Server Integration Services

o   Introduction

o   Product History

o   Architecture overview

o   Packages

Business Intelligence Development Studio

o   Introduction

o   Package Designer

o   Toolbox

o   Solution explorer

o   Properties window

o   Variables window

Control Flow Overview

o   Introduction

o   Connection Managers

o   Tasks

o   Precedence Constraints

o   Containers

Control Flow Task Detail

o   Introduction

o   Data Preparation Task

o   File System Task

o   FTP Task,  XML Task

o   Web Services Task

o   Data Profiling Task

o   Execute Package Task

o   Execute Process Task

Data Flow basics

o   Introduction

o   Data Sources

o   ADO.NET Source

o   Excel Source

o   Flat File Source

o   OLE DB Source

o   XML Source

o   Raw File Destination

Data Flow Transformations

o   Introductions

o   Row Transformations

o   Copy Column

o   Data Conversion

o   Derived Column

o   Aggregate, Sort

o   Multicast

o   Union All

o   Merge & Merge Join

Debugging Packages

o   Debugging

o   Breakpoints

o   Data Viewer

Deployment Management

o    The deployment utility

o    Deployment options

o    Deployment security

o    Executing packages – DTExec & DTExecUI

Deployment Options   & Utilities

o   Package Execution Options

o   File System Security Limitations

o   SSIS Deployment & DB Engine

o   SSIS Catalog Project Files

o   Package Migration Utilities

o   Command-Line Deployments

Security

o   Security Options

o   Encrypting SSIS Packages

o   Event Logging Activities

Upgrading Packages

o   Migrating packages

o   DTS packages to SSIS migration

Back to top                                                                                      Back to MSBI top

SSAS: Analysis Services

Introduction to Analysis Services

  • Introduction
  • Business Intelligence Queries
  • Architecture Options
  • Database Developments
  • Development, Management & Client Tools
  • Summary

Dimensional Model Development

  • Introduction
  • Dimension wizard & designer
  • Unknown member
  • Attribute properties
  • Date dimension
  • User Hierarchies
  • Parent child hierarchy
  • Attribute relationship
  • Translation
  • Summary

Cube Development

  • Data Source and Data Source Views
  • Computed and Named Queries
  • Building Entity Relationships
  • Deciding Data Warehouse Schema
  • Creating Dimensions and Builds
  • Attributes and Member Names
  • Choosing Dimension Templates
  • Applying Time Based Dimensions
  • Need for Hierarchies and Limitations
  • Attribute Relations and Uses
  • Building Levels and Hierarchies
  • Need for Composite Attribute Keys

KPI Calculations and Partitioned Aggregations

  • Identifying Cube Entries for FASMI Rules
  • Measures and Additives (Full and Semi)
  • Defining Measure Groups and Measures
  • Cube Customizations and Options
  • BI Enhancements and Granularity
  • Building Fact Less Cube Dimensions
  • Calculations and Conditional Colors
  • MDX Scripting for Calculations
  • Defining KPIs and Goals using MDX
  • Perspectives using MDX Expressions
  • SSAS Actions with MDX and XMLA
  • Need for Cube Partitions & Query Binding
  • Local and Remote Server Partitions
  • Need for Storage Models–MOLAP. ROLAP
  • Generation of Aggregations on Partitions
  • Storage Modes and Proactive Caching
  • Hierarchies & Relations in Tabular Mode

Security

  • Overview
  • User Security
  • Dimension Security
  • Cell Security
  • Administrator Security
  • Service amount configuration

Back to top                                                                                      Back to MSBI top

SSRS – Reporting Services

 

Introduction

o   Introduction to Business Intelligence Development Studio

o   Introduction to SSRS

o   Working with SSRS in BIDS

Basic Report Development

o   Data Sources

o   Creating a Data Source

o   Datasets & Tables

o   Adding Textbox, image etc

Tablix

o   Introduction

o   Table and Matrix

o   Tablix demo

o   Cell Contents

Expressions

o   Introductions

o   Placeholders

o   Global collections

o   Expression editor

o   Parameters in expression

Parameters

o   Introductions

o   Report parameters

o   Filtering data with Report Parameter

o   Parameter values from Dataset

o   Dynamic parameter values

Report Dataset

o   Introduction

o   Joining dataset

Delivering SSRS Reports

o   Report Delivery Options & Schedules

o   Accessing and controlling reports

o   Leveraging RS Web services

o   Choosing between Rendering Formats

Managing Reports

o   Report Manager Configurations

o   Managing Data Sources Security

o   Exporting and Importing Reports

o   Creating Global Schedules – Site Level

o   Snapshot Management & Schedules

o   Regenerating Snapshots for Tuning Options

Learning Centers:

1st Floor, ‘Sheeba Bhavan’,                                        8th Floor, RDB Boulevard

1/22, Poddar Nagar, (Nr South City Mall)           Salt Lake Sector V

Kolkata 700068  +91-4001 47947                         Kolkata - 700091

o   ReportServerTempdb Usage

o   Tuning Reports with Caching Options

Scheduling and Subscriptions

o   Creating Standard Subscriptions

o   Data-Driven Subscriptions

o   Subscription & Logging Options

SSRS Report Security

o   Report Data Source Security

o   Report Server Security Levels

Report Server DB Security

 Back to top                                                                                      Back to MSBI top

 

About the Faculty

The programs are conducted by an experienced IT professional with many years of experience in IT Consulting domain. He has been working with MSBI for the last 4-5 years in a top tier IT company and has implemented the solution in India and abroad.


Who are we?

Palium is a training organization conducting trainings on Functional, Soft-Skills, IT and Project Management areas. We have conducted trainings for leading corporates like ITC, JUSCO, CMS and many others.

We also conduct trainings on Primavera P6, MS Project and other Project Management related topics.

For Registration Contact:               

Barindra De:  + 91 – 90510  92035   or

Shrabana Pal: + 91 – 84205  94969

Palium Software Services Private Limited

1st Floor, ‘Sheeba Bhavan’,

1/22, Poddar Nagar

(Near South City Mall/Dominos Pizza),

Kolkata, West Bengal 700068

P: +91-842 059 4969 L: +91-33-4001 7947

E: trainings@paliumsoftware.in

www.paliumtrainings.biz

Plz call +91-9051092035 for more details -
 

 


Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save