BEST MSBI TRAINING INSTITUTE IN HYDERABAD-SRI VINAY TECHHOUSE. MSBI ONLINE TRAINING INSTITUTE.

BEST MSBI CLASS ROOM / ON LINE / FAST TRACK / WEEK-END /ONE ON ONE TRAINING

2017-03-03T07:16:00.089-08:00

DEDICATED INSTITUTE FOR CLASSES, PROJECTS & SUPPORT

a) MSBI CLASS ROOM TRAINING b) MSBI ONLINE TRAINING
c) MSBI FAST TRACK TRAINING d) MSBI WEEK-END BATCHES
e) SSIS TRAINING f) SSAS TRAINING g) SSRS TRAINING h) MSBI Projects Training

Course	Type(Online, Class Room)	Schedule
MSBI	Both	06-07-2019 8AM-9.15AM
SSRS	Both	10-07-2019 10AM-11.15AM
SSIS	Both	12-07-2019 8AM-9.15AM
PROJECT	Both	10-07-2019 10AM & 7PM
Register: Call us on 9573168449 / drop a message to vinaytechhouse.info@gmail.com Fast Track, Week-End and One on One reach us directly (Call / Email). More focus on real time case studies and projects

Microsoft Business Intelligence (SSIS, SSAS, SSRS, DQS) and Power-BI Training with Near Real Time Projects. Detailed content with real case studies explanation. Complete Project Oriented Training and suitable for Freshers, Experienced and BI Aspirators.

ONLY INSTITUTION PROVIDING GOOD REAL TIME PROJECTS FOR MSBI & POWER BI.

Vinaytechhouse offers the below projects to the students during classes

a) BANKING PROJECT
[ 3NF Model, Agile SDLC, TFS, Kimball]

b) RETAIL PROJECT (E-Commerce)

[ Snowflake , Facts, Dimensions, LLD, HLD, Database Design]

c) INSURANCE PROJECT

[ Dimensional model, Loops, NodeList, Source Map, Excel, XML, XML Config]

Why VinayTechHouse?

Completely Practical and Real-time

Suitable for Freshers,Experienced and Architects

Session wise Handouts,Tasks and Solutions

One Real-time Project explanation for

Interview Guidance & Certification

Resume Preparation & Project Specification

Broad and detail subject with practicals and case-studies.

Direct corporate companies recruitment for freshers and experienced.

MSBI DETAILED COURSE CONTENT

http://msbivinay.blogspot.in/p/msbisyllabus.html

MSBI CLASSES MODES

A)MSBI CLASSROOM TRAINING

B) MSBI ONLINE TRAINING

C) MSBI FAST TRACK CLASSES

D) MSBI ONE ON ONE SESSIONS

E) MSBI WEEK-END SESSIONS
                                   F) SSIS TRAINING
                                   G) SSAS TRAINING
                                   H) SSRS TRAINING

FOR DETAILS CONTACT ON : 09573168449/ 04066638869

MSBI COMPONENT	DURATION	CONTACT INFO
SQL SERVER INTEGRATION SERVICES [SSIS]	20 HOURS	Contact us immediately for Class Room/ Online / fast Track/ Week-end / One on one session. 9573168449 / 040 66638869
SQLSERVER ANALYSIS SERVICES [SSAS] {MULTI DIMENSIONAL & TABULAR MODELS}	17 HOURS
SQLSERVER REPORTING SERVICES [SSRS]	17 HOURS
DATA QUALITY SERVICES [DQS]	3 HOURS
MSBI PROJECT CLASSES [REAL TIME]	10-15 HOURS

MANDATORY FUNDAMENTALS FOR MSBI DEVELOPERS [SSIS / SSAS/ SSRS DEVELOPER]

IT Data Fundamentals & MSBI Existence

v Data, Data Availability in IT

v IT data storage areas

v Data warehouse, BI definitions and layers

v MSBI existence in IT, Product services

v MSBI Tools and Components

v MSBI Opportunities

Creative visualization through screen shots

MSBI and Competitiveness

v What are BI, MSBI, and SSBI? Importance in the current Enterprise? Competitive advantages

v MSBI vs Other BI tools

v MSBI 2016 Vs Others (2014, 2012, 2008, 2005)

v Hardware, Software requirements

v Instances and installation methods

Tools& Utilities to work with MSBI

v SSDT, BIDS , SSMS, DQS Client /Server /Installer

v Sqlserver Profiler, Deployment Wizards

v Command Line Utilities

o DTUTIL b) DTUTILEXEC c) RS

§ RSCONFIG e) ASCMD etc…

Data warehousing fundamentals

v Data definitions

o (Data, Information, BI, Mining, ODS, DSS, Analysis, OLTP, OLAP, OLCP)

v Dwh Characteristics, Principles

v Dwh approaches (Top down/Bottom up)

v Dwh Life Cycle steps

v Data Mart & Types

v Data Processing Types (OLAP)

v Granularity and various granularities

v Diff between OLTP and OLAP

Creative visualization through screen shots

Dimensional Modeling Fundamentals

