Build Expertise is a Global leader in training,development,and consulting services that helps participants learn new technology and keep themselves updated with the new developments. Build Expertise is formed by and of certified professionals with more than decade of industry experience.
Business Intelligence
Business Intelligence is techniques for transforming data into information. This information helps to make quick decisions.
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.
SQL Server Integration Service- SSIS
Chapter-1 Introduction to BI and other BI tools
Introduction to BI
Difference between BI, DWH, Data Mining and Data Mart
Future for BI
MSBI and its Modules
Chapter -2 – Introduction to SSIS
SSIS Framework/Architecture
SSIS Overview of Components
Blocked VS Non-Blocked Transformations
Synchronous and Asynchronous Transformations
Chapter -3-Control Flow Elements
Precedence Constraints
Containers
For Loop Container
For Each Loop Container
Sequence Container
Tasks
The Execute SQL Task
The Bulk Insert Task
The File System Task
The FTP Task
The Send Mail Task
Bulk Insert Task
Data Flow Task
Execute Package Task
Execute Process Task
Tasks
Chapter -4-Data Flow Transformations
Sort Transformation
Aggregate Transformation
Audit Transformation
Character Map Transformation
Conditional Split Transformation
Copy Column Transformation
Derived Column Transformation
Data Conversion Transformation
Multicast Transformation
OLE DB Command Transformation
Percentage Sampling Transformation
Row Count Transformation
Union All Transformation
Advanced Transformations
Lookup Transformation
Merge Transformation
Merge Join Transformation
Slowly Changing Dimension Transformation
Export and Import Transformation
Pivot and Unpivot Transformation
Chapter-5- Debugging, Error Handling and Logging
SSIS debugging overview
Configuring Package Logging
Breakpoints in SSIS
Event handler in SSIS
Configure Error output in Data Flow
Data Viewers
Configure Check Points
Transactions in SSIS
SSIS Security
Chapter-6- Data Profiling and Data Cleansing
Fuzzy Lookup Transformation
Fuzzy Grouping Transformation
Chapter-7-SSIS Deployment
Create Configuration Files
Implement Logging
Different Deployment Options
Executing packages using utilities – DTExec and DTExecUI
Schedule SSIS Packages with SQL Server Agent Jobs
Monitoring Jobs in SQL Server
Call SSIS Packages in Stored Procedures
Call SSIS Packages in cmd prompt
SQL Server Analysis Service- SSAS
Chapter-1- Introduction to SSAS
Brief Introduction to SSAS and ITS Components
BIDS Environment for SSAS
Creating Project SSAS
Chapter-2-Dimensional Modeling
Introduction to Dimensions and Fact Tables
Snowflake and Star Schema Methodology
Building Data Warehouse
Loading Data using OLTP to OLAP using SSIS Packages
Full and Incremental Loading of Data
Understand Dimensions and Facts
Types of Dimension and Facts
Fact less Fact Table
SSAS Architecture
Chapter-3-Data Source and DSV
Introduction and Creation of DS, DSV
Named Queries
Options in DSV
Chapter-4-Cube Designing and development
Different Ways to Create CUBE
Measures and Measure Groups
Diff between BUILD, DEPLOY and PROCESS
Calculated Columns
Chapter-5-Hierarchies
Creating and Managing Hierarchies
Translations
Chapetr-6-Intro to MDX
Syntax of MDX
Understanding MDX
About Members, Tuple and Sets
Common MDX Functions
New or Updated MDX Functions or Keywords
Understanding the Calculations
Adding Calculated Members
Chapter-7-Processing Options
Understanding Processing
Different Processing Options
Chapter-8- Relationships
Different Types of Relationships
Creating Relationship between Fact and Dimensions
Chapter-9-Storage Modes
Different Storage Modes
How to select different Storage Modes
Chapter-10-Partitions-Aggregations
What are Partitions and How to create Partitions?
On what basis a Partition are created?
Chapter-11-Actions, Calculations, Perspectives and KPIs
What are Actions and How to create IT?
Understand KPIs and Create KPIs
Understand Calculations and Create Calculations
Creating Perspectives
Chapter-12-Deploying the Cube
Generate XMLA and Deploy a Cube in SQL Server
Create Jobs to process the cube in SQL Server
Different Approaches to Deployment
Client Interactions with Excel
SQL Server Reporting Services – SSRS
Chapter-1-Introduction to SSRS
Architecture of SSRS
Components in SSRS
Phases of Report Development Life Cycle
What is a Report?
Chapter-2-Creating Basic Report in SSRS
Wizard to develop SSRS Report
Shared Vs. Embedded Data Sources & Data Sets
Chapter -3-Report Authoring
Table Reports and Matrix Reports
Report Designer Paging Options
Drill-down Reports
Chart Reports, Indicator, Gauge Control Reports
List Reports
Use Page Header and Page Footer
Drill-Through or Linked Reports
Sub Reports
Create Report Template and use it in new Reports
Parameter Reports
Single Parameter
Multiple Parameters
Cascading Parameter
Create Calendar in Parameters
Default Values and Drop Down list options
Expressions in SSRS
Understand conditional formatting
Adding images
Grouping and Sorting
Page Header and Page Footer
Aggregate Functions
Sub Totals and Grand Totals
Document Map Reports
Create Reports with Stored Procedures
Create Reports with SSAS Cube
Chapter-4- Deploying Reports
Report Server Configuration
Configure Report Server details in SSRS Project
Report Deployment to Report Server
Chapter-5-Report Manager and Delivery
Report Builder to create ad-hoc Reports
Create Linked Reports
Create Subions
Standard Subions
Data Driven Subions
Cache a Report
Snapshot a Report
Report Logging
Contact on: 040-48513939, +91 9703347567 (BUILD EXPERTISE TRAINING & CONSULTING)
Website: buildexpertise.com
