Data Manager Course: Excel, SQL & Power BI

Next Date: December 2025 | 2 months | 100 hrs | Remote

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.

What you will learn:
In this intensive course, you’ll learn to manage, analyse, and visualise data using today’s leading tools. You’ll master SQL, from relational database concepts to advanced commands and hands-on practice. With Excel, you’ll organise, transform, and visualise data efficiently — even integrating it with SQL. You’ll also build interactive dashboards in Power BI, explore Power Query, and understand the basics of Big Data. The course concludes with a final project, where you’ll apply all your skills to a real-world data management scenario.

Deep Focus on the Most Needed Expertise in Tech

Practical training with real market examples.

Open Doors With Industry Connections

Recognized certification to strengthen your CV.

Deliver a Professional Project

Essential skills for careers in data analysis, business intelligence and information management.

Who Is the Program For?

The Data Manager Course with Excel, SQL and Power BI is perfect for professionals in management, marketing, finance and technology who want to stand out in the job market through data analysis and smart visualization.

Teachers

This unique program was built by a professional team made up of the leading experts in Development, 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.

Course Curriculum

SQL

Master the essential language of data!
In this module, you’ll learn the basics of SQL and relational databases, exploring how to query, filter, and manage information efficiently. You’ll practise advanced commands and build optimised queries to solve real-world problems. Through hands-on exercises, you’ll understand how SQL is used daily by Data Managers to turn raw data into actionable insights.

Intro to SQL & relational databases
Querying data
Advanced SQL commands
Hands-on practice

Excel

Turn spreadsheets into powerful analytical tools!
In this module, you’ll learn to organise and structure data, apply advanced functions, and build clear, effective visualisations. Discover how to turn complex information into visual insights using charts, pivot tables, and dashboards. You’ll also integrate Excel with SQL, combining the strengths of both tools to manage and analyse data more efficiently and professionally.

Data organization
Advanced functions
Data visualization
Excel & SQL integration

Power BI + Big Data

Bring your data to life and unlock the power of large-scale analysis!
In this module, you’ll learn to prepare and transform data with Power Query, build interactive dashboards, and visualise insights clearly and effectively. You’ll explore the differences between Power BI and Tableau, understanding when and how to use each tool. Finally, you’ll be introduced to the world of Big Data, learning how to handle large datasets and extract meaningful, strategic insights.

Data prep with Power Query
Dashboards & visuals
Power BI vs. Tableau
Intro to Big Data

Final Project

Put everything you’ve learned into practice with a real-world data management project!
In this final module, you’ll develop a complete project that combines your skills in SQL, Excel, and Power BI. You’ll collect, process, and visualise data, building an interactive dashboard that delivers clear, actionable insights. This project will showcase your technical mastery and your ability to turn data into strategic decisions — a valuable highlight for your professional portfolio.

Related Programs and Courses

Data Analyst

Analyze huge sets of data using cutting edge tools to produce insights that would enable your company to grow and take action! A program for beginners and career changers with a passion for numbers.

RESKILLING

UPSKILLING

Power BI

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

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

ESG & Sustainability Consultant

“Fiz o curso de análise de dados na TechOf e, do primeiro contato até a apresentação do trabalho final, só tive boas experiências. No início, estava com dúvidas se fazia o curso e logo em seguida recebi uma chamada da professora Beatriz super disposta a tirar todas as minhas dúvidas. A metodologia é ágil, eficiente e completa. A professora é muito atenciosa, sempre disponível e consegue dar atenção para os alunos com diferentes ritmos de aprendizagem. O espaço é amplo e equipado com materiais de qualidade. Eu recomendo 100% a TechOf!”

José Madureira Pinto

Financial Business Consultant

“Encontro-me a concluir o curso de Analista de Dados na TechOf e só posso deixar elogios. A equipa é incrível, sempre disponíveis e atentos ao progresso de cada aluno e com feedback de experiências do “mundo real”. Mas talvez o maior elogio que posso fazer seja este: após 6 meses intensivos, com uma abordagem muito prática, vi colegas de curso — vindos das mais diversas áreas e sem experiência prévia em ferramentas como SQL, Python ou Power BI — a desenvolverem projetos com uma qualidade surpreendente, ao nível (ou até superior) de muitos profissionais com anos de experiência na área. Recomendo vivamente a quem procura uma formação sólida, prática e transformadora.”

João Teixeira

NOC Service Desk Analyst

