Forbes contributors publish independent expert analyses and insights. I write about how to drive more value with data and analytics. Decisions are the lifeblood of business. From the c-suite to ...

Q. You explained Excel’s Scenario Manager in your November 2024 Tech Q&A article and Goal Seek in your December 2024 Tech Q&A article. Can you please explain the final What-If Analysis tool: Data ...

A version of this article appeared in the Autumn 2019 issue of strategy+business. The entire ethos of the Spanish hotel chain Ilunion is built on innovation, and its most powerful tool for solving ...

Excel macros save you time and headaches by automating common, repetitive tasks, and you don’t have to be a programmer or know Visual Basic Applications (VBA) to write one. With Excel, it’s as simple ...

Data underpins business success. As a result, more organizations are making substantial investments in data management strategies. A survey by HFS Research and Syniti found that 65% of respondents had ...

For some data.table users, “dot-SD” is a bit of a mystery. But data.table creator Matt Dowle told me that it’s actually quite simple: Just think of it as a symbol representing “each group.” Let’s go ...

Make your R data.table code more efficient and elegant with these special symbols and operators. Plus, learn about the new fcase() function R data.table code becomes more efficient — and elegant — ...