MICROSOFT BUSINESS INTELLIGENT

MICROSOFT BUSINESS INTELLIGENT Course Overview

Online Guru Technologies’s MSBI training running with industry experts  according to industry requirements and demands.

This training helps you crack the interview and clear the certification as well.

Here you will get all class videos lifetime access.

Even after completion of course 24/7 support is provided for clearing interviews and certification.

By the end of the course a separate class is scheduled for interview questions and answers.

Online Guru Technologies will provide a platform to work for real time projects.

  1. Introduction to MSBI and Data warehouse concepts
  • Definition of Data Warehouse
  • Why Data Warehouse
  • DWH Architecture
  • Master Data
  • Transaction Data
  • Dimension Table
  • Fact Table
  • OLTP(Online Transaction Processing System)
  • OLAP(Online Analytical Processing System)
  1. SQL Server
  • SQL Basics
  • Constrains
  • Joins
  • Working with Data
  • String Functions
  • Date Functions
  • Aggregate Functions
  • Identity
  • Temp Table, Table Variable
  • CTE(Common Table Expression)
  • Sub Queries
  • Operators
  • Case Statements
  • While Loop and If else Statements
  • Views
  • Stored procedures
  • Functions
  • Cursor
  • Triggers
  • Indexes
  • Exception Handling
  1. SSIS (SQL Server Integration Services)
  • Introduction of SSIS
  • BIDS(Business Intelligence Development Studio)
  • Components of SSIS
  • Control Flow Items
  • For Loop Container
  • Foreach Loop Container
  • Sequence Container
  • Bulk Insert Task
  • Data Flow Task
  • Execute SQL Task
  • Execute Package Task
  • Execute Process Task
  • FTP Task
  • File System Task
  • Script Task
  • Send Mail Task
  • Data Flow Items
  • Data Flow Sources
  • OLE DB Source
  • Flat File Source
  • Excel Source
  • Data Flow Transformations
  • Aggregate
  • Audit
  • Character Map
  • Conditional Split
  • Copy Column
  • Data Conversion
  • Derived Column
  • Lookup
  • Fuzzy Lookup
  • Fuzzy Grouping
  • Merge
  • Merge Join
  • Multicast
  • SCD(Slowly Changing Dimension)
  • Sort
  • Union All
  • Data Flow Destinations
  • OLE DB Destination
  • Excel Destination
  • Flat File Destination
  • SQL Server Destination
  • Variables
  • Loggings
  • Configurations
  • Package Deployment
  • Scheduling SSIS Packages
  • SSIS Package Tuning
  1. SSRS (SQL Server Reporting Services)
  • Core Components of SSRS Reports
  • Types of Reports
  • Basic SSRS Report
  • Data Sources and Shared Data Sources
  • Datasets and Shared Datasets
  • Report Parameters
  • Cascading parameters
  • Drill down Report.
  • Report Formatting
  • Custom Expressions
  • Drill Through Report
  • Ad-Hoc Reporting with Report Builder
  • Report Model Projects
  • Subscriptions
  • Report Manager and Report Server
  • Report Security
  • Improving Report Performance
  1. SSAS (SQL Server Analytical Services)
  • Definition of Cube
  • Advantage of Cube
  • Star and snowflake schema
  • Dimensions and Dimension Types
  • Measures and Measure Types
  • Fact Table and Types
  • Data Source
  • DSV(Data Source View)
  • Hierarchy and Types
  • Cube Structure
  • Dimension Usage and Relationships
  • Calculations
  • Partitions
  • KPIs
  • Actions
  • Aggregations
  • Perspectives
  • Translations
  • Browser
  • Storage Models (ROLAP,MOLAP and HOLAP)
  1. MDX (Multi-Dimensional expressions)
  • Retrieving Cube data using MDX
  • Hierarchy
  • Sets
  • Tuples
  • Calculated Member
  • Basic MDX Functions
  • PARANT and CHILDREN Functions
  • LAG and LEAD Functions
  • TIME Functions
  • PARALLELPERIOD Function
  • YTD , QTD , MTD and WTD
  • MDX Calculations.

Online Guru Technologies conducting MSBI demo Classes with Industry experts for clarifying doubts and knowing about course, for attending free demo session Click on the “Schedule Free Demo Session” and Fill the form. Our representative will call you back and they will fix demo session timings according to your convent timings

The Demo sessions are conducting every day 1 Hour Session, the demo session conducting by real-time working professionals.

Call us on +91 - 9886508358

Training class hours – 45


All classes recorded videos


Lifetime access videos


Project classes hours – 10


Everyday support

Related Courses

MICROSOFT BUSINESS INTELLIGENT DEMO SESSIONS

7:00 AM-10:00AM - MON TO FRI


7:00 AM-10:00AM - SAT & SUN


CONTACT US


×
WhatsApp chat