Assignment 2
Reading:Study industry benchmarks for social media analytics and reporting from HubSpot. Research:Compare pricing structures of leading social media marketing agencies across different regions. Hands-on Assignment: You have been hired by a startup named “NovaTech Solutions” to manage its social media presence. Develop a comprehensive client readiness portfolio including KPI selection, a monthly report template, an […]
Class Activity 2
Create a professional monthly social media report, define KPIs, prepare a client onboarding checklist, and design a three-tier pricing model for a hypothetical brand.
Assignments 2
Reading Assignment Read about the importance of data preparation in analytics and how it improves decision-making accuracy. Research Assignment Research how companies use conditional formatting and filtering in dashboards and reporting systems. Hands-on Assignment A retail chain operating across multiple cities in Nigeria wants to analyze its regional performance. The dataset includes city, product category, […]
Class Activity 2
A company has provided a cleaned dataset containing: Customer NameCityProductSales Amount Students should: Sort the dataset by sales amount Filter data for a specific city Apply conditional formatting to highlight high sales Use data validation to control product entries
Assignments 1
Reading Assignment Read about the importance of data cleaning in business intelligence and how poor data quality affects decision-making. Research Assignment Research different data cleaning techniques used in large organizations and compare them with Excel-based cleaning methods. Hands-on Assignment A financial company discovered inconsistencies in its transaction dataset, including duplicate transactions, missing amounts, and incorrectly […]
Class Activity 1
A company has provided a messy dataset containing customer names, phone numbers, sales values, and dates. Students should: Identify missing values Remove duplicates Split combined columns Use Flash Fill to extract patterns Format all data correctly
Assignments 1
Reading Assignment Explain how incorrect task sequencing can cause major delays in project execution. Research Assignment Research a major technology or infrastructure project and analyze how task dependencies influenced its schedule and execution strategy. Hands-on Assignment (Real-Life Case) A logistics technology company is launching a smart delivery management platform that will allow businesses […]
Class Activity 1
Students analyze a real-world project scenario and perform the following: Identify at least ten project activities• Arrange tasks in logical sequence• Identify predecessor and successor tasks• Determine dependency types between tasks• Draw a basic project network diagram