BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

Microsoft BI Training


MSBI

What is MSBI?

The course is projected and responsible for IT Professionals who are responsible for implementing and maintaining SQL Server 2014 reporting and analysis solutions is Microsoft Business Intelligence [MSBI] .Microsoft Business Intelligence [MSBI] training course, you will lunge into Designing an ETL Solution Architecture of Using Microsoft SQL Server Integration Services and Implementing and Maintaining Microsoft SQL Server Integration Services. In accumulation, we will comprehensively cover how to Design an Analysis Solution Architecture Using Microsoft SQL Server Analysis Services and Implement and Maintain Microsoft SQL Server Analysis Services. You will increase your understanding on MDX Queries and gain knowledge of how to create complex reports employing expressions, global collections, and conditional formatting using SQL Server Reporting Services. This course which is called MSBI consists of all genuine tasks which arise in day to day activities. Each and every topic is covered with unique case studies.

MSBI has 3 classifications: –

SSIS – SQL Server Integration Services: This is used for the coordination like deceiving the data beginning with one database then onto the following like from Oracle to SQL Server or from Excel to SQL Server et cetera

SSAS – SQL Server Analytical Services: This is used to separate the execution of the SQL server to the extent stack-altering, overpowering data, transaction etc

SSRS – SQL Server Reporting Services: This device is related to the time of the report. This is an extraordinarily profitable gadget as it is stage self-sufficient.

After completion of MSBI [Microsoft Business Intelligence] course from Best Way Technologies, students will be able to:

Understand the structure of a Business Intelligence Solution, including multi-dimensional database models and the role of data transforms and data analytics.

Make the blueprint and implement various kind of data transformation solutions to populate data-marts and data-warehouses using SSIS

Define business dimensions, measures, hierarchies, members and KPIs in BIDS using SSAS.

Build custom reporting solutions using SSRS.

As we move from experience and intuition based decision making to actual decision making, it is increasingly important to capture data and store it in a way that allows us to make smarter decisions. This is where Business Intelligence / Data warehouse comes into picture in mind. There is an enormous requirement for Microsoft Business Intelligence professionals and this course acts as a foundation which opens the door to a variety of opportunities in Business Intelligence space. Although there are many vendors provide MSBI tools, very few of them provide end to end BI suite and huge customer base. One of the big giant called Microsoft stands as head with its user-friendly and cost effective Business Intelligence suite helping customers to get a 360 degree view of their businesses.

Who Can Take This Course in Best Way Technologies?

Any individual with a desire to make a career in the field of Business Intelligence and Data Warehousing can opt for this course. All that the student requires to pursue this course is dedication and passion to learn it. Business Intelligence is one of the streams that are looking for talented professionals. There is a huge demand for data warehousing and the professionals with experience tools and platforms like Microsoft Business Intelligence.

We are Provides Microsoft Business Intelligence (MSBI) Online Training in India with Real time working Professionals.

MS-BI Course Content

SQL Server Integration Services

Introduction to SQL Server Integration Services

  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools

Using SQL Server Management Studio

  • The Import and Export Wizard
  • Review SQL Queries, Sub Queries, Joins

Using SQL Server Data Tool

  • Launching Data Tool
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

Introduction to Control 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

Advanced Control Flow

  • Containers grouping and looping
  • The Web Service Task
  • The WMI tasks
  • The Analysis Services tasks
  • The Execute Process Task
  • The Execute Package Task

Introduction to Data Flow

  • Data Flow Overview
  • Sources
  • Destinations
  • Overview of Transformations
  • Data Conversion Transformation
  • Copy Column Transformation
  • Derived Column Transformation
  • Conditional Split Transformation
  • Aggregate Transformation
  • 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

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 Data Mining Query
  • Pivot and UnPivot Transformations

SCD(Slowly Changing Dimensions)

  • About SCD
  • Types of Slowly Changing Transformations
  • Loading SCD with SSIS
  • Handling Inferred Member in SCD

CDC (Change Data Capture)

  • About CDC & LSN
  • Enabling CDC on database
  • Enabling CDC on table
  • Implementing Incremental Load with CDC

Debugging, Error Handling and Logging

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The On Error event handler
  • Data Flow: Error data flow
  • Configuring Package Logging
  • Built-in log providers
  • Transformation
  • The Data Mining Model Training Destination
  • The Slowly Changing Dimension
  • Transformation

Extending SSIS through Custom Code

  • 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 DTExecUl

SSIS Package Management

  • The SSIS Service
  • Managing packages with DTUtil
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent

 

SQL Server Reporting Services

Introducing SQL Server Reporting Services

  • Tour of Features
  • Reporting Services Architecture
  • Reporting Services Terminology
  • Reporting Services Editions

Creating Reports

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

Creating Matrix Reports and Charts

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities

Report Parameters

  • Creating Report Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters
  • Implementing Cascading Parameters

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

Advanced Reports

  • Creating Drill-Through Reports
  • Creating Sub-Reports
  • Using Page Header, Page Footer
  • Using Page Splits

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
  • Formatting Items
  • Conditional Formatting

Ad-Hoc Reporting with Report Builder

  • The Report Builder Architecture
  • Creating Report Model Projects
  • Running Report Builder

 

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

Using SSAS in SQL Server Data Tool

  • Understanding the development environment
  • Creating cubes – using the UDM and the Cube Build Wizard
  • Creating Data Sources and Data Source Views
  • Refining Dimensions and Measures

Intermediate SSAS

  • Relations
  • Hierarchies
  • KPIs
  • Perspectives
  • Translations – cube metadata and currency localization
  • Actions – regular, drill-through and Reporting

Advanced SSAS

  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions. Fact (degenerate) dimensions, Role- playing dimensions, writeback dimensions
  • Using the Add Business Intelligence Wizards – write­back. semi-additive measures, time intelligence, account intelligence
  • Modeling changing dimensions – Dimension Intelligence w/Wizard

Cube Storage and Aggregation

  • Storage topics – basic aggregations, MOLAP
  • Advanced Storage Design – MOLAP. ROLAP. HO LAP
  • Partitions – relational and Analysis Services partitions
  • Customizing Aggregation Design – Processing Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Welcome to the Real Time – Proactive Caching
  • Cube processing options

Beginning MDX (All Basics)

  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Most-used Functions & Common tasks
  • New MDX functions

Intermediate MDX

  • Adding calculated members
  • Adding scripts
  • Adding named sets

SSAS Administration

  • Best practices – health monitoring
  • XM LA scripting
  • Other Documentation methods
  • Security – roles and permissions
  • Disaster Recovery – backup / restore
  • Clustering – high availability

Introduction to Data Mining

  • What and why?
  • Data mining dimensions
  • Data mining clients
  • Processing mining models

Interview Based FAQ’s Resume Preparation

  • Request Demo

  • Add Your Review