Data Analytics

You are a data analyst in the Finance team. The star * means "everything". We ask the computer to show every row of payments.

You are a data analyst in the Finance team. Instead of everything, we only want the region column.

You are a data analyst in the Finance team. A comma joins two column names, like 'apples, pears'.

You are a data analyst in the Finance team. WHERE is a filter. It keeps only the rows where region is 'North'.

You are a data analyst in the Finance team. The > sign means "bigger than". We keep rows where amount is bigger than 300.

You are a data analyst. You have joined the claims analytics team at a short-term insurer. The regional manager for North suspects a spike in large motor claims and wants the list before the 10:00 review.

You are a data analyst in the Finance team. ORDER BY sorts rows. DESC means start with the biggest.

You are a data analyst in the Finance team. COUNT(*) counts how many rows there are, like counting sweets in a jar.

You are a data analyst in the Finance team. SUM adds all the numbers in amount together.

You are a data analyst in the Finance team. AVG gives the middle-ish value: add everything, then share equally.

You are a data analyst in the Finance team. GROUP BY puts rows into piles by region, then COUNT counts each pile.

You are a data analyst in the Finance team, working with payments data. plt.bar draws one bar per group, so you can compare sizes by eye.

You are a data analyst in the Finance team, working with payments data. plt.plot joins the points with a line — good for showing change.

You are a data analyst in the Finance team, working with payments data. sns.barplot groups and averages for you in one line.

You are a data analyst in the Finance team, working with payments data. groupby puts matching rows together, sum adds each group.

You are a data analyst in the Finance team, working with payments data. A histogram shows how values are spread out.

You are a data analyst in the Finance team. DISTINCT removes repeats, so every region appears only one time.

You are a data analyst in the Finance team. LIMIT stops after a few rows — handy for a 'top 2' list.

You are a data analyst in the Finance team. MIN finds the smallest number, MAX the biggest.

You are a data analyst in the Finance team. AS renames a result column so reports are easy to read.

You are a data analyst in the Finance team. IN checks if a value is in a short list — like a guest list.

You are a data analyst in the Finance team. BETWEEN keeps numbers inside a range, including both ends.

You are a data analyst in the Finance team. LIKE searches text. % means 'anything after this'.

You are a data analyst in the Finance team. HAVING filters groups AFTER GROUP BY. WHERE filters rows before.

You are a data analyst in the Finance team. CASE WHEN makes a new label column — an 'if this, then that' rule.

You are a data analyst in the Finance team. RANK() OVER gives every row a place number without hiding any rows.

You are a data analyst in the Finance team, working with payments data. A box plot shows the middle, the spread and odd values.

You are a data analyst in the Finance team, working with payments data. plt.subplots makes several small charts in one picture.

You are a data analyst in the Finance team, working with payments data. Share = group total ÷ grand total × 100.

You are a data analyst in the Finance team, working with payments data. A pivot table turns rows into a grid; a heatmap colours it.

You are a data analyst in the Finance team, working with payments data. savefig writes the chart to an image file you can share.