Data Analyst
- Next Date: January 2026 | 450 Hours | 9 Months
Your best path to a career transformation. This part-time data analyst (BI analyst) program features expert instruction, hands-on projects, and a real connection to the industry to get you hired.
This training is eligible for the Portuguese Digital Training Voucher.
In the digital kingdom where web and mobile applications help us manage nearly every aspect of our lives, data is king. Every digital action is visible and trackable, enabling corporations to accumulate and analyze vast amounts of both personal and business data. The use of ‘Big Data’ is driving disruption in every field — from vehicle navigation, through medicine, to cybersecurity.
Over the last few years, new professions like Data Analysts and Data Scientists have appeared on the market. Data Analysts, also known as Business Intelligence (BI) Analysts, examine large sets of data to identify patterns in the data. These patterns are then used to inform strategic business decisions.
Solve The World’s Most Interesting Problems
Become indispensable to employers with data analysis fluency. Harness the predictive power of data to work at the forefront of diverse industries like public policy, robotics, and FinTech.
Open Doors With Industry Connections
Equip yourself to succeed in a rapidly expanding field with help from our network of data experts, instructors, hiring partners, and alumni. The Data Analyst curriculum was created in collaboration with the industry’s leading companies to make our programs as relevant as possible to the local industry’s needs, assuring you’ll be job-ready as soon as the program ends.
Deliver a Professional Project
Throughout the program, practical skills are acquired through the completion of projects that tackle real-world data problems from end to end. You’ll gain hands-on experience with market-leading technologies, processing information, data analysis capabilities, business intelligence, and more, compiling a portfolio of projects designed to reinforce what you’ve learned in each unit.
Who Is the Program For?
Driven and motivated individuals with previous backgrounds or with no background at all, who wish to launch a highly sought-after career as a Data or BI Analyst.
Candidates for the program are required to have basic Microsoft Excel skills.
The Data Analyst Program has been accredited by the IoA – Institute of Analytics, the world's leading professional body for Analytics and Data Science, which promotes the continuous development of skills and networking opportunities in the field.
This accreditation attests that trainees acquire not only technical data analysis skills, but also essential soft skills, preparing them to effectively respond to the real needs of the market.
Teachers
This unique program was built by a professional team made up of the leading experts in Data Science and Analytics, with vast knowledge and experience in training, too.
Beatriz Duarte
Program Trainer
With 2 years as a professional consultant in data analysis and Business Intelligence and 7 years of prior experience in the banking sector, she has a strong foundation in data-driven decision-making.
At CapGemini, she developed tools and automated systems for business data management and analysis, enhancing operational efficiency.
Currently, she works at Cofidis, focusing on Data Governance, where she applies her expertise to ensure data accuracy, compliance, and effective data use across the organization.
Her background in both consulting and banking enables her to bridge technical and business needs, providing strategic insights and solutions.
Nuno Gil
Program Trainer
A graduate of Economics and in Computer Engineering, he held a Master of Information Management and BI, an Executive MBA, as well as owning several other certifications.
More than 30 years of work experience in the Bank, Insurance and Financial Services industries, with specialization in business analysis in the commercial scope, strategic management of people and information systems.
During his career, he served several roles, starting as Financial Market Operator and currently acting as Product Owner and Data Business Partner, in the Data and Intelligence at the Crédito Agrícola Bank.
Júlia Benikes
Career Advisor
Throughout and after the course, Júlia works closely with each student to guide their professional growth. Through practical, results-oriented sessions, she helps participants refine their CVs and LinkedIn profiles, highlight key skills, and develop effective job search strategies.
Upon course completion, Júlia plays a vital role in bridging the gap between graduation and employability, supporting students with interview preparation, professional networking, and translating their new skills into career opportunities.
With a personalized and people-focused approach, Júlia believes that every career path is unique — and that success begins when talent meets the right opportunity.
Program Curriculum
Step into the world of data and discover the power of information!
In this module, you’ll explore the role of a Data Analyst and the key skills needed to turn data into valuable insights. Learn what KPIs are, how the analytical work cycle functions, and get introduced to relational databases. A practical and inspiring start to a field that blends logic, curiosity, and real business impact.
- General introduction
- Analyst role and capabilities required
- KPI
- Analyst work circle
- Introduction to relational database
- Insights that can be derived from the data
Master the language of data!
In this module, you’ll learn to work with MSSQL, create queries, joins, and functions that turn data into insight. Explore advanced filtering, aggregations, CTEs, window functions, DML, and DDL, understanding how everything connects within the analytical workflow. Finish by writing custom functions and stored procedures, mastering the key techniques to extract, transform, and analyse data like a pro.
- Introduction to MSSQL
- Introduction to work environment
- Basic SQL query
- Calculated columns
- Basic built in functions
- Sorting the results
- Grouping and aggregate
- Advance filtering
- Working with NULL values
- Diagram
- Join tables
- Conditional statement
- Related and unrelated nested queries
- Most common built in functions
- Window functions
- CTE (Common Table Expression)
- DML (Data Manipulation Language)
- DDL (Data Definition Language)
- Data analysis using analyst work circle
- Writing user scalar functions
- Stored procedure
- Formulas
- Basic and advanced filtering data
- Sorting data
- Common use build-in functions
- Connectivity to outer data source
- If functions
- VLOOKUP
- Error handling
- What is analysis functionality
- Conditional formatting
- Charts and chart components
- Pivot tables
- Pivot charts
- Slicers
- Dashboarding
In this module, you’ll learn to use Power BI to turn data into interactive dashboards and powerful visual insights. Connect to multiple data sources, create dynamic charts, apply filters, hierarchies, calculated fields, and custom aggregations. Explore everything from basic charts to advanced combos, and learn how to export presentation-ready dashboards. A hands-on journey to mastering the art of visual data storytelling.
- Introduction to Power BI
- Connect to data
- Connections
- Basic chart types
- Grouping
- Advance chart types
- Combo chart
- Filtering
- Sorting
- Hierarchy
- Total and subtotals
- Calculated fields
- Custom aggregations
- Logic statements
- Dashboards
- Exporting a dashboard
Unlock the power of programming in data analysis!
In this module, you’ll master the fundamentals of Python, from variables and functions to data structures like DataFrames and Series with Pandas. Learn to import, clean, group, and visualise data using Matplotlib and Seaborn. You’ll also work with conditions, loops, regex, and custom functions, plus connect Python to MSSQL. Finish by creating automated scripts and export-ready dashboards — all through a practical, results-driven approach.
- Python fundamentals
- Numpy basics
- Basic operations and use of operators
- Documentation – importance and how to document
- Variables and basic data types
- Python basic build in functions
- String slicing
- Conditions
- Introduction to Pandas package
- Import data from CSV
- Pandas data structures: DataFrame, Series
- Pandas descriptive methods (head (), tail (), info (), describe () etc.)
- Filter records by conditions
- Complex conditions
- Regex
- Sorting data
- Retrieving data
- Handling NULL values
- Update data
- Grouping and aggregations
- Pivot table
- Cross tab
- Merging DataFrame methods
- Loops: For, While, Loop flow control
- Def functions
- Local and global variable
- Lambda function
- Apply method
- Connect to MSSQL
- Visualization with Matplotlib
- Visualization with Seaborn
- Adjusting the graph display
- Save data and pictures into Excel file
- Make your script a running program
Explore the world of large-scale data!
In this module, you’ll understand what Big Data is, how it’s generated, and how it’s transforming the way organisations make decisions. Learn the fundamentals of storage, processing, and analysis of massive datasets, along with the key technologies and real-world applications. An essential introduction for anyone looking to grasp the impact and opportunities of the data-driven world.
Projects requiring integration of skills and knowledge from extended training periods. The training contains 4 step projects:
- SQL Project
- XLS Project
- PowerBI
- Python
We believe that the most effective training is through practical work. Thus, the course requires students to use analysis tools and invest in the actual work of the data visualization project. The project covers the consolidation of all the subjects acquired, in terms of knowledge and soft skills.
Related Programs and Courses
Data Manager
- 2 months | 100 hrs | Remote | After Work
Become an expert in data management and analysis with our Data Manager Course, designed for those who want to master the most in-demand tools: Excel, SQL and Power BI.
UPSKILLING
UPSKILLING
Power BI
- 1 month | 30 hrs | Remote | After Work
This course is designed for professionals who want to master one of the most in-demand tools in Business Intelligence and Data Visualization.
UPSKILLING
Advanced Excel
- 1 month | 35 hrs | Remote | After Work
This course is designed for professionals who want to enhance their skills in data management and interpretation, using advanced Excel features to optimize processes and boost productivity.
What do our students have to say?
Nathalia Gaiarim
José Madureira Pinto
João Teixeira
Caroline Brockveld
Sofia Carvalho
Hugo Boavista
Tiago Jesus
Patrícia Tavanez
Diana Levytska
Marília Cremaschi
FAQs
Yes! All graduates who have successfully completed the program will receive a certificate.
You will also receive the SIGO Certificate, as our training is DGERT Certified.
Use you new course certificate to demonstrate skills to potential employers, along with their LinkedIn networks.
Our content is certified also by IoA – Institute of Analytics, the world’s leading professional body for Analytics and Data Science, promoting the continuous development of skills and networking opportunities in the field.
Yes! All of our courses are aligned with Cheque-Formação + Digital, feel free to ask us anything related with this 750 Euros fund from the state.
Our hybrid learning model ensures that you can study in the way that works best for you—either at our physical center or remotely. All classes are recorded and securely stored for a period of 3 months, so you never have to worry about missing a session, but remember that you need to attend 80% of the classes to have a certificate.
This approach allows your learning to continue uninterrupted, with live, interactive sessions led by expert trainers.
Additionally, learning materials and self-study topics, are available on-demand. Access these resources anytime, from anywhere, to reinforce your knowledge and stay on track with your studies.
Register your interest below to be contacted by one of our Career Consultants. Book an in-person or online consultation session to validate the desired course content, available classes and schedules, and gain access to our assessment test.
Our program is designed to bridge the gap for those without a programming background, providing the foundational skills you need to succeed.
For all candidates, we conduct a comprehensive computerized assessment to evaluate key attributes such as personality fit, basic math skills, and logical thinking.
This ensures you’re prepared not just to excel in the program, but also to thrive in your future career.
English 
Portuguese