Description.
ObjectiveIn this exercise, you’ll practice cleaning a customer dataset in Power BI Power Query by:Splitting full names into first and last names.Removing bad or incomplete records (e.g., missing emails, nulls,…
Weekend Mini Project: Sales Insights ExplorerObjectiveUse SQL and Power BI to answer three key business questions from your sales dataset:Who are the top 5 customers by total sales?Which product category…
Exercise: Find customers who ordered more than the average order value.Steps to follow:Identify the relevant tables — You’ll likely need Orders and maybe Customers.Find the average order value — This…
Exercise Peek:Goal: List each customer with their total number of orders.🪜 Hint Steps (Partial)🥇 Step 1: Identify your tablesYou’ll need at least two tables:One with customer information (e.g., Customers)One with…
Steps to follow:Identify the relevant table(s) — you’ll likely need the one that contains customer, country, and sales (amount or order value).Decide what to group by —To find total sales…
Exercise Peek:Goal:Find products costing between $50 and $200.Get the top 10 orders by price.🪜 Step-by-Step Hints (Partial)🥇 Step 1: Identify the right tableLook for a table that contains product price…
Guided Exercise:🧾 “Get all customers from Kenya”🧾 “Get all orders after 2024”Step 1: Understand the ExerciseYou’re working with two tables:Customers — stores customer information.Orders — stores customer purchase details.You’ll write…
Make a program that says your best friend’s name and their favorite game.Use f-strings to write:"My school is {school_name} and it has {number_of_students} students."Write a program that shows the price…
Modify the calculator to also do modulus (%) (remainder).Add a power operator (**) to calculate exponents.Create a Kenyan version:Ask for the price of milk and bread.Use the calculator to add…
Use this example to come up with your own Shopping Basket.The Task is to:Change the name to yours.Add a new item to the basket.Change the shop status to False.Print everything…