“O verdadeiro desafio foi conseguir transpor as minhas ideias e conceitos para a prática. A TechOf ajudou-me imenso, proporcionando-me a liberdade de errar e corrigir ao longo do caminho. Recebi orientações valiosas, como: ‘Aqui, poderias aprofundar mais este ponto ou melhorar nesta área’. Isso foi crucial, pois muitas vezes falta-nos essa abertura para receber feedback sincero, algo que nem sempre encontramos. A abordagem transparente e construtiva da equipa fez toda a diferença”

Caroline Brockveld

Civil Engineer

My goal in this course was to learn how to use tools, manipulate data, and derive insights from it. What I gained, however, was much more than that. I had the privilege of learning from an amazing mentor, Beatriz Duarte, who encouraged us to question and analyze data from different perspectives. I also had the opportunity to connect with colleagues from diverse backgrounds, whose insights I will carry with me. I am deeply grateful for the knowledge shared by the TechOf team. I’m already applying what I’ve learned in my daily work and am eager to keep improving my results through data-driven decisions.

Sofia Carvalho

Insurance Specialist at Tesla

“Escolhi a TechOf porque foi a única escola que encontrei que oferecia as ferramentas de SQL, Python, e Power BI, focadas especificamente em análise de dados. A praticidade do curso, com uma forte aposta em exercícios e projetos, foi crucial para a sua aprendizagem. Adoro analisar dados e queria muito aprender estas técnicas”. “Agora, em vez de extrair grandes bases de dados em Excel, que muitas vezes iam abaixo, uso SQL para extrair exatamente a informação que preciso, o que aumentou a eficiência, o próximo passo é usar Power BI para facilitar a comunicação com os stakeholders”

Hugo Boavista

Data Analyst | Civil Engineer

“Na área em que eu estava, Engenharia Civil, estava num beco sem saída. Comecei a procurar cursos no mundo das tecnologias e achei que o curso de Data Analyst era o ideal para mim, dado que sou mais analítico. Foi um gosto trabalhar aqui durante seis meses e sair com perspetivas novas para a minha vida. Saio com um sentimento de dever cumprido”

Tiago Jesus

Call Center Manager

“Foi muito desafiante, sem dúvida, porque não tinha qualquer base de programação. No entanto, os conteúdos que nos deram foram straight to the point. Começámos com SQL, Microsoft Excel avançado, Power BI e terminámos com o Python. Foi muito desafiante. No entanto, os conteúdos que nos deram foram eficazes, praticámos bastante e também ajudou a nossa professora, Beatriz Duarte, ser excecional e prática. Consigo criar, analisar e acompanhar toda a informação da minha equipa, simplesmente porque adiciono informação e a programação automaticamente dá-me tudo o que preciso, porque a configurei assim. Facilita-me imenso a vida. O Power BI foi life changing. Se encontraram a TechOf, e se estão com dúvidas, acho que devem dedicar tempo e visitar a escola, onde todos são muito prestáveis. Não tenham dúvidas em inscrever-se na TechOf, porque acho que é o início de muitas carreiras de sucesso”

Patrícia Tavanez

Lab Technician

“Sempre gostei da parte de análise e tratamento de dados, porque é uma área que, ao contrário da Química em laboratório, não traz surpresas desagradáveis no final de um dia de trabalho. No início, a programação assustava-me, mas acabei por gostar muito. Achei que foi uma oportunidade fantástica para explorar o meu lado mais criativo e pensar fora da caixa, Aproveitem toda a disponibilidade que a TechOf oferece e não tenham medo de explorar coisas diferentes”

Diana Levytska

Export Sales Manager

“Recomendo vivamente. Superou todas as expectativas! Um curso que prepara para o mercado de trabalho, com conteúdos atualizadíssimos e uma abordagem prática que faz toda a diferença. O suporte da professora e a qualidade do material foram fundamentais para o sucesso deste curso.”

WhatsApp Image 2025-01-29 at 18.21.54_3c02d8c4

Marília Cremaschi

Business Operations Specialist

A escola é excelente. Curso, equipa, estrutura… tudo fantástico! Fiz o curso de Data Analyst e terminei o curso muito satisfeita com todo o desenvolvimento que me foi promovido.”

FAQs

Will I receive a certificate?

Yes! All graduates who have successfully completed the program will receive a Frontend Developer certificate.

Thousands of alumni use their course certificate to demonstrate skills to potential employers, along with their LinkedIn networks. Our web development programs are well-regarded by many top employers, who contribute to our curriculum and partner with us to train their own teams.

Are the classes online or presential?

Our hybrid learning model ensures that you can study in the way that works best for you—either at our physical center or remotely. Some courses like this one, are only online. 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.

What is the application process like?

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.

What if I don’t have the required skills prior to this program?

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.