|
|
|
 CALL + 1-866.611.4476 |
|
|
 |
| |
| Data wareHousing & Business Intelligence |
|
| |
| |
| |
Data Warehousing plays an essential role for sustaining the demands from the business - global competition, thinner margins and tougher market conditions.
The ability to provide the right information to the right people at the right time assumes high significance than ever. The huge volumes of data add more challenges
It is proven that Organizations that are most successful at consolidating and deriving intelligence out of the data are consistently leading their respective industries.
It is the ability to act faster and more effectively than the competition can be the defining advantage in today’s marketplace and the means for successfully managing customer relationships in the long run. As companies look at DW & BI solutions to address the business challenges, DW &BI software has become a multi-billion dollar market. The current business trends shows that BI is not just implemented in bigger Organizations, the SMBs also started evaluating and deriving value out of BI solutions
|
|
| |
| |
|
|
| |
| DW0101 |
Microsoft Buniess Intelligence
|
| Data warehousing Foundation |
| • |
Designing Components and Approaches |
| • |
Data Modeling Entities |
| • |
Techniques |
| SQL Server |
| • |
Fundamentals of SQL Server 2005 |
| • |
SQL Server 2005 Programming |
| • |
Managing Transactions and Locks |
| • |
Exception Handling |
| • |
Monitoring and Performance Tuning |
| SQL Server Integration Services |
| • |
Planning For ETL |
| • |
SQL Server Architecture |
| • |
SSIS Tuning Techniques |
| • |
Data Profiling |
| • |
ETL Design Alternatives - Case Study |
| • |
ETL Mapping Specs Design |
| • |
ETL Test Strategy |
| • |
Migration From DTS to SSIS |
| • |
SSIS Overview & Architecture |
| • |
Introduction to Control Flow |
| • |
Advanced Control Flow |
| • |
Introduction to Data Flow |
| • |
Variables and Configurations |
| • |
Advanced Data Flow |
| • |
Debugging, Error Handling and Logging |
| • |
Extending SSIS through Custom Code |
| • |
SSIS Configurations & Deployment |
| • |
SSIS Service & Security |
| • |
SSIS Utilities |
| • |
SSIS Packages Scheduling & Managing |
| • |
SSIS Best Practices, Optimization Techniques |
| SQL Server Reporting Services |
| • |
Dynamic Query |
| • |
Managing Reporting Services |
| • |
Reporting Services Security |
| • |
Subscriptions |
| • |
Programming Reporting Services |
| • |
Reporting and Web Services |
| • |
Reporting Services Tips and Tricks |
| • |
Report Builder |
| • |
Creating Reports |
| • |
Calculations and Formatting |
| • |
Adding, Grouping, Sorting |
| • |
Matrix Reports and Charts |
| • |
Report Parameters |
|
| DW0102 |
Hyperion Buniess Intelligence |
| Data warehousing Foundation |
| • |
Designing Components and Approaches |
| • |
Data Modeling Entities |
| • |
Techniques |
| Oracle |
| • |
Basic Oracle SQL |
| • |
Advanced Oracle PL/SQL Topics |
| • |
Exception Handling |
| • |
SQL Tuning |
| Hyperion Essbase |
| • |
Introduction to Hyperion System 9 |
| • |
Hyperion Essbase Architecture |
| • |
Creating Multidimensional Databases & Application |
| • |
Enhancing Database Outlines |
| • |
Creating Basic Dimensions Build Rules Files |
| • |
Creating Advanced Dimension Build Rules Files |
| • |
Loading Data |
| • |
Calculating the Essbase Analytics Database |
| • |
Retrieving Data |
| • |
Advanced Web Analysis Tasks |
| • |
Setting user Preferences |
| • |
Administering Web Analysis |
| • |
Designing and Managing Security Policies |
| • |
Monitoring Performance |
| • |
Optimizing the Essbase Environment |
| • |
Maintaining the Essbase Environment |
| • |
Web Analysis Overview |
| • |
Creating Web Analysis Documents
|
| Hyperion Interactive Reporting |
| • |
Dashboards Overview |
| • |
Creating Dashboards in Workspace with the Web Dash Template |
| • |
Creating Dashboards with Dashboard Studio |
| • |
Configuring Dashboard Options |
| • |
Importing and Scheduling Documents on the Web |
| • |
Optimizing Documents |
| • |
Introduction to Hyperion System 9 |
| • |
Manipulating Interactive Reporting Documents |
| • |
Creating Data Models & Querying |
| • |
Creating Table Reports |
| • |
Creating Charts & Band-Style Reports |
|
| DW0103 |
Data Warehousing & Business Objects |
| Data warehousing Foundation |
| • |
Designing Components and Approaches |
| • |
Data Modeling Entities |
| • |
Techniques |
| SQL Server |
| • |
Fundamentals of SQL Server 2005 |
| • |
SQL Server 2005 Programming |
| • |
Managing Transactions and Locks |
| • |
Exception Handling |
| • |
Monitoring and Performance Tuning |
| |
OR |
| Oracle |
| • |
Basic Oracle PL/SQL Topics |
| • |
Advanced Oracle PL/SQL Topics |
| • |
Exception Handling |
| Business Objects |
| • |
Universe Design |
| • |
BO Enterprise XI |
| • |
Universe Design Basics |
| • |
Web Intelligence |
| • |
Desktop Intelligence |
|
| DW0104 |
Data Warehousing & Informatica - Coming soon |
| Data warehousing Foundation |
| • |
Designing Components and Approaches |
| • |
Data Modeling Entities |
| • |
Techniques |
| SQL Server |
| • |
Fundamentals of SQL Server 2005 |
| • |
SQL Server 2005 Programming |
| • |
Managing Transactions and Locks |
| • |
Exception Handling |
| • |
Monitoring and Performance Tuning |
| |
OR |
| Oracle |
| • |
Basic Oracle PL/SQL Topics |
| • |
Advanced Oracle PL/SQL Topics |
| • |
Exception Handling |
| Informatica |
| • |
Planning For ETL |
| • |
Informatica - Tuning Techniques |
| • |
Repository Manager |
| • |
Informatica Power Center – Work flow Manager |
| • |
PMCMD command line utilities |
| • |
Designing ETL Mapping Specifications |
| • |
ETL Design Alternatives |
| • |
ETL Test Strategy |
| • |
Mapping parameters & variables |
| • |
Slowly Changing Dimensions |
| • |
Mapplets |
| • |
Source and Target Instances and Transformations |
| • |
Overview Informatica & Architecture |
|
| Microsoft Buniess Intelligence |
| • |
Data Warehousing Foundation |
| • |
SQL Server |
| • |
SQL Server Reporting Services |
| • |
SQL Server Integration Services |
|
Hyperion Business Intelligence
|
| • |
Data Warehousing Foundation |
| • |
Oracle |
| • |
Hyperion Essbase |
| • |
Hyperion Interactive Reporting |
|
| Data warehousing & Business Objects |
| • |
Data Warehousing Foundation |
| • |
SQL Server/Oracle |
| • |
Business Objects |
|
| Data Warehousing & Informatica - Coming soon |
| • |
Data Warehousing Foundation |
| • |
SQL Server/Oracle |
| • |
Informatica |
|
|
|
| |
|
|
|
| |
|
| |
|
|
|
|
|
| |
|
|
|
Course List
Enterprise Application
