A play story to help women achieve work life and family balance, stable children and build the nation.
A gripping, soul-stirring, and unforgettable journey — all between two covers.
A play story to help women achieve work life and family balance, stable children and build the nation.
A gripping, soul-stirring, and unforgettable journey — all between two covers.
It is a new standard for engaging, educating and empowering women from all spheres of life. The evident in the book ‘Women the Time is Now’ promotes the link between balancing work and family life, raising stable children and finally, nation-building.

Pamela is an experienced Human Resource Consultant, Entrepreneur, Leadership Coach, Keynote Speaker and Self-Improvement Author. Driven by a mix of passion to advocate women’s interest and implement nation-building efforts, she takes pride in building human capital through valuable training in order to promote women empowerment and development.
She has built her reputation and credibility as a thought leader through her expertise, insight and valuable perspective in empowering women for successful living.
Pamela is setting a new standard for engaging, educating and empowering women from all spheres of life. This is evident in her new book ‘Women the Time is Now’ which promotes the link between balancing work and family life, raising stable children and finally, nation-building. She is available as a keynote speaker and panellist for conferences, workshops and knowledge sharing platforms.
Pamela graduated with a Bachelor’s Degree in Botany from the University of Calabar, Cross River State in Nigeria. Outside of the office, as a devoted wife to her loving husband, and mother to three amazing daughters, Pamela enjoys spending time with her family.
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:
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
Advanced Logical Functions
ACTIVITIES:
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:
What you’ll learn
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
PRESENTATION
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:
ACTIVITIES
Data Cleaning and Transformation
ACTIVITIES
Data Modeling
ACTIVITIES
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:
Recommend which products or categories should be prioritized based on sales performance and customer demand.
ACTIVITIES
DAX Formulars
ACTIVITIES
Dashboard Creation
ACTIVITIES
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.
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.
© 2024 SkillBoost Limited
After payment, send a WhatsApp message to 08028973599
After payment, send a WhatsApp message to 08028973599
After payment, send a WhatsApp message to 08028973599
After payment, Send Your Receipt The WhatsApp Number 08028973599