Statistical Analysis with Stata and Integration with R Training Course

This instructor-led, live training in US (delivered online or onsite) is designed for intermediate-level public sector participants seeking to master advanced data integration and visualization techniques in Looker Studio for government use. The curriculum covers connecting diverse data sources, designing effective dashboards, and automating reporting workflows to enhance decision-making processes.

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

• Connect and integrate multiple data sources into Looker Studio for government analysis.
• Create custom metrics and calculated fields for tailored assessments.
• Design advanced visualizations, including interactive filters and charts.
• Automate reporting workflows to facilitate real-time data updates.
• Apply best practices for visual storytelling and report customization in government contexts.

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 instructor-led, live training session, delivered in US (online or in-person), targets entry-level to intermediate professionals aiming to develop foundational skills in data visualization and reporting. The program focuses on leveraging Looker Studio to integrate data sources, present information with clarity, and extract actionable insights for decision-making.

Upon completion of this training, participants will be proficient in:

• Identifying the core capabilities of Looker Studio and identifying relevant operational use cases.
• Initializing the Looker Studio environment and linking it to various data repositories.
• Constructing clear dashboards using charts, graphs, and filtering mechanisms.
• Adapting reports to meet the distinct requirements of specific stakeholders and organizational goals.
• Facilitating effective collaboration and managing the sharing of dashboard assets.

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.

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 in US (online or onsite) is designed for intermediate-level data analysts seeking to expand their proficiency in Splunk, building upon the foundational competencies established in Splunk Fundamentals 1.

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

• Execute advanced searches utilizing Splunk’s comprehensive search commands and capabilities.
• Leverage subsearches, statistical commands, and evaluation functions to conduct detailed data analysis.
• Develop sophisticated reports and dashboards incorporating advanced visualization options.
• Deploy alerts and scheduled reports to enhance monitoring and notification processes.

This instructor-led, live training in US (online or onsite) is designed for intermediate-level IT administrators who require proficiency in using Splunk to profile and manage IT infrastructure, optimize system architecture, perform effective troubleshooting, and leverage the platform’s capabilities for comprehensive data analysis and real-time monitoring.

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

• Comprehend and administer the complete Splunk infrastructure.
• Master Splunk architecture, core components, and their interactions.
• Effectively diagnose and resolve common and advanced operational issues.
• Maximize the utility of Splunk for data analysis, monitoring, and reporting purposes.
• Manage data inputs, user access controls, and system configurations in accordance with organizational standards.

This instructor-led, live instructional session, conducted either virtually or in-person at US, is designed for technical personnel seeking to ingest data into Splunk Indexers and manage data operations within the platform.

By the conclusion of this program, attendees will be equipped to:

• Utilize various data intake techniques and origins.
• Deploy, configure, administer, and monitor Forwarder units.
• Process and adjust raw data within Splunk.
• Generate a Splunk Diag.