Adaptive OfficeConnect Training Course

This instructor-led, live training in US (delivered online or onsite) is intended for data scientists and data analysts who aim to learn the application of each tool within the developer tool palette in Alteryx Designer.

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

• Utilize and configure all tools located in the developer tab.
• Develop efficient workflows in Alteryx employing dynamic, validation, and testing tools.
• Apply API tools to download and process web data.
• Operate Alteryx scripting tools, including Python and R.

Alteryx Designer serves as a visual data preparation and analytics platform that facilitates the blending, transformation, and automation of data workflows with minimal reliance on coding.

This instructor-led, live training module, available in online or onsite formats, is designed for professionals ranging from beginner to intermediate levels who require practical Alteryx competencies for data preparation, blending, basic analytics, and workflow automation for government operations.

Upon completion of this training, participants will possess the ability to:

• Develop Alteryx workflows addressing common data preparation requirements.
• Integrate and parse data from multiple sources and varying formats.
• Construct and apply standard macros to encapsulate reusable analytical logic.
• Organize and automate workflows employing established best-practice techniques.

Instructional Methodology

• Interactive lectures accompanied by live demonstrations.
• Hands-on exercises utilizing Alteryx Designer and representative sample data.
• Practical mini-projects and workflow automation tasks focused on operational efficiency.

Course Customization Provisions

• Entities requiring a customized training curriculum for this course should initiate contact to arrange specific modifications.

This instructor-led, live training in US (online or onsite) is designed for intermediate-level data analysts who require a deep understanding of the theoretical frameworks of Cognos 11 and the skills necessary to utilize the platform effectively for government purposes.

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

• Analyze the distinct differences and functional enhancements present in Cognos 11 relative to Cognos 10.
• Leverage the advanced data module and data management capabilities to ensure efficient and compliant data handling.
• Apply established best practices to facilitate a seamless transition and ensure optimal utilization of the Cognos 11 platform for government operations.

This instructor-led, live training session, conducted either online or onsite, is structured for consultants and finance professionals of varying experience levels. The objective is to facilitate preparation for the Cognos Analytics certification and to develop advanced expertise in financial data analysis for government, with particular emphasis on accounts payable, treasury, and expense management modules.

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

• Efficiently navigate and operate the Cognos Analytics interface.
• Develop and tailor financial reports and visual dashboards.
• Manage underlying data models and optimize query performance.
• Prepare for the Cognos Analytics certification examination.

This instructor-led, live training conducted in US (either online or onsite) is specifically targeted at business analysts who intend to utilize IBM Cognos for data analysis and reporting purposes.

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

• Analyze and share insights derived from data.
• Visualize business performance indicators.
• Utilize AI-assisted preparation methods to cleanse and integrate data sources.
• Discover hidden patterns within data by employing the built-in AI capabilities of IBM Cognos Analytics.

This live, instructor-led training, conducted in US (virtual or onsite), targets data analysts and data scientists engaged in collecting, querying, and visualizing data for business intelligence analysis and reporting. The curriculum is structured to meet the needs of public sector professionals.

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

• Configuring and installing Metabase for the construction of data visualizations and dashboards.
• Executing data queries, aggregations, and visualizations within the Metabase environment.
• Leveraging Metabase tools to author SQL queries for analytical purposes.
• Developing analytics charts and dashboards to derive strategic business insights.
• Applying best practices for Metabase usage and addressing common technical issues.

This professional development program, offered in virtual or on-site formats at US, is designed for system administrators and developers tasked with deploying, managing, and optimizing Oracle GoldenGate for advanced data transformation.

Upon completion, participants will demonstrate the ability to:

• Complete the installation and configuration of Oracle GoldenGate.
• Interpret Oracle database replication mechanisms through the Oracle GoldenGate toolset.
• Articulate the architectural framework of Oracle GoldenGate.
• Execute database replication and migration tasks with precision.
• Optimize system performance and diagnose operational challenges.

Pentaho Data Integration is an open-source solution for orchestrating job workflows and data transformations, suitable for government data management requirements.

In this instructor-led live training, participants will develop proficiency in utilizing Pentaho Data Integration's ETL capabilities and graphical interface to manage the full big data lifecycle, thereby maximizing data value for government operations.

Upon completion, participants will be equipped to:

• Construct, validate, and execute fundamental data transformations utilizing defined steps and hops
• Configure and implement security controls for the Pentaho Enterprise Repository
• Consolidate heterogeneous data sources to establish a unified, analytics-ready data foundation
• Facilitate data exchange with third-party applications for downstream processing for government use

Intended Audience

• Data Analysts
• ETL Developers

Course Delivery Method

• Combination of instructional lectures, collaborative discussions, guided exercises, and intensive hands-on practice

Pentaho Data Integration provides a robust platform for engineering enterprise-grade ETL processes and data pipelines.

This instructor-led training, available in online or onsite formats, is designed for advanced engineers seeking to master high-performance, enterprise-scale, and highly automated PDI solutions suitable for government operations.

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

• Architect large-scale ETL pipelines utilizing advanced orchestration techniques.
• Optimize complex transformations to ensure optimal performance.
• Implement scripting, automation, and hybrid integration patterns for government use cases.
• Design robust, maintainable, and production-ready data workflows.

Course Format

• Demonstrations and architectural discussions led by subject matter experts.
• Comprehensive lab exercises focusing on advanced real-world ETL challenges.
• Hands-on development within a production-simulated environment.

Customization Options

• Contact our team if a customized version of this training is required for specific government needs.

This instructor-led, live training in US (delivered online or onsite) targets data analysts and data scientists who require proficiency in searching, analyzing, and visualizing data using Splunk for government applications.

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

• Perform the installation and configuration of Splunk.
• Acquire and index diverse categories of machine data.
• Execute real-time search, analytical processing, and visualization of extensive datasets.
• Develop and disseminate sophisticated dashboards and reports.

This instructor-led, live training session held in US (online or on-site) is tailored for system administrators, data scientists, and business analysts responsible for configuring Talend Administration Center to deploy and manage organizational roles and operational duties for government and other public sector entities.

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

• Install and configure Talend Administration Center for operational use.
• Comprehend and apply core Talend management principles.
• Construct, deploy, and execute business projects and tasks within the Talend environment.
• Oversight of dataset security and the development of business routines utilizing the TAC framework.
• Gain an expanded understanding of big data applications in a professional context.

This instructor-led live training program, conducted in US (via online or onsite modalities), is designed for technical professionals aiming to deploy Talend Open Studio for Big Data to optimize the retrieval and analysis of large-scale data.

Following the completion of this program, participants will possess the capability to:

• Perform the installation and configuration of Talend Open Studio for Big Data.
• Establish integrations with Big Data platforms such as Cloudera, HortonWorks, MapR, Amazon EMR, and Apache.
• Analyze and set up the Big Data components and connectors within Open Studio.
• Configure parameters to enable the automatic generation of MapReduce code.
• Employ the drag-and-drop interface to initiate Hadoop job executions.
• Construct prototypes for Big Data pipelines.
• Automate Big Data integration projects.

This instructor-led, live training in US (delivered online or onsite) is intended for entry-level to intermediate-level data analysts aiming to refine their expertise in managing and enhancing data quality for government using Talend Data Stewardship.

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

• Achieving a thorough comprehension of the essential role data stewardship fulfills in preserving data integrity.
• Applying Talend Data Stewardship to manage data quality responsibilities.
• Creating, assigning, and controlling tasks within the Talend Data Stewardship environment, including workflow customization for operational efficiency.
• Employing the system’s reporting and monitoring tools to oversee data quality and stewardship initiatives, supporting accountability objectives.

In this instructor-led, live training in US, participants will learn how to use Talend Open Studio for ESB to create, connect, mediate and manage services and their interactions.

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

• Integrate, enhance and deliver ESB technologies as single packages in a variety of deployment environments.
• Understand and utilize Talend Open Studio's most used components.
• Integrate any application, database, API, or Web services.
• Seamlessly integrate heterogeneous systems and applications.
• Embed existing Java code libraries to extend projects.
• Leverage community components and code to extend projects.
• Rapidly integrate systems, applications and data sources within a drag-and-drop Eclipse environment.
• Reduce development time and maintenance costs by generating optimized, reusable code.