Git Product home page Git Product logo

clarelgibson / england-school-admissions Goto Github PK

View Code? Open in Web Editor NEW
1.0 1.0 0.0 15.99 MB

An interactive dashboard helping parents in England understand the primary and secondary school admissions process.

License: Creative Commons Zero v1.0 Universal

R 100.00%
dashboard data-visualization england primary-school r school school-admissions secondary-school tableau tableau-public tidyverse uk united-kingdom

england-school-admissions's Introduction

My desktop

For as long as I can remember I have had a love of numbers and words. As a kid I would while away long journeys with a book of logic puzzles or hanjie. I spent many a rainy afternoon on caravan holidays playing Boggle with my Mum. At Sixth Form I added A-Level Further Maths and GCSE Italian to my set of qualifications via evening courses. Yes, I am that geek!

When it came to university, I chose the path of words over numbers, graduating with First Class Honours in Interpreting & Translating (French and Russian) from Heriot-Watt University in Edinburgh. I had ambitions to be a conference interpreter in Brussels or Geneva, but in the end a special person meant that Edinburgh would remain my home for a while longer. With a vibrant life sciences sector in the central belt of Scotland I pivoted into a career in clinical research, bringing my passion for words and numbers into roles as diverse as Contract and Budget Negotiation, Proposal Writing, Clinical Trial Intelligence and Feasibility, Commercial Insights and Trial Diversity Analytics. As I enter my 18th year in the industry, delivering valuable data products to business analysts and decision makers has become my passion.

My approach to data analytics is a lot like my approach to translating a document from French into English. Early in my career I realised that data was another language; one that I could translate into insights that decision makers could act on. I needed the help of some tools like R, SQL, Power BI and Tableau to manage the process of translation, and so began my journey of learning and practising the art of data translation.

england-school-admissions's People

Contributors

clarelgibson avatar

Stargazers

 avatar  avatar

Watchers

 avatar

england-school-admissions's Issues

Not displaying properly in Chrome

Looks good but not displaying properly in Chrome (latest ver) - there's a white panel obscuring the right third of the dashboard, from top to bottom.

-Feedback provided by u/dr_rainbow on Reddit.

bug

Fix missing LA Keys in School Year facts

Some of the la_key values are missing in the fct_school_year table. This is because the offers df does not contain the right local authority data. Need to use offers_la as the basis. offers_la needs to be modified to retain the URNs and years as well so that the rest of the offers data can be joined back in.

Add in LA-level facts

It can be hard to determine the local authority level facts for things like number of applications from the school level data. It would be better to use the LA-level data from the source data. I would also like to put all facts into a single table for use in Tableau.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.