> For the complete documentation index, see [llms.txt](https://concentra-analytics.gitbook.io/working-with-data/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://concentra-analytics.gitbook.io/working-with-data/master.md).

# Introduction

## Aim of this book

In this book, we provide guidance on how to write 30 or so common calculations in each of the following tools: **Excel**, **Tableau**, **Alteryx**, **OrgVue**, **tSQL**, **Python**.

The audience is analysts, consultants and data scientists who may be familiar with one or more of the tools listed. You will hopefully find it useful if you want to:

* Get an introduction to the key calculations you should master as a regular user of data
* Refresh your memory of how to write specific functions
* Translate an expression you know in one tool into the syntax used by another tool

It's written clearly and concisely with explanations of each calculation, model syntax, worked examples and user notes to help explain certain things.

![](/files/-M4uOulMZ_khEKmfiXHb)

Directly informed by our experience in consulting, analytics and technology, we hope this serves as both an induction manual for new analysts and a reference guide for experienced users.

## What do I need to know?

We assume you have some basic knowledge of when to use certain expressions, so although each expression has an example and may contain additional notes, extensive explanations and use cases aren't provided.

We also assume you are roughly aware of basic data types. Below is a quick summary:

| Data Type | Notes                                                                          |
| --------- | ------------------------------------------------------------------------------ |
| Measure   | <p>Integer (incl. various bytes) <br> Decimal (incl. Float, Double, Fixed)</p> |
| Dimension | String (incl. variations e.g. VString, Wstring, Char etc.)                     |
| Temporal  | Date (incl. Time and DateTime)                                                 |
| Bool      | Boolean (True/False)                                                           |
| Image     | Image XML (64bit)                                                              |

NB. Different tools can be more or less strict about handling different data types, and most will let you change types through the UI as well as with a conversion expression.

## Resources

There is a fuller list of support materials in the [Appendix](https://github.com/concentra-analytics/working-with-data/tree/51c414aad5b91e0da2741a07a436476e362ed6ce/appendix/helpful_resources.md), but here are some websites worth checking out:

| Tool        | Online                                                                                                                                                                                                                            | Have a look                                                                                                |
| ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------- |
| **Excel**   |                                                                                                                                                                                                                                   |                                                                                                            |
| **Tableau** | [Website](http://www.tableau.com/), [Forum](https://community.tableau.com/welcome), [Viz-of-the-day](https://public.tableau.com/s/gallery), [Blogs](https://www.concentra.co.uk/blog?search_api_views_fulltext=tableau\&x=0\&y=0) | [2 week free trial](http://get.tableau.com/partner-trial.html?partner=20362)                               |
| **Alteryx** | [Website](http://www.alteryx.com/), [Community](http://community.alteryx.com/), [Macros](https://gallery.alteryx.com/#!)                                                                                                          | [2 week free trial](http://pages.alteryx.com/free-trial.html?partner_lead_src=Website\&partner_id=A119596) |
| **OrgVue**  | [Website](https://www.orgvue.com), [Portal](https://support.orgvue.com/hc/en-us), [Cookbook](https://orgvue.gitbooks.io/gizmocookbook/content/), [Blog](http://blog.orgvue.com/)                                                  | [Get in touch](https://www.orgvue.com/contact)                                                             |
| **tSQL**    |                                                                                                                                                                                                                                   |                                                                                                            |
| **Python**  | [Website](https://www.python.org/)                                                                                                                                                                                                | [Free download](https://www.python.org/downloads/)                                                         |