Tag: Data Integration

Course content

• Introduction and Prerequisites
• The Basics
• IICS – Informatica Intelligent Cloud Services
• Getting Started with IICS
• Data Integration Service
• Transformations in Informatica Cloud
• Business Use Case
• Tasks
• Scheduling in Informatica Cloud
• Bonus

• 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

1. Connecting to datasources
   • Loading data into Tableau
   • Combining data tables – join
   • Combining data from different sources– merge
   • Extracting data to Tableau format
   • SQL queries
   • Managing data
   • Renaming data
   • Creating parameters (workbook variables)
   • Metadata
2. Effective visualisations
   • What makes a good visualisation
   • Choosing the right chart
   • The role of colour in data storytelling
   • How to avoid misleading your audience
   • Best practices
3. Calculations
   • Arithmetic calculations
   • Working with strings
   • Operations on dates and time
   • Array calculations
   • Conditional and logical expressions
   • Conditional filtering
4. Processing Array Data
   • Difference between Excel and Tableau
   • Processing arrays in Tableau
   • Writing custom SQL statements
5. Statistics
   • Adding reference and trend lines
   • Calculating descriptive measures
   • Subtotals
   • Aggregation and disaggregation
   • Forecasting
6. Building effective dashboards
   • Combining visualizations
   • Formatting dashboards
   • Adding filters and actions to create interactive dashboards
   • Making an aesthetically pleasing dashboard
   • Best practices for creating dashboards
7. Sharing dashboards
   • Publish to Tableau Reader
   • Publish to Tableau Server
   • Publish to PDF

Introduction to Pentaho Open Source BI Suite Community Edition (CE)

Overview of CE Features and Architecture

• Pentaho Community Edition vs. Enterprise Edition
• Pentaho CE Tools

Installing and Configuring Pentaho CE

Using the Pentaho CE Business Analytics User Console

Creating Reports with the Pentaho CE Business Analytics Report Designer

Performing Data Integration in Pentaho CE

Working with Databases in Pentaho CE

• Relational Databases
• NoSQL Sources
• Analytic Databases

Working with the Analysis View in Pentaho CE

• Predictive Analytics

Working with Big Data in Pentaho CE

• Graphical Designer for Big Data

Maximizing the Community Online Forums of Pentaho CE

Deploying or Embedding Your Pentaho CE Project

• Licensing

Troubleshooting