The Power of Data at Your Fingertips

Tableau Partner

We have extensive experience and can support your organisation to fulfil its goals by utilising one of its biggest assets

Arrow
Arrow
Slider

About Us

Cloudstream Partners are a team of data specialist who are passionate about helping people use data simply and effectively. We are believers in making data and analytics simple, and are proud partners of both Tableau Software and Alteryx, which truly help bring data to life. We have several years of analytics and business intelligence experience, and are both Tableau Qualified Associates and Alteryx Certified.

Our portfolio of clients covers healthcare, insurance, food, finance, banking, sport and more – so no matter which sector you are in or where you are in your journey towards data enlightenment, we can support you.

Find out more

 

Tableau Training Courses

Tableau is a simple product to learn and pick up, but some focussed training will always help to ensure a successful deployment of the tool. We are a unique Tableau Partner such that all our training courses are designed specifically for our clients.

We sit down with our clients, understand where they are in their Tableau journey and design a course to fit their needs, this will include using your data! Whether it’s on site, or at our training facilities you are guaranteed to benefit from our training sessions.

 

Fundamentals

 

Advanced

 

Data Visualisation

Alteryx Training Courses

Looking to make the most of your data, but struggling with messy and disparate data sources? With our Alteryx training course you can learn how to bring all your data together, and prepare all your analytics in simple, easy to create workflows.

Like all our training, our Alteryx courses are specifically designed for you and customised to suit your company and reporting workflow.

Click here for Courses

 

Use Cases of Waterfall charts in Tableau

Kejsi Bebi

Waterfall charts are best used to visualise part-to-whole relationships if some of the dimension values are negative. To avoid confusing them with a simple running total calculation try to think about them as illustrations of how each dimension member (positively valued) adds to a running total whereas a negatively valued dimensions members detract from a running total.

Use the following 6 steps to help you create them in Tableau:

1. We’ll use the Little League dataset to visualize how each player position is contributing to total runs. From the Players’ sheet, drag Position to Columns and Runs to Rows. This will create a vertical bar chart showing the measure (total runs), by the dimension (player position):

 

 

2. Next, add a table calculation to the Runs measure, to calculate a “Running total”. Choose the “Compute using options> Table (Across)” from the options available. See Cloudstream’s post on Tableau Calculations in Tableau as a reminder. Your view should be similar to the following:

 

3. From the view above, we’re now able to see how the running total cumulates across various players’ positions, yet we ’re unable to visualise whether there is a positive or negative contribution of specific dimension members. At the Marks card, change your “Automatic” to the “Gantt Bar” mark type to switch from your current bar chart to the new chart option.

 

4. Additionally, create a calculated field as displayed in the image below. This is a quick trick to make your Gantt bars for each dimension member lined up i.e create a lining up effect between the tops or bottoms of each bar on the Y-axis.

 

5. Drag your new calculated field to the Size Marks Card creating the following waterfall effect:

6. Add a few additional steps to your work to help polish the final view by further editing or formatting your axis, colouring Gantt bars by Runs by dragging the Runs measure to the Color Marks Card. Subject to your preferred colour choice the two-toned bar will help distinguish your positive and negative values.

You could also choose to add Row Grand Totals to your visualization by navigating to Analysis > Totals in the top navigation and choosing “Show Row Grand Totals” or simply sorting Runs by Player positions

Depending on your business requirements or the to-be-addressed questions, waterfall charts provide you with the necessary flexibility to experiment with dimension members’ sort orders, adding inherent flexibility to your visualisation.

 

Free Alteryx Trial!

Free Tableau Trial!

Get in touch with us today!

Contact us
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
More information Ok