This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Use the tools and techniques of data analysis to make sense of mountains of information.

Pareto analysis states that 80% of a project’s results are due to 20% of the inputs, and 80% of problems can be traced to 20% of the causes.

Vertical analysis looks at the contributing percentage of each line item to the total base figure. Here’s an example.

Unlock deeper analytical capabilities by integrating BQL, Bloomberg’s most advanced data API,  with Python via the BQL Object ...

Today, some of that detective work is being made easier thanks to a new emphasis on data analysis in police departments. For example, departments can now detect correlations between statistics ...

As it mines new insights from all those numbers, data analysis in sports is already producing some game-changing results.