v Dimension, Dimension Table & types

v Fact, Fact Table & measures types

v Fact less fact table

v Various schemas (Star, Snow Flake, Galaxy & Hybrid )

v Surrogate key and usages in real time

v Model, Business, Conceptual, Logical, Physical Data Models

Real time project tables, models and tables

SQL SERVER INTEGRATION SERVICES [SSIS (Basic-Advanced):15 hours]: 2016 & 2014

SSIS in real-time projects (DWH and OLTP)

v SSIS resources in the BI and Non BI projects

v SSIS collaboration with other DWH tools

v SSIS strengths than contemporary ETL tools

v SSIS installation (SSDT, SSMS) and observation

v SSIS real time projects flow and explanation

v SSIS Development / Support responsibilities

v SSIS Testing, Deployment, Versioning, Scheduling, Defect Handling

v Normalization vs demoralization in DWH

v Dimensional Model (Facts, Dimensions) load

SSIS-2016 Logical & Physical Architectures

v What is SSIS? Detailed logical architecture and components.

v SSIS-2016 newly added features, disconnected features, enhancement and break down features

v SSIS Practical architecture, Solution, Project and Package creations and executions.

v Connection Managers, Shared Data Sources, Parameters(2012,2014,2016)

v Discussion on new Features in SSIS 2016

§ Balanced Data Distributor,

§ OData v4 data sources & and Bug Fixes

§ Data Feed Publishing Components

Real time DWH-ETL flow and SSIS operations

SSIS resources and responsibilities

ETL operations in SSIS (Data Flow Task) (Extract, Transform and Load)

v Objective of Dataflow and process flow

v In memory model and performance tips

v Aggregate, Data Conversion, Derived column ,Character Map, Audit

v Merge, Merge Join, Union All, Sort

v Multicast, Conditional Split, Oledb command

v Lookup, Fuzzy lookup, Copy column

v Pivot, Un pivot, Term Extract, Term Lookup

v CDC, Data Cleansing, Script Component

v Checksum transformation (2014) real usage

Real time scenarios, Business Logics

Custom Operations, Complex issues & situations

Implementing SCDs, CDC in DWH using restarts, transactions and data tracking

v Using Check points to configure restarts and preserve operations

v Implementing Transactions for historical and business evaluations

v Implementing Slowly Changing Dimensions in Data warehouse using No, Full and Partial chches

v No history tracking of dimension (Type1)

v Full history track and methods (Type2)

v Partial history track and need (Type3)

v Manual Implementation of SCDs, Incremental (Delta) Loading.

v Change data capture in data warehouse tables for the events insert, update and delete on OLTP

Real time scenarios and important tips

Versioning and scheduling in DWH projects

v SSIS versioning, other versioning tools

v SSIS Scheduling, other versioning tools

v Jobs, Proxy and Sqlserver agent account

Practical explanation on versioning and scheduling

SSIS ETL, Windows and Sql Server Admin tasks (Control Flow Tasks and Operations)

v Looping usages (For Each loop, For lo

v op) and various scenarios (Files, Datasets, XMLs, Excels)

v Transactional operations and Parallel processing implementation using Sequence container

v Using File System to move, copy, create folders

v Execute Sql for Single, Multi SQL, Procedure, functions with Various parameters and implementing DML, DDL statements

v Working on Master, Child Packages using Execute Package task and variables

v Expression task for evaluations, iterations

v Using Script task for customized operations

v Execute process task for Zip, Exe Operations

v Profiling and cleansing the data using Data Profiler, DQS cleansing operations.

v Controlling tasks using Precedence Constraints

Real time scenarios and many important tips

Data Loading, Fact and Dimensions load

v Direct load and components (Truncate & Load)

v Fast load implementation in SSIS

v Incremental load in warehouse tables

v Wizards, Tools, Tasks for different types of load

Practical on these with various approaches

Debugging, Logging and Event handling

v Trouble shooting and Bottlenecks identification using DataViewer, BreakPoint, Hit count debug methods

v Real time Logging, usages and observations

v Log Providers and Catalog Logging.

v Implementing Basic, Verbose and Performance

v Event vs Error Handling, real time handling

Error identification, Bottleneck resolutions

Command Line Utilities Utilization

v Various environments operations of packages using a) DTUTIL b)DTEXECUI c) DTEXEC

Practical execution with configurations

Configurations and Parameters in DWH

v Various ways of configuring SSIS packages (Legacy)

v User interactions to the packages for incremental load

v Parameters and environments in Catalog Database

Real time handling, configuring and passing values

Security, Deployment in real time projects

v Security in various ways (Password protection & Role based security), DBA role in security

v Package deployment using manifest file

(File System, Sqlserver deployment)

v Project deployment using Catalog database (SSDB) and explaining various features

Bottlenecks, Performance Tuning

v Production issues in real time, other pkg issues

v Bottleneck, various ways to identify bottlenecks

v Tuning Source, Destination, Transformation, Package and System level.

v Data pipeline optimization, in memory model

v Execution trees, memory buffer optimization

