Call Us: +91-99495-33324 Land Line: 040-40208208
Free Demo Classes on Every Saturday and Sunday at 9:30 Am onward

Microsoft Business Intelligence

  • Home
  • Microsoft Business Intelligence
Loading Events

« All Events

Microsoft Business Intelligence

May 23, 2018 - May 23, 2022

$52

Microsoft Business Intelligence Pro Training

MS-BI( Microsoft Business Intelligence) is powerful Tool .which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empowers users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.

 

Curriculum
Our Courses prepared by Industry experts and BI Consultants
Lab Support
Our technical team is ready to assist you both online and inpremise
Scenarios
Our training covers best practices and real-time scenarios
Certification Assistance
We help you to prepare for certification exam

Trainers

Mr .Mahesh
MS BI Testing Specialist
Having 9+ years of experience in MSBI Technologies, Mahesh worked in Accenture Company.

What do our Students say ?

The Spoorthy training and the support that they offered were really top quality. I have only positive reviews for the entire MSBI online training. Great to learn at Spoorthy!
Consultant
Nagendra Samsani
Thank you for your solution to my issues faced. I am giving full marks to the entire Spoorthy Support team. You are the best!!
IT Consultant, Banglore
Ronik Josh
The Microsoft Business Intelligence Stack can be mastered by anybody regardless of their prior skills thanks to game-changing Spoorthy Online MSBI training and certification course.
Business Analyst, Pune
Alok Panday
The best part of this Microsoft Business Intelligence training course from Spoorthy is that it can be taken by professionals to gain succeed in their respective careers.
MSBI Consultant, Delhi
Krtithi Gupta

Course Content

A Introduction of MS-BI

 

  • What is MS-BI?
  • Modules in MS-BI
  • S ( SQL Server Analysis Service)
  • SSIS ( SQL Server Integration Service)
  • SSRS ( SQL Server Reporting Service)

 

Module 1 – SQL Server Analysis Services (S )

 

Introduction to S and DW Storage 

  • Need of OLAP Databases and DW Store
  • Tabular & Multidimensional Modes
  • Need for Cubes and Measures
  • Identifying Facts and Dimensions
  • Identifying Measures and Aggregates
  • Identifying Attributes and Hierarchies

S Design Entities & Cube Usage

  • 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 Colours
  • MDX Scripting for Calculations
  • Defining KPIs and Goals using MDX
  • Perspectives using MDX Expressions
  • S Actions with MDX and XMLA
  • Need for Cube Partitions and Query Binding
  • Local and Remote Server Partitions
  • Need for Storage Models – MOLAP and ROLAP
  • Generation of Aggregations on Partitions
  • Storage Modes and Proactive Caching
  • Hierarchies and Relations in Tabular Mode
  • TIME Dimensions in Tabular Mode

MDX Functions, FILTERS and JOINS 

  • MDX Language Syntax & Statements
  • MDX Functions & JOINS
  • Complex MDX Queries & FILTERS
  • PARALLELPERIOD, TIME Functions
  • Conditional FILTERED JOINS in MDX
  • Cube and Dimension Write backs
  • MDX Transactions & Limitations

Data Mining and Forecast

  • Need for Data Mining Structures
  • Data Mining Algorithms and Rules
  • DMX Queries and Forecast Reports
  • Data Mining Scope and Ranking
  • Prediction Functions and Analysis

Deployment (Tabular & Multidimensional)

  • Deployment Options and Tools
  • Creating OLAP (S ) Databases
  • Processing Options and stages
  • S Database and Cube Audits
  • Managing S Log Providers
  • OLAP & Tabular Database Backups
  • Restore Options and Partitions
  • Scripting DB Backups and XMLA
  • Scheduling Backups and Jobs
  • DB Synchronizations and XMLA
  • Managing Partitions & Aggregations

OLAP Management (Tabular & Multidimensional)

  • Need for Optimizations and Audits
  • Designing Aggregations using UBO
  • OLAP Restore Options and XMLA
  • S Security Roles and Scope
  • Object Level Access and MDX
  • Drill-Through Security and MDX
  • Item Level Security and DAX Filters
  • Dynamic Security Implementation
  • Security Audits and Cube Access Logs
  • Upgrading OLAP Databases (DW)
  • OLAP DB Synchronization Script

 

Module 2 – SQL Server Integration Services (SSIS)

 

SSIS Architecture and DW Concepts

  • Data Warehouse Design and SSIS
  • DW Components and SSIS Tools
  • Need of SSIS for ETL Operations
  • SSIS Configuration and Catalogue DB
  • Control Flow Tasks Architecture
  • Data Flow Tasks Architecture
  • Data Pipelines and Buffer Usage
  • SSIS Data Types and Conversions
  • SSIS Local & Global Variables
  • Dynamic Precedence Constraints
  • Dynamic Connection Managers
  • Data Flow Transformations usage
  • Handling Enumerations in SSIS
  • Expressions and Iterations
  • SCRIPT Task usage in SSIS

SSIS Expressions & Debugging 

  • Conditional Precedence Expressions
  • SSIS Parameters Usage and Variable
  • Control Flow Breakpoints
  • Data Flow Data Viewers and Audits

Data Flow Transformations .

  • Row and Column Transformations
  • Combining and splitting datasets
  • Performing database operations
  • MERGE Vs UNION ALL Transformations
  • Lookup, Fuzzy Grouping, OLE-DB Command
  • SORT Vs AGGREGATE Transformations
  • Custom Code Handling in DW
  • Event Notifications and Emails
  • Data Sampling and Data Delta
  • Type I and Type II SCDs
  • Performing PIVOT operations
  • SSIS Transactions & Isolation Levels
  • CHECKSUM Transformation in DW
  • Iterating XML nodes and Data
  • CACHE Transformation & Performance
  • Applying Configuration Options
  • Parent – Child Parameters & Options

