Become A Certified Data Analyst with Excel & Power Bi
Time before the price increases:
Why You Should Take This Course
Data Analysis Is One Of The Most In Demand Skills In The World Today
With this training, you will have all the skills, knowledge, techniques and tools that will make it super easy for you to get jobs in data analytics. Guaranteed.
Our Instructors are among the best I.T Trainers and Consultants in Nigeria.
This program is designed to hold you by the hand and show you all the tools, trick and techniques practically. You will learn all these by DEMONSTRATION. No theory.
Four (4) weeks into the Course, you will begin your Internships with 2 among the global top 5 consulting firms where you will build and apply your knowledge and skills to real world business problems. Upon course completion, we will support you through your job search and you will get exclusive access to our dedicated job group to apply for relevant jobs.
Skills You'll Learn
In this course, you'll learn the most effective ways to go become a World Class Data Analyst by using professional and complex datasets of real companies, and developing data analytics skills and experience.
As students of Data analysis you will be introduced to data analysis softwares and techniques.
Data Cleaning
What you’ll learn:
1. Removing duplicates and handling missing values.
2. Standardizing data formats (dates, numbers, text).
3. Correcting data entry errors and inconsistencies.
4. Split and merge columns as needed.
Text Functions
What you’ll learn:
1. Introduction to Text functions: Trim, Left, Right, Substitute, etc…
2. Practice using the text functions on sample datasets.
Basic Functions
What you’ll learn:
1. Introduction to Basic arithmetic functions: SUM, AVERAGE, MIN, MAX.
2. Practice using the basic arithmetic functions on sample datasets.
Background:
Netflix Inc. aims to optimize its content recommendation algorithm and improve customer satisfaction by ensuring that its content library data is clean, accurate, and ready for analysis. The company has observed inconsistencies in its data, such as missing values, duplicate records, and incorrect classifications, which may affect the performance of its recommendation system.
Task Overview:
As a data analyst at Netflix, you are tasked with cleaning and preparing the company’s dataset for further analysis. The dataset includes information about movies and TV shows, such as titles, genres, release dates, ratings, and user interaction metrics.
Your Responsibilities:
- Determine which columns have missing data.
2. Decide on appropriate strategies to handle missing values, such as imputation, filling with default values, or removal of rows/columns.
3. Identify and remove any duplicate records in the dataset to ensure each entry is unique.
4. Check for and correct inconsistencies in data formats (e.g., dates, ratings).
5. Standardize categorical data, such as genre and country names, to maintain consistency.
6. Verify that numeric data (e.g., duration, user ratings) is within a reasonable range.
7. Cross-check dates and other time-based data for logical consistencies.
What you’ll learn
- IF function: Basic usage and syntax.
- Creating more complex conditional logic by nesting IF functions.
- Introduction to the IFS function as an alternative to nested IFs.
Advanced Logical Functions
ACTIVITIES:
- Understanding and applying the SUMIF, COUNTIF, AVERAGEIF functions.
- Use SUMIF with multiple criteria (by combining with SUMIFS).
- Use COUNTIF with multiple criteria (by combining with COUNTIFS).
- Use AVERAGEIF with multiple criteria (by combining with AVERAGEIFS).
Background:
A global retail company wants to optimize its marketing campaigns to increase sales and improve customer engagement. The marketing team has collected sales data from various campaigns over the last year, including information about customers, sales transactions, and campaign-specific details. Your task is to analyze this data using logical functions to identify trends, segment customers, and recommend strategies to improve future campaigns.
Your Responsibilities:
- Use logical functions to segment customers based on various criteria such as age group, purchase amount, and loyalty program membership.
- Identify high-value customers who consistently make large purchases or frequently engage with marketing campaigns.
- Determine the effectiveness of different campaigns by calculating total sales, average purchase amount, and the number of transactions for each campaign.
- Use logical functions to filter and compare the performance of campaigns based on specific conditions, such as region, discount application, and sales channels.
- Use logical functions to identify trends in sales data, such as peak purchase times, popular product categories, and regional preferences.
- Analyze the behavior of loyalty program members compared to non-members using logical conditions.
- Based on your analysis, recommend strategies to optimize future marketing campaigns, such as targeting specific customer segments, adjusting discount strategies, or focusing on high-performing channels and regions.
What you’ll learn
- Introduction to VLOOKUP
- Practicing basic VLOOKUP with simple datasets.
- Nesting VLOOKUP within other formulas for advanced functionality.
- Explore alternative lookup functions like INDEX and MATCH.
- Learning how to combine INDEX and MATCH to create powerful lookup formulas.
- Understanding the advantages of using INDEX and MATCH over VLOOKUP.
Background:
A retail company is looking to enhance its sales reporting by integrating additional data from various sources to gain deeper insights into sales performance. The company has data on sales transactions, customer information, and product details stored in separate datasets. Your task is to use lookup functions to consolidate this data and perform a comprehensive sales analysis.
Your Responsibilities:
Use lookup functions to match and combine data from the Sales Transactions dataset with the Customer and Product datasets.
Create a comprehensive sales report that includes the customer name, product name, category, region, and loyalty program membership for each transaction.
Use lookup functions to categorize sales data by product category.
Leverage lookup functions to segment sales data by customer region and loyalty program membership.
Analyze the sales contribution from different regions and compare the purchasing behavior of loyalty program members versus non-members.
Use lookup functions to link sales data with product suppliers.
Calculate important sales metrics such as average order value, total units sold, and revenue per customer using the consolidated data.
Suggest strategies for targeting high-value customers, optimizing inventory, and enhancing supplier relationships.
What you’ll learn
- Design dashboard layout and structure.
- Use PivotTables, Pivot Charts, and slicers for interactivity.
- Include key performance indicators (KPIs) and metrics.
PRESENTATION
- Working in teams to deliver presentation
- Practice delivering the presentation.
- Gather feedback and make adjustments.
Background:
A leading bike retailer is looking to improve its business strategy by analyzing its bike sales data. The company wants to understand sales trends, identify key customer segments, and optimize its inventory management. Your task is to analyze the provided bike sales data, create an interactive dashboard, and deliver actionable insights and recommendations to the management team.
Your Responsibilities:
- Analyze overall sales trends over time, identifying peak sales periods, and seasonal variations.
- Evaluate the performance of different bike types in terms of sales volume and revenue generated.
- Segment customers based on demographics such as age, gender, and region to understand purchasing behavior.
- Create an interactive dashboard that visually represents the key findings from your analysis.
- Include key performance indicators (KPIs) such as total sales, average order value, top-selling bike types, customer demographics, and regional sales distribution.
- Implement filters for the dashboard that allow users to drill down into specific time periods, regions, or customer segments.
- Use a variety of visualizations, such as bar charts, line graphs, pie charts, and heat maps, to present data clearly and effectively
- Recommend which bike types should be prioritized in marketing and inventory based on sales performance and customer demand.
ACTIVITIES
- Identifying various data sources.
- Importing data into Power BI from various sources (Excel, CSV, databases, etc.).
Data Cleaning and Transformation
ACTIVITIES
- Using Power Query to clean data
- Applying Data types and
Data Modeling
ACTIVITIES
- Creating relationships between tables.
- Defining primary keys and foreign keys.
Background:
Choprite, a retail chain with multiple locations, has accumulated a large volume of sales data over the past year. However, the data is messy and unstructured, with inconsistencies and missing values. The management team wants to leverage this data to understand sales performance, identify trends, and make informed business decisions. Your task is to clean, transform, and analyze the sales data to provide actionable insights.
Your Responsibilities:
- Identify missing values and decide how to address them (e.g., filling in with mean/median, forward/backward filling, or removing rows/columns with excessive missing data)
- Identify and remove duplicate records to ensure each transaction is unique
- Validate that the Total Sale Amount matches the product of Quantity Sold and Unit Price; correct any discrepancies
- Group products into broader categories if necessary, and create a summary of sales by category
- Analyze overall sales trends over time, identifying peak sales periods, seasonal variations, and store performance.d on sales volume and revenue
- Analyze customer purchasing behavior, identify high-value customers, and understand the impact of discounts on sales.
Recommend which products or categories should be prioritized based on sales performance and customer demand.
ACTIVITIES
- Creating basic visualizations (bar charts, line charts, pie charts etc.).
- Using visualizations to understand data distributions and trends.
DAX Formulars
ACTIVITIES
- Creating summary statistics using DAX measures.
- Using DAX for complex measures and calculated columns.
- Using DAX for creating Calculate Functions
Dashboard Creation
ACTIVITIES
- Building Interactive Dashboards
- Creating key visualizations and adding them to the dashboard.
- Adding interactivity with slicers, filters etc.
Background:
A retail analytics firm has gathered a comprehensive dataset from a large online retailer to understand consumer shopping trends. The firm aims to identify patterns in customer behavior, spot emerging trends, and provide strategic insights to improve the retailer’s marketing, product offerings, and customer experience. Your task is to analyze the shopping trends dataset and provide detailed insights and recommendations.
Your Responsibilities:
Analyze customer demographics to segment shoppers by age, gender, income level, and region. Identify which segments are most valuable based on purchase frequency and total spending.
Determine which product categories are most popular among different customer segments. Identify any emerging trends in product preferences.
- Analyze the timing of purchases to identify peak shopping times, including day of the week, time of day, and seasonal trends.
Determine which devices (mobile, desktop, tablet) are most commonly used by customers and whether there are differences in purchase behavior depending on the device
Analyze payment method preferences across different customer segments. Identify if certain methods are more popular with specific demographics or during particular times of the year.
Identify products that are frequently purchased together. Analyze these co-purchase patterns to uncover potential cross-selling or bundling opportunities.
Determine which products are often bought by the same customer segments, suggesting affinities between product types.
Provide recommendations for targeted marketing campaigns based on customer segmentation, device usage, and purchase timing.
Implement visualizations that highlight emerging shopping trends, allowing the retailer to adjust strategies in real-time.
The Artificial Intelligence (AI) is currently shaping processes in every businesses and industries, in this unit, you will learn how to integrate generative AI into data analytics workflows, and help organizations significantly enhance their ability to derive actionable insights, improve data quality, and make more informed decisions.
In this segment, you will have a Ask-Me-Anything session with a top data analyst to guide you further.
In this segment, a top freelancer will share with you a blueprint that guarantees you to make at least $1,000 Monthly working Remotely As A Data Analyst… Even if you know nothing about remote work.
The Skilled Worker visa allows qualifying individuals to come to the UK to work for an approved sponsor in an eligible role. We will give you a Guide on How To Apply for Skilled Worker Visa and Tech Nation Visa.
Register today to enjoy our Workspace with Ultra Fast Satellite Internet (Starlink) for FREE.
Skills You'll Learn
In this course, you'll learn the most effective ways to go about studying data, using professional and complex datasets, and developing fundamental data skills and knowledge.
Data science project failure can often be attributed to poor problem definition. In this module, you will the techniques for defining the need for data analysis by framing up a business problem in a way that can be addressed with data.
In this segment, a top freelancer will share with you a blueprint that guarantees you to make at least $1,000 Monthly working Remotely As A Data Analyst… Even if you know nothing about remote work.
The Skilled Worker visa allows qualifying individuals to come to the UK to work for an approved sponsor in an eligible role. We will give you a Guide on How To Apply for Skilled Worker Visa and Tech Nation Visa.
Training Details
No need to quit your job or school, you can enhance your professional and earning potential with our weekday, weekend and online sessions.
Day: Monday, Wednesday & Friday
Time: 10 AM - 1 PM
Duration: 6 Weeks + Internship
Day: Tuesday & Thursday
Time: 7PM - 9PM
Duration: 6 Weeks + Internship
Saturday Time: 1PM-4PM
Sunday Time: 1PM-4PM
Duration: 8 Weeks + Internship
Early Bird*: Pay N50,000 Instead of N100,000
SkillBoost Limited: Fonte House, 1 Temple Ejekwu Close, First Artillery Junction, Aba Road, Port Harcourt, Rivers State.
Training Start Date: 28th July 2025
SkillBoost Limited: 4, Obe Street, Beside BOVAS Filling Station, New Bodija, Ibadan, Oyo State, Nigeria.
Training Start Date: 28th July 2025
Surfweb Digital Solutions: 321 Road, E Close, House 10, Festac Town, Lagos State Nigeria.
Training Start Date: 28th July 2025
Other Skills You'll Learn
Become a Google power user. Master Docs, Sheets, Forms, and Drive to handle tasks, organize information, and collaborate seamlessly—whether you’re in the office or classroom.
Sharpen your edge with top-tier workplace essentials: teamwork, negotiation, and impactful communication. Learn what it takes to thrive in fast-paced, competitive environments. Step into leadership with confidence. Develop strategic thinking, decision-making, and administrative mastery to grow your influence and unlock new career opportunities.
Whether it’s a blog, report, or proposal—your writing should get results. Learn to write with clarity, precision, and purpose for the digital age and professional world.
Communicate like a leader. Discover how to write polished emails, reports, and formal correspondence that command respect and drive action.
Nervous speaking in front of others? Say goodbye to fear. Learn the secrets of powerful presentations, persuasive storytelling, and audience engagement that inspires action.
Get more done in less time. Master tools like Microsoft Office, Notion, and digital calendars to organize your workflow and skyrocket productivity.
Turn every client into a loyal fan. Learn to manage inquiries, solve problems, and build powerful customer relationships that drive business growth.
- Not sure where you fit in? Uncover your ideal path by identifying industry opportunities, exploring high-demand roles, and aligning your strengths with careers that excite you.
Capture attention. Learn how to create engaging blog posts, compelling videos, and powerful digital stories that grow audiences and drive conversions.
Lead with clarity and control. Discover how to manage deadlines, delegate tasks, and execute efficiently using top tools like Trello, Asana, or ClickUp.
Master the art of working online. Learn everything from setting up your workspace to collaborating virtually and maintaining professionalism in digital environments.
Tap into the power of Artificial Intelligence (AI). Discover how to use tools like ChatGPT and other cutting-edge technologies to automate tasks, boost productivity, and stay ahead of the curve.
Turn your business idea into a rock-solid plan. Learn how to write a winning business plan and understand startup essentials for launching with confidence. No more funding guesswork. Learn where and how to secure money for your business, from grants to angel investors and more.
Discover the exact steps to start earning in USD using the skills from this program. Perfect for freelancers, solopreneurs, and side hustlers ready to cash in. go from one-time gigs to long-term income. Learn to set up a profitable, sustainable online business that runs even while you sleep.
Land the job you want. Build a standout resume, ace interviews, and optimize your LinkedIn to attract top employers.
Beyond the core tracks, our SIWES, IT, and NYSC interns are empowered with the kind of real-world experience most people wait years to gain. We equip you with high-demand workplace skills, entrepreneurial know-how. Whether you’re pitching an idea, leading a team, or building something of your own from the ground up, we’ll equip you with the tools, strategies, and drive to lead, earn, and grow.
Meet Your Instructors & Mentors
To deliver excellent training, we work with the very best talents.
Testimonials
99% of our previous students rated us 5 stars.
Don’t take our word, just read what some of them have to say.
Frequently Asked Questions
Yes. We’re happy to work with you on a payment plan. If you’d like to speak with a member of staff about possible payment options, you may reach us at 07030163486 via WhatsApp.
- Communication and Presentation Skills.
- Identifying data uses in everyday life and business.
- Data Gathering and Exploration
- Organizing data for data analysis.
- Problem Definition and Solving
- Step-by-Step process of Data Analysis
- We designed this training for those seeking the practical skills in Excel to perform data analysis and visualization.
- Professionals who need to upskill their skills in data analysis and visualisation.
- Anyone aspiring to become a Professional Data Analyst
- Business Owners who want to make sense of their business numbers.
- Business Consultant and Coach.
People prefer SkillBoost over others because our trainings are:
- Experts Led: Some of our trainers and Mentors work with some of the biggest Tech Companies in the World (Google, Facebook, etc)
- Projects-Based Training: We build our students confidence with in-depth live projects.
- Job Recommendation: We connect our students to top employers within and outside Nigeria.
- We offer FREE Career Guidance and mentoring.
- FREE Access to Support & Jobs Community.
- Recognized Certificate: Our certificates are recognized globally.
- Flexible Timing (In-Class, Online & Weekend).
- Flexible Payment Plan
Yes. it is recommended you come with your own laptop as it will help you to practice whatever you are learning easily. However, we provide laptop that can be used only within our premises if need be.
Generally, Microsoft Excel and Power Bi are the most-widely used data analysis tool of all the hundreds of data analysis tools in the world. There are hundreds roles available on job websites and other platforms in need of a Data Analyst. We will should you how to get hundreds of these jobs.
Our I.T classes are on a rolling basis. It’s not like schools when you can only start in September or January. Call us on 07030163486 and we will fill you in on all the details.
© 2023 SkillBoost Limited
