Bridging the Gap between Technology and Business

Microsoft SQL Server 2012 BI (Advanced) (40 Hours)

SSIS Advance Training

  • Designing a basic data warehouse
  • Loading a dimension with the SCD Wizard
  • Dimension Load Patterns: Type 0, Type 1, and Type 2
  • Demo: Transforming and Loading Data for Type 0
  • Demo: Loading Data with The Slowly Changing Dimension Wizard
  • Fact Table Design Patterns
  • Demo: Performing ETL for A Fact Table
  • Change data capture (CDC)
  • Hands-On Lab: Loading a Dimension

  • Tactics for quickly loading a fact table
  • When do you stage and when do you use in-memory processes?
  • Hands-On Lab: Loading a fact table

  • Effectively loading massive amounts of data incrementally
  • Using change data capture (CDC) in SQL Server and SSIS 2012 and 2008

  • Overcoming common performance problems in SSIS
  • How to use the new SSIS 2008 and 2012 features to synchronize systems like Change Data Capture and the Merge statement
  • Measuring performance in SSIS

  • Loading large amounts of data in parallel
  • Creating and using a queue system

  • Using transactions in SSIS
  • Using checkpoints in SSIS

  • Common Script Task patterns
  • Integration into 3rd party DLL files
  • Common Script Component patterns in the SSIS data flow

  • Using Fuzzy logic in SSIS to de-duplicate bad data

  • Using the Term Extraction transform
  • Using the Unpivot Transform
  • Using the Data Mining Transform

  • What's new in SQL Server 2012 SSIS
  • Upgrading to the project deployment model
  • Deploying packages in project deployment model
  • Configuring and administering packages

  • Learn how to use DQS to cleanse data without SSIS
  • Learn how to integrate the same pattern into SSIS

  • Creating a framework to simplify your package execution
  • Creating a logging framework

  • Loading a cube in SSIS
  • Repartitioning a cube

SSAS Advance Training

  • Analysis Services Ecosystem
  • Dimension Data Structures
  • Partition Data Structures
  • IO Patterns and Infrastructure Best Practices

  • Advanced Dimension Design Practices
  • Special Dimension Types
  • Partition Sizing and Management
  • Aggregation Best Practices
  • Handling Special Partitions (i.e. Distinct Count, ROLAP)

  • Command and Query Architecture in SSAS
  • Formula Engine Architecture and Optimization
  • Storage Engine Architecture and Optimization
  • Memory Management in Analysis Services

  • Optimizing Processing in Analysis Services
  • Base lining Analysis Services
  • Important Performance Metrics
  • High availability with Analysis Services

  • Demo: Creating the Account Dimension
  • Demo: Defining Account Intelligence
  • Demo: Working with Unary Operators
  • Demo: Configuring the IsAggregatable Property
  • Demo: Working with the Naming Template
  • Demo: Defining a Default Member
  • Demo: Configuring a Custom Rollup
  • Parent-Child Hierarchy Considerations

  • Demo: Creating a Referenced Relationship
  • Demo: Creating a Many-to-Many Relationship

  • Writeback Concepts
  • Dimension Writeback
  • Demo: Dimension Writeback
  • Cell Writeback
  • Demo: Cell Writeback

  • Aggregation Concepts
  • Query Processing
  • Aggregation Usage
  • Demo: Aggregation Usage
  • Aggregation Wizard Optimizations
  • Demo: Aggregation Wizard Optimizations
  • Aggregation Designer
  • Demo: Aggregation Designer
  • Usage Based Optimization
  • Demo: Usage Based Optimization

  • Partitioning Strategy
  • Partition Storage
  • Demo: Configuring Storage Modes and ROLAP Dimensions
  • Demo: Adjusting ROLAP Dimension Settings for Deployment
  • Demo: Adding Records to a ROLAP Partition and ROLAP Dimension
  • Partition Design
  • Demo: Using the Partition Wizard
  • Merging Partitions
  • Demo: Merging Partitions
  • Dynamic Partitioning
  • Demo: Dynamic Partitioning Implementation
  • Processing Strategies
  • Demo: Backup and Restore a Database

  • Dynamic Security in SSAS.
  • Roles and MDX.

