MSBI 2012 - SSIS,SSRS,SSAS Course Content and Online Trainings.



                                                   MSBI Course Content

        1. SSIS (SQL Server Integration Services)
        2. SSAS (SQL Server Analysis Services)
        3. SSRS (SQL Server Reporting Services)

1.    Introduction:
a.    Import and Export Wizard
b.    SQL Server Data Tools
2.    Installation and Getting Started
a.    Moving Data with the Import and Export Wizard
b.    Installing SQL Server Integration Services
c.     Installing the Sample Databases
d.    Creating a Solution and Project
e.    Exploring SQL Server Data Tools
f.     Creating Your First Package
3.    Control Flow
a.    Using Precedence Constraints
b.    Manipulating Files with the File System Task
c.     Coding Custom Script Tasks
d.    Using the Execute SQL Task
e.    Using the Execute Process Task
f.     Using the Expression Task
g.    Using the Send Mail Task
h.    Using the FTP Task
i.      Creating a Data Flow
4.    Data Flow
a.    Extracting Data from Sources
b.    Loading Data to a Destination
c.     Changing Data Types with the Data Conversion Transform
d.    Creating and Replacing Columns with the Derived Column Transform
e.    Rolling Up Data with the Aggregate Transform
f.     Ordering Data with the Sort Transform
g.    Joining Data with the Lookup Transform
h.    Auditing Data with the Row Count Transform
i.      Combining Multiple Inputs with the Union All Transform
j.     Cleansing Data with the Script Component
k.    Separating Data with the Conditional Split Transform
l.     Altering Rows with the OLE DB Command Transform
m.   Handling Bad Data with the Fuzzy Lookup
n.    Removing Duplicates with the Fuzzy Grouping Transform
5.    Configuring Packages
a.    Easing Deployment with Configuration Tables
b.    Easing Deployment with Configuration Files
c.     Configuring Child Packages
6.    Troubleshooting SSIS
a.    Logging Package Data
b.    Using Event Handlers
c.     Troubleshooting Errors
d.    Using Data Viewers
e.    Using Breakpoint
7.    Introduction
a.    Define Business Intelligence
b.    Understand the Cube Structure
c.     Deploy and View a Sample Cube
d.    View a Cube by using Excel
e.    View a Cube by using SQL Reporting Services
8.    OLAP Modeling
a.    Understand Basic OLAP Modeling (star schema)
b.    Understand Dimensional Modeling (stars and snowflakes)
c.     Understand Measure (fact) and Cube Modeling
9.    Introduction to SQL Server Data Tools (SSDT)
a.    Create Data Sources
b.    Create Data Source Views
c.     Create Cubes by using the Cube Wizard
d.    Understand the Development Environment
10.  Intermediate SSAS
a.    Learn how to Create Key Performance Indicators (KPIs)
b.    Discover how to Create Perspectives
c.     See how to Create Translations for Cubes and Dimensions
11.  Cube Storage and Aggregation
a.    View Aggregation Designs
b.    Customize Aggregation Designs
c.     Implement Proactive Caching
d.    Use Relational and SSAS Partitions
e.    Customize Cube and Dimension Processing
12.  Introduction to MDX Queries
a.    Understand Basic MDX Syntax
b.    Use the MDX Query Editor in SSMS
c.     Understand Common MDX Functions and Tasks
d.    Review MDX Functions New to SSAS 2012
13.  SSRS Overview and Tools
14.  Creating Basic Reports
a.    What is a Data Source?
b.    What is a Dataset?
c.     Using the Report Wizard
d.    What is Tablix?
e.    Creating a Tabular Report
f.     Creating a List Report
g.    What is a Matrix?
h.    Deploying a Project
15.  Formatting Reports
a.    Working with Text Boxes
b.    Rich Text Formatting
c.     Managing Text Boxes
d.    Drawing Lines and Boxes
e.    Images
f.     Page Headers and Footers
g.    Adding a Document Map
h.    Rendering Reports
16.  Custom Expressions
a.    Understanding Expressions
b.    Defining Expressions
c.     Working with Report Variables
d.    Understanding Lookup, LookupSet, and Multilookup Functions
e.    Expression Samples
17.  Summarizing and Sorting
a.    Creating Groups
b.    Parent/Child vs. Adjacent Groupings
c.     Adding Totals and Aggregations
d.    Creating Aggregates of Aggregates
18.  Add Flexibility with Parameters
a.    Adding Parameters to a Report
b.    Report Parameters vs. Query Parameters
c.     Manage Report Parameter Properties
d.    Use Parameters with SQL Queries and Stored Procedures
e.    Work with Cascading Parameters
f.     Sort Based on a Parameter Setting
g.    Filtered Reports
19.  Enhanced Report Items
a.    Charts
b.    Gauges
c.     Add a Map to a Report
d.    Data Bar, Indicator, and Sparkline Report Items
e.    Nesting Data Regions
f.     Subreports and Drillthrough Reports
g.    Working with Drillthrough Reports
20.  Using Report Manager
a.    Deployment
b.    Navigating Report Manager
c.     Understanding Permissions
d.    Viewing Reports
e.    Working with Shared Data Sources
f.     Managing Reports









4 comments:

  1. thank u for sharing this best information..it's really very interesting..we are giving msbi online training

    ReplyDelete
  2. erptree training institute is one of the best oracle fusion procurement training center in Hyderabad provide training on all oracle fusion modules with real time experts across the world like USA UK India Australia
    regards
    oracle fusion procurement online training
    oracle fusion procurement training

    ReplyDelete
  3. Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a .Net developer learn from Dot Net Online Training India. or learn thru ASP.NET Essential Training Online . Nowadays Dot Net has tons of job opportunities on various vertical industry.

    ReplyDelete

Popular Posts