DATA WAREHOUSE (DW) - VERSION P10



Objective

Business Intelligence (BI) describes resources and IT tools that allow corporations to access data and exploit the information contained in a Data Warehouse / Datamart. The stored data can be of the company, its competitors, clients and vendors, as well as situational aspects that can influence business. The analysis and understanding of such information enables safer decision-making.

Target Audience

IT analysts, DBAs, Business Analysts, Data Warehouse Analysts, who use any ERP platform and Databases.

Pre-requirements

  • Basic SQL knowledge;
  • Technical notion of Protheus, its architecture (directories, server configurations, dictionaries) and installation;
  • Knowledge in systems analysis: data standardization;
  • We recommend basic knowledge of ADVPL syntax to better use DW tool.


Topics addressed

  • Data Warehouse Concepts;
  • Installation and Configuration of DW;
  • Case Study:
    •     Creating a logical design;
    •     Creating Dimensions;
    •     Fact-table;
    •     Cube;
    •     Queries:
      •         Table;
      •         Chart.
  • Setting up User passwords;
  • Scheduling Import;
  • Administrative Tools;
  • Native Indicators;
  • Off-line panels.

Course Load

16 Hours

Para conferir as próximas turmas desse curso acesse:

>>CALENDÁRIOS DE CURSOS

Noticias

Read More

Blog

Blog

O que é Big Data?
Tags: 3 três vs, big data, business analytics, cloud computing, conectar, conectividade, dados, excesso de informação, grande quantidade, internet, pequenas e médias, pme, produção de informação, rede virtual, tendência
Por que o MSN Messenger morreu
Tags: ciclo de vida, compartilhar, comunicação, comunicar, devices, dividir, instantaneidade, mensagem instantânea, mobilidade, msn messenger, redes sociais, smartphone, tablet
Subscribe to this blog. Subscribe to this blog.