Pauline Cairns – Data Analyst

Contact me - Let's talk!

Freelance

Analysing data to gain more insights and streamline processes

Learn

Helpful tips for Power BI and RStudio via my YouTube channel and Blog

Pauline Cairns - Data Analyst - Data For Knowledge

Follow on LinkedIn

Freelance

Moving and Cleaning Data

Moving data from one location to another

Monitoring the status of a matter

Spotting anomalies in financial reports

Monitor results against KPIs

Comparing items - how a data analyst may help you

Compare budget to actual costs

Compare costs across different finance systems

Data analysis can aid with providing transparency on a matter

show status of repairs to properties

Case Studies

Energy performance metrics tracked using Power BI

Retrofit - tracking metrics

Using Power Bi to monitor a project’s progress and quantifying energy savings achieved.

A data analyst can help move data from an old database to a new database

Clean, map, transfer data

Moving data from an legacy system to a new more efficient, reliable and faster system.

A data analyst can help move data from an old database to a new database

Tracking inspections status

Tracking both the status of inspections carried out and invoiced raised for the work undertaken.

Data cleanse for embedding new system

Data cleanse new system

Regular data cleansing of new system spots anomalies early

Qualifications and skills

MSc IT with Business Intelligence (Distinction) from Robert Gordon University, Aberdeen, Scotland, UK.

Pauline Cairns - Microsoft Certified Data Analyst

Microsoft Certified: Power BI Data Analyst Associate

Tool - Power BI

Tools used include R Shiny

Software languages used

Software language DAX

Languages used include SQL

Learn – YouTube and Data Topics

Data For Knowledge on YouTube

Power BI

A tool for analysing and visualising data. Follow along projects and helpful tips provided. See how easy this tool can be to use.

Ship direction of travel created in R shiny app

RStudio and R

Using the R programming language insider RStudio you can manipulate, clean and graphically display data in apps, in documents and on web pages.

Let's chat!

Pin It on Pinterest