Martin Tronier

52 Added | 1 Magazine | 2 Following | @MTronier | Keep up with Martin Tronier on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Martin Tronier”


Power BI – Experience your data. Any data, any way, anywhere.

Power BI

Getting Started with Power BI

Power BI

Start A Fire

Floating Bars in Excel Charts

Floating bars can be used to plot many types of data sets. (“Bars” in this usage means “bars”, as Excel calls horizontally oriented bars, as well as …

Data Visualization

Wireless Range Extender 101

Introduction<p>Wireless networking is ubiquitous in homes and businesses alike. The rise of devices that rely on these wireless networks – smart phones, …


How To Create Custom Functions In Excel

Don't waste time typing the same formulas over and over again. Creating custom functions in Excel is easy to do.<p><i>Produced by Sara Silverstein</i><p><b>Follow BI Video: On Facebook</b>


Corralling Costs Down Under

Using Monte Carlo simulation in project planning has proven to save time and money, yet many organizations still rely on less effective methods to …

Project Management

There’s an increasing demand for businesses to better understand the data around them to make better decisions and stay competitive. Excel may have the self-service analytics features you need! Visit the new Excel for Business Analytics site and try the new innovative interactive tours that’ll help you be more productive with your data analyses and decision making!

Ever wish you had a time machine? Well, now you do! Timeline Slicer in Excel makes it possible to turn back or stop! Quickly see your data visualizations over different time periods:

I love this slide!! RT @hackathorn: #BBBT nice flow from hindsight to insight to foresight from @HPVertica

How to build a search box to highlight data

In this video, we'll look at a way to create a search box that highlights rows in a table, by using conditional formatting, and a formula that checks …


5 Great Online Tools for Creating Infographics

Professional infographic designers rely primarily on a core vector graphics software program to create their infographics designs. The main advantage …

Visualising dependencies

Juju is a pretty large project. Some of our core packages have large complex dependency graphs and this is undesirable because the packages which …

Power Map just got even more powerful with Custom Maps. Take any image, plot your data, and see the transformation to a more interesting story.

What Are the Odds?

The probability of an event represents the likelihood of the event to occur. For example, most of us would agree that the probability of getting a …

Data Science

9 Steps to Avoid Analysis Paralysis

Posted over 3 years ago<p>When it comes to cause analysis for performance measures, many people put the cart before the horse. They rush too quickly to …

5 Basic KPI Quantification Formulae

Posted over 3 years ago<p>By far the most common quantification formulae used for performance measures are counts and percentages. They’re easy. But …


9 Rules of KPI Buy-in

Posted over 3 years ago<p>I used to think that performance measurement was about the techniques of selecting, collecting, analysing, presenting, and …


Use multiple tables to create a PivotTable

Applies To: Excel 2016 Excel 2013 More... Less<p>PivotTables are great for analyzing and reporting on your data. And when your data happens to be …


This Excel Trick Lets You Easily Spot Trends In Piles Of Data

Sparklines are word-sized charts that live in individual cells. This great feature was added to Excel in 2010 but still remains massively underutilized.<p><i>Produced by Sara Silverstein.</i><p><b>Follow BI Video: On Facebook</b>

Edward Tufte

How to create a dynamic Waterfall Chart

This follow-up article to “<i>How to create a Waterfall Chart in Excel</i>”, adds a dynamic drop-down list to enable users to change the source time series …

Data Visualization

ComputerWorld: 22 free tools for data visualization and analysis

ComputerWorld: 22 free tools for data visualization and analysis<p>Updated Apr 10, 2014<p><p>Use Evernote to create, collect, and share …

Using INDEX/MATCH as a Cell Reference – Bacon Bits

Last week during our adventure in Omaha, Dick Kusleika taught me two things.<p>First, he introduced me to a new beer: Lucky Bucket Certified Evil. It’s …


How to find and list all links (external references) in Excel?

In Excel, you refer to the contents of cells in another workbook by creating an external reference. But when you want to list all links of a workbook …

Avoiding Excel VBA Errors Caused by Changing Worksheet Names – Bacon Bits

Here’s a story about an angry man named Mahesh Pamecha. This angry man came up to me at one of my classes and said,<p>“Mike, I’m dealing with bool-sheet …