"Be Part Of A Community Of Thriving Talents and Businesses In The Digital And
Tech Space"
Data Foundations: For Early Professionals
The Advanced Data Analytics Bootcamp is a 6-week program designed for professionals who want to take their skill in data analytics to the next level.
This course is designed to provide participants with the advanced knowledge and technical skills needed to tackle complex data problems and succeed in the job market.
We’ve had these companies train their workforce with us… and have taught students who got jobs in the following companies
Program Overview
The Data Foundations course for Advanced Training is a comprehensive program designed for individuals seeking advanced skills and knowledge in data analytics.
This course covers four major topics: Microsoft Excel, Power BI, SQL, and Tableau. Participants will gain in-depth knowledge of each tool and its application in data analysis, as well as real-world projects and portfolio development to showcase their proficiency in data analytics.
Who Should Attend
This course is ideal for individuals seeking to advance their career in data analytics, including data analysts, business analysts, financial analysts, and anyone who wants to learn advanced data analytics skills. Prior experience in data analytics is recommended, but not required.
How You Will Learn
Methods: Virtual and Physical classes, Business case-studies, Virtual projects, and Interactive quizzes.
Overall, the course is designed to provide a mix of theoretical concepts and practical applications to ensure you acquire a holistic understanding of data analysis.
What You Will Learn
I. Microsoft Excel for Data Analysis
- Gain an in-depth understanding of Excel for data analysis, including Pivot Tables, Hlookup, Vlookup, and Exact Match functions.
- Learn how to create dynamic dashboards that display and visualize data in real-time.
- Acquire advanced skills in Excel formulas and functions for data analysis, such as array formulas, index match, and conditional formatting.
- Master Excel’s data visualization tools, including charts, graphs, and sparklines.
ll. Power BI for Data Modeling and Visualization
- Learn how to design and create effective data models for efficient data analysis.
- Master Data Analysis Expressions (DAX) for complex calculations, such as time intelligence, filtering, and ranking.
- Acquire advanced skills in Power BI’s visualization tools, including custom visuals, drill-through, and drill-down.
- Gain experience in designing and creating reports, dashboards, and scorecards for data-driven decision-making.
lll. SQL for Data Analysis
- Understand the fundamentals of SQL and relational databases, including tables, keys, and constraints.
- Learn how to write advanced queries using aggregate functions, subqueries, and common table expressions (CTEs).
- Acquire skills in using SQL for data manipulation, such as updates, inserts, and deletes.
- Gain experience in optimizing SQL queries for performance and scalability.
IV. Tableau for Data Visualization and Storytelling
- Master the art of storytelling in data visualization, including design principles, visual hierarchy, and narrative flow.
- Acquire advanced skills in Tableau’s visualization tools, such as data blending, dual-axis charts, and set analysis.
- Learn how to design and create interactive dashboards that engage and inform users.
- Gain experience in building complex calculations, such as table calculations, LOD expressions, and parameter controls.
V. Real-World Projects and Portfolio Development
- Master the art of storytelling in data visualization, including design principles, visual hierarchy, and narrative flow.
- Acquire advanced skills in Tableau’s visualization tools, such as data blending, dual-axis charts, and set analysis.
- Learn how to design and create interactive dashboards that engage and inform users.
- Gain experience in building complex calculations, such as table calculations, LOD expressions, and parameter controls.
By the end of the Data Foundations course for Advanced Training, you will have gained advanced skills and knowledge in data analytics using Excel, Power BI, SQL, and Tableau. You will have developed a portfolio showcasing your proficiency in data analysis and completed real-world projects that demonstrate your expertise. You will also have built a network of professionals in the field and expanded your career opportunities in the data analytics industry. Enroll now to take your data analytics skills to the next level!
Class Requirements
NEXT KICK-OFF:
Course Schedule:
Virtual Classes
Thursday: 10:00am - 4:00pm
Friday: 10:00am - 4:00pm
Duration: 4 weeks
Saturday: 10:00am - 4:00pm
Duration: 8 weeks
Enrolment Deadline
N135,000
Pay in Installment
With our flexible payment option, you can enroll and attend our digital marketing class while paying in installments.
All You Need To Do Is:
- Enroll and make your first installment of 60%
- Enusre that a 30% installment payment is made during the mid-week of class
- Enusre that a 20% final installment payment is made before the last week of class
Testimonials
Get Certified
With our flexible payment option, you can enroll and attend our digital marketing class while paying in installments.
Explore your professional development opportunities at PDMA