Real time issues with detailed explanation

Real time errors, memory issues and system issues

SQL SERVER ANALYSIS SERVICES [SSAS (Basic-Advanced):15 hours]:Includes 2016 &2014

SSAS in real-time projects (DWH & BI)

v SSAS resources in the BI projects

v SSAS collaboration with other DWH tools

v SSAS strengths than contemporary tools

v SSAS installation (SSDT, SSMS) and observation

v SSAS real time projects flow and explanation

v SSAS Development / Support responsibilities, SSAS Processing

v SSAS Testing, Deployment, Versioning, Scheduling and Defect Handling

v Normalization vs demoralization in DWH

v Dimensional Model (Facts, Dim) process

BISM (Business Intelligence Semantic Model) role in analysis and data mining

v SSAS 2016, 2014 and 2012 discussions.

v Installation of SSAS, Analysis Modes

v Multidimensional model and real time usage

v Tabular mode and real time usage

v Power Pivot and real time usage

v Over view of SSBI, Multidimensional Model, Tabular Model and Power Pivot

v Power Pivot for Excel and Share Point

v What is OLAP, Types of OLAP (MOLAP, ROLAP, DOLAP, HOLAP)

v Sample project, Modeling, Designing & Solution

s Detailed diagrammatic presentation

s Visualizations on multi-dimensional & tabular

Multi-dimensional model (Cube Data mart) creation in real time with various settings

v Developing Analysis Services Multi Dimension Corporate Solution with SSDT tools, Command lines.

v Data source view creation

s Add / Remove tables

s Design / Diagram panes

s Named calculations

s Named Queries

s Relationships

v Identifying dimensions with types (Date, Time, Regular, Scenario etc…)

v Creating, Deploying and Processing of cubes

s Class room cube creation with practical

s Real time cube creation and explanation

Kimball approach of Facts, Dimensions add / removal (configuring measures and dimensions)

v Working with Measures, Measure Groups, Members and Dimensions in data warehouse

v Maintaining measures in analytical format using various properties

v Configuring Dimensions, taking all attributes, composite keys, Duplicate Attribute Keys

v Discretization feature, Sort order

v Hierarchies, levels, members, performance improvement features implementation

v Linking dimensions , gathering/ collecting calculations, KPIs and actions

s Complete practical on these concepts

s Detailed coverage of each concept with its

features (not mentioned due space issue)

Semantic operations on Cube and its functionalities in DWH

v Writing various calculations using MDX

v Preparing script with multiple members

v Pros and cons of various members

v Implement Key Performance Indicators for effective report analysis

v Pull model analysis with Actions.

v Implementing Perspectives/Translations to restrict visibility and for multi-language translation

Effective relationships (Dim & Fact)

v Working with Dimension Usage Wizard

v Real time usages of various relationships (Regular, Referenced, Fact etc…)

Working on multiple tables to show practical

Parallel processing of data using Fact Partitions and various ways of processing

v Implementing Partitions (Table and Query)

v Usage of various storage modes

v Automatic processing using Proactive Caching.

v Cube, Fact and Dimension table processing

(Full, Clear, Data, Incremental, Add, Index, Update, Default etc…)

Practical on this with performance observations

Faster retrieval of data using Aggregates design and Usage based optimization

v Working with Designing Aggregations

v Normal Mode and advanced mode

v Usage based optimization

Practical on this with performance observations

Working with MDX and components

v What is MDX, MDX Fundamentals

v Identifiers, Expressions, Literals

v Data Types, Operators

v Functions (twelve types of functions)

v MDX language reference DDL, DML etc…

v MDX multi-function operators

v Sub cube expressions

v Member, Measure, Tuple, Set features

v Advanced Time and Date functions for cumulative preceding and following analysis

v MDX expressions in SSDT

v MDX Querying against OLAP Cube

s Explaining with various queries and examples

s Dedicated material and more practical oriented

s Many functions, features explanation practically

(Due to space issue, all features are not mentioned)

Data Analysis Extensions [DAX]

v Need of DAX in tabular models, Excel

v Expressions in DAX

v Identifiers, Literals and Operators

v Functions and various types of functions

s Explaining with various queries and examples

s Dedicated material and more practical oriented

s Many functions, features explanation practically

(Due to space issue, all features are not mentioned)

SSAS Deployment, real time methods

v BIDS / SSDT deployment

v SSAS deployment wizard

v XMLA method of deployment

v Backup and Restore

v SSAS synchronization wizard

v AMO objects (Analysis Services Management Objects)

SSAS Cube and MDX Performance tuning

v Production issues while cube processing

v Memory, Time and threads issue at MDX

v SSAS Database and Cube Audits - Query Logs

v Security Audits and Need for Optimizations

v DB Audits, Usage Based Optimization

v Aggregations, Usage Based Optimization Options (MOLAP) and Filters

v Partitions, Query binding

v Named Calculations, Queries and Named Sets

v Flight Recorder Settings, Query Logs

v Data Sampling Intervals and MDX Query Tuning Process

