Assignments

Final Project: Building a Complete Sales Insights Data Story🎯 Project OverviewYou’ll work with a Sales dataset containing information about customers, products, orders, and sales transactions.Your task is to:Extract insights using…

Example:Ask for a product (like “maize bags”) and show how much total cost changes for each quantity. item = input("Enter the product name: ")price = int(input("Enter the price of one item:…

 Create a program that calculates the total price of items bought at a market.💡 Example:The program should ask for 5 prices (like sukuma wiki, tomatoes, onions, etc.)Add them all together…

🧠 Try This ChallengeMake your own version of the game!Pick a different secret number (like 7 or 9).Change the messages to make it fun or local (e.g., “Try again, champ…

Exercise: Import Sales Dataset and View Data ModelObjective:In this exercise, you’ll learn how to import data from an external source (like Excel or CSV) into Power BI Desktop and explore…

🚌💡 Student Challenge: Matatu Fare Checker🧠 Your MissionYou’re going to help people decide if they can take a matatu to town — just by using Python!The matatu fare is 100…

Submit a link of this:Add another input like “favorite color” or “weather.”Add choices that change the ending (use if statements).Make the story longer or more dramatic!

Exercise: Build a Sales Performance DashboardObjective:You’ll create a complete Sales Performance Dashboard in Power BI that brings together key business metrics like total revenue, top products, and customer trends. This…

Analyzing Sales Performance with DAX MeasuresObjectiveBy the end of this exercise, students should be able to:Create key business performance metrics using DAX.Understand how DAX measures respond to filters and visuals.Visualize…

Exercise GoalBy the end of this activity, you’ll:Visualize total sales by region using a chartAdd a slicer to filter data by year interactively🪜 Step-by-Step GuideStep 1: Open your Power BI…