Visão Geral

Curso IBM Planning Analytics Developer, Este curso fornece uma compreensão de como construir modelos de relatório e planejamento no TM1 com confiança. Este é um curso aprofundado que cobre todos os aspectos do software para permitir que os desenvolvedores construam novos cubos, criem aplicativos, gerenciem a segurança, usem o Architect e Modelador de Desempenho, administração e muito mais.

Isso foi projetado para quem deseja começar a usar o TM1 para construir modelos. Presume-se que você tenha conhecimento básico do TM1, conforme abordado no curso IBM Planning Analytics - Introdução.

Por que Cognos Analytics?

Os benefícios para o negócio

1. Exploração de dados automatizada
2. Insights direto para o telefone com o aplicativo móvel
3. Governança forte em autoatendimento com recursos de segurança robustos
4. Comunicação em linguagem simples
5. Relatórios perfeitos de pixels e uma ampla gama de visualizações
6. Conexão com Jupyter Notebooks
7. Recursos preditivos com IA integrada

Pre-Requisitos

• Visão geral da arquitetura IBM Analytics
• Componentes do IBM Planning Analytics

Materiais

Conteúdo Programatico

PLANNING ANALYTICS MODEL BUILDING REQUIREMENTS

1. IBM Analytics architecture overview
2. IBM Planning Analytics components

BUDGETING, PLANNING, AND FORECASTING REQUIREMENTS

1. Understanding the IBM Planning Analytics development lifecycle
2. Review the development requirements for a course model build

BP&F requirements

1. Budget and qtrly forecast cycle
2. Sales planning
3. Driver based P&L planning
4. Central overheads planning
5. Currency translation
6. Plans secured for each country manager
7. Visibility of the status of each contributor
8. Centralised planning for group finance
9. User to update actuals on demand via a button
10. Scenario analysis
11. Commentary

REPORTING REQUIREMENTS

1. Reporting requirements
2. P&L report based on dynamic current period
3. Excel and web based reports
4. Top 10 reports
5. Ad-hoc reporting
6. Currency translation
7. Import source data from mixture of csv and directly from systems

BUILDING MODELS INCLUDING DIMENSIONS, PROCESSES, CUBES, SUBSETS, RULES, CALCULATIONS AND FEEDERS

1. Dimension order
2. Object naming conventions
3. Create a Sales cube
4. Create a P&L cube
5. Create a Currency cube
6. Create a Parameter cube
7. Adding a new dimension to an existing cube
8. Creating a dynamic subset
9. Default subsets
10. Using the dimension editor
11. Element formats
12. Element weights
13. Element attributes
14. Manual sort order

IMPORTING DATA

1. Importing from CSV and ODBC
2. Defining data source to cube mappings
3. Accumulate vs Stored Values
4. Specifying a zero out view
5. Removing redundant variables to speed up the import
6. Creating a parameter
7. Advanced scripting

CREATING REPORTS

1. Create a P&L report in Excel (Planning Analytics for Excel)
2. Create a P&L report in Web (Planning Analytics Workspace)
3. Creating a picklist in a cube cell
4. Creating a dynamic top 10 report
5. Create report with a button to import/refresh data
6. Publishing Excel reports to Web (Planning Analytics Workspace)
7. SETTING UP SECURITY
8. Adding users and groups
9. Security access privilege types
10. Securing cubes
11. Securing dimensions
12. Securing processes
13. Securing chores
14. Element and cell security

CREATING APPLICATIONS, APPROVAL HIERARCHIES, WORKFLOWS, WHAT IS SCENARIOS (SANDBOXES) AND COMMENTARY

1. Different application types
2. Building the application front end views
3. Creating an approval hierarchy / application workflow
4. Securing applications
5. Deploying applications
6. Application workflow statuses
7. Enter data as a contributor and reviewer
8. Data spreading techniques
9. Sandboxes (scenario analysis)
10. Commentary

ADMINISTRATION

1. Message log
2. Documentation
3. Chores / Scheduling jobs