Data Analysis Training in Cascais

This instructor-led, live training in Cascais (online or onsite) is aimed at intermediate-level data scientists and engineers who wish to use Google Colab and Apache Spark for big data processing and analytics.

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

• Set up a big data environment using Google Colab and Spark.
• Process and analyze large datasets efficiently with Apache Spark.
• Visualize big data in a collaborative environment.
• Integrate Apache Spark with cloud-based tools.

Stratio is a data-centric platform that seamlessly integrates big data, AI, and governance into a unified solution. Its Rocket and Intelligence modules facilitate rapid data exploration, transformation, and advanced analytics within enterprise environments.

This instructor-led live training (available online or onsite) is designed for intermediate-level data professionals aiming to effectively utilize the Rocket and Intelligence modules in Stratio with PySpark. The curriculum focuses on looping structures, user-defined functions, and advanced data logic.

Upon completing this training, participants will be able to:

• Navigate and operate within the Stratio platform using the Rocket and Intelligence modules.
• Apply PySpark for data ingestion, transformation, and analysis.
• Utilize loops and conditional logic to manage data workflows and feature engineering tasks.
• Develop and manage user-defined functions (UDFs) to ensure reusable data operations in PySpark.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical sessions.
• Hands-on implementation in a live laboratory environment.

Course Customization Options

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

Making data-informed decisions involves weaving relevant data, evidence, and analysis into the decision-making process to enhance outcomes and accountability within the public sector.

This instructor-led live training, available online or onsite, is designed for public sector professionals with limited or emerging experience in utilizing data for decision-making. It targets those who design, evaluate, or manage government programs and wish to strengthen their ability to interpret, validate, and apply data to real-world choices.

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

• Grasp the concept of being data-informed, as opposed to being solely data-driven or relying on intuition.
• Identify and assess data pertinent to specific policy or service contexts.
• Formulate better questions for data analysts and effectively interpret dashboards and reports.
• Apply data to justify, refine, or defend decisions within public service contexts.

Course Format

• Interactive lectures and discussions.
• Practical application through decision scenarios, data sets, and mock policy briefs.
• Guided exercises focused on practical decision-making use cases.

Course Customization Options

• To request customized training for this course tailored to your department's workflows or internal tools, please contact us to arrange.

This instructor-led, live training in Cascais (online or onsite) is aimed at intermediate-level data professionals who wish to apply time series forecasting techniques to real-world data using Google Colab.

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

• Understand the fundamentals of time series analysis.
• Use Google Colab to work with time series data.
• Apply ARIMA models to forecast data trends.
• Utilize Facebook’s Prophet library for flexible forecasting.
• Visualize time series data and forecasting results.

Digital Intelligence refers to the capability of comprehending and utilizing digital tools, data, and systems to facilitate informed decision-making within the realm of public service delivery and governance.

This instructor-led, live training session (available online or onsite) is designed for public sector professionals who possess limited or developing experience in digital intelligence. It targets individuals working with data, digital tools, or service performance metrics who aim to enhance their ability to analyze, interpret, and apply information for improved decision-making.

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

• Grasp the fundamentals of digital intelligence and its relevance to public sector operations.
• Utilize digital tools to gather, visualize, and communicate actionable insights.
• Evaluate the digital maturity of their respective teams or departments.
• Develop a roadmap to bolster digital capacity and data-driven practices.

Format of the Course

• Interactive lectures and discussions.
• Practical application of digital tools and dashboard mockups.
• Guided exercises centered on real-world public service scenarios.

Course Customization Options

• To request a customized training session tailored to your department's workflows or internal tools, please contact us to arrange.

Data storytelling involves employing visual and narrative methods to convert intricate datasets into clear, compelling narratives that inform and motivate action.

This instructor-led, live training (available online or onsite) targets public sector professionals who work with data but have limited or informal training in data storytelling, aiming to enhance their ability to present data clearly and persuasively through narrative and visuals.

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

