CONSULTING

ADMINISTRATION

  • Administrating users and content including users, folders, categories, objects, inboxes, calendars, events and applications security and integration with 3rd party security infrastructures (Microsoft Active Directory and LDAP).
  • Configuration and administration including server groups and nodes.
  • Deployment infrastructure, clustering, load balancing and server settings optimization.

META-DATA LAYER (UNIVERSES)

  • Universe design tips including creation of dimensions, attributes, measures and filters; security, hierarchies, list of values, security, connections and loop resolution techniques.

WEB PORTAL, DASHBOARDS AND ANALYTICS

  • Setting appropriate viewers/editors for each type of document. Regional and language settings; Search; Discussions; Folders; Categories; Sending documents; Scheduling documents.
  • Creating and customizing personal and corporate dashboards.
  • Creating dashboard analytics including text and compound analytics.

AD-HOC ANALYSIS, REPORTING AND VISUALIZATION

  • Creating reports; Using multiple data providers (including personal data providers), prompts, filters, sets, tables, charts, ranking, sorting, variables, hyperlinks, contexts; Merging dimensions; Multilanguage support.
  • Creating workspaces based on OLAP data.
  • Creating dashboards for data visualization and “what-if” analysis.
  • Retrieve data from universe queries or published reports in Microsoft Office (Excel, Word, PowerPoint, Outlook); Using query prompts in Excel.

DATA SERVICES

  • Data Warehouse design Data Warehouse design tips and techniques; Data Warehouse concept and architecture.
  • ETL processes Creating and managing ETL jobs; Data profiling; Performance tips; Monitoring and reporting on ETL activities.
  • Data validation & Cleansing Validating data; Data cleansing techniques and workflows.

 

DEVELOPMENT

ANALYSIS

  • Business processes analysis
  • Data source analysis
  • Reporting requirements analysis

DATA SERVICES

  • Data Warehouse design Data Warehouse design based on the reporting requirements.
  • ETL processes Creating ETL jobs in Business Objects Data Integrator to feed the data warehouse structure from the operational systems’ data sources and/or flat files.
  • Data validation & Cleansing Implementing validation and data cleansing routines in Business Objects Data Integrator.

META-DATA LAYER (UNIVERSES)

  • Building meta-data layer on top of the data warehouse structure or directly over the operational systems data structures (RDBMS or OLAP). The process involves creation of classes, dimensions, attributes, measures, filters, hierarchies, lists of values, etc.

AD-HOC ANALYSIS, REPORTING AND VISUALIZATION

  • Creating reports based on universes and/or personal data providers.
  • Creating dashboards for data visualization and “what-if” analysis.

DASHBOARDS AND ANALYTICS

  • Creating and customizing personal and corporate dashboards.
  • Creating dashboard analytics including text and compound analytics.

DEPLOYMENT

  • Deployment, configuration and performance tuning of all Business Objects products.

TRAINING:

BTS provides standard and customized trainings and workshops.

COVERED TOPICS INCLUDE:

  • Administration
  • Data Services
  • Universes
  • Reporting