SSRS Advance Training

  • 5 Second Rule
  • Spotting Design Mistakes
  • Choosing Colors
  • Choosing Charts
  • Hands-on Lab: Identifying Report Design Mistakes

  • Why use Custom Code?
  • Direct Embedding
  • External Assemblies
  • Hands-on Lab: Implementing Custom Code

  • Advanced Functions
  • Launch Office Tools from your report
  • Launching Bing Maps
  • Hands-on Lab: Dynamically launching Bing Maps
  • Report Manager
  • Linked Reports
  • Object Visibility
  • My Reports
  • Hands-on lab: Using Linked Reports
  • Report Builder 3.0
  • Train the Trainer: How to Teach End Users
  • Using Report Parts
  • Hands-on Lab: Building and Using Report Parts

  • Setting up an Email Server
  • Configuring an Execution Account
  • Understanding and Enabling Encryption Keys
  • Using SSL within SSRS
  • Usage Reports
  • Hands-on Lab: Implementing Report Server Monitoring Reports
  • Role based security explained
  • Creating System-Level Permissions
  • Creating Item-Level Permissions
  • Creating Custom Security Roles
  • Hands-on Lab: Creating and Using a Custom Security Role
  • Creating Snapshots
  • Performance Tuning with Report Caching
  • SSRS Performance Counters
  • Hands-on Lab: Setting up a Report Snapshot

  • Report Server Database
  • Configuration
  • Deployment
  • Building a Subscription
  • Monitoring Subscriptions
  • Debugging Failed Subscriptions
  • Hands-on Lab: Building a Data Driven Subscription

  • Demo: Creating a Custom Color Palette
  • Demo: Adding Intervals to a Line Chart
  • Demo: Adding a Scale Break to a Column Chart
  • Demo: Configuring Empty Points
  • Demo: Adding a Moving Average to a Column Chart
  • Demo: Moving a Series to a Secondary Axis
  • Demo: Changing the Series Chart Type
  • Demo: Assigning a Series to a Separate Chart Area
  • Demo: Working with Pie Slice Properties

  • Map Layer Data Properties
  • Map Layer Properties
  • Demo: Adding and Configuring a Line Layer
  • Demo: Adding and Configuring a Point Layer
  • Color Rule Options
  • Demo: Working with an Analytical Dataset
  • Demo: Applying a filter to an Analytical Dataset
  • Map Elements and Viewport Properties
  • Demo: Working with Viewport Properties
  • Scales and Legends
  • Demo: Configuring Legends
  • Demo: Adding a Custom Point

  • Query Designer - Design Mode
  • Query Designer
  • Demo: Building a Basic Query
  • Demo: Working in Query Mode
  • Demo: Using the FormattedValue Property
  • Demo: Adding Formatting Properties to a Cube
  • Configuring Font Properties with Extended Field Properties
  • Demo: Using the Aggregate Function
  • Demo: Using Aggregations Directly from the Cube
  • Demo: Adding a Calculated Member to a Dataset



Be Our Channel Partner for IT Training Division

Do you want to be a part of our mission in providing Quality Training and help in “Bridging the Gap Between technology and Business”?

  • Amoeba Technologies Sales Executive will contact you and shortlist you for being our channel partner based out on our discussion and shortlisting process
  • We only promote limited partnership depending upon the credibility, location and Business demand
  • No compromise on Trainer Technical Expertise. Amoeba Technologies will provide their own Technical Consultants and Trainers

Please drop your interest and profile at Sales@amoebatechno.com

Testimonials

We sincerely perceive, consider and positively act on our customer’s feedback

Our Clients

Our focus is only you and your benefit