Tag: Data visualization

Introduction

Stata and Big Data

• What is Stata?
• Stata syntax and commands

Preparing the Development Environment

• Installing and configuring Stata

Datasets and Data

• Opening and cleaning datasets
• Compressing datasets
• Importing and exporting datasets
• Viewing, describing, and summarizing raw data
• Using tabulations and tables
• Working with distributional analysis
• Implementing variables for data manipulation
• Saving data
• Working with commands

Graphing in Stata

• Using plots, charts, and graphs
• Working with distributional analysis in graphing
• Styling and combining graphs

Statistics and Regression

• Using bivariate correlation and regression
• Working with OLS regression, logits, and probits
• Using interactive effects in regression models

Summary and Conclusion

Introduction

SAS in Depth

• SAS data sets
• SAS variables
• SAS libraries
• SAS code structure

Preparing the Development Environment

• Installing and configuring SAS Studio
• Installing and configuring WPS

Data management in SAS

• Importing data
• Exporting data
• Creating variables and calculations
• Filtering observations
• Creating conditionals and loops
• Merging data sets
• Using statements
• Cleaning data

Arrays and Functions

• Recording new variables with loops
• Constructing new variables
• Using built in SAS functions
• Combining raw data files

Data Visualization

• Creating a bar chart
• Creating a scatter plot
• Creating a pie graph
• Overlaying plots

Statistics Analysis

• Reporting data
• Using linear regressions
• Using multiple regressions
• Interpreting data
• Making predictions

SAS SQL

• SAS SQL syntax
• Using clauses and statements
• Working with columns and rows
• Working with tables

SAS Index

• Testing with data sets
• Using PROC
• Creating, updating, and applying an index

SAS Macro

• Using macro variables
• Using macro functions
• Creating a Macro
• Debugging and storing Macros

Predictive Modeling

• Using linear regressions
• Using multiple regressions
• Evaluating data patterns
• Using input variables
• Working with PROC MI

Summary and Conclusion

Introduction

Review of Basic Features and Architecture of Splunk

Developing a Splunk Application and a Technology Add-on

Connecting Data to Splunk

• Understanding various data input methods and sources
• Processing data
• Improving the input process

Conducting Advanced Data Analytics

• Manipulating and filtering data
• Combining searches and using subsearches
• Working with time and multivalue fields
• Creating advanced reports
• Using geography and location
• Using advanced transactions
• Dealing with anomalies
• Predicting and trending
• Understanding machine learning

Performing Advanced Visualization

• Drilldown
• Sunburst Sequence
• Geospatial visualization
• Punchcard visualization
• Calendar heatmap visualization
• Sankey diagram

Customizing Dashboard

• Using Dashboard controls
• Managing multi-search
• Customizing tokens
• Customizing layout, look and feel
• Implementing the custom alert action

Integrating Splunk with Other Enterprise Systems

• Working with the Splunk SDK
• Splunk with Python and R for analytics
• Splunk with Tableau for visualization

Troubleshooting

Summary and Conclusion

• Introduction
• Setting up Splunk
• Overview of Splunk Features and Architecture
• Navigating the Splunk User Interface
• Performing Searches Using SPL (Search Processing Language)
• Using Transforming Commands and Visualization
• Building Your Own Dashboards and Creating Reports
• Understanding Data Models and Pivot
• Working with the Common Information Model (CIM)
• Integrating Splunk with Different Databases
• Getting to Know Advanced Splunk Concepts
• Troubleshooting
• 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

Installing and Configuring Cloud-Native Apache Superset

• Using Docker to initialize development environment
• Using Python’s setup tools and pip

Overview of Basic Features and Architecture of Apache Superset

• Rich visualizations
• Easy-to-navigate user interface
• Integration with most databases

Connecting Data to Apache Superset

• Configuring data input
• Improving the input process

Conducting Advanced Data Analytics

• Getting a rolling average of the time series
• Working with Time Comparison
• Resampling the data using various methods
• Scheduling queries in SQL Lab

Performing Advanced Visualization

• Creating a Pivot Table
• Exploring different visualization types
• Building a visualization plugin

Creating and Sharing Dynamic Dashboards

• Adding Annotations to Your Chart
• Using REST API

Integrating Apache Superset with Databases

• Apache Druid
• BigQuery
• SQL Server

Managing Security in Apache Superset

• Understanding provided roles and creating new roles
• Customizing permissions

Troubleshooting

Summary and Conclusion

• 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.