Tag: Business Intelligence

Overview

Prescriptive analytics is a branch of business analytics, together with descriptive and predictive analytics. It uses predictive models to suggest actions to take for optimal outcomes, relying on optimization and rules-based techniques as a basis for decision making.

In this instructor-led, live training, participants will learn how to use Matlab to carry out prescriptive analytics on a set of sample data.

By the end of this training, participants will be able to:

• Understand the key concepts and frameworks used in prescriptive analytics
• Use MATLAB and its toolboxes to acquire, clean and explore data
• Use rules-based techniques including inference engines, scorecards, and decision trees to make decisions based on different business scenarios
• Use Monte Carlo simulation to analyze uncertainties and ensure sound decision making
• Deploy predictive and prescriptive models to enterprise systems

Audience

• Business analysts
• Operations planners
• Functional managers
• BI (Business Intelligence) team members

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Course Outline

To request a customized course outline for this training, please contact us.

Introduction

IBM Cognos Analytics

• What is IBM Cognos Analytics?
• IBM Cognos Analytics features

Preparing the Development Environment

• Setting up IBM Cognos Analytics

IBM Cognos Analytics Fundamentals

• Creating dashboards
• Creating, extending, and updating modules
• Visualizing data
• Working with widget connections
• Creating a story
• Sharing dashboards and stories

IBM Cognos Analytics Advanced

• Creating a report from scratch
• Adding data sources
• Working with SQL queries
• Creating and using prompts

Summary and Conclusion

• Introduction
• Installing and Configuring MicroStrategy
• Overview of MiroStrategy Features and Design
• Understanding MicroStrategy Hierarchy and Grouping
• Connecting to a Data Source
• Designing Schema Objects
• Creating Application Objects
• Overview of the Report and Query Execution Workflow
• Creating a Report
• Manipulating Report Data
• Creating a Dashboard
• Troubleshooting

• Introduction
• Setting up Apache Superset
• Overview of Apache Superset Features and Architecture
• Connecting Your Own Data Sources
• Exploring and Visualizing Data
• Building Your Own Dashboards and Creating Reports
• Integrating Apache Superset with SQL Databases
• Troubleshooting
• Summary and Conclusion

Tibco Jaspersoft Studio

• Navigating Jaspersoft Studio
• Setting Up the Design Environment
• Building a Report
• Practice Building Reports
• Adding Parameters
• Adding Variables
• Composing Expressions
• Implementing Styles
• Adding Subreports
• Connecting to a JasperReports Server
• Publishing a Simple Report

Tibco Jaspersoft Server

• Creating Input Controls
• Adding Resources
• Adding Resource Bundles
• Running Reports
• Scheduling Reports

• Introduction
• Overview of the Power BI Dashboard
• Examples and Comparisons between Well-Designed Dashboards and Poorly-Organized Dashboards
• Understanding Basic and Key Features of Power BI
• Essential Rules to Design A Beautiful Dashboard
• Choosing the Right Visuals for Your Data

Dashbuilder is an open-source web application for visually creating business dashboards and reports.

In this instructor-led, live training, participants will learn how to create business dashboards and reports using Dashbuilder.

By the end of this training, participants will be able to:

• Visual configure and personalize dashboards using drag-and-drop
• Create different types of visualizations using charting libraries
• Define interactive report tables
• Create and edit inline KPIs (Key Performance Indicators)
• Customize the look and feel of metric displayers

Audience

• Managers
• Analysts

Format of the course

• Part lecture, part discussion, exercises and heavy hands-on practice

Course Outline

To request a customized course outline for this training, please contact us.

• Introduction
• Installing and Configuring Pentaho
• Overview of Pentaho Features and Architecture
• Understanding Pentaho’s In-Memory Caching
• Navigating the User Interface
• Connecting to a Data Source
• Configuring the Pentaho Enterprise Repository
• Transforming Data
• Viewing the Transformation Results
• Resolving Transformation Errors
• Processing a Data Stream
• Reusing Transformations
• Scheduling Transformations
• Securing Pentaho
• Integrating with Third-party Applications (Hadoop, NoSQL, etc.)
• Analytics and Reporting
• Pentaho Design Patterns and Best Practices
• Troubleshooting

• Deployment types and installation
• Server components and architecture
• License management
• QlikView server configuration – QMC
• Security
• User and document management
• Sharing QlikView objects
• QlikView Publisher
• Logging and monitoring and troubleshooting
• Advanced administration
• Multi-server and distributed deployments
• Backing up the QlikView site

Introduction

Qlik Sense at a Glance

• What is Qlik Sense?
• Qlik Sense multi-cloud architecture
• The associative engine and AI

Preparing the Development Environment

• Installing and configuring Qlik Sense Desktop
• Navigating the interface

Qlik Sense Quick Start

• Creating a chart
• Building a dashboard
• Customizing Qlik
• Working with data sources
• Managing Qlik Sense sheets
• Creating pivottables and reports
• Sorting and filtering data

Qlik Sense Scripting

• Using data load editor
• Connecting, extracting, and loading data
• Working with tables
• Debugging scripts

Synthetic Keys and Flat Files

• Working with synthetic keys
• loading tables
• Importing data
• Adding flat files

Data Model Optimization

• Creating QVD files
• Optimizing QVD load