Microsoft Excel and Power BI together
Excel is a powerful, flexible tool for every analytics activity. Combine it with Power BI to get broad data analytics and visualization capabilities. Easily gather, shape, analyze, and explore key business data in new ways—all in less time—using both apps together.
Build self service Business Intelligence reports
Create rich, interactive visualizations and reports with advanced visualization and analytical capabilities of Microsoft Power BI and Excel. Automate mundane and repetitive reporting with the best analytical tools in the world.
Become a Data Professional.
- Data Analyst
- Data Scientist
- BI Analyst
- Business Analyst
- Data Engineer
- Financial Analyst
Sign up
Data Analyst
Business Analyst
Data Scientist
BI Analyst
BootCamp Curriculum
The program's curriculum is challenging, comprehensive, and constantly updated, ensuring you are always learning the most in-demand data analytics skills, techniques, and tools used by Data Analysts. You will learn Modern Excel, Microsoft Power BI, and SQL.
Data Analytics with Excel
Skills you'll gain: Data analytics, Data visualization, PivotTables, Excel charts, Dashboard design etc.
Beginners
No experience required
Power BI for Analytics
Skills you'll gain: Data visualization, Data cleaning, DAX, Dashboard Design, Data modeling etc.
Beginners
No experience required
Practical and Job-ready content
The program's curriculum is challenging, comprehensive, and constantly updated, ensuring you are always learning the most in-demand data analytics skills, techniques, and tools used by Data Analysts. You will learn Modern Excel, Microsoft Power BI, and SQL.
Introduction to Data Analytics and Business Intelligence
- Data analytics and Business Intelligence
- The Data Job Landscape
- Types of Data Analytics
- Application of Data Analytics
- Tools of Trade for Analysts
- Data Analytics lifecycle
- Roles in the Data Space
- Becoming a BI and Data Analyst - Skills required
Microsoft Excel for Analytics and Reporting
- Microsoft Excel Fundamentals
- Microsoft Excel Formulas and Functions
- Working with Excel Tables
- Advanced Formulas and Functions - Dynamic arrays
💡 Portfolio Project: Analyzing Data with Excel formulas and Functions
- Introduction to PivotTables
- Data visualization and Reporting
- Advanced PivotTables and Charts
- Working with Data from multiple sources
- Data cleaning and Transformation - Power Query
- Data modeling and DAX - PowerPivot
💡 Portfolio Project: Developing interactive dashboard with Excel.
Final Capstone: Pizza demand case study
Data Analytics and Visualization with Power BI
- Get started with Microsoft data analytics
- Prepare data for analysis
- Data Modeling in Power BI
- Creating custom business calculations with DAX
- Time Intelligence Calculations
- Performing advanced analytics with AI
💡 Portfolio Project: Analyzing HR Data with DAX
- Visualizing Data in Power BI
- Reporting and Dashboarding
💡 Portfolio Project: Analyzing Hotel Booking Data for Reporting
- Creating user-experience designs
- Sharing and consuming reports
💡 Portfolio Project: Analyzing and developing Financial Analytics Reports
Final Capstone: Team Projects
Get Certified!
Earn your verifiable digital certificate and validate your data analytics and business intelligence skills.
FESTMAN LEARNING HUB
FESTMAN LEARNING HUB
FESTMAN LEARNING HUB
.
.
MS EXCEL
MYSQL
POWER BI
Certified Business Intelligence & Data Analyst
ISSUED TO
John Walker
ctfestus
THOMAS FESTUS CUDJOE
FOUNDER - FESTMAN LEARNING HUB
Microsoft MVP | Chartered Accountant
Certificate ID: BNKMYNK18009
Program Details
Next Cohort
17
April
4 weeks
Mon - Thurs
6:00pm - 8:00pm
Apply Now
Book a Call
Apply Now
Limited seats
Join our Learning Community
With the support of a diverse community of mentors and peers, our immersive learning experience will provide you with the skills and support you need to succeed in our data-driven world today.
Sign up
Trusted by over 5k students across the globe
5,000+
Real-world Projects
Analyze and visualize Hotel booking Data
HR Analytics using Power BI
Financial Analytics using Power BI
FestMan is trusted by students working in top companies
I just created and designed an interactive dashboard on Power BI from the scratch using different AI/Machine Learning visualizations on Power BI.
Thanks, Thomas Festus Cudjoe, my wonderful instructor, FestMan™ Learning Hub, for the learning platform. It was awesome working with you.
Kafayat Bamishigbin
Maths tutor | Graphics designer
I am so grateful to the entire FestMan™ Learning Hub for awarding me a scholarship for their new curated HR analytics course.
The course has expanded my knowledge of data visualization and how to use tooltips to create additional visually appealing insights in your reports.
I enjoyed every bit of the course and would gladly recommend it to anyone aspiring to develop skills in data analytics.
Bright Alorwoyie
Client Delivery and Analytics Manager at SumsureIQ
Thanks to Thomas Festus Cudjoe and FestMan™ Learning Hub for the detailed tutorial that guided me to design this Financial Analysis Report with Power BI, It was very helpful.
Richmond Yeboah
National Service Person
This was fun!
Thank you FestMan™ Learning Hub for a wonderful learning experience, teaching us how to prepare, organize, model, and visualize data (using excel) to answer business questions.
I cannot wait to share my HR analytics projects (in progress)
Rejoice Gorni
People Partner | HR Business Partner
It's been fun and challenging learning with Festman in the second part of the year and their courses have been a huge blessing in improving my data analytics skillset as I transition into the data space through business problem case scenarios.
Thank you very much FestMan™ Learning Hub, and your team for putting this amazing contents together
Victor Ayodeji
Clinical physiologist
A Big thanks to FestMan™ Learning Hub for an opportunity to improve my skills in Power BI.
I also appreciate Thomas Festus Cudjoe for an insightful and wonderful session where I learned more on Data modeling, Data analysis, and Data Visualization.
Mary Titus
Financial reporting
/Accounting
Thank you FestMan™ Learning Hub for the Python for Data Science fundamentals training.
I learned about NumPy, pandas, concepts such as Dataframe, loops, sets & dictionaries, and functions.
This training is highly recommended. The learning continues with the Bootcamp in 2023.
Ayodeji Popoola
Data Analyst | Trade Finance Officer
FestMan™ Learning Hub has good guided projects and courses.
In this guided project, Thomas Festus Cudjoe gives a heuristic teaching experience on creating a financial dashboard in Power BI, highlighting some of the financial metrics and KPIs.
Victor Nyakako
Data Analyst
The idea of DAX calculations has always been intimidating for me.
After going through this project with aid of FestMan™ Learning Hub, I finally have an understanding of how DAX and time intelligence calculations are done.
Tafadzwa Chigwada
AWS Certified Cloud Practitioner
FestMan Learning Hub is a digital learning platform that provides premium digital skills in Data Science, Business Intelligence, Data Analytics and Financial Modeling.
All rights reserved 2023
LEARNING PATHS
Power BI Track
Microsoft Excel Track
Data Analytics Track
Business Intelligence Track