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
  • Authorship
  • Software Versions

Was this helpful?

Document Notes

Last Updated: 2016-09-08 (BM)

Authorship

Editor: B Marshall

Authors: D Baskaran, R Campbell, M Copps, C Fillion, M Kenney, B Marshall, E No

Contributors: T Day, O Della Casa, D Kandeil, L Laver, J Lee, R Smith, T Wintle, N Voirin

Infrastructure: W Ingram, L Mariano, J Szepietowski, A Triantafillou

Acknowledgements: P Gracey, B Scott Knight

Software Versions

Excel: Microsoft Office Professional Plus 2013

Tableau: Desktop9.2.2 (64-bit)

Alteryx: Designer 10.0.9.58949 (64-bit)

OrgVue: orgvue2.concentra.co.uk/2.22.70 (also orgvue and orgvuedemo environments)

tSQL: Transact-SQL for SQL Server 2012

Python: Python 3.5.1 (with package distribution Anaconda 2.5.0)

PreviousHow to Use this BookNextAuthors' Thanks

Last updated 5 years ago

Was this helpful?