• Transform raw data into impactful visual stories.
• Use chart selection and layout to support key messages.
• Structure data narratives that align with audience needs.
• Apply best practices for visual clarity and cognitive impact.

Course Format

• Interactive lecture and discussion.
• Hands-on use of storytelling techniques in data presentations.
• Guided exercises focused on clarity, visual flow, and audience impact.

Course Customization Options

• To request a customized training for this course based on your department's workflows or internal tools, please contact us to arrange.

By completing this instructor-led, live training in Cascais, participants will acquire a practical, real-world grasp of Big Data, along with its associated technologies, methodologies, and tools.

Attendees will be able to apply this knowledge through hands-on exercises. The class places significant emphasis on group interaction and feedback from the instructor.

The course begins with an overview of fundamental Big Data concepts, then moves on to the programming languages and methodologies employed for Data Analysis. Finally, we examine the tools and infrastructure that facilitate Big Data storage, Distributed Processing, and Scalability.

This instructor-led, live training in Cascais (online or onsite) is aimed at beginner-level data engineers, analysts, and scientists who wish to understand how to use dbt Cloud to manage their data warehousing and transformation projects in the cloud.

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

• Create and manage projects on dbt Cloud.
• Use the dbt Cloud interface to schedule and run data transformations.
• Collaborate on projects with team members.
• Deploy their dbt projects to production.
• Debug and troubleshoot dbt projects.

AI Builder serves as Microsoft Power Platform’s low-code AI capability, empowering organizations to build, train, and deploy AI models for common business scenarios such as form processing, object detection, and prediction without deep data science expertise.

This instructor-led, live training (online or onsite) is aimed at advanced-level Power Platform professionals and automation leaders who wish to apply AI Builder to OCR extraction from structured and unstructured forms, build custom predictive models for qualitative and quantitative outcomes, and optionally incorporate Process Mining concepts to complement process analysis and optimization.

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

• Design and build AI Builder form processing models for structured and unstructured documents.
• Train, evaluate, and deploy custom prediction models for classification and regression tasks.
• Integrate AI Builder models into Power Apps and Power Automate flows for end-to-end automation.
• Understand how Process Mining can complement AI Builder by revealing process bottlenecks and data-driven optimization opportunities.

Format of the Course

• Interactive lecture and demonstration.
• Hands-on labs building AI Builder models and integrating them into Power Platform apps and flows.
• Use-case workshops and model evaluation sessions.

Course Customization Options

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

This instructor-led, live training in Cascais (online or onsite) is designed for beginner to intermediate-level data analysts and business professionals who want to perform complex data analysis tasks more intuitively across various industries using Google Gemini AI.

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

• Understand the fundamentals of Google Gemini AI.
• Connect various data sources to Gemini AI.
• Explore data using natural language queries.
• Analyze data patterns and derive insights.
• Create compelling data visualizations.
• Communicate data-driven insights effectively.

This instructor-led live training in Cascais (online or onsite) is aimed at data analysts and anyone interested in learning how to use and integrate Tableau, Python, R, and SQL for data visualization and analysis.

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

• Execute data analysis using Python, R, and SQL.
• Generate insights through data visualization with Tableau.
• Make data-driven decisions to support business operations.

This instructor-led, live training in Cascais (online or onsite) is aimed at beginner-level data scientists who wish to learn how to create meaningful and visually appealing data visualizations.

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

• Set up and navigate Google Colab for data visualization.
• Create various types of plots using Matplotlib.
• Utilize Seaborn for advanced visualization techniques.
• Customize plots for better presentation and clarity.
• Interpret and present data effectively using visual tools.

This instructor-led live training in Cascais (online or onsite) targets intermediate-level data engineers who wish to become proficient in using Azure Synapse Analytics for a wide range of data processing, analytics, and visualization tasks.

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

