Make “M”agic with Power Query – Episode 1

Welcome to the first video of my introductory series on Power Query, this fantastic Excel add-in! By taking you through different scenarios and the M language behind the scenes, my aim is to show you how Power Query is a game changing tool that will make you look like a “M”agician (…get it?) to your co-workers.

In this 1st scenario we’re going to reshape and transform a raw data table into something cleaner. I will show you how to connect Power Query to an Excel workbook and remove columns and rows. Enjoy the video, let’s begin 🙂

Our Rio 2016 Olympic Medals Report

Using Power BI’s powerful Query Editor feature (Power Query in Excel), we scraped the internet for some relevant data to analyze the Olympic results in Rio.

Rio 2016 Medals – Official Rio 2016 Website

London 2012 Medals – BBC

Number of athletes by country – Wikipedia

Population – Wikipedia

GDP – Wikipedia


PS Good internet connection required 🙂

Building a beautiful non-Excel-looking Dashboard using…Excel (part 1)

When dealing with a client that has Excel 2010, 2013 or 2016, the Sensdat team builds and formats the dashboard with Excel of course, using Pivot Tables, slicers, hyperlinks and conditional formatting. This blog post is about visuals only, what we call the “window” that we create and set on the very messy and dark “data-Mordor” 🙂 . The “back-end stuff” (data modelling, Kpis, etc…) is of course made with our favorite tools: Power Pivot and Power Query but does not interest us here.  The following process will help you save a lot of time and repetitive tasks while creating an awesome cockpit that will make all of your colleagues admire your skills! 🙂

Dashboard Sensdat1

Note: How sexy is that? 🙂

Continue reading “Building a beautiful non-Excel-looking Dashboard using…Excel (part 1)”