Business Intelligence with SSAS Training Course

This instructor-led live training in Czech Republic (online or onsite) targets data scientists and analysts who wish to master each tool in the developer tool palette of 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.

Alteryx Designer serves as a visual platform for data preparation and analytics, allowing 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-level professionals seeking to master practical Alteryx skills in data preparation, blending, basic analytics, and workflow automation.

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

• Construct Alteryx workflows to handle common data preparation tasks.
• Combine and parse data originating from various sources and formats.
• Develop and utilize standard macros to encapsulate reusable logic.
• Organize and automate workflows using established best practices.

Course Format

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

Customization Options

• For customized training requests, please contact us to arrange details.

This instructor-led live training in Czech Republic (online or onsite) is designed for data scientists who wish to utilize Alteryx for data analysis.

By the end of this 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 in Czech Republic (online or onsite) targets intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and learn how to apply it effectively.

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

• Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
• Utilize the improved data module and data management features for more efficient data handling.
• Implement best practices for a smooth transition and optimal use of Cognos 11.

This instructor-led live training in Czech Republic (online or onsite) is designed for consultants and finance professionals at beginner to advanced levels who wish to prepare for the Cognos Analytics certification and acquire skills in financial data analysis, covering modules for accounts payable, treasury, and expenses.

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

• Navigate and effectively utilize the Cognos Analytics interface.
• 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 Czech Republic (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 for later visualization.
• Perform ETL operations with zero code.
• Leverage Alteryx to improve business intelligence and business analytics.

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

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

• Set up and install Metabase to begin building data visualizations and dashboards.
• Learn how to query, aggregate, and visualize data using Metabase.
• Utilize Metabase's features and tools to write SQL queries.
• Create analytics charts and dashboards to derive business insights.
• Understand best practices and tips for using Metabase and resolving common issues.

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

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

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

• Install and configure the Pentaho Open Source BI Suite Community Edition (CE)
• Grasp the core concepts and features of Pentaho CE tools
• Develop reports using Pentaho CE
• Integrate external data sources into Pentaho CE
• Apply big data and analytics functionalities within Pentaho CE

Target Audience

• Software Programmers
• Business Intelligence Developers

Course Format

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

Important Note

• For inquiries regarding customized training options for this course, please reach out to us directly.

Pentaho Data Integration serves as an open-source tool for defining jobs and data transformations.

This instructor-led live training enables participants to leverage the robust ETL capabilities and intuitive GUI of Pentaho Data Integration to oversee the entire big data lifecycle and maximize the organizational value of their data.

Upon completing this training, participants will be capable of:

• Creating, previewing, and executing fundamental data transformations that incorporate steps and hops
• Configuring and securing the Pentaho Enterprise Repository
• Consolidating disparate data sources to produce a single, unified, analytics-ready version of truth
• Delivering results to third-party applications for additional processing

Audience

• Data Analysts
• ETL developers

Course Format

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

Pentaho Data Integration serves as a robust platform for architecting enterprise-grade ETL processes and data pipelines.

This instructor-led training session, available both online and onsite, targets advanced engineers seeking to master the creation of high-performance, enterprise-scale, and highly automated PDI solutions.

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

• Architecting large-scale ETL pipelines utilizing advanced orchestration techniques.
• Optimizing complex transformations to achieve peak performance.
• Implementing scripting, automation, and hybrid integration patterns.
• Designing robust, maintainable workflows ready for production environments.

Course Format

• Demonstrations and architectural discussions led by experts.
• Extensive laboratory exercises focusing on advanced real-world ETL challenges.
• Hands-on development within a production-like environment.

Customization Options

• Please contact us if you need a customized version of this training program.

Pentaho Data Integration serves as a platform for extracting, transforming, and loading data.

This live, instructor-led training (available online or onsite) is designed for intermediate-level professionals looking to deepen their PDI skills to handle more complex transformation scenarios.

Upon completing this course, participants will be capable of:

• Designing multi-step transformations with enhanced performance.
• Utilizing variables, parameters, and reusable components.
• Integrating PDI with databases, APIs, and external systems.
• Implementing best practices for maintainable and scalable ETL pipelines.

Format of the Course

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

Course Customization Options

• Should you require a tailored version of this course, please contact us to arrange customization.

This instructor-led live training in Czech Republic (online or onsite) is designed for data analysts and scientists who aim to search, analyze, and visualize data using Splunk.

Upon completing this training, participants will be capable of:

• Installing and configuring Splunk.
• Gathering and indexing various types of machine-generated data.
• Executing real-time search, analysis, and visualization of large-scale datasets.
• Developing and distributing complex dashboards and reports.

This instructor-led, live training in Czech Republic (online or onsite) is aimed at intermediate-level data analysts who wish to deepen their understanding of Splunk and build upon their foundational knowledge acquired in Splunk Fundamentals 1.

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

• Conduct advanced searches using Splunk's powerful search commands and capabilities.
• Utilize subsearches, statistical commands, and evaluation functions to analyze data.
• Create sophisticated reports and dashboards with advanced visualization options.
• Implement alerts and scheduled reports for monitoring and notification purposes.

This instructor-led, live training in Czech Republic (online or onsite) is aimed at intermediate-level IT administrators who wish to use Splunk to profile and manage IT infrastructure, optimize system architecture, troubleshoot effectively, and leverage Splunk’s capabilities for comprehensive data analysis and real-time monitoring.

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

• Understand and manage the complete Splunk infrastructure.
• Master Splunk architecture and components.
• Troubleshoot common and advanced issues effectively.
• Utilize Splunk to its full potential for data analysis, monitoring, and reporting.
• Administer data inputs, user management, and system configurations.