Business Intelligence school training courses in Boston, MA (public, in-house or online)

This one-day, hands-on introductory course discusses enterprise BI architecture, demonstrates business user interactivity, details BI application development, and covers BI application administration. Students will spend about one-half of the class exploring MicroStrategy software with hands-on, instructor-driven exercises.

8:30AM�:00AM Registration
9:00AM�2:30PM Morning Session: Intuitive, Interactive Experience for Users and Rapid BI Application Development

Understanding th...

Full archival course description>>

You Will Learn How To

Build, query and manipulate Oracle 10g databases to create powerful applications
Retrieve and manipulate data efficiently using powerful SQL features
Create and manage database tables, views and sequences
Maintain data integrity and enforce security with privileges and roles
Compose reusable structured PL/SQL code with cursors and procedures
Enhance performance through indexes and PL/SQL optimization

Course Benefits

To efficiently h...

Full archival course description>>

You Will Learn How To

Design, build and manage Oracle 11g database applications
Establish a data model and a storage framework
Retrieve and manipulate data efficiently using SQL Developer
Create and manage database tables, sequences and synonyms
Ensure data integrity, enforce security and enhance performance
Write structured PL/SQL code to develop stored procedures, triggers and packages

Course Benefits

The Oracle Database 11g server enables high-speed t...

Full archival course description>>

You Will Learn How To

Leverage SQL Server Analysis Services to produce Business Intelligence solutions
Create and deploy multidimensional data cubes
Extend hierarchies and exploit advanced dimension relationships
Build custom solutions with MDX
Implement Key Performance Indicators (KPIs) to monitor business objectives
Make smarter business decisions with data mining techniques

Course Benefits

With the current explosion of data in today’s enterprise ...

Full archival course description>>

You Will Learn How To

Migrate and transform data using SQL Server Integration Services (SSIS)
Upgrade DTS packages and perform imports and exports
Assemble tasks to perform complex data migrations
Enhance package functionality with scripting
Extract, Transform and Load (ETL) data
Integrate Business Intelligence components

Course Benefits

In order to improve business intelligence capabilities, organizations must effectively and securely manage data migrat...

Full archival course description>>