Course Contents
What you will learn:
·
Manually design the Reports in
reporting Services and get the most out
of the automated wizards
·
Developing reports against both
Relational and OLAP Databases. Deploy and Administer the reports
·
Set up report subscriptions and control
report security
·
Practical skills in the use of
integration services to transform the data from varies file to sever
·
A thorough understanding of the data
warehouse concepts
·
MDX queries to develop the reports
using Cube
Microsoft Business Intelligence with SQL SERVER 2008R2 Training Course
Outline
SQL SERVER 2008R2 Reporting Services (SSRS)
Overview
·
Reporting Service(SSRS)
·
Report Server
·
Report Designer
·
Report Builder 3.0
·
Report Manager
Designing Reports –Fundamentals
·
Develop Reports using Report Wizard
·
Developing reports using Table
·
Developing reports using Matrix
·
Using Report Builder 3.0
·
Previewing Reports
Designing Reports –Advanced
·
Formatting (Including dates, Currency
and Other formats)
·
Using expressions
·
Conditional reporting
·
Grouping
·
Sorting
·
Interactive sorting
·
Drill-Down
·
Totals and Running total (Difference)
·
Pagination
·
Charts and Gauges
·
Parameterized Reports
o
Single Value Parameters
o
Multi Value Parameters
o
Cascading parameters
Multiple Reports
·
Drill through Reports
·
Sub Reports
·
Linked Reports
Administration
·
Configuration Manager
·
Report Manager
·
Caching Reports
·
Report Snapshots
·
Subscriptions
o
File Share
o
E –Mail (Standard and Data-Driven)
·
Security
SQL SERVER 2008R2 Integration Services (SSIS)
Overview
Data Flow
Control Flow
Data Flow
·
Sources
o Excel Source
o Flat File Source
o Raw File Source
o OLEDB Source
o XML Source
·
Destinations
o Excel Destination
o Flat File
Destination
o OLEDB Destination
o RAW File
Destination
·
Transformations
o Aggregate
o Audit
o Cache
o Character Map
o Conditional Split
o Copy Column
o Data Conversions
o Derived Column
o Fuzzy grouping
o Look up
o Merge
o Merge Join
o Multicast
o Percentage
Sampling
o Pivot
o Row Sampling
o Slowly Changing
Dimensions
o Sorting
o Term extraction
o Union All
o Unpivot
Control Flow
o Variables
o For Loop
Container
o For Each Loop Container
o Sequence
Container
o Execute Process
Task
o Execute SQL Task
o File system task
o Send mail task
o Script task
o Bulk Insert Task
o Data profiling
Task
o Check Points
Administration
·
Deploying Packages
·
Configuring Packages
·
Logging Packages
SQL SERVER 2008
R2 Analysis Services (SSAS)
Overview
Business Intelligence Overview
Analysis Services (SSAS)
Data warehouse Concepts
Introduction
o Need of Data Warehouse
o Purpose of Analysis
o Importance of Transaction Systems -- OLTP
o Characteristics
of OLTP
Architecture of Data Warehouse
o Definition of Data Warehouse
o Architecture of Data Warehouse
o Goals of Data Warehouse
o Characteristics of Data Warehouse
o Differences -- OLTP / DW
o Dimensional Modeling
o Dimension and Fact Tables
o Size of Fact Table
o Star Schema, Snow Flake Schema
o Surrogate Keys
Implementation
Methodology
o Data Mart
o Difference between Data Mart and Data Warehouse
o Inmon& Kimball Methodology
o Importance of Staging Area
Slowly Changing
Dimensions (SCD)
o SCD Type 1
o SCD Type 2
o SCD Type 3
Types of
Dimensions and Fact Tables
o Conformed Dimension
o Degenerated Dimension
o Time Dimension
o Types of Facts -- Additive, Semi Additive, Non
Additive
o Factless Fact Table
Analysis Services (SSAS)
- Introduction to Relational star schemas
- Building Dimension tables
- Building Fact tables
- Building Cubes in BIDS
- Developing
Reports using Cube
- Developing Reports in excel using Cube and
Power-pivot
MDX Functions
- MDX Functions
- Axis
- Set
- Non-Empty VS NonEmpty (Difference)
- Except
- Exists& Order
- YTD
- TopCount
- Distinct
- Current
- CurrentMember
No comments:
Post a Comment