Event Logging and Event Handling

  • Configurations and benefits
  • System Events and Audits
  • Package Event Handling
  • Limitations of Event Handling
  • Event Bubbling Escalations
  • Benefits of SSIS Logging
  • Environment Variables Usage
  • Windows Event Logs and SSIS
  • SQL Server Logging Limitations
  • Choosing correct log providers
  • Package Execution Audits

Deployment Procedures

  • Deployment Versioning & Options
  • SSIS Deployment Phases & Manifest Files
  • Project Packaging and ISPAC Files
  • Validation & Verification Techniques
  • SSIS Checkpoints and Usage
  • Data Analytics and Debugging
  • Data Profiler & ADO Connections

Deployment Options & Utilities

  • Package Execution Options
  • File System Security Limitations
  • SSIS Deployment & DB Engine
  • SSIS Catalogue
  • Project Files
  • Package Migration Utilities
  • Command-Line Deployments
  • TDS Sizing and Tuning Options

SSIS Package Security and Upgrades

  • Encrypting SSIS Catalogs
  • Package Store and SSISDB
  • Security Audits and Reports
  • Container and Package Logging
  • DTS packages to SSIS migration
  • Upgrading 2008 Packages to 2012
  • MSDB and SSIS Catalog Files
  • Comparing SSIS 2008 R2 & 2012
  • ISPAC Files & Package Migrations

 

Module 3- SQL Server Reporting Services (SSRS)

 

Reporting Services Architecture 

  • Introduction to Reporting Services
  • Three-Phase Report Life Cycle
  • Reporting Engine Architecture
  • SSRS 2012 and Web Service URLs
  • SSRS 2012 Configuration & Ports

Report Design with Data Sets & Aggregates

  • Report Designer Usage and Scope
  • Report Builder Usage and Scope
  • Report Manager and Options
  • Report Delivery & Layout Planning
  • Enterprise and Ad-hoc Reports
  • Working with Multiple DataSets
  • Configuring Dynamic DataSets

Sub Reports – Parameters & Filters

  • Designing Wizard based Reports
  • Designing Custom Reports
  • Using Tables and Matrix
  • Chart Based Reports and Images
  • Using SSRS Expressions & Global Fields
  • Sub Reports and Report Options
  • Report Testing and auto Refresh
  • BUILD and DEPLOY Options
  • Parameters and Dynamic Populations
  • Report Filters in Data Sets
  • Sub Reports and Nested Reports
  • Gauge Reports, Indicator Reports
  • Charts and Data Bars
  • Exporting Reporting Data

Cube Reports and Report Models 

  • Designing Reports using OLAP DBs
  • Identifying KPIs and Measures
  • MDX Queries in Cube Reports
  • Report Models and parameters
  • Identifying Report Entities
  • Identifying different Attributes
  • Aggregations Based Expressions Calculations
  • Remote Data Sources & Data Sets
  • Linked Reports and Graphs

Report Builder Usage & Schedules 

  • Using Report Builder Wizards
  • Map Reports with UI and Site Settings
  • Report Parts and Web Services
  • Report Designer Vs Report Builder
  • Report Server Configurations Tools
  • Report Migrations and Precautions

Delivering SSRS Reports 

  • Report Delivery Options & Schedules
  • Accessing and controlling reports
  • Leveraging RS Web services
  • Choosing between Rendering Formats

Managing Reports 

  • Report Manager Configurations
  • Managing Data Sources Security
  • Exporting and Importing Reports
  • Creating Global Schedules – Site Level
  • Snapshot Management & Schedules
  • Regenerating Snapshots for Tuning Options
  • ReportServerTempdb Usage
  • Tuning Reports with Caching Options

Scheduling and Subscriptions 

  • Creating Standard Subscriptions
  • Data-Driven Subscriptions
  • Subscription & Logging Options

SSRS Report Security 

  • Report Data Source Security
  • Report Server Security Levels
  • Report Server DB Security

SSRS Configurations

  • Report (RDL) Configurations
  • Email Based Report Subscriptions
  • Managing Configurations Files
  • Choosing correct Configuration Values
  • RDL Reports Upgrades & Downloads
  • Scale-out Deployments in SSRS
  • Execution Accounts and SSRS Schedules

 

Fix an appointment with our Consultant




Select Course Interested

I Accept that Sporrthy Solutions Agent can call me, to explain about the course and Best Offers

Details

Start:
May 23, 2018
End:
May 23, 2022
Cost:
$52
Event Category:
Event Tags:
Website:
www.spoorthysolutions.com

Organizer

Spoorthy Software Solutions
Phone:
+91 040-40208208
Email:
info@spoorthysolutions.com
Website:
https://spoorthysolutions.com

Venue

Spoorthy Software Solutions
#302,15/A, 16/A, 17/A, Nandhini Enclave, Addagutta Society, HMT Hill Road, Hyderabad, India
Hyderabad, Telangana 500090 India
+ Google Map
Phone:
+91 040-40208208
Website:
https://spoorthysolutions.com/

Subscribe to our newsletter

logo

Spoorthy Software Solutions believes in providing the quality training, consultation, staffing service to its clients.

With to impart new energy in the IT training by endowing first rate and industry oriented courses to churn out the next generation IT experts.

Upcoming Demos

  1. Microsoft Business Intelligence

    May 23, 2018 - May 23, 2022
  2. Informatica

    May 23, 2018 - May 23, 2022