Bridging the Gap between Technology and Business

Microsoft Business Intelligence SQL Server 2012

SQL Server Integration Services (SSIS)

  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools
  • Deploying and Managing SSIS Packages
  • Source Control for SSIS Packages

  • Import and Export Wizard
  • Importing and Exporting Data
  • Working with Packages
  • Database Maintenance Plans
  • Creating Database Maintenance Plans using SSMS
  • Scheduling and Executing Plans
  • Examining Database Maintenance Plan Packages

  • Launching BIDS
  • Project templates
  • The package designer
  • Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

  • Control Flow Overview
  • Precedence Constraints
  • Execute SQL Task
  • Bulk Insert Task
  • File System Task
  • FTP Task
  • Send Mail Task

  • Containers – grouping and looping
  • Web Service Task
  • The WMI tasks
  • The Analysis Services tasks
  • Execute Process Task
  • Execute Package Task

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations
  • Copy Column Transformation
  • Derived Column Transformation
  • Data Conversion Transformation
  • Conditional Split Transformation
  • Aggregate Transformation
  • Sort Transformation
  • Data Viewers

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages
  • Property expressions
  • Configuration Overview
  • Configuration options
  • Configuration discipline

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The OnError event handler
  • Data Flow: Error data flow
  • Configuring Package Logging
  • Built-in log providers

  • Revisiting data sources and destinations
  • Lookup Transformation
  • Fuzzy Lookup and Fuzzy Grouping Transformations
  • Multicast Transformation
  • Merge and Merge Join Transformations
  • Data Mining Query Transformation
  • Data Mining Model Training Destination
  • Slowly Changing Dimension Transformation

  • Introduction to SSIS scripting
  • SSIS script editor
  • SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development

  • Configurations and deployment
  • Deployment utility
  • Deployment options
  • Deployment security
  • Executing packages – DTExec and DTExecUI

  • SSIS Service
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent

SQL Server Reporting Services (SSRS)

  • Tour of Features
  • Reporting Services Architecture
  • Reporting Services Terminology
  • Reporting Services Editions
  • Taking Reporting Services for a Spin

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

  • Creating Expressions
  • Using the Global Collections
  • Formatting Items
  • Conditional Formatting

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

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

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

  • Deploying Reports and Data Sources
  • Exporting Reports and Printing
  • Using the Web-Based Report Manager
  • Using SQL Server Management Studio-based Reporting
  • Services Manager

  • Caching and Snapshots
  • Creating Standard Subscriptions
  • Creating Data-Driven Subscriptions
  • Managing Subscriptions

  • Report Builder Architecture
  • Creating Report Model Projects
  • Running Report Builder

SQL Server Analysis Services (SSAS)

  • Core concept – BI is the cube or UDM
  • Example cube as seen using Excel pivot table
  • MS BI is comprehensive – more than Analysis Services on SQL Server
  • Demonstration of SQL Reporting Services with cube as data source

  • Understanding the development environment
  • Creating Data Sources and Data Source Views
  • Creating cubes – using Cube Build Wizard
  • Refining Dimensions and Measures in BIDS

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

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

  • Basic syntax
  • using the MDX query editor in SQL Server Management
  • Studio
  • Most-used Functions & Common tasks
  • New MDX functions
  • Adding calculated members
  • Adding scripts
  • Adding named sets


Introduction to new SQL Server 2012 Features



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