Statistical Analysis with Stata and R Training Course

This instructor-led, live training in Uzbekistan (online or on-site) is aimed at data analysts, data scientists and data engineers who wish to carry out advanced data search, analytics and visualisation using Splunk.

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

• Create a Splunk application and a technology add-on.
• Use different data input methods and sources.
• Implement advanced search, analysis and visualisation of large datasets.
• Customise and share dashboards and reports.

This instructor-led, live training in Uzbekistan (online or onsite) targets data scientists and analysts who want to learn how to use each tool in the developer tool palette in Alteryx Designer.

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

• Learn to use and configure all the tools in the developer tab.
• Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
• Learn how to use API tools to download and parse web data.
• Use Alteryx scripting tools, including Python and R.

This instructor-led, live training in Uzbekistan (online or onsite) is designed for data analysts who wish to use Alteryx for data processing and data visualisation.

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

• Leverage Alteryx to enhance business intelligence and business analytics.
• Perform ETL operations without writing any code.
• Visualise data using analytical suites such as Excel.

Alteryx Designer serves as a visual platform for data preparation and analytics, empowering users to blend, transform, and automate data workflows with minimal coding requirements.

This instructor-led live training, available online or onsite, targets beginner to intermediate professionals seeking to acquire practical Alteryx skills in data preparation, data blending, fundamental analytics, and workflow automation.

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

• Constructing Alteryx workflows to address common data preparation needs.
• Combining and parsing data from diverse sources and formats.
• Developing and utilizing standard macros to encapsulate reusable logic.
• Organizing and automating workflows using industry best practices.

Course Format

• Interactive lectures and demonstrations.
• Hands-on exercises utilizing Alteryx Designer and sample datasets.
• Practical mini-projects focused on workflow automation tasks.

Customization Options

• To arrange customized training for this course, please contact us.

This instructor-led live training in Uzbekistan (online or onsite) targets data scientists interested in using Alteryx for data analysis.

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

• Prepare data in Alteryx for later visualization in Power BI or Excel.
• Create and perform ETL operations with little to no code.
• Embed custom R code inside Alteryx.

This instructor-led live training, accessible online or onsite in Uzbekistan, targets intermediate data analysts who aim to understand the theoretical foundations of Cognos 11 and learn how to apply it effectively.

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

• Recognize the differences and improvements in Cognos 11 compared to Cognos 10.
• Utilize the upgraded data module and data management features for enhanced data efficiency.
• Implement best practices to facilitate a smooth transition and maximize the benefits of Cognos 11.

This instructor-led, live training in Uzbekistan (online or on-site) is designed for consultants ranging from beginner to advanced levels, as well as finance professionals aiming to prepare for the Cognos Analytics certification and build 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 use the Cognos Analytics interface efficiently.
• Develop and customise financial reports and dashboards.
• Manage data models and optimise queries.
• Prepare for the Cognos Analytics certification exam.

This instructor-led, live training in Uzbekistan (online or onsite) is aimed at data scientists who wish to use Alteryx to prepare data for visualization and analysis.

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

• Prepare data with Alteryx to visualize later.
• Perform ETL operations with zero code.
• Leverage Alteryx to improve business intelligence and business analytics.

This instructor-led, live training in Uzbekistan (online or on-site) is designed for 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 in Uzbekistan (online or onsite) is designed for data analysts and data scientists who aim to use Metabase to collect, query, and visualize data for business intelligence analysis and reporting.

Upon completing this training, participants will be able to:

• Set up and install Metabase to begin creating data visualizations and dashboards.
• Master the techniques for querying, aggregating, and visualizing data within Metabase.
• Utilize Metabase's features and tools to write SQL queries effectively.
• Construct analytics charts and dashboards to derive meaningful business insights.
• Apply best practices and troubleshooting tips for using Metabase and resolving common issues.

The Pentaho Open Source BI Suite Community Edition (CE) is a comprehensive business intelligence solution offering data integration, reporting, dashboarding, and ETL capabilities.

Through this instructor-led live training, attendees will gain the knowledge necessary to fully leverage the capabilities of the Pentaho Open Source BI Suite Community Edition (CE).

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

• Install and configure the Pentaho Open Source BI Suite Community Edition (CE)
• Grasp the core principles and functionalities of Pentaho CE tools
• Create reports using Pentaho CE
• Integrate external data sources into Pentaho CE
• Manage big data and analytics tasks within Pentaho CE

Target Audience

• Software Developers
• BI Developers

Course Format

• A blend of lectures, discussions, exercises, and extensive hands-on practice

Important Note

• For customized training options, please reach out to us to make arrangements.

Pentaho Data Integration is an open-source data integration tool used for defining jobs and data transformations.

In this instructor-led, live training, participants will learn how to leverage Pentaho Data Integration's powerful ETL capabilities and rich graphical user interface to manage the entire big data lifecycle and maximise the value of data within their organisation.

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

• Create, preview, and execute basic data transformations containing steps and hops
• Configure and secure the Pentaho Enterprise Repository
• Consolidate disparate data sources and generate a single, unified version of the truth in an analytics-ready format.
• Deliver results to third-party applications for further processing

Audience

• Data Analyst
• ETL developers

Format of the course

• Part lecture, part discussion, with exercises and extensive hands-on practice

Pentaho Data Integration is a comprehensive platform for designing enterprise-grade ETL and data pipelines.

This instructor-led, live training (online or onsite) is aimed at advanced-level engineers who wish to master high-performance, enterprise-scale, and highly automated PDI solutions.

Upon completing this course, learners will be equipped to:

• Architect large-scale ETL pipelines with advanced orchestration.
• Optimise complex transformations for high performance.
• Implement scripting, automation, and hybrid integration patterns.
• Design robust, maintainable, production-ready workflows.

Course Format

• Expert-led demonstrations and architectural discussions.
• Extensive practical lab work tackling advanced real-world ETL challenges.
• Hands-on development within a production-like environment.

Course Customisation Options

• Contact us if you require a customised version of this training.

Pentaho Data Integration is a platform for data extraction, transformation, and loading.

This instructor-led, live training (online or on-site) is designed for intermediate-level practitioners who wish to enhance their PDI skills to handle more complex transformation scenarios.

Upon completing this training, participants will be able to:

• Design multi-step transformations with improved performance.
• Work with variables, parameters, and reusable components.
• Integrate PDI with databases, APIs, and external systems.
• Apply best practices for maintainable and scalable ETL pipelines.

Course Format

• Interactive demos and instructor-led explanations.
• Guided exercises and scenario-based practice.
• Hands-on work within a real-world ETL project environment.

Course Customisation Options

• If you require a tailored version of this course, please contact us to customise it.

Target Audience

Course Format

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

This instructor-led, live training guides participants through the process of manipulating and visualizing data using the tools provided by the Tidyverse.

The Tidyverse is a comprehensive collection of powerful R packages designed for cleaning, processing, modeling, and visualizing data. Key packages included in the Tidyverse are: ggplot2, dplyr, tidyr, readr, purrr, and tibble.

• Beginners to the R language
• Beginners to data analysis and data visualization

• A blend of lectures, discussions, exercises, and extensive hands-on practice

• Perform data analysis and create compelling visualizations
• Draw actionable insights from various sample datasets
• Filter, sort, and summarize data to answer exploratory questions
• Convert processed data into informative line plots, bar plots, and histograms
• Import and filter data from diverse sources, including Excel, CSV, and SPSS files