Analysing Financial Data in Excel Training Course

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level advanced R users who wish to use R to build faster workflows, improve code quality, and handle more complex analysis tasks.

By the end of this training, participants will be able to: create reusable functions, improve data workflows, debug and optimize code, and produce reproducible reports.

Big Data refers to the range of solutions designed for storing and processing extensive data sets. Originally developed by Google, these Big Data solutions have advanced and inspired numerous similar initiatives, many of which are now available as open-source projects. R has become a widely adopted programming language within the financial sector.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner-level data analysts who wish to use R programming to manipulate data, perform basic data analysis, and create compelling visualizations for insights.

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

• Understand the basics of R Programming.
• Apply fundamental data science processes.
• Create visual representations of data.

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 Portugal (online or onsite) is aimed at beginner-level professionals who wish to clean and analyze data, make statistical projections, and create insightful visualizations using these tools.

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

• Understand the basics of Python, R, Power Query, and Power BI for data analysis.
• Clean and organize datasets using Python and Power Query.
• Perform statistical analysis and projections with R.
• Create professional dashboards and reports with Power BI.
• Integrate and analyze data from multiple sources effectively.

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

This instructor-led, live training in Portugal (online or onsite) is aimed at anyone who wishes to learn and master the fundamentals of econometric analysis and modeling.

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

• Learn and understand the fundamentals of econometrics.
• Utilize EViews and risk simulators.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate-level data analysts and business professionals who wish to perform time series forecasting and automate data analysis workflows using R.

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

• Understand the fundamentals of forecasting techniques in R.
• Apply exponential smoothing and ARIMA models for time series analysis.
• Utilize the ‘forecast’ package to generate accurate forecasting models.
• Automate forecasting workflows for business and research applications.

This instructor-led live training in Portugal (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.

R Markdown is an authoring framework that combines executable R code with narrative text to create dynamic and reproducible documents.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level R users who wish to generate automated, dynamic reports using R Markdown for internal documentation, research publications, or web publishing.

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

• Create R Markdown documents with embedded R code chunks and formatted text.
• Generate outputs in multiple formats including HTML, PDF, and Word.
• Use parameterized reports and conditional logic to generate dynamic content.
• Customize document appearance with themes, templates, and LaTeX for professional presentation.

Format of the Course

• Interactive lecture and discussion.
• Lots of 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.

Shiny is an R package that empowers users to develop interactive and dynamic web applications directly within the R environment, eliminating the need for JavaScript expertise or knowledge of complex web frameworks.

This instructor-led live training, available online or on-site, targets intermediate R users aiming to construct and deploy custom web applications using Shiny for data visualization, user engagement, and reporting purposes.

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

• Develop interactive web applications leveraging Shiny and R.
• Design user interfaces incorporating reactive components and dynamic input controls.
• Integrate data visualizations and reporting capabilities into Shiny applications.
• Deploy and share Shiny apps either locally or online using Shiny Server or Posit Cloud.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practical practice.
• Hands-on implementation within a live-lab environment.

Customization Options

• For bespoke training arrangements, please contact us directly.

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate to advanced computer science professionals who wish to leverage Stata for statistical analysis and integrate it with R.

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

• Effectively use Stata for data analysis and statistical modeling.
• Compare Stata’s functionalities with SPSS and R.
• Integrate Stata with R for seamless statistical computing.
• Develop and automate workflows using Stata and R.

This instructor-led, live training in (online or onsite) is aimed at data analysts who wish to use Stata and R to analyze big data for statistical analysis.

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

• Create statistical models for predicting key interest variables and events.
• Generate descriptive visualizations, summary tables, frequencies, and more.
• Manage and structure large databases to prepare for data analysis.

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

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

• Implement Tableau analytics with R.
• Return values to Tableau using learning algorithms in R.
• Structure and visualise R functions in Tableau.
• Make data driven decisions for business operations.