
Meet your instructor, Alex, a product researcher with a PhD in anthropology, guiding you through the professional program for data analysts at the Institute of Management, Technology and Finance.
Embark on the data analyst: professional certificate in data analysis with a warm welcome to MTF.
Please, look to attached files
Please, look to attached files
Explore exploratory data analysis (eda) to uncover patterns, outliers, and trends using descriptive statistics and visualizations such as histograms, box plots, and scatter plots.
Turn raw data into clear visuals with dashboards and charts to reveal patterns and trends, using Tableau, Power BI, matplotlib, or ggplot2 to deliver audience-specific, real-time, actionable insights.
Translate data analysis into meaningful insights and actionable recommendations that inform business decisions for non-technical stakeholders through clear reports and engaging presentations.
Learn how data privacy and ethics shape responsible data analysis under GDPR and CcpA. Apply data minimisation, consent, access rights, encryption, and audits to protect individuals and ensure transparency.
Explore exploratory data analysis to understand data structure, spot outliers, identify trends, and generate hypotheses using descriptive statistics and visualizations such as histograms, box plots, and heatmaps, guiding subsequent modeling.
Develop hands-on data cleaning, analysis, and visualization skills across Excel, SQL, Python, R, and Tableau, including missing data, descriptive statistics, and regression.
Learn to clean and analyze data in Excel by identifying missing values, replacing them with the average, using sumifs and pivot tables to summarize regional sales and identify top salesperson.
please, download attachments for practicing
please, download attachments for practing
please, download attachments for practing
please, download attachments for practicing
please, download attachments for practicing
Master advanced formulas and functions, data analysis and visualization with pivot tables and dynamic charts, data cleaning, macros and VBA automation, and advanced filtering and dynamic arrays.
Please, look to attached file
also, please look to attachments at each module
Learn to apply if, and, or functions to classify sales performance and verify conditions like above 1000, above 100 in all months, or above 300 in any month.
Learn how lookup and reference functions work, including vlookup, index, and match, to retrieve exact or approximate values from tables, as shown with widget prices.
Explore text to columns to split data by delimiters into separate fields, such as turning product codes into type id and variant for clean csv data.
Automating tasks with Excel macros streamlines workflows, reduces repetitive effort, minimizes errors, freeing time for strategic data analysis and reliable report generation.
Use Get and Transform to import a CSV, rename columns to employee name, team, and annual salary, filter out salaries below 60,000, then close and load to a new worksheet.
Integrate SQLite and Excel to create a robust data workflow that stores and queries data, exports to CSV, analyzes with Excel pivot tables and charts, and enhances collaboration.
Build on your advanced excel skills by mastering complex formulas, data analysis, and automation with VBA. Apply these techniques to real world practice and explore power BI and SQL.
Please, look to attached files
Learn to use SQL Lite and SQLite from basics to advanced, performing data retrieval, manipulation, joins, subqueries, and indexing for real-world analytics.
Explore advanced queries using aggregate functions, group by, and having to analyze data by category; calculate total and average prices, count products per category, and filter groups for business insights.
Learn four join types—inner, left, right, and full outer—for combining data, then practice an inner join to link products with categories and query their details.
Please, look to attached file
Please, look to attached files
Master data-driven marketing decisions by learning foundations, tools, and strategies to optimize campaigns, boost customer insights, and turn data into actionable marketing intelligence.
Explore how marketing data underpins modern strategies by distinguishing quantitative from qualitative insights and structured from unstructured formats. Combine these data types to optimize campaigns and reveal customer needs.
Predictive analytics uses regression, classification, and decision trees to forecast sales, segment customers, optimize campaigns, and predict churn and lead scoring to improve marketing decisions.
Learn to collect, process, and analyze sales and service data using key analytical tools and techniques to improve decision making, customer experience, and performance.
Please, look to attached files
Please, look to attached file
Define data governance roles—data owners, stewards, and custodians—and align data management with business goals, establish policies, ensure data quality, and promote cross-functional collaboration under the chief data officer.
Appoint a chief data officer and establish a data governance office. Define scope, choose a centralized, decentralized, or hybrid model, and implement governance policies across data management.
Discover how data governance tools ensure data quality, metadata management, and compliance, and learn to select and implement tools like Collibra, Informatica, talent, IBM, Erwin, ASG technologies, and SAP.
Please, look to attached file
If you want to become a Data Analyst — this course gives you everything you need to go from beginner to job-ready.
Most courses teach tools separately.
This course teaches you how to use data to solve real business problems — exactly what employers expect.
Why this course stands out
Complete Data Analyst pathway (22+ hours)
From data collection → analysis → visualisation → decision-making
All key tools in one place
Excel, SQL, Python, R, Tableau + AI-powered workflows
Real-world applications across industries
Marketing, finance, operations, customer analytics
Hands-on projects & exercises
Build practical experience — not just theory
Career-focused approach
Portfolio building, job guidance, and real-world positioning
Future-ready skills (2026 and beyond)
Understand how AI is transforming data roles — and how to stay relevant
What you’ll actually be able to do
Turn raw data into actionable insights
Clean and prepare messy datasets
Analyse data using statistical and analytical techniques
Build dashboards and visualisations that drive decisions
Write SQL queries to extract and analyse data
Use Python for real-world data analysis
Apply data analysis to business problems
Communicate insights clearly to stakeholders
Make confident, data-driven decisions
Designed for real-world impact
This course goes beyond technical skills.
You’ll also learn:
How businesses actually use data
How to structure problems and think analytically
How to present insights in a way decision-makers understand
How to position yourself for data roles
Career Accelerator Edition
When you enrol, you unlock additional advantages:
Dual Certification
Udemy Certificate + Official MTF Institute Certificate
Portfolio & LinkedIn Guidance
Learn how to showcase your work and increase visibility to recruiters
Global Professional Network
Join a community of 700,000+ learners worldwide
About MTF Institute
MTF Institute is a global educational and research organisation headquartered in Lisbon, Portugal.
Present in 200+ countries
Trusted by 700,000+ students
Official partner of IBM, Intel, Microsoft
Member of the Portuguese Chamber of Commerce and Industry
Course Authors
This course is designed and delivered by experienced academics and industry professionals, combining:
Research excellence
Real-world business experience
Practical, applicable knowledge
Your outcome
By the end of this course, you will not just understand data analysis —
you will be able to apply it confidently in real-world scenarios and position yourself for data roles.
Start your transformation into a Data Analyst today.
Course provided by MTF Institute of Management, Technology and Finance
MTF is the global educational and research institute with HQ at Lisbon, Portugal, focused on business & professional hybrid (on-campus and online) education at areas: Business & Administration, Science & Technology, Banking & Finance.
MTF R&D center focused on research activities at areas: Artificial Intelligence, Machine Learning, Data Science, Big Data, WEB3, Blockchain, Cryptocurrency & Digital Assets, Metaverses, Digital Transformation, Fintech, Electronic Commerce, Internet of Things.
MTF is the official partner of: IBM, Intel, Microsoft, member of the Portuguese Chamber of Commerce and Industry.
MTF is present in 216 countries and has been chosen by more than 712 000 students.
Course Authors:
Dr. Alex Amoroso is a seasoned professional with a rich background in academia and industry, specializing in research methodologies, strategy formulation, and product development. With a Doctorate Degree from the School of Social Sciences and Politics in Lisbon, Portugal, where she was awarded distinction and honour for her exemplary research, Alex Amoroso brings a wealth of knowledge and expertise to the table.
In addition to her doctoral studies, Ms. Amoroso has served as an invited teacher, delivering courses on to wide range of students from undergraduate level to business students of professional and executives courses. Currently, at EIMT in Zurich, Switzerland, she lectures for doctoral students, offering advanced instruction in research design and methodologies, and in MTF Institute Ms. Amoroso is leading Product Development academical domain.
In synergy between academical and business experience, Ms. Amoroso achieved high results in business career, leading R&D activities, product development, strategic development, market analysis activities in wide range of companies. She implemented the best market practices in industries from Banking and Finance, to PropTech, Consulting and Research, and Innovative Startups.
Alex Amoroso's extensive scientific production includes numerous published articles in reputable journals, as well as oral presentations and posters at international conferences. Her research findings have been presented at esteemed institutions such as the School of Political and Social Sciences and the Stressed Out Conference at UCL, among others.
With a passion for interdisciplinary collaboration and a commitment to driving positive change, Alex Amoroso is dedicated to empowering learners and professionals for usage of cutting edge methodologies for achieving of excellence in global business world.
Dr. Pedro Nunes has built a multifaceted career combining academia and practical business expertise. His educational journey culminated with a Doctorate in Economic Analysis and Business Strategy with a cum laude mention from the University of Santiago de Compostela. Professionally, he has navigated through various sectors, including technology, international commerce, and consultancy, with roles ranging from business analyst to director. Currently, Pedro serves as a Professor in several DBA programs, applying his extensive industry experience and academic insights to educate the next generation of professionals.