MSBI TRAINING IN PUNE | ONLINE

Duration of Training  :  50 hrs

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

COURSE CONTENT :

Introduction to SQL Server Integration Services

• Data warehousing Basics

• Product History

• SSIS Package Architecture Overview

• Development and Management Tools

Business Intelligence Development Studio

• Launching BIDS

• Project templates

• The package designer

• The Toolbox

• Solution Explorer

• The Properties window

• The Variables window

• The SSIS menu

Introduction to Control Flow and Data Flow

• Control Flow Overview

• precedence Constraints

• The Execute SQL Task

• The Bulk Insert Task

• The File System Task

• The FTP Task

• The Send Mail Task

• Containers – grouping and looping

• The Web Service Task

• The WMI tasks

• The Analysis Services tasks

• The Execute Process Task, Execute Package Task

• Data Flow Overview

• Data Sources

• Data Destinations

• Data Transformations

• The Copy Column Transformation

• The Derived Column Transformation

• The Data Conversion Transformation

• The Conditional Split Transformation

• The Aggregate Transformation

• The Sort Transformation

• Data Viewers

Variables and Configurations

• Variables Overview

• Variable scope

• SSIS system variables

• Using variables in control flow

• Using variables in data flow

• Using variables to pass information between packages

• Property expressions

• Configuration Overview

• Configuration options

• Configuration discipline

Debugging, Error Handling and Logging

• SSIS debugging overview

• Breakpoints in SSIS

• SSIS debugging windows

• Control Flow: The OnError event handler

• Data Flow: Error data flow

• Configuring Package Logging

• Built-in log providers

SSIS Using SQL Server Management Studio

• The Import and Export Wizard

• Importing and Exporting Data

• Scheduling and Executing Plans

Advanced Data Flow

• Revisiting data sources and destinations

• The Lookup Transformation

• Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations

• The Multicast Transformation

• The Merge and Merge Join Transformations

• The Slowly Changing Dimension Transformation

• Transaction Handling in SSI

• Check Point configurations

Introduction to SSIS scripting

• The SSIS script editor

• The SSIS object model

• Script in Control flow: The Script Task

• Script in Data flow: The Script Component

• Introduction to SSIS component development

SSIS Package Deployment

• Configurations and deployment

• The deployment utility

• Deployment options

• Deployment security

• Executing packages – DTExec and DTExecUI

SSIS Package Management

• The SSIS Service

• Managing packages with DTUtil

• Managing packages with SQL Server Management Studio

• Scheduling packages with SQL Server Agent

Introduction to Microsoft SQL Server Analysis Services

• Overview of SQL Server Analysis Services

• Installing SQL Server Analysis Services

OLAP Modeling

• Modeling source schemas—stars and snowflakes

• Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing

• Understanding fact (measures) and cube modeling

• Other types of modeling—data mining etc…

Understanding the development environment

• Creating Data Sources and Data Source Views

• Configuring Dimensions

• Defining Attribute Hierarchies

• Sorting and Grouping Attribute

• Creating cubes

• Refining Dimensions and Measures in BIDS

Intermediate SSAS

• KPIs

• Perspectives

• Translations – cube metadata and currency localization

• Partitions

• Storage topics – basic aggregations, MOLAP, ROLAP, HOLAP

• Aggregations

MDX

• Using the MDX query editor in SQL Server Management Studio

• Most-used Functions & Common tasks

• New MDX functions

Security

• Securing a cube

DEPLOYMENT & PROCESSING THE CUBE

Introduction to SQL Server Reporting Services

Tour of Features
Reporting Services Architecture
Reporting Services Terminology
Reporting Services Editions
Taking Reporting Services for a Spin

Creating Reports
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch

Calculations and Formatting
Creating Expressions
Using the Global Collections
Formatting Items
Conditional Formatting

Grouping and Sorting
Creating Groups
Calculating Totals and Percentages
Interactive Sorting
Creating Drill-Down Reports

Report Parameters
Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues

Creating Matrix Reports and Charts
Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
Exploring the Charting Possibilities

Managing Reporting Services
Deploying Reports and Data Sources
Exporting Reports and Printing
Using the Web-Based Report Manager
Using SQL Server Management Studio-based Reporting Services Manager

Reporting Services Security
Two Parts to Reporting Services Security
Securing Access to Reports
Data Source Security

Programming Reporting Services
The Many Reporting Services APIs
Integrating Reporting Services into Applications using URL Access
Using the Report Viewer Controls

Advanced Reporting Services Programming
Using the Reporting Services Web Service
Working with Custom Assemblies

Snapshots and Subscriptions
Caching and Snapshots
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions

Ad-Hoc Reporting with Report Builder
The Report Builder Architecture
Creating Report Model Projects
Running Report Builder

Interview Question No. 1 for Microsoft Business Intelligence MSBI :  Can you provide an overview of your experience with Microsoft Business Intelligence (MSBI) tools, including the specific components you’ve worked with (eg, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services)?

Interview Question No. 2 for Microsoft Business Intelligence MSBI :  How do you design and develop ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS) to extract data from various sources and load it into a data warehouse or data mart?

Interview Question No. 3 for Microsoft Business Intelligence MSBI :  Describe your experience with creating and maintaining SSIS packages for data migration, data cleansing, and data synchronization tasks

Interview Question No. 4 for Microsoft Business Intelligence MSBI :  Can you explain your approach to implementing data quality checks and transformations within SSIS packages to ensure data accuracy and consistency?

Interview Question No. 5 for Microsoft Business Intelligence MSBI :  Discuss your familiarity with SQL Server Analysis Services (SSAS) and how you’ve used it to build multidimensional or tabular models for analytical reporting and data analysis

Interview Question No. 6 for Microsoft Business Intelligence MSBI :  Have you developed custom MDX queries or DAX expressions in SSAS to retrieve and manipulate data within multidimensional or tabular models? If yes, provide examples

Interview Question No. 7 for Microsoft Business Intelligence MSBI :  Describe your experience with building and deploying SSAS cubes or tabular models, including considerations for partitioning, aggregation, and processing

Interview Question No. 8 for Microsoft Business Intelligence MSBI :  How do you optimize SSAS cubes or tabular models for query performance and efficient data retrieval, especially when dealing with large volumes of data?

Interview Question No. 9 for Microsoft Business Intelligence MSBI :  Discuss your experience with SQL Server Reporting Services (SSRS) and how you’ve used it to design and develop interactive reports, paginated reports, and mobile reports

Interview Question No. 10 for Microsoft Business Intelligence MSBI :  Can you explain your approach to parameterizing and filtering SSRS reports to provide users with customized views of the data based on their requirements?

Interview Question No. 11 for Microsoft Business Intelligence MSBI :  Describe your familiarity with deploying and managing SSRS reports within a report server environment, including scheduling report subscriptions and managing permissions

Interview Question No. 12 for Microsoft Business Intelligence MSBI :  Discuss your involvement in designing and implementing self-service BI solutions using tools like Power BI in conjunction with Microsoft BI stack components What advantages do these solutions offer?

Interview Question No. 13 for Microsoft Business Intelligence MSBI :  Have you integrated Microsoft BI tools with other Microsoft products like SharePoint or Office 365 for collaborative reporting and dashboarding capabilities? If yes, explain your experience

Interview Question No. 14 for Microsoft Business Intelligence MSBI :  How do you handle security and access control in Microsoft BI solutions, including user authentication, authorization, and data encryption?

Interview Question No. 15 for Microsoft Business Intelligence MSBI :  Describe your experience with data visualization and dashboard design principles in Power BI How do you create compelling and insightful visualizations for business users?

Interview Question No. 16 for Microsoft Business Intelligence MSBI :  Can you discuss your familiarity with data modeling techniques in Power BI and how you design data models to support analytical reporting and ad-hoc analysis?

Interview Question No. 17 for Microsoft Business Intelligence MSBI :  Discuss your involvement in data warehousing projects using SQL Server as the backend database How do you design and optimize the data warehouse schema to support BI requirements?

Interview Question No. 18 for Microsoft Business Intelligence MSBI :  Describe your approach to performance tuning and optimization in Microsoft BI solutions, including query optimization, index tuning, and data caching strategies

Interview Question No. 19 for Microsoft Business Intelligence MSBI :  Can you explain your experience with data integration and data federation using SQL Server Master Data Services (MDS) or SQL Server Data Quality Services (DQS)?

Interview Question No. 20 for Microsoft Business Intelligence MSBI :  How do you stay updated with the latest Microsoft BI releases, features, and best practices, and how do you incorporate them into your BI development and administration tasks?