• Understand the core concepts, architecture, and components of Azure Synapse Analytics.
• Create, configure, and manage scalable data warehouses using Azure Synapse.
• Master the techniques for ingesting, transforming, and loading data (ETL) from various sources into Azure Synapse.
• Optimize query performance, secure data, and integrate Azure Synapse with Power BI and other tools to visualize data and share insights.

Big Data and Advanced Analytics involves the application of sophisticated techniques and tools to analyse large, complex datasets to derive actionable insights and support strategic decision-making.

This instructor-led, live training (available online or onsite) is designed for advanced-level data professionals who wish to leverage cutting-edge analytical methods and big data technologies for predictive, prescriptive, and real-time analytics.

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

• Design and implement large-scale data processing pipelines for structured and unstructured data.
• Apply advanced machine learning and deep learning techniques to massive datasets.
• Leverage distributed computing frameworks for real-time analytics and data streaming.
• Integrate big data analytics into business intelligence and decision-making systems.

Format of the Course

• Interactive lecture and discussion.
• Ample exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

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

The aim of the course is to help delegates to give evidence-based answers to questions:

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

R is a widely used, open-source environment for statistical computing, data analysis, and data visualisation. This course provides students with an introduction to the R programming language, covering its core fundamentals, essential libraries, and advanced concepts. Participants will explore advanced data analytics and graphical techniques applied to real-world datasets.

Target Audience

Developers and data analysts

Duration

3 days

Delivery Format

Lecture-based instruction combined with practical, hands-on exercises

Data analytics serves as an essential instrument for modern business operations. This course concentrates on cultivating practical skills for hands-on data analysis, empowering participants to provide evidence-based responses to critical inquiries:

What has occurred?

• processing and analysing data
• generating insightful data visualisations

What is anticipated to happen?

• forecasting future performance
• evaluating forecast accuracy

What ought to happen?

• transforming data into evidence-driven business decisions
• optimising operational processes

This instructor-led, live training in Cascais (online or onsite) is aimed at intermediate-level Python developers and data analysts who wish to enhance their skills in data analysis and manipulation using Pandas and NumPy.

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

• Set up a development environment that includes Python, Pandas, and NumPy.
• Create a data analysis application using Pandas and NumPy.
• Perform advanced data wrangling, sorting, and filtering operations.
• Conduct aggregate operations and analyze time series data.
• Visualize data using Matplotlib and other visualization libraries.
• Debug and optimize their data analysis code.

This instructor-led, live training in Cascais (online or onsite) is designed for developers and administrators who wish to use OpenSearch to perform distributed search and data analytics in a unified and secure system.

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

• Set up the necessary development environment to start building search and analytics solutions with OpenSearch and OpenSearch Dashboards.
• Understand the three approaches (snapshot, restart, and rolling) in upgrading from Elasticsearch OSS to OpenSearch.
• Learn how to index data, create data streams, run queries, and streamline cross-cluster operations in OpenSearch.
• Explore and use plugins, APIs, clients, and ingestion tools (Beats, Logstash, Grafana, etc.) to optimize search experience while keeping clusters secure.
• Use OpenSearch Dashboards to centralize data management, visualization, logging, monitoring, and maintenance.

This instructor-led, live training in Cascais (online or onsite) is aimed at persons who wish to learn just enough Python to begin crunching numbers from sales data, traffic analytics, customer interactions, etc..

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

• Install and configure the necessary software, libraries and development environment to begin writing Python code for data analysis.
• Analyze data from sources such as Excel, CSV, JSON files and databases.
• Clean data to improve its usefulness before analyzing it.
• Perform simple statistical analysis.
• Generate reports that present the desired data in just the right format, from straight numbers to data visualizations.
• Gain valuable insight from data, including trends in performance, problematic areas.

This course aims to provide a comprehensive understanding of SQL usage across various databases (such as Oracle, SQL Server, and MS Access). Gaining insight into analytic functions and techniques for joining different tables within a database will enable participants to shift data analysis operations to the database layer, rather than relying on MS Excel. This knowledge is also valuable for developing any IT system that utilizes relational databases.