v 100% Aggregations (FULL), CPU and Space Thresholds

v Proactive cache solution for fresh update

v Lazy Aggregations & UBO in Partitions, Performance Settings

v Writeback option to save OLTP analysis

v Writeback Partitions - Cube & Dim, UPDATES

v Using MDX Expressions and Queries for Writeback. Advantages

v Writeback Tables. MDX Transactions - COMMIT / ROLLBACK

v Subcube - Creation, Advantages Usage. MDX Query Plans

v Subcube - DESCANDANTS, PARENT & MEMBER Functions

v SSAS threads, taking required number of threads

v SSAS Trace Monitoring and Sql server Profiler

s Explaining by taking a real time situation

s Many functions, features explanation practically

(Due to space issue, all features are not mentioned)

SSAS-TABULAR MODEL CONCEPTS

v Workspace Database , Workspace Server , Direct Query , Backup to disk

v Installation steps , error mechanisms and error rectification process

v Creating a tabular model and setting model properties

v Adding data to the model , renaming tables, filtering columns

v Rename Columns

v Monitoring relationships , Providing relationships

v Create Hierarchies

v Create partitions

v Create perspectives

v Create Roles

v Create KPIs

v Deployment

v Using in Excel Power Pivot and PowerView

s Explaining by constructing a real time tabular model

s Many functions, features explanation practically

(Due to space issue, all features are not mentioned)

SQL SERVER REPORTING SERVICES [SSRS (Basic-Advanced):15 hours]: 2016 & 2014

SSRS in real-time projects (DWH-BI, OLTP)

v SSRS resources in the BI and OLTP projects

v SSRS various visualizations for analysis

v SSRS and general Report Life Cycle Steps

v SSRS collaboration with other DWH tools

v SSRS strengths than contemporary tools

v SSRS installation (SSDT, SSMS) and observation

v SSRS real time projects flow and explanation

v SSRS Development / Renderer responsibilities, SSRS Subscriptions

v SSRS Publishing, and real time scheduling

SSRS Architecture and Components

v SSRS 2016, 2014 and 2012 discussions.

v SSRS Reporting Components (Report Server, Report Manager, and Databases etc…)

v SSRS Models (Push and Pull)

v SSRS report store and retrieve flow

SSRS Administration (Tools and Configuration files) and Management

v RS Manager Configuration Tool

v Configuration Files for install and configure

v SharePoint mode of explanation & install

v Create / modify Report manager / Server / Database Creation and Monitoring

v Start / Stop report server

Working with various Report facilities

v Report Server Wizard

v Report Server Project

v Report Builder

v Power View

v Dashboard

Report Design, Sub Reports & Groups

v Designing Wizard based Reports

v Custom Reports and Report Groups

v Column groups and row groups

v Child column and row groups

v Row Drilldown and Column Grouping

v Advanced and Static Options in SSRS

v Chart Based Reports and Images

v Using SSRS Expressions & Global Fields

OLTP and OLAP Reports in SSRS

v Table Reports, Tablix Properties

v Gauge Reports, Indicator Reports

v Pie Charts, Bars and Spark Lines

v Report Testing and Auto Refresh

v Map Reports and Report Dashboads

v Multiple Chart Areas in Dashboards

v Report Dashboard & Limitations

v Report Scorecards with SQL Queries

v Sparkline, Databars in Reports

v Lines, PlaceHolder usages in reports

v Images acquisition in the reports

v Exporting RDL Reports in SSRS

Excel, Map, Cube, XML Reports

v Excel reporting with DAX

v XML reporting with / without XSD

v Map Reports and Stored Procedures

v Indicators with Map Reports

v Designing Reports using OLAP DBs

v Identifying KPIs and Measures

v MDX Queries with Cube Reports

v MDX Filters with Sub Reports

v Scorecards with MDX and DAX

v Sub Reports versus Report Actions

v Accessing and Controlling Reports

Report Model, Builder & Power View

v Report Model and Features

v Model and DataSets use in Report Builder

v Chart and Map Wizard in Report Builder

v Report Parts and Web Services

v Report Designer Vs Report Builder

v Publishing Report Parts with RB

v Stored Procedures with Report Builder

v Report Downloads and Edit Options

v Power Pivot & PowerView Addins

v Power View for RDLX Reports

v Understanding Data Models

v Tables, Charts and Data Bars

v SparkLines and Data-Mashup

v Report Builder Vs PowerView

v New ReportBuilder Extensions

v ReportBuilder Mobile Edition

Report Security and Upgrades

v Data Source Security Credentials

v Report Server Security Levels

v Security Options and Report Users

v Content Manager and My Reports

v Cloning Report Roles and Schedules

v Report Browser and Report Publisher

v Report (RDL) Configuration Options

v Managing Configurations Files

v RSConfig & Encryption (snk) Keys

v SSRS Reports Upgradations

v Scale-out Deployments in SSRS

Share point server, Power View with SSRS

v Managing RDL and RDLX Reports

v Comparing PowerView and Report Builder

v Drillthrough Report Management Options

