Tag: Data visualization

Installation and Configuration

• Zabbix architecture
• Installation: Server, WEB interface and agent
• Initial configuration
• Zabbix definitions
• WEB interface overview

Data Collection and Monitoring

• Configuration management by using templates
• Agent-less monitoring
• Data collection – hosts, Zabbix agent checks
• Data visualization – simple graphs, overview
• Problem detection – triggers, less sensitive triggers, dependencies
• Data collection – aggregate and calculated checks
• Data visualization – custom graphs

Events and Alerts

• Events
• Notifications and escalations – media types, actions, operations

Zabbix Administration and Monitoring

• Automatic recovery by using remote commands
• Host and host group level maintenance
• Zabbix Administration – working time, housekeeper, authentication, front-end scripts
• Managing permissions – users and user groups, audit
• Automatic discovery – network discovery, active agent auto-registration
• Command line utilities: zabbix_get, zabbix_sender

Maintenance

• Proxy overview
• Maintenance and operations – best practices, DB sizing, upgrades

Day 1:

Module 1: KNIME Analytics Platform: Overview

• Installation
• Starting and customizing KNIME Analytics Platform
• Nodes, data and workflows
• The data science cycle

Module 2: Data Access

• Read Data from file
• Accessing REST Services

Module 3: ETL and Data Manipulation

• Row & Column filtering
• Aggregators
• Join & Concatenation
• Transformation: Conversion, Replacement, Standardization, and New Feature Generation
• Data Preparation for Time Series Analysis

Day 2:

Module 4: Exporting Data

• Write to a file
• Generating a Report

Module 5: Data Visualization

• Interactive Univariate Visual Exploration
• Interactive Multivariate Visual Exploration
• Advanced Visualization Features
   

Module 6: Predictive Analytics using KNIME

• Data Mining Basic Concepts
• Regressions
• Decision Tree Family
• Model Evaluation

Day 3:

Module 7: Controlling the flow

• Workflow Parameterization: Flow Variables
• Re-executing Workflow Parts: Loops
• Cleaning up your Workflow

Module 8: Hands on KNIME Analytics Platform based Case Study

Course Outline

Introduction

• What’s new in TIBCO Spotfire X?
• Overview of TIBCO Spotfire X features and architecture
• Understanding augmented and predictive analytics

Getting Started

• Installing TIBCO Spotfire X
• Upgrading Spotfire
• Navigating the UI

Loading Data

• Connecting to a database
• Configuring an on-demand data source
• Importing data from a file
• Transforming data

Processing Data

• Working with large data sets
• Connecting to streaming data
• Handling data in analysis flyout
• Managing data in data canvas
• Manipulating data tables
• Working with multiple data tables

Visualizing Data

• Types of charts, tables, maps, and other visualizations
• Interacting with visualized data
• Enhancing visualizations
• Collaborating using conversations, annotations, etc.
• Using tags, filters, lists, and other tools

Troubleshooting

Day 1

1. Intoruduction
2. Overview
3. Adding Data Table (Flat-file, database) – different options
4. Working with Information Links (optional, needed access to Spotfire Server and some test database)
5. Data Wrangling
6. Filtering, Marking, Table Relationship
7. Visualization types (Table, Cross Table, Pie Chart, Bar Chart, Line Chart, Combination Chart, Waterflow Chart…)

Day 2

1. Geo Visualizations – optional, if requested
2. Calculated Columns
3. Property Controls, Text Area
4. Report Custom Styling (Corporate design)
5. Spotfire Library Concepts, Report sharing and access concepts
6. Web Player, Scheduled Updates
7. Wrap up

• Introduction
• Overview of Spotfire Server and Spotfire Analyst
• Navigating the Web Client
• Managing Libraries
• Collaborating with Spotfire
• Creating Information Links to Access Data
• Performing Advanced Visualizations
• Beyond the GUI – Advanced Analysis through Expressions
• Creating Property Controls
• Integrating Statistical Engines
• Data Relationships and Predictive Modeling
• Multivariate Data Analysis
• Troubleshooting
• Summary and Conclusion

Setting up Prerequisites

• Elasticsearch: Introduction 
• Elasticsearch: Installation and Configuration
• elasticdump
• Brief Introduction to Kibana
• Nested Objects – Limitation to Kibana

Setting up Kibana

• Kibana: Install and Configure
• Configuring Elasticsearch and connecting Kibana
  • Dynamic Mapping
  • Limitations
• Tribe Nodes

Using Kibana

• Indices and Filters
• Discover Interface
  • Time Filter
  • Toolbar and Searchbar
  • Field Lists
  • Document Data and Context – Add/View/Edit/Delete
• Visualization Interface
  • Aggregations
    • Bucket Aggregations – Date Histogram, Date Range, Range, Histogram, Terms and Filters
    • Metric Aggregations – Count, Sum, Average, Min, Max, Percentile, Percentile Ranks and Unique
  • Create Visualization
  • Chart, Line, Area
  • Data Table
  • Metrics
  • Other Visualization Types
• Dashboard Interface: Building, Merging, Loading and Sharing
• Graph: Configure, Troubleshoot and Limitations

Kibana: Dev Console

• Overview
• Shortcuts: Brief
• Settings and Configuring

Kibana in Production

• SSL encryption
• Load Balancing using Elasticsearch Nodes

Management

• Managing Fields and Formatters
• Saved Searches, Visualizationad and Dashboards
• Apache/nginx proxy for security

Plugins

• Install/Update/Disable/Remove Plugins
• Plugins Manager

Introduction to QlikView

Overview of QlikView Features

Installing and Configuring QlikView

• Setting User Preferences
• Configuring Document Properties

Creating Visualizations in QlikView

• Managing Data Sources
• Creating and Modifying Objects

Managing QlikView Sheets and Files

• Working with Sheets in QlikView
• Exporting QlikView Data to Excel

Creating Summaries and Charts in QlikView

• Sorting and Filtering QlikView Data
• Creating and Modifying Charts

Building and Manipulating Pivot Tables in QlikView

Using Your QlikView Data for Decision Making

Troubleshooting

Summary and Conclusion

Introduction

Google Sheets Overview

• What is Google Sheets?
• Google Sheets features
• Google Sheets vs Excel

Google Sheets Fundamentals

• Creating, sharing, formatting spreadsheets
• Working with pivot tables
• Sorting and filtering data
• Using find and replace

Functions and Formulas

• Creating functions and formulas
• Using lookups

Data Visualization

• Creating charts and graphs

Google Sheets Advanced

• Pulling data
• Creating macros
• Using add-ons

Summary and Conclusion

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

Alteryx Overview

• What is Alteryx
• Alteryx features

Preparing the Development Environment

• Installing and configuring Alteryx
• Navigating the interface

Alteryx Quick Start

• Importing data
• Creating and executing a workflow
• Working with documentation tools and cumulative tools

Data Management

• Preparing and cleansing data

Data Wrangling

• Creating custom formulas, algorithms, and calculations
• Performing data transformations

Data visualization

• Integrating a BI platform (Tableau, Power BI, etc.)
• Creating data visualizations
• Automating reporting

Summary and Conclusion