MSBI

PRAGIM Technologies: MSBI Course Contents

Introduction to MS - BI:

  • What is MS-BI
  • BI/DWH life cycle
  • ETL and OLAP Tools
  • Features of MS-BI

Introduction to SSIS:

  • Package
  • Tasks
  • SSIS installation
  • SSIS Architecture
  • SSIS Wizard
  • Control Flow Tasks
  • Data Flow Task
  • Variables and Expressions
  • Errors and Debugging SSIS
  • Data viewers
  • Deployment
  • Manually Executing SSIS Package
  • Scheduling SSIS Package
  • Importing and Exporting Packages
  • Monitoring and Optimizing Packages

Introduction to SQL Server Reporting Services:

  • Reporting Services Architecture
  • Reporting Services Terminology

Creating Reports:

  • Deconstructing Reporting Services
  • Shared Data Sources
  • Creating Reports from Scratch

Calculations and Formatting:

  • Creating Expressions
  • Using the Global Collection

Grouping and Sorting:

  • Creating Groups and Calculating Totals and Percentages
  • Interactive Sorting, Creating Drill-Down Reports

Report Parameters

  • Creating Report Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters
  • Debugging Parameter Issues

Creating Matrix Reports and Charts:

  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities

Reporting Services Security:

  • Two Parts to Reporting Services Security
  • Securing Access to Reports
  • Data Source Security

OLAP Modeling:

  • Modeling source schemas—stars and snowflakes
  • Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
  • Understanding fact (measures) and cube modeling

Intermediate SSAS:

  • KPIs
  • Perspectives
  • Translations – cube metadata and currency localization
  • Actions – regular, drill-through and reporting

Advanced SSAS:

  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
  • Modeling changing dimensions – Dimension Intelligence w/ Wizard
  • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account
    intelligence

Cube Storage and Aggregation:

  • Storage topics – basic aggregations, MOLAP
  • Advanced Storage Design – MOLAP, ROLAP, HOLAP
  • Partitions – relational and Analysis Services partitions
  • Customizing Aggregation Design - Processing Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Welcome to the Real Time – Proactive Caching
  • Cube processing options

Beginning MDX:

  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Most-used Functions & Common tasks
  • New MDX functions

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

MSBI

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.