v Migrating Reports with SSRS and Excel

v Migrating Reports from 2012,2014 to 2016

Working with report layout and design

v Sub totals /Full totals

v Page Breaks

v Page Footer/Header

v Table Header/Footer

v Sorting

v Grouping

v Applying Colors, Fonts etc…

Dataset features and performance tips

v Shared dataset usage

v Table, Query, Procedure options

v Import from File, Refresh Fields, Time Out

v Calculated fields, Query Fields

v Filter usage in real time

v Parameters in the dataset

Working with Report Definition Language (RDL)

v Identifiers, Operators, Expressions

v Functions (Built in, Date, Mathematical and String)

v Report, Group variables with expressions

Drill Down, Drill through Analysis and Parameterization

v Parameterized Reports (a. Non Queried b. Queried c. Multivalued d. Cascading e)NO parameters)

v Dynamic Report Parameters and Filters

v Dependent Parameters & Usage

v Multi Valued Nullable Parameters

v Report Filters - Options and Types

v Toolbox Filters and Limitations

v Sub Reports and Report Actions

v Parent-Child Report Parameters

v Jump from one report to another using drill through

v Hierarchical analysis using drill down

Report Manager administrative features

v New folders, Data Sources, Folder Security

v Web site options, schedules, security

v Linking reports, Download and Replace of reports based on CR documents

v Maintaining history of reports

v Report security

v Report Parts in Report Builder

Report processing, rendering performance tuning tips

v Report issues at production

v Publishing and Executing Reports

v Observing Execution Logs, Execution log views

v Creating cached Instances, cache refreshment

v Creating snapshots

v Live report features

v Subscription reports (Normal, Data driven)

v SSRS components optimization

DATA QUALITY SERVICES [DQS : 4 hours]: 2016, 2014 and 2012 features

Data profiling versus DQS

DQS installation and implementation

v INSTALLING Data Quality Services 2012

v BUILDING A KNOWLEDGE BASE

v BUILDING KNOWLEDGE DISCOVERY IN DQS

v Data Cleansing in DQS

v Building a Matching Policy in DQS

v Matching Projects in DQS

v Activity Monitoring ,Configuration & Security in DQS

Practical on Data Quality and Cleansing

Share training and course content with friends and students:

msbi course fee
msbi
msbi training in hyderabad
msbi course
msbi course details
MSBI Training Institute in Hyderabad Hyderabad Telangana
msbi course fee in hyderabad
msbi online training
best msbi online training
msbi training
Msbi training inistitutes in ameerpet
msbi courses
msbi classes in hyderabad
msbi online classes
best msbi online training in hyderabad
best msbi training
Microsoft BI training in hyderabad
Microsoft BI training
Microsoft BI online training
SSIS training
SSAS training
SSRS training

MSBI RESUME CONTENT-PROFESSIONAL SUMMARY & PROJECT RESPONSIBILITIES

2017-02-03T19:06:00.002-08:00

PROFESSIONAL SUMMARY

=========================================================================

-- FOR MORE AND LATEST PLEASE CONTACT VINAY SIR ----------------

1.    Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.

2.      Work on various Business and Technical documents (Business Map, Business Change , Unit Testcase ,High level etc...)

3    Focused on Truncate & Load ,Incremental (includes SCD) and Change Data Capture Loading by using various Packages.

4.      Experienced in creating simple, medium and complex packages by using normal and Fast load options

5.      Working with Loop containers to continually repeat operations,Seqence container for transactional operations.

6.      Extensively worked on Data Flow task various sources,transforms(Derived,Lookup,Conditional Split,Sort,Merge ectc...) and destinations.

6.      Used Execute SQL task,Script task and Execute Package task when required.

7.      Implementing error handling ,branching,check point operation ,configurations and parameterization.

8.      Created simple ,Medium and complex reports based on Business Report Design documents.

9.      Using variables,parameters and various expressions to implement business logics.

10.     Using various visualizations such as Table,Matrix,Chart,List ,Indicator etc...

11.     Creating Drill Down , Drill through and Parameterized reports

8.      Participated in the bottlenecks elimination of various packages ,reports and implemented tuning standards.

6.     Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries and joins ,procedures etc...

9.      Reviewed & Tested packages and reports (Unit test ,Report test and Reconciliation).

11.      Maintained versioning in Version Tools such as TFS ,Sharepoint Server etc...

12.      Acquired good knowledge on Data Warehousing and Data Model Fundamentals.

13.      Attended trainings on MSBI2014 version.

INDIVIDUAL PROJECT RESPONSIBILITIES

=======================================================================

--FOR MORE AND LATEST PLEASE CONTACT VINAY SIR-----
       •    As an Associate I involved in getting documents, understanding, analysing documents, creating packages and queries according to those.
•    In case of changes we follow CR document procedure of the client
•    Different types of Data Loading (Direct, Incremental, SCD Type2 et...) implemented using packages and used configuration files.
•    Handled, reported errors in error tables and files.
        Using lookup ,derived, sort ,merge ,oledb command etc... transforms , various containers and tasks at control flow level.
