Data Analysis Resources – cw.is

Menu

Chris Whitlock

Menu

Home

This is a developing list of data resources I find useful and hopefully you do too. Suggest a link via @datajumps

Datasets

OpenODS – NHS Organisation API
Pubmed Central Open Access Subset

NHS

Gov UK Health Data
NHS Data Dictionary
NHS Digital
NHS England Datasets
NHS Website
NHSX Dashboards & Datasets
OpenODS – NHS Organisation API

Excel

Excel Functions List
Fuzzy Lookup Add-In for Excel
How to Switch from Excel to SQL
Power Query
You Suck at Excel

Misc Analysis

Presentation Tips
Requirement Gathering Techniques
The Data Visualisation Catalogue

PowerBI

15 Power BI tips
7 reasons to use Microsoft Power BI
DAX Guide
Introduction to DAX
Power Query

Qlikview

Qlik Community
Qlik Developer
Qlikview Help

R

Big Book of R
NHS R Community
R Bloggers
R Project
R Seek

SQL

How to Switch from Excel to SQL
SQL in 10 mins
The SQL Crash Course