Categories: Practice Datasets
Tags:

Solar Panel Sales Dataset (2024–2025) for Data Analytics Practice

For Power BI and DAX Practice

📘 Dataset Column Descriptions:

Column NameDescription
Sale DateThe date when the solar panel sale occurred (spanning 2024 and 2025).
Panel TypeType of solar panel sold — either Monocrystalline or Polycrystalline.
SegmentCustomer segment — Residential Load or Commercial Load.
Wattage (W)Power output rating of the panel in watts (e.g., 300W, 450W).
Efficiency (%)The efficiency percentage, representing the conversion of sunlight to electricity.
Voltage at Max Power (Vmp)Voltage when the panel produces its maximum power.
Current at Max Power (Imp)Current at which the panel delivers its maximum power output.
Open Circuit Voltage (Voc)Voltage across the panel when there is no load (circuit is open).
Short Circuit Current (Isc)Current when the output terminals of the panel are shorted.

Get the Dataset Here : https://www.kaggle.com/datasets/slidescope/electrical-bazaronweb-com-solar-panels-sales

⚡ DAX Questions for Solar Panel Sales Dataset

1. YTD Sales Calculation

Question: Calculate the total solar panel wattage sold Year-to-Date (YTD) for each year.

Concept: Use TOTALYTD

2. Panel Type Sales Comparison

Question: For each panel type, calculate the difference in wattage sold compared to the previous month.

Concept: Use PARALLELPERIOD or DATEADD

3. First Sale Date of Each Panel Type

Question: Find the first date when each panel type was sold.

Concept: Use FIRSTDATE, CALCULATE, and FILTER

4. % Contribution of Each Segment

Question: Calculate the percentage of total wattage contributed by each segment (Residential or Commercial) for the year 2025.

Concept: Use DIVIDE, CALCULATE, and ALL

5. Top 3 Efficient Panels

Question: Create a measure to rank panel sales by their efficiency and display only the top 3 most efficient panels.

Concept: Use RANKX, TOPN

6. Running Total of Sales (Cumulative Wattage)

Question: Create a measure that gives a cumulative total of wattage sold over time.

Concept: Use DATESYTD, CALCULATE

7. Dynamic Title with Selected Year

Question: Create a measure that shows a title like:
"Sales Summary for the Year 2024"
based on the year selected in the slicer.

Concept: Use SELECTEDVALUE, CONCATENATE, or FORMAT

8. Check if Sale is in Summer

Question: Create a column that shows "Summer" or "Winter" based on the sale month.

Concept: Use SWITCH or IF with MONTH

9. Count of Unique Panel Configurations

Question: How many distinct combinations of Wattage and Panel Type were sold?

Concept: Use DISTINCTCOUNT, SUMMARIZE, COUNTROWS

10. Latest Sale Date for Each Segment

Question: What is the latest sale date recorded for each segment?

Concept: Use LASTDATE, CALCULATE, FILTER

Solutions are Given Here: