elektrikçi şişli elektrikçi ataşehir elektrikçi üsküdar elektrikçi ümraniye deri mont

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

Rating