•    Written SQL queries and delivered results as per the client requirement
•    Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
10.     Used Sql commands and queries to monitor ,reconciliate and manage packages.
•    Performance tuning of packages when necessary.
•    Adhoc and Unit testing for packages.

Share training and course content with friends and students:
msbi course fee
msbi
msbi training in hyderabad
msbi course
msbi course details
MSBI Training Institute in Hyderabad Hyderabad Telangana
msbi course fee in hyderabad
msbi online training
best msbi online training
msbi training
Msbi training inistitutes in ameerpet
msbi courses
msbi classes in hyderabad
msbi online classes
best msbi online training in hyderabad
best msbi training
Microsoft BI training in hyderabad
Microsoft BI training
Microsoft BI online training
SSIS training
SSAS training
SSRS training

MSBI TRAINING BASIC - ADVANCED WITH PROJECT

2016-08-28T03:24:00.000-07:00

Share training and course content with friends and students:
msbi course fee
msbi
msbi training in hyderabad
msbi course
msbi course details
MSBI Training Institute in Hyderabad Hyderabad Telangana
msbi course fee in hyderabad
msbi online training
best msbi online training
msbi training
Msbi training inistitutes in ameerpet
msbi courses
msbi classes in hyderabad
msbi online classes
best msbi online training in hyderabad
best msbi training
Microsoft BI training in hyderabad
Microsoft BI training
Microsoft BI online training
SSIS training
SSAS training
SSRS training

PROJECT FAQS SESSION -CONTENT

2016-06-27T10:27:00.000-07:00

BEST MSBI RESUME CONTENT & MSBI RESUME PREPARATION PROCESS

2016-03-13T01:52:00.002-08:00

====================================================================

RESUME PREPERATION PROCESS

====================================================================

1. READ AND USE THE ABOVE CONTENT FORMAT

2. OBSERVE THE BELOW PROFESSIONAL SUMMARY

AND INDIVIDUAL PROJECT RESPONSIBILITIES

3. REFER TO THE RESUMES GIVEN AS SOFT COPY

DOCUMENTS AT THE INSTITUTION

(HOW MUCH YOU OBSERVE THAT MUCH YOU WILL GAIN)

4. PLACE ALL THE IMPORTANT POINTS AND INTERESTING

POINTS IN THE RESUME FORMAT GIVEN ABOVE.

5. GET THAT MONITORED BY THE MENTOR

PROFESSIONAL SUMMARY

=========================================================================

INDIVIDUAL PROJECT RESPONSIBILITIES

MSBI-MDX CLASS ROOM QUERIES

2016-01-22T04:57:00.001-08:00

SELECT FROM [cb_Adventure Works DW2012]
---
SELECT [Measures].[Fact Internet Sales Count] ON COLUMNS
FROM [cb_Adventure Works DW2012]
---
SELECT
{
[Measures].[Sales Amount],
[Measures].[Tax Amt]
}
ON 0
FROM [cb_Adventure Works DW2012]
----
WITH
MEMBER DIFF AS [Measures].[Sales Amount]-[Measures].[Tax Amt]
MEMBER CONTVAL AS 100
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt],DIFF,CONTVAL} ON 0
FROM [cb_Adventure Works DW2012]
----
WITH
MEMBER DIFF AS [Measures].[Sales Amount]-[Measures].[Tax Amt]
MEMBER CONTVAL AS 100
MEMBER PHONE_CNT AS COUNT([Dim Customer].[Email Address].CHILDREN)
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt],DIFF,CONTVAL,PHONE_CNT} ON 0
FROM [cb_Adventure Works DW2012]
---
/*
WITH
MEMBER DIFF AS [Measures].[Sales Amount]-[Measures].[Tax Amt]
MEMBER CONTVAL AS 100
MEMBER PHONE_CNT AS COUNT([Dim Customer].[Email Address].CHILDREN)
*/
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
[Dim Product].[Product Key] ON 1
FROM [cb_Adventure Works DW2012]
----

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
[Dim Product].[Product Key].CHILDREN ON 1
FROM [cb_Adventure Works DW2012]
---

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
NONEMPTY([Dim Product].[Product Key].CHILDREN) ON 1
FROM [cb_Adventure Works DW2012]
---

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
NONEMPTY([Dim Product].[Product Key].MEMBERS) ON 1
FROM [cb_Adventure Works DW2012]
--

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
[Measures].[Sales Amount],DESC)ON 1
FROM [cb_Adventure Works DW2012]
---
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
TOPCOUNT(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
[Measures].[Sales Amount],DESC),5) ON 1
FROM [cb_Adventure Works DW2012]
----
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
HEAD(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
[Measures].[Sales Amount],DESC),5) ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
BOTTOMCOUNT(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
[Measures].[Sales Amount],DESC),5) ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
TAIL(ORDER(NONEMPTY([Dim Product].[Product Key].CHILDREN),
[Measures].[Sales Amount],DESC),5) ON 1
FROM [cb_Adventure Works DW2012]
--

SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
(
[Dim Product].[Product Key].CHILDREN,
[Dim Customer].[First Name].CHILDREN
)
ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
CROSSJOIN(
[Dim Product].[Product Key].CHILDREN,
[Dim Customer].[First Name].CHILDREN
)
ON 1
FROM [cb_Adventure Works DW2012]
--
SELECT
{[Measures].[Sales Amount],[Measures].[Tax Amt]} ON 0,
([Dim Product].[Product Key].CHILDREN) * ([Dim Customer].[First Name].CHILDREN)
)
ON 1
FROM [cb_Adventure Works DW2012]
---

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
[Date].[Calendar Year].children
)
ON 1
FROM [Analysis Services Tutorial]
---
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
[Date].[Calendar Year].&[2005]
)
ON 1
FROM [Analysis Services Tutorial]
--
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
{[Date].[Calendar Year].&[2005],[Date].[Calendar Year].&[2008]}
)
ON 1
FROM [Analysis Services Tutorial]
---

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
(
[Product].[Product Name].children,
[Date].[Calendar Date].[Calendar Year].[2005]:[2008]
)
ON 1
FROM [Analysis Services Tutorial]
---

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0

FROM [Analysis Services Tutorial]
where (
[Product].[Product Name].children,
[Date].[Calendar Date].[Calendar Year].[2005]:[2008]
)
--

SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,

[Date].[Calendar Date].[Calendar Year].&[2005] on 1

FROM [Analysis Services Tutorial]
where [Date].[Calendar Date].[Calendar Year].&[2005]

--failed query
---------------------------------
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
[Product].[Product Name].firstchild on 1

FROM [Analysis Services Tutorial]

---
SELECT
[Measures].[Internet Sales-Sales Amount] ON 0,
[Product].[Product Name].lastchild on 1

FROM [Analysis Services Tutorial]
---
SELECT [Measures].[Internet Sales-Sales Amount] ON 0,
FILTER([Product].[Model Name].MEMBERS,
VBA!INSTR(1,[Product].[Model Name].CURRENTmember.NAME,'Gloves')>0) ON 1
from [Analysis Services Tutorial]
---
SELECT [Measures].[Internet Sales-Sales Amount] ON 0,
filter([Product].[Product Name].children,
[Measures].[Internet Sales-Sales Amount]>90000) ON 1
from [Analysis Services Tutorial]
--

SSRS FAQS-MSBI FAQS FROM SRI VINAY TECHHOUSE

2015-12-03T22:25:00.003-08:00

MSBI-SSIS IMPORTANT SCENARIOS

2015-12-01T23:18:00.000-08:00

5TH SCENARIO: CAPTURING OUTPUT VALUE FROM A PROCEDURE

create procedure totalincome (@loc varchar(20),@total integer output)

as
begin
select @total=sum(sal) from emp_hist where eloc =@loc;

end;

SCENARIO:

MOVING FIXED LENGTH DATA INTO VARIABLE LENGTH

INPUT FILE:

SCENARIO : PROCEDURE TO CAPTURE OUTPUT VALUE AND TO RETURN A VALUE

BY PASSING AN INPUT VALUE

ALTER PROCEDURE NOV_PROC (@PARTYID VARCHAR(30),@NM VARCHAR(30) OUT)

BEGIN

DECLARE @CNT INTEGER;

SELECT @NM=PARTYNAME FROM PARTY WHERE PARTYID=@PARTYID;

select @cnt=count(*) from party;

RETURN @CNT;

END;

SSIS FAQS--CDC IMPLEMENTATION IN SSIS-2012

2015-11-24T23:14:00.003-08:00

CDC—CHANGE DATA CAPTURING IN SQLSERVER 2012

Capture changes of particular database / tables. Means DML events (Insert, Update, Delete etc…) operations on a table we can track here.

This concept introduced in 2008 (which is complex to implement since many procedures required,

Maximum work at database level and SSIS front very less effort required). Where as in 2012 CDC tasks introduced to simplify the operations process.

Step1:

Run the below queries in a database to enable CDC option on a Database and Table level

CREATE A DATABASE : VINAYTECH

CREATE A TABLE: PARTY (COLUMNS PID(INT) PRIMARY KEY,PNM VARCHAR(30))

ENABLING CDC AT DB LEVEL

===========================

EXEC sys.sp_cdc_enable_db

ENABLING CDC AT TABLE LEVEL

===========================

EXEC sys.sp_cdc_enable_table

@source_schema = N'dbo',

@source_name = N'PARTY',

@role_name = N'VINAYAKA',

@supports_net_changes = 1

Start->SQLServer Agent

Start->SqlserverAgent

Step 2

Create Package1 like below

Create Package2 like below

Create the Dataflow in the package like below

Step3

Run Package1, Package 2 and observe the result in the DataFlow task of Package2

It won’t show any rows

Step4

Run the below queries in the SCENARIOS_DB

INSERT INTO PARTY VALUES(2,'YYY')

DELETE FROM PARTY WHERE PID=2

UPDATE PARTY SET PNM='VINAYAKA1' WHERE PID=1

