Data Analysis: I've probably got a spreadsheet for that
Here you can access live examples of how I can import, transform and visualise data using Google Sheets.Portfolio of 100+ Google Sheets - A Google Drive folder listing practical and creative uses of my function/formula knowledge. Click on an example to open up a sheet and review in your browserWales 6N Rugby App - Disappointed by the lack of a decent Welsh-focused app for the 2020 Six Nations rugby tournament, I made my own using the Glide platform, powered by data held in Google Sheets. It got a bit out of hand with the amount of data I ended up crunching! Gave it a miss for 2021Below are examples of automated dashboards and analytical tools I've published online from Google Sheets. COVID-19 UK Vaccination progress dashboard - Imports GOV.UK data at c.5:00 PM BST each day and utilises the SEQUENCE function to visualise progress made between those receiving just one jab of the vaccine compared to those fully-vaccinated as a % of total UK population COVID-19 UK Daily Cases & Deaths - An all too topical example of publicly available data being imported into Sheets with a scheduled Apps Script, parsed with QUERY & used to power a fully-automated dashboard. Updates c.8:30 AM BST, daily Citymapper Mobility Index for London - Dashboard uses data from an imported Citymapper CSV file and visualises the impact the pandemic has had upon travel in London. Key lockdown milestones indicated. Updates c.9:00 AM BST, daily Google Finance chart with dynamic labels - This chart of the GBP to USD exchange rate for a rolling 13-week period, illustrates how employing dynamic labels can help provide insights on the chart's data RATP Dev London Bus Route Analysis - An example of how live website content can be analysed in real timeUS Presidents Age Analysis - Wikipedia data imported, analysed and charted for the ages of the 46 Presidents of the United States upon first assuming office UK General Election 2019 - This re-models and visualises live data imported from a publicly shared Google Sheet illustrating the MPs that stood down in that year's electionCurrent UK Parliamentary seats by party - This live chart is built from a CSV imported directly from the UK Parliament's websiteSheets v Excel - Which one has the most functions? Well, there's only one way to find out. Make a live dashboard using IMPORTHTML, QUERY & INDEX to find the winner!!Dynamic analysis of current month - An example of the kind of dynamic date analysis that can be easily built into business planning dashboards. Extending this approach further, this dynamic schedule, details first work day, total work days and bank holidays per month5 years of Todoist - Combining data from each of the 'your year in review,' summaries Todoist has issued since 2016, Sheets helped me gain some further insights on my usage of this excellent task management applicationGoogle map of Welsh SIMM summit peaks - Built from both online data and the what3words APIPDF Data Extraction - An example of how data held within PDFs can be extracted as CSV files for use in spreadsheets using TabulaRugby Union - Wales v England - All results from 2000 analysed - References live Wikipedia data and updates its insights automatically whenever the base data gets edited RWC 2019 pool stage analysis - Transforms Wikipedia data to deliver insights on the pool stage of the Rugby World Cup held in Japan Six Nations - England v Wales - Analysis of the 22 halves of rugby played between the two in the Six Nations at HQ Six Nations - France v Wales - A more conventional dashboard, this time for Wales in Paris, illustrating the types of analysis & data visulaisation that can be achieved with Google Sheets Six Nations - Wales Win/Loss analysis - A creative use of Sparklines to visualise Wales' performance over the full 22 years of the Six Nations tournament, up to and including its most recent match Wales World Rugby ranking at start of 6N - This charts and analyses the World Rugby ranking for Wales at the start of each Six Nations tournament, going back to 2004 when rankings were first available Wales World Rugby rankings analysis (live) - Tracks Wales' position and movements in the World Rugby rankings for every week since 2014. Pulls data via the API and auto-updates each Monday, c.1:00 PM BST
- Todoist Google Sheets
- Todoist App Store
Todoist Google Sheets
Complete Guide to Resolve 50% Off Alternative: Introduction to Wunderlist - Tutorial for Beginners ht.
Todoist App Store
Here’s how I use Mint, Todoist and Google Sheets to track and analyze my expenses each month in order to budget how much I put into savings. Written by Adam on October 9, 2016 2016-10-09. Updated February 11, 2021. 🏆 2020 Editor's Choice by Google 🥇 'Todoist is the best to-do list app right now' - The Verge Todoist is used by 20 million people to organize, plan and collaborate on projects, both big and small. Use Todoist to:. Capture and organize tasks the moment they pop into your head.