Data Science & Analytics

Data analytics for professional development.

What is a data function? Examples in Math, Excel, Computer, & Programming Languages

Data functions are the nuts and bolts of the digital world. In development, they allow programmers to exchange directly with a database and modify object in-line. In Excel, they query, create, and modify arrays. In math, they allow statisticians to address datasets using Sigma (Σ) and Pi (∏) notation. But what exactly is a data …

What is a data function? Examples in Math, Excel, Computer, & Programming Languages Read More »

Change Color of 1 Column in Tableau (Conditional Formatting)

If you’re coming from Excel, manipulating colors in Tableau can feel unnecessarily complicated, especially while you’re learning. In Excel, changing the color of a column is as easy as highlighting and right-clicking the cells you want to change. However, colors in Tableau are usually modified at the data level. The methodology depends on whether you’re …

Change Color of 1 Column in Tableau (Conditional Formatting) Read More »

How to Make a Floating Box Non-Transparent in Tableau Dashboard

Have you ever tried to put a floating object over a tiled object in Tableau dashboard, only to see a blur of layered content? In Tableau, the default background setting for floating objects is transparent, which is the source of this challenge. In early versions of Tableau, transparency wasn’t available. This meant the format of …

How to Make a Floating Box Non-Transparent in Tableau Dashboard Read More »

Sort by Grand Total or Window Calculation in Tableau

Tableau’s sorting function can be tricky. Have you tried sorting a grand total column that aggregates values from calculated fields, or maybe tried using a window (across/down) calculation instead of the grand total? In other words, have you tried sorting a dimension by a table calculation of calculated fields? Unfortunately, directly sorting on aggregates of …

Sort by Grand Total or Window Calculation in Tableau Read More »

Grab & Drag All Instances of Cell Reference in Excel Formula

Excel users often find themselves dragging colored box references when moving a formula in an asymmetric worksheet. The all-too-frustrating reality, however, is that when a formula references the same cell multiple times, you have to drag each reference in the formula. Unfortunately, there is no shortcut to select all instances of a cell reference within …

Grab & Drag All Instances of Cell Reference in Excel Formula Read More »

Scroll to Top