INSERT INTO PARTY VALUES(3,'DDD')

Step5

Run Package2 and Observe DataFlow reault on links.

(Shows 2 inserts, 1 update and 1 delete)

Thank you for reading completely. Have a nice practice.

SSIS IMPORTANT SCENARIOS

2015-11-23T02:56:00.001-08:00

====================================================================
1ST SCENARIO:
ENSURE THE FOLDER AVAILABILITY ,IF IT IS NOT AVAILABLE CREATE IT

2ND SCENARIO: ENSURE FILE AVAILABILITY,IF AVAILABLE LOAD THE DATA OTHERWISE SEND AN EMAIL TO THE MANAGER

3RD SCENARIO:
BASED ON EMP_DAILY DATA INCREMENT SAL WITH THE INPUT INCREMENT IN THE HISTORY TABLE.

4TH SCENARIO: SET OF FILES FROM A FOLDER LOAD TO A TABLE,MAINTAN AUDIT INFO SUCH AS FILEPATH,TIME,USERNAME,FILESIZE AND ARCHIEVE OF FILE

5TH SCENARIO: CAPTURING OUTPUT VALUE FROM A PROCEDURE

6TH SCENARIO: CAPTURING OUTPUT AND RETURN VALUE FROM A PROCEDURE

7TH SCENARIO: MOVING DATA FROM FIXED LENGTH TO VARIABLE TEXT

8TH SCENARIO: INPUT DATA WITH SINGLE QUOTES AND OUTPUT NEEDED IN DOUBLE QUOTES.
=====================================================================

SCENARIO 1:

HOW TO LOAD MULTIPLE TABLES WITH THE SAME STRUCTURE TO A DESTINATION

1ST STEP:(CREATE THREE TABLES LIKE BELOW)

create TABLE S1(TID INTEGER,TNM VARCHAR(30))

INSERT INTO S1 VALUES(1,'XXX')

INSERT INTO S1 VALUES(2,'YYY')

create TABLE S2(TID INTEGER,TNM VARCHAR(30))

INSERT INTO S2 VALUES(3,'ZZZ')

INSERT INTO S2 VALUES(4,'PPP')

create TABLE S3(TID INTEGER,TNM VARCHAR(30))

INSERT INTO S3 VALUES(5,'GGG')

INSERT INTO S3 VALUES(6,'KKK')

SELECT * FROM S1;

SELECT * FROM S2;

SELECT * FROM S3;

---

2ND STEP:(CREATE AN INTERMEDIATE TABLE LIKE BELOW WITH THE LIST OF TABLE NAMES)

SELECT t.NAME,RANK() OVER(ORDER BY T.NAME DESC) AS TCNT INTO TEMP

FROM sys.tables AS t

INNER JOIN sys.schemas AS s

ON t.[schema_id] = s.[schema_id]

WHERE s.name = N'dbo' AND T.NAME <>'TEMP'

---

SELECT * FROM TEE

--DROP TABLE TEE

3^RD STEP:

CREATE PACKAGE WITH TWO VARIABLES AND A TASK FLOW LIKE BELOW

VARIABLE : I à NUMERICà1

TNAME àSTRING àS1

SCENARIO 1:

HOW TO CREATE A DIRECTORY IF IT DOES NOT EXIST

Two ways to implement

Script task
Filesystem Task

2ND SCENARIO: ENSURE FILE AVAILABILITY,IF AVAILABLE LOAD THE DATA OTHERWISE SEND AN EMAIL TO THE MANAGER;

Script task:

Language: C#

Read Only Variable: User::File

Read Write Variable : User:: FileExists

Write the below code

Script-> precedence constraint ((DT_STR, 10, 1252) @[User::FileExists]=="True")àDataflow

ScriptàPrecedenceconstraint ((DT_STR, 10, 1252) @[User::FileExists]=="Flase")—Send Mail

3RD SCENARIO:
BASED ON EMP_DAILY DATA INCREMENT SAL WITH THE INPUT INCREMENT IN THE HISTORY TABLE.

CREATE TABLE EMP_DAILY(EID INTEGER,ENM VARCHAR(30),INC INTEGER);

INSERT INTO EMP_DAILY VALUES(1,'VINAY',2000);

INSERT INTO EMP_DAILY VALUES(2,'MADHU',1000);

INSERT INTO EMP_DAILY VALUES(3,'RAJESH',2000);

CREATE TABLE EMP_HIST(EID INTEGER,ENM VARCHAR(30),ELOC VARCHAR(30),SAL INTEGER);

INSERT INTO EMP_HIST VALUES(1,'VINAY','HYD',10000);

INSERT INTO EMP_HIST VALUES(2,'MADHU','HYD',20000);

INSERT INTO EMP_HIST VALUES(3,'RAJESH','USA',30000);

5TH SCENARIO: CAPTURING OUTPUT VALUE FROM A PROCEDURE

create procedure totalincome (@loc varchar(20),@total integer output)

begin

select @total=sum(sal) from emp_hist where eloc=@loc;

end;