Martin Tronier

52 Flips | 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”

March 2016 updates for Get & Transform in Excel 2016 and the Power Query add-in

Excel 2016 includes a powerful new set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Today, …

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

Getting Started with 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 …

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>

Analytics

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 …

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! http://spr.ly/6188fpZ8

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: http://spr.ly/61880Xj2

I love this slide!! RT @hackathorn: #BBBT nice flow from hindsight to insight to foresight from @HPVertica http://t.co/wmHnvGncDE

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 …

Analytics

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. http://bit.ly/1sbY6uQ

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 …

9 Steps to Avoid Analysis Paralysis

Posted about 4 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 …

Data Science

5 Basic KPI Quantification Formulae

Posted almost 4 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 almost 4 years ago<p>I used to think that performance measurement was about the techniques of selecting, collecting, analysing, presenting, and …

KPIs: 5 Steps To Meaningful And Relevant Metrics

Here I want to outline the 5 most essential steps to follow when setting out to measure your Key Performance Indicators (KPIs). These are taken from …

Use multiple tables to create a PivotTable

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

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>

Trends

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 …

ComputerWorld: 22 free tools for data visualization and analysis

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

Data Visualization

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 …

Analytics