This instructor-led, live training in Cascais (online or onsite) is designed for business analysts wishing to learn advanced Spotfire Analyst techniques for data analysis.

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

• Share visualizations with various team members.
• Secure software access according to roles and access controls.
• Create visualizations such as map charts.
• Integrate statistical computing languages like R with Spotfire.

Data Analysis for Business Users is a practical, hands-on training designed to help participants work confidently with business data, extract meaningful insights, and support better decision-making. This instructor-led, live training (online or onsite) is aimed at beginner-to-intermediate-level business professionals who wish to use modern analytical techniques and tools to interpret data, identify trends, and communicate insights effectively.

This instructor-led live training in Cascais (online or onsite) is designed for data scientists, data analysts, and business analysts who aim to effectively clean and process data.

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

• Develop an effective data cleaning strategy.
• Implement useful tools for data cleaning.
• Get a result more efficiently.
• Learn and apply data cleaning best practices.

The KNIME Analytics Platform stands as a premier open-source solution for driving data-led innovation. It empowers users to uncover latent potential within their data, extract novel insights, or forecast future trends. Boasting over 1,000 modules, numerous pre-built examples, a robust suite of integrated tools, and the broadest selection of advanced algorithms, KNIME Analytics Platform serves as the ideal toolkit for any data scientist or business analyst.

This course on the KNIME Analytics Platform offers an excellent opportunity for beginners, advanced users, and KNIME specialists alike to become familiar with KNIME, enhance their proficiency, and learn how to generate clear, comprehensive reports using KNIME workflows.

This instructor-led live training (available online or onsite) is designed for data professionals seeking to leverage KNIME to address complex business challenges.

It is specifically targeted at participants with no programming background who wish to utilize cutting-edge tools to implement analytics scenarios.

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

• Install and configure KNIME.
• Develop Data Science scenarios.
• Train, test, and validate models.
• Implement the end-to-end value chain of data science models.

Format of the Course

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Practical implementation in a live laboratory environment.

Course Customization Options

• To request customized training for this course or to learn more about this programme, please contact us to arrange it.

The "KNIME Analytics Platform" training offers a comprehensive overview of this free data analytics platform. The programme covers an introduction to data processing and analysis, installation and configuration of KNIME, building workflows, business modelling methodology, and data modelling. The course also discusses advanced data analysis tools, workflow import and export, tool integration, ETL processes, data mining, visualisation, extensions, and integrations with tools such as R, Java, Python, Gephi, and Neo4j. The conclusion covers reporting, integration with BIRT, and KNIME WebPortal.

This instructor-led live training in Cascais (online or onsite) is aimed at data scientists who wish to program in Python and R for KNIME.

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

• Plan, build, and deploy machine learning models within KNIME.
• Make data-driven decisions for operations.
• Implement end-to-end data science projects.

As your delegates prepare for advanced Data Analytics degrees abroad, they face a dual challenge: mastering technical coding and understanding how to translate data into business value. This intensive 5.5-hour program is architected to bridge both gaps simultaneously. By combining Python technical foundations with an introductory business analytics framework, we ensure your team starts their academic journey as leaders, not just learners.

This instructor-led, live training in Cascais (online or onsite) is aimed at business analysts and data analysts who wish to use TIBCO Spotfire X with its artificial intelligence capabilities to visualize, transform, and analyze data.

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

• Install and configure TIBCO Spotfire X.
• Understand the features and architecture of TIBCO Spotfire X.
• Understand the concepts behind augmented and predictive analytics.
• Learn how to load, process, and visualize data using Spotfire X.
• Create interactive and enhanced data visualizations.

This instructor-led, live training in Cascais (online or onsite) is aimed at business professionals who wish to use data storytelling, PowerPoint, and AI tools to create executive presentations that support decision-making and follow corporate branding standards.

By the end of this training, participants will be able to: structure messages with AI, improve slide design, strengthen visual stories, and deliver clearer executive presentations.