MS BI

LIVE ONLINE INTERACTIVE
Attend our Instructor Led Live OnLine Interactive Training
28000 Enroll now
VIDEO BASED SELF TRAINING
Attend our Video Based Selfed Paced Training
40 Hours Enroll now

OVERVIEW

Business Intelligence MSBI

Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. BI technologies are capable of handling large amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities.

Microsoft provides tools to transform your business data into information. User can use these tools with Visual Studio Integrated Development Environment.

Microsoft Business Intelligence suit comprises of SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) packages.

Quick Stats

  • Gartner positions Microsoft as a leader in BI and Analytics Platforms for ten consecutive years.
  • 75% of Companies are Investing or Planning to Invest in Big Data by 2017 – Gartner
  • Global BI and Analytics Market to Reach $16.9 Billion in 2016 – Gartner
  • Average US Salary for a Microsoft BI professional is $ 107,000 – indeed.com

Benefits

Inexpensive and easy to operate

The BI solution is relatively inexpensive, especially when it is compared with other large BI vendors. For most BI users the functionality is more than adequate and ‘office-like’ user interface, the tool is relatively easy to operate.

Very user-friendly features

Very user-friendly, because of a strong integration with the Office products.

Interactive features with complete support

  • Easy exploration of data and better visualization.
  • Fully managed self-serviced business intelligence.
  • Complete use of native Excel features.
  • Interactive dashboards, guided navigation and drill-down.
  • Complete support to .Net and web services.
  • Complete end-to-end solution.

Who Should Attend

  • Engineering and IT students – B.Tech/B.E, BCA, MCA, B.Sc IT, M.Sc IT
  • People who are interested in reports creation in Microsoft SQL Server Reporting Services. No prior experience with T-SQL is required.
  • People with previous exposure to any Relational Database System or spreadsheet data, wants to design and create reports with SQL Server.
  • Professionals including Software and Analytics who have basic experience in Relational Database Systems, ETL, OLAP.

Course Outcome

  • Installation of Microsoft Business Intelligence suite with all the required components i.e. SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.
  • Understanding the concepts of ad-hoc reports using SQL Server Reporting Services.
  • Creation of basic and advanced reports and visualizations.
  • Understanding the concept of Data Warehousing (ETL and multi-dimensional modeling)
  • Creation of cubes using SQL Server Analysis Services.

COURSE MAP

Installation of Microsoft Business Intelligence Suite

  • Introduction to Microsoft Business Intelligence
  • Installation of Visual Studio Integrated Development Environment
  • Installation of Pro BI Tools Microsoft Report Services Projects for Visual Studio
  • Installation of Pro BI Tools Microsoft Analysis Services Projects for Visual Studio
  • Installation of Pro BI Tools Microsoft Integration Services Projects for Visual Studio

SQL Server Reporting Services Data Sources

  • Query Designer
  • Creating New Project
  • Creating Shared Data Source
  • Create Shared Dataset
  • Creating Embedded Data Source
  • Creating Embedded Dataset
  • Combine Two Datasets

SQL Server Reporting Services Report Items

  • List of Report Items
  • Create New Table Report
  • Create New Matrix Report
  • Display Image in Report
  • Add Text Box to Report
  • Rectangle in a Report

SQL Server Reporting Services Basic Reports

  • Create a New Report
  • Create Table Report Using Report Wizard
  • Add Grouping in Table Report
  • Create Matrix Report Using Report Wizard
  • Adding Row Groups & Column Groups to Matrix Report
  • Create a Report using SQL Views
  • Create a Report using SQL Stored Procedure
  • Add Totals, and Subtotals to Reports
  • Add, Or Remove Headers and Footers on Reports
  • Global Variables to Report
  • Export Reports to PDF, XML, Excel, Word

Basic Formatting of reports

  • Format Table Report
  • Changing Font and Background Color of a Text Box
  • Format Numbers in a Text Box
  • Format Date and Time in a Report
  • Repeat Headers on Each Page
  • Headers Visible While Scrolling
  • Filters at Tablix Level
  • Filters at Dataset Level
  • Sorting Data at Tablix Level
  • Interactive Sorting
  • Add Alternative Row Color to Report
  • Add Row Numbers to Report

Advanced SQL Server Reporting Services Reports

  • Add Custom Code inside a Report
  • Calculated Fields
  • Dashboards
  • Document Map
  • Drill Down Reports
  • Drill Through Action
  • Drill Down Matrix Reports
  • Go to URL Action
  • Lookup
  • Page Breaks
  • Subreports

SQL Server Reporting Services Parameters

  • Report parameters
  • Drop down list Parameters
  • Multi Value parameters
  • Multiple Parameters
  • Cascading Parameters

SQL Server Reporting Services Charts

  • Charts Introduction
  • Area Chart
  • Bubble Chart
  • Column Chart
  • Formatting Column Chart
  • Data Bars
  • Creating Data Bars in Matrix Report
  • Formatting Data Bars
  • Funnel Chart
  • Creating Radial Gauges
  • Creating Linear Gauges
  • Formatting Gauges
  • Indicators
  • Formatting Indicators
  • Line Chart
  • Pie Chart
  • Formatting Pie Chart
  • Pyramid Chart
  • Radar Chart
  • Range Chart
  • Scatter Plot
  • Sparklines
  • Stacked Bar Chart

SQL Server Reporting Services Report Manager

  • SQL Server Reporting Services Configuration Manager

SQL Server Reporting Services Report Builder

  • Installation of Report Builder 3.0

SQL Server Integration Services Connection Manager

  • Connection Managers Introduction
  • OLE DB Connection Manager
  • ADO Connection Manager
  • ADO.NET Connection Manager
  • Cache Connection Manager
  • EXCEL Connection Manager
  • File Connection Manager
  • FTP Connection Manager
  • SMO Connection Manager

SQL Server Integration Services Sources

  • Source Assistant
  • ADO.NET Source
  • Excel Source
  • OLE DB Source
  • Flat File Source

SQL Server Integration Services Destinations

  • ADO.NET Destination
  • OLE DB Destination
  • FLAT FILE Destination

SQL Server Integration Services Containers

  • For Loop Container
  • ForEach Loop Container – File Enumerator
  • ForEach Loop Container – SMO Enumerator

SQL Server Integration Services Transformations

  • List of Transformations
  • Audit Transformation
  • Aggregate Transformation Basic Mode
  • Aggregate Transformation Advanced Mode – Configure Multiple Outputs
  • Cache Transformation
  • Character Map Transformation
  • Conditional Split Transformation
  • Copy Column Transformation
  • Data Conversion Transformation
  • Derived Column Transformation
  • Export Column Transformation
  • Fuzzy Grouping Transformation
  • Fuzzy Lookup Transformation
  • Import Column Transformation
  • Lookup Introduction
  • Merge Transformation
  • Merge Join Transformation
  • Multicast Transformation
  • OLE DB Command Transformation
  • Percentage Sampling Transformation
  • Pivot Transformation in SQL Server Integration Services
  • Row Count Transformation
  • Row Sampling Transformation
  • Script Component As Source
  • Use Script Component as Transformation
  • Script Component as Destination
  • Slowly Changing Dimension
  • Sort Transformation
  • Term Lookup Transformation
  • Term Extraction Introduction
  • Union All Transformation
  • Unpivot Transformation

SQL Server Integration Services Control Flow Tasks

  • Bulk Insert Task
  • Data Profiling Task
  • Execute T-SQL Statement Task
  • Execute SQL Task
  • Execute Package Task
  • File System Task
  • FTP Task
  • Script Task
  • Transfer SQL Server Objects Task
  • Web Service Task
  • XML Task – Validate XML File

SQL Server Integration Services Deployment

SQL Server Import and Export Data Wizard

  • Export Data From SQL Server to Flat File Using Import and Export Data Wizard
  • Import Data from Flat File to SQL Server Using Import and Export Data Wizard
  • Export Data From SQL Server to Excel File Using Import and Export Data Wizard
  • Import Data from Excel File to SQL Server Using Import and Export Data Wizard

Microsoft SQL Server Analysis Services

  • Create a New Project
  • How to Create Data Source
  • Create Data Source View
  • Add or Remove Tables from Data Source View
  • Difference between Star Schema and Snow Flake Schema
  • Create Dimensions
  • Creating OLAP Cube
  • How to Create Cube Dimensions
  • Difference between Cube Dimension and Database Dimension
  • How to Create Named Calculations
  • Creating Measure Groups

CERTIFICATION

GET CERTIFICATION AFTER THE ASSESSMENT TEST CLEARED

FEES

Fees

 
Application Fees INR 0
Total Program Fees INR 28,000
The Program Fees can also be paid in installments
Registration  Fees INR 5000
First installment of the Program Fees

(Needs to be Paid Before the Batch Start Date)

 INR 12,000
Second installment of the Program Fees

(Needs To Be Paid in the 6th Class)

 INR 11,000
10% Early Bird Discount

10%  Extra discount on Lumpsum Payment

 

 
Apply for Programme

Drop us a Query