• Mark O'Gara
  • Work
  • CV
Data analyst, coder & visualization designer using R, Python, Tableau, d3.js & Git.

1. Customer mapping (2018)

Visualizations exploring customer distribution. Data assembly & cleaning in R; mapping in kepler.gl

Sales trend by sector

1a. kepler.gl map

Margin analysis by sector

1b. kepler.gl map

Annual sales change

1c. kepler.gl map

2. Point of sales analytics (2016)

Visualizations analyzing POS data from a B2C retailer. Data assembly & cleaning in R; mapping with custom parameter calculations in Tableau.

Sales trend by sector

2a. Distribution gap analysis

Margin analysis by sector

2b. Variance vs. expected sales

Annual sales change

2c. Actual sales vs. target

3. Petrol forecourt pricing in Ireland (2016)

Analysis of oil (€/barrel) & petrol (€/per litre) prices from 1985—2016. Oil data from Eurostat; petrol data from theaa.ie; visualizations in Tableau.

Oil v. Petrol 1985—2013

3a. Oil vs. Unleaded (1985—2013) r² = 0.96

Oil v. Petrol 2014—2016

3b. Oil vs. Unleaded (2014—2016) r² = 0.88

Oil v. Petrol 1985—2016 (Detail)

3c. Oil vs. Unleaded (1985—2016) Detail

4. Milk constituent analysis (2015)

Visualizations examining correlations between milk constituents. Data assembly, cleaning & analysis in R; visualizations in Tibco Spotfire.

Sales trend by sector

4a. Var1 vs. Var2

Margin analysis by sector

4b. Var3 vs. Var2

Annual sales change

4c. Var3 vs. Var4

5. Product portfolio analysis (2015)

Visualizations analyzing SKU performance across a range of clusters. Data assembly, cleaning & analysis in R; visualizations in Tableau.

Sales trend by sector

5a. Cluster volume analysis (by SKU)

Margin analysis by sector

5b. Margin analysis (by cluster)

Annual sales change

5c. Sales change (by cluster)

6. OEE — Overall equipment effectiveness analysis (2014)

Visualizations analyzing OEE by machine at one plant over 12 months. Data assembly, cleaning & analysis in R; visualizations in Tableau.

OEE Analysis

6a. Hours (available vs. running)

OEE Analysis

6b. Output (total vs. hourly)

OEE Analysis

6c. OEE by machine (A.M. shift)

7. Links (etc.)