Working with Data: All the calculations you need t
  • Introduction
  • What is this book?
  • How to Use this Book
  • Document Notes
  • Authors' Thanks
  • Strings
    • Concatenate
    • Split
    • Length
    • Slice
    • Trim
    • Contains
    • Match
    • Replace
    • Upper/Lower Case
  • Numbers
    • Sum
    • Average
    • Roll Ups
    • Round
    • Floor
    • Power
    • Square Root
    • Absolute
  • Dates
    • Date Difference
    • Age
  • Logical
    • Logical Operators
    • If
    • Case / Switch
    • Is Null/Empty
  • General
    • Count
    • Filter
    • Sort
    • Lookup/Join
    • Variables
    • Convert Type
  • Appendix
    • DateTime Parts
    • Helpful Resources
Powered by GitBook
On this page
  • Download Software / Request Trial
  • Sites and Resources by Each Tool
  • Writing Code
  • Data Visualisation

Was this helpful?

  1. Appendix

Helpful Resources

PreviousDateTime Parts

Last updated 5 years ago

Was this helpful?

Download Software / Request Trial

  • Tableau ()

  • Alteryx ()

  • OrgVue ()

  • Python ()

Sites and Resources by Each Tool

Tool

Link(s)

Excel

Tableau

Alteryx

OrgVue

tSQL

Python

Writing Code

  • – an online computer programming environment for writing and testing code

  • W3Schools - for testing SQL on a ready-made data schema

  • – a free platform for learning code interactively, especially useful for and

  • (Regex) – a powerful and commonly used form of syntax for searching for patterns of characters e.g. in search engines.

  • – easily test regular expressions online

  • – list of commonly used HTML tags for formatting (can be used within markdown or OrgVue surveys)

Data Visualisation

- the best place to go to find answers to your Tableau questions - for a variety interesting and good looking dashboards published daily by advanced Tableau users - a variety of content from Concentra's expert Tableau consultants, analysts and trainers

- Alteryx's discussion and KnowledgeBase portal - online gallery of downloadable custom macros and tool palettes - a blog and list of custom macro packages written by Alteryx Guru Adam Riley

- a public guide to OrgVue expressions and their use cases - industry commentary, OD methodology and technical advice from the OrgVue team

(MSDN) - advanced list of tSQL functions

- an introduction to Python & thinking like a computer scientist - a more focused look at using Python for data manipulation

– some Do and Don’t rules of thumb from visualisation expert Stephen Few

– to contrast that, some more “out there” visualisations to get you inspired

2 week free trial
2 week free trial
Get in touch
Free download
repl.it
Tryit Editor
Codecademy
JavaScript
Python
Summary of Regular Expressions
regexr.com
Quick HTML Guide
Perceptual edge
Information is Beautiful
Website
Forum
Viz-of-the-day
Blogs
Website
Community
Macros
Chaos Reigns Within
Website
Portal
Cookbook
Blog
Microsoft Developer Network
Website
Think Python
Python for Data Analysis