Business Intelligence with SSAS Training Course

This instructor-led, live training in Sweden (online or onsite) targets data scientists and data analysts who wish 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.

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 both online and onsite, is designed for professionals at beginner to intermediate levels who seek to master practical Alteryx skills for data preparation, blending, foundational analytics, and workflow automation.

Upon completing this training, participants will be able to:

• Construct Alteryx workflows tailored to common data preparation tasks.
• Combine and parse data originating from various sources and formats.
• Create and utilize standard macros to encapsulate reusable logic.
• Organize and automate workflows employing best-practice techniques.

Course Format

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

Course Customization Options

• To request customized training for this course, please contact us to make arrangements.

This instructor-led, live training in Sweden (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use 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 Sweden (online or onsite) is targeted at consultants and finance professionals, from beginner to advanced levels, who seek to prepare for the Cognos Analytics certification and acquire specialized skills in financial data analysis, including accounts payable, treasury, and expenses.

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

• Navigate and effectively use the Cognos Analytics interface.
• Create and tailor financial reports and dashboards.
• Manage data models and optimize query performance.
• Prepare thoroughly for the Cognos Analytics certification exam.

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

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

• Set up and install Metabase to start building data visualizations and dashboards.
• Learn how to query, aggregate, and visualize data in Metabase.
• Use the features and tools in Metabase to write SQL queries.
• Build analytics charts and dashboards to get business insights.
• Know the best practices and tips on using Metabase and resolving common issues.

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

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

Upon completing this training, participants will be capable of:

• Installing and configuring the Pentaho Open Source BI Suite Community Edition (CE)
• Grasping the core concepts of Pentaho CE tools and their features
• Constructing reports using Pentaho CE
• Integrating third-party data sources into Pentaho CE
• Handling 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

Note

• For bespoke training arrangements, please reach out to us.

Pentaho Data Integration is an open-source tool designed for data integration, enabling users to define jobs and data transformations.

During this instructor-led live training, participants will learn to leverage Pentaho Data Integration’s robust ETL capabilities and intuitive GUI to manage the complete big data lifecycle, thereby maximizing the value of data within their organizations.

Upon completing this training, participants will be able to:

• Create, preview, and execute basic data transformations comprising steps and hops
• Configure and secure the Pentaho Enterprise Repository
• Integrate diverse data sources to produce a single, unified version of truth in an analytics-ready format.
• Deliver results to third-party applications for further 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 building enterprise-grade ETL processes and data pipelines.

This instructor-led training session, available either online or onsite, is designed for advanced engineers aiming to master high-performance, enterprise-scale, and highly automated PDI solutions.

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

• Architect large-scale ETL pipelines with sophisticated orchestration.
• Optimize complex transformations to ensure peak performance.
• Apply scripting, automation, and hybrid integration techniques.
• Create resilient, maintainable, and production-ready workflows.

Course Format

• Expert-led demonstrations and architectural discussions.
• Extensive hands-on labs addressing advanced, real-world ETL challenges.
• Practical development within a production-like environment.

Customization Options

• Please reach out to us if you need a tailored version of this training.

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

This instructor-led live training, available online or on-site, is designed for intermediate practitioners looking to elevate their PDI capabilities for handling more complex transformation scenarios.

After completing this course, participants will be equipped to:

• Design multi-step transformations that offer improved performance.
• Effectively utilize variables, parameters, and reusable components.
• Seamlessly integrate PDI with databases, APIs, and external systems.
• Implement best practices to ensure ETL pipelines are maintainable and scalable.

Format of the Course

• Interactive demonstrations accompanied by instructor explanations.
• Guided exercises and practice based on real-world scenarios.
• Practical application within a realistic ETL project environment.

Course Customization Options

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

This instructor-led live training in Sweden (online or on-site) is aimed at data analysts and scientists who wish to search, analyze, and visualize data using Splunk.

Upon completing this training, participants will be able to:

• Install and configure Splunk.
• Collect and index various types 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 in Sweden (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 Sweden (online or onsite) targets 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.

This instructor-led, live training in Sweden (online or onsite) is aimed at engineers who wish to get data into Splunk Indexers and manipulate data in Splunk.

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

• Use different data input methods and sources.
• Install, configure, manage and monitor Forwarders.
• Manipulate raw data in Splunk.
• Create a Splunk Diag.