BW #28: Pret a Manger (solution)
Get practice with Excel files, dates and times, window functions, and filtering
Window functions perform aggregate operations across either a growing number of rows or a "sliding window" of rows.
Get practice with Excel files, dates and times, window functions, and filtering
Get practice with Excel files, dates and times, window functions, and filtering
Get practice with CSV files, pivot tables, window functions, and plotting
Get practice with CSV files, pivot tables, window functions, and plotting
Get practice working with Excel, dates and times, multiple files, window functions, plotting
Get practice working with Excel, dates and times, multiple files, window functions, plotting
Get better at: Excel files, cleaning data, dates and times, string operations, sorting, grouping, window functions
Get better at: Excel files, cleaning data, dates and times, string operations, sorting, grouping, window functions
Get practice working with Excel files, cleaning data, formatting, window functions, and strings.
Get practice working with Excel files, cleaning data, formatting, window functions, and strings.
Get practice working with Excel files, datetime data, pivot tables, grouping, and window functions.
Get practice working with Excel files, datetime data, pivot tables, grouping, and window functions.