Problem Statements
1.Super store data set
Beginner-Friendly Questions
(Each question can be turned into a Power BI visual)
Beginner-Friendly Questions
(Each question can be turned into a Power BI visual)
1. Sales Overview
● Card → What is the total sales for the entire dataset?
● Line chart → In which month did sales reach their highest value?
2. Category Insights
● Treemap → Within the top-selling category, which subcategory generated the
most sales?
3. Regional View
● Map → Which region recorded the highest sales amount?
● Clustered bar chart → How do sales and profit compare across different regions?
4. Customer Analysis
● Table → Who are the top 5 customers ranked by total sales?
5. Order Trends
● Line chart → How have sales values changed month-by-month over the dataset
period?
6. Profitability
● Column chart → Which product category has the highest total profit?
7. Shipping Insights
● Pie chart → Which shipping mode is used most frequently?
● Bar chart → How does each shipping mode compare in terms of average delivery
day
2-Edu-Data
1. Cards
● Display the total number of students in the dataset.
● Show the highest obtained marks in training.
● Show the total number of trainings completed by all students.
2. Donut / Pie Charts
● Create a donut chart showing percentage distribution of students by gender.
● Make a pie chart showing the share of students by educational background.
● Show the distribution of students by department.
3. Bar Charts
● Create a bar chart showing number of students per city.
● Display a bar chart comparing number of students in each training program.
● Show number of students by performance grade.
4. Column Charts
● Build a column chart showing total obtained marks by department.
● Compare obtained marks for male vs female students.
● Show number of trainings completed by each city.
5. Tree Map
● Create a tree map showing student count by department and city.
● Create a tree map of obtained marks by training type.
6. Map
● Plot students on a map by city location.
● Create a map showing total obtained marks by city.
7. Slicers
● Add a slicer for gender to filter all visuals.
● Add a slicer for department so users can filter the charts.
● Add a slicer for training program to view performance for specific programs.
8. Line Chart
● Create a line chart showing trend of obtained marks across training dates.
● Show number of students joining each month.
9. Table with Sorting
● Create a table with Student Name, Department, Obtained Marks and allow sorting
by marks.
● Create a table showing Student Name, City, Trainings Completed sorted by city
name.
3-Aero-tech data
(airplane_database_v1.0)
1. Cards
● Show the total number of aircraft in the dataset (name count).
● Display the highest maximum speed (max_speed).
● Show the largest passenger capacity (n_pax).
2. Donut / Pie Charts
● Show the percentage of aircraft by airplane_type (e.g., general, regional).
● Show the distribution of aircraft by engine_type.
● Show the share of aircraft by energy_type.
3. Bar Charts
● Show the number of aircraft by n_engine (number of engines).
● Compare aircraft counts by thruster_type.
● Show the count of aircraft by year of manufacture.
4. Column Charts
● Display total passenger capacity by airplane_type.
● Compare max speeds for different engine_type categories.
● Show the total nominal range by airplane_type.
5. Tree Map
● Aircraft count by airplane_type and engine_type.
● Passenger capacity by engine_type.
7. Slicers
● Filter by airplane_type.
● Filter by engine_type.
● Filter by year.
8. Line Chart
● Show the trend of aircraft production over year.
● Show total passenger capacity by year.
9. Table with Sorting
● Table: name, airplane_type, max_speed, n_pax — sorted by max_speed (highest
first).
● Table: name, engine_type, nominal_range — sorted by nominal_range.
4.Sports-tech data (athlete_events_200)
1. Cards
● Show the total number of athletes in the dataset (Name count).
● Display the total number of Gold medals.
● Show the number of unique sports represented.
2. Donut / Pie Charts
● Show the percentage of athletes by Sex (Male/Female).
● Show the share of medals by Medal type (Gold, Silver, Bronze).
● Show the distribution of athletes by Season (Summer/Winter).
3. Bar Charts
● Show the number of athletes by Sport.
● Display the number of medals won by Team (country).
● Show the number of athletes per Year.
4. Column Charts
● Compare number of athletes for each City (Games location).
● Show the number of medals by Sport.
● Compare medals by Sex for each sport.
5. Tree Map
● Athlete count by Sport and Team.
● Medal count by Sport and Medal type.
6. Map
● Plot athlete participation by NOC (National Olympic Committee — country code).
● Map showing number of medals by country.
7. Slicers
● Filter by Year.
● Filter by Season.
● Filter by Sport.
8. Line Chart
● Show the trend of athlete participation over the years.
● Show the number of medals over time.
9. Table with Sorting
● Table: Name, Team, Sport, Medal — sorted by Team.
● Table: Name, Year, City, Medal — sorted by Year.
5.Bio tech data
(healthcare_dataset)
1. Cards
● Show the total number of patients (Name count).
● Show the total billing amount.
● Show the number of unique hospitals.
2. Donut / Pie Charts
● Percentage of patients by Gender.
● Distribution of patients by Blood Type.
● Share of patients by Admission Type (Urgent, Emergency, Elective).
3. Bar Charts
● Number of patients by Medical Condition.
● Number of patients by Insurance Provider.
● Number of patients by Medication.
4. Column Charts
● Compare billing amounts by Medical Condition.
● Compare number of patients by Hospital.
● Compare patients by Doctor.
5. Tree Map
● Patient count by Hospital and Medical Condition.
● Billing amount by Insurance Provider.
6. Map (if hospital location data is available)
● If you have hospital addresses or city info, plot patients by location.
7. Slicers
● Filter by Gender.
● Filter by Medical Condition.
● Filter by Admission Type.
● Filter by Insurance Provider.
8. Line Chart
● Show trend of patient admissions over time (Date of Admission).
● Show billing amount trend over time.
9. Table with Sorting
● Table: Name, Age, Gender, Medical Condition, Billing Amount — sorted by Billing
Amount.
● Table: Name, Hospital, Doctor, Admission Type, Date of Admission — sorted by Date of
Admission.
6-Supply-chain management data (SCM Dataset_Updated)
1. Cards
● Total number of companies in the dataset.
● Total supplier count.
● Total Implementation Cost (sum of all companies).
2. Donut / Pie Charts
● Percentage share of companies by SCM Practices.
● Distribution of Supply Chain Agility levels (High, Medium, Low).
● Sustainability Practices distribution.
3. Bar Charts
● Supplier Count by Company Name.
● Customer Satisfaction (%) by Company Name.
● Lead Time (days) by Company Name.
4. Column Charts
● Order Fulfillment Rate (%) by Company Name.
● Operational Efficiency Score by Company Name.
● Supply Chain Risk (%) by Company Name.
5. Tree Map
● Supplier Count by Company and SCM Practice.
● Total Implementation Cost by Company Name.
6. Map
● If company headquarters location data is available, plot companies on a world map with
supplier counts.
7. Slicers
● Filter by SCM Practices.
● Filter by Supply Chain Agility.
● Filter by Sustainability Practices.
8. Line Chart
● Lead Time (days) compared to Order Fulfillment Rate (%) by Company.
● Revenue Growth Rate out of (15) compared to Supply Chain Risk (%) by Company.
9. Table with Sorting
● Table: Company Name, SCM Practices, Supplier Count, Lead Time (days), Order
Fulfillment Rate (%) — sorted by Supplier Count (highest first).
● Table: Company Name, Operational Efficiency Score, Revenue Growth Rate out of (15),
Supply Chain Risk (%) — sorted by Revenue Growth Rate (highest first).
●
