DataBrighten

    Data practice exercises

    Six exercises for Excel, SQL, Power BI and pandas. Each one uses a file from this site, and every answer was computed twice, in SQL and in Python, and the two had to match.

    Excel

    Excel PivotTable practice

    Build PivotTables from 1,000 order lines and check your totals against ours.

    5 questionssample sales data
    Excel

    Excel formula practice

    Conditional sums, counts, averages and lookups on real-looking business tables, with the formulas.

    11 questionssample employee data
    SQL

    SQL practice questions with answers

    GROUP BY, JOIN, LEFT JOIN and filters on a four-table store database.

    8 questionssample sql database
    Power BI

    Power BI dashboard practice

    Build a one-page sales report: cards, a region bar chart, a margin table and a monthly trend.

    4 questionssample sales data
    Python

    pandas practice with real datasets

    groupby, idxmax and sorting on real 2024 weather and on sales orders, with code you can run.

    6 questionsdaily weather data, 2024
    Python

    Data cleaning practice dataset

    Find and fix duplicates, blanks, mixed date formats and text in number columns.

    8 questionsmessy data for cleaning practice