Adaptive OfficeConnect Training Course

This instructor-led, live training delivered via US (remote or in-person) is designed for data scientists and analysts seeking to master the developer tool palette within Alteryx Designer. These programs provide government-focused capabilities for enhancing analytical workflows.

Upon completion of this training, participants will be equipped to:

• Operate and configure all tools available in the Developer tab.
• Construct efficient Alteryx workflows utilizing dynamic, validation, and testing functionalities.
• Leverage API tools to extract and parse web-based data.
• Apply Alteryx scripting capabilities, including Python and R, for advanced data processing.

Alteryx Designer provides a graphical interface for data preparation and analytics, allowing personnel to integrate, modify, and automate data processes with limited reliance on programming.

This facilitated instruction, available via virtual or in-person delivery, is designed for entry-level to mid-career professionals seeking to acquire practical competencies in Alteryx for data preparation, integration, foundational analytics, and workflow automation for government agencies.

Upon completion of this instructional module, attendees will demonstrate proficiency in the following areas:

• Constructing Alteryx workflows to address standard data preparation requirements.
• Merging and structuring data originating from diverse sources and file types.
• Developing and utilizing standard macros to encapsulate reusable operational logic.
• Structuring and automating workflows in accordance with established best practices.

C instructional Delivery Format

• Interactive instruction accompanied by software demonstrations.
• Practical laboratory exercises utilizing Alteryx Designer and representative datasets.
• Execution of practical mini-projects and workflow automation assignments.

Course Customization Availability

• To arrange customized training for this curriculum, please contact the program administrator.

This instructor-led, live training in US (online or onsite) is designed for intermediate-level data analysts who seek to grasp the theoretical foundations of Cognos 11 and learn how to deploy it effectively for government operations.

Upon completion of this program, participants will be able to:

• Distinguish between the features and enhancements of Cognos 11 relative to Cognos 10.
• Leverage the enhanced data module and management capabilities to optimize data handling processes.
• Apply established best practices to facilitate a seamless transition and ensure optimal utilization of Cognos 11.

This instructor-led, live training in US (online or onsite) is aimed at beginner-level to advanced-level consultants and finance professionals who wish to prepare for the Cognos Analytics certification and gain expertise in financial data analysis, including modules for accounts payable, treasury, and expenses.

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

• Navigate and utilize the Cognos Analytics interface efficiently.
• Develop and customize financial reports and dashboards.
• Manage data models and optimize queries.
• Prepare for the Cognos Analytics certification exam.

This instructor-led, live training in US (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.

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

• Analyze and share insights about data.
• Visualize business performance.
• Use AI-assisted preparation to cleanse and combine data sources.
• Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.

This instructor-led, live training offered in US (via online or onsite delivery) is designed for data analysts and scientists seeking to leverage Metabase for collecting, querying, and visualizing data to support business intelligence analysis and reporting. The curriculum is tailored for government professionals requiring robust tools for government analytics.

Upon completion of this program, participants will be capable of:

• Installing and configuring Metabase to initiate the creation of data visualizations and dashboards.
• Executing queries, aggregating datasets, and generating visual representations within the Metabase environment.
• Utilizing Metabase features and tools to author SQL queries effectively.
• Developing analytical charts and dashboards to derive actionable business insights.
• Applying established best practices and troubleshooting techniques for resolving common Metabase issues.

This instructor-led, live training in US (online or onsite) is aimed at sysadmins and developers who wish to set up, deploy, and manage Oracle GoldenGate for data transformation for government.

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

• Install and configure Oracle GoldenGate.
• Understand Oracle databases replication using the Oracle GoldenGate tool.
• Understand the Oracle GoldenGate architecture.
• Configure and perform a database replication and migration.
• Optimize Oracle GoldenGate performance and troubleshoot issues.

Pentaho Data Integration serves as an open-source platform for orchestrating jobs and executing data transformations.

During this instructor-led session, attendees will acquire the skills necessary to leverage Pentaho Data Integration’s robust ETL functionality and graphical interface to oversee the complete big data lifecycle and optimize organizational data assets. This training is specifically designed for government operations and other public sector entities seeking efficient data management solutions.

Upon completion of this course, participants will be equipped to:

• Construct, validate, and execute fundamental data transformations utilizing steps and hops
• Configure and secure the Pentaho Enterprise Repository
• Integrate diverse data sources to establish a unified, analytics-ready authoritative record
• Deliver processed results to external applications for subsequent analysis

Audience

• Data Analysts
• ETL developers

Format of the course

• A combination of lectures, discussions, exercises, and extensive practical application

Pentaho Data Integration (PDI) serves as a robust platform for the engineering of enterprise-grade ETL workflows and data pipelines.

This instructor-led training module, available both online and onsite, is designed for advanced-level technical personnel seeking to master high-performance, scalable, and highly automated PDI solutions suitable for complex organizational needs.

Upon completion of this course, participants will be prepared to:

• Architect large-scale ETL pipelines incorporating advanced orchestration frameworks.
• Optimize intricate transformations to ensure peak performance and efficiency.
• Implement scripting, automation, and hybrid integration patterns for government data operations.
• Design robust, maintainable, and production-ready workflows aligned with public sector standards.

Training Delivery Model

• Demonstrations led by subject matter experts, accompanied by architectural analysis.
• Comprehensive laboratory exercises addressing advanced, real-world ETL scenarios.
• Practical development tasks conducted within a production-simulated environment.

Customization Opportunities

• Please contact the training provider if a tailored version of this curriculum is required for specific agency needs.

Pentaho Data Integration serves as a robust platform for data extraction, transformation, and loading operations.

This instructor-led live training, available online or onsite, is designed for intermediate-level practitioners seeking to refine their PDI competencies for complex transformation scenarios.

Upon completion of this training, participants will be able to:

• Architect multi-step transformations with enhanced performance characteristics.
• Implement variables, parameters, and reusable components effectively.
• Integrate PDI with databases, APIs, and external systems for government applications.
• Apply best practices for maintainable and scalable ETL pipelines.

Course Delivery Format

• Interactive demonstrations and instructor-led instruction.
• Guided exercises and scenario-based practical work.
• Hands-on execution within a realistic ETL project environment.

Course Customization Options

• For a tailored version of this course for government requirements, please contact us to discuss customization.

This instructor-led, live training in US (online or onsite) is tailored for data analysts and data scientists who intend to search, analyze, and visualize data using Splunk. The program is designed for government professionals seeking to enhance their capabilities in this area.

Upon completion of this training, participants will be able to:

• Install and configure Splunk.
• Collect and index all kinds of machine data.
• Implement real-time search, analysis and visualization of large datasets.
• Create and share complex dashboards and reports.

This instructor-led, live training is offered in US (either online or onsite) for government system administrators, data scientists, and business analysts who intend to establish the Talend Administration Center to oversee organizational roles and tasks. Upon completion of this program, participants will be capable of:

• Installing and configuring the Talend Administration Center.
• Comprehending and executing core principles of Talend management.
• Constructing, deploying, and executing business projects or tasks within the Talend environment.
• Assessing dataset security and establishing business routines aligned with the TAC framework for government operations.
• Gaining a comprehensive understanding of big data applications.

This instructor-led, live training in US (available online or onsite) is designed for technical personnel seeking to deploy Talend Open Studio for Big Data, facilitating the efficient processing and analysis of large datasets. This program provides resources for government teams managing complex data workflows.

Upon completion of this course, participants will demonstrate proficiency in the following areas:

• Install and configure Talend Open Studio for Big Data.
• Connect with Big Data systems such as Cloudera, HortonWorks, MapR, Amazon EMR and Apache.
• Understand and set up Open Studio's big data components and connectors.
• Configure parameters to automatically generate MapReduce code.
• Use Open Studio's drag-and-drop interface to run Hadoop jobs.
• Prototype big data pipelines.
• Automate big data integration projects.

This instructor-led, live training in US (available online or onsite) is designed for beginner to intermediate-level data analysts seeking to enhance their proficiency in managing and improving data quality using Talend Data Stewardship. The program is tailored for government professionals requiring robust tools for data governance.

Upon completion of this training, participants will be equipped to:

• Develop a comprehensive understanding of the critical role data stewardship plays in maintaining high-quality data standards.
• Utilize Talend Data Stewardship effectively to oversee and execute data quality management tasks.
• Create, assign, and manage specific tasks within the Talend Data Stewardship environment, including the customization of workflows.
• Leverage the platform’s reporting and monitoring functionalities to track progress and evaluate the effectiveness of data stewardship initiatives.

In this instructor-led training session held at US, participants will acquire the skills necessary to utilize Talend Open Studio for ESB to establish, link, mediate, and oversee services and their associated interactions. This curriculum is designed for government professionals seeking to master enterprise service bus capabilities.

Upon completion of this course, participants will be capable of

• Deploying ESB technologies as cohesive packages across diverse operational environments.
• Proficiently applying the most frequently utilized components within Talend Open Studio.
• Connecting any application, database, API, or Web service.
• Facilitating the integration of heterogeneous systems and applications.
• Incorporating existing Java libraries to expand project functionality.
• Utilizing community-contributed components and code to enhance projects.
• Rapidly linking systems, applications, and data sources using a drag-and-drop Eclipse interface.
• Lowering development timelines and maintenance expenditures by producing optimized, reusable code.