14 Apr, 2008
First steps in Business Intelligence
Posted by: Anca Alimanescu In: Business Intelligence
As a beginner in this area, I thought the first things to do is to get a little familiarized with the main concepts it involves. So, some of the keywords to start with are :
Bussines Intelligence, Data warehouse, Data mart, Key performance indicators, Extract Transfer Load (ETL), Data mining, OLAP Modelling, Multidimensional analysis, Type of models, Cube model.
My Cognos training was composed of the following :
Impromptu Series 7 Administration.
The course contained :
- Administrator Role
- Planning Process
- The Project lifecycle in 14 steps
- How to use the catalog’s data
- Joints
- Folders
- How to create user profiles
- How to optimize the performance
- User defined functions
- System deployment and mentenance
Power Play Series 7 Version 3 – OLAP Modelling using Transformer
The modules studied were :
- Plannfication, creation and use of a model plan
- Organizing multiple data sources
- How to use the measurements and the data dimensions
- Customizing the model in order to satisfy specific business needs
- Cubes customization and optimization
- Customizing the dimensions
- Security application
Tags: Business Intelligence
