Tag: Digital Analytics

PowerQuery and PowerPivot, the two new powerful features for the latest Excel

PowerQuery and PowerPivot, the two new powerful features for the latest Excel

You are a proficient Microsoft Excel user – vlookup is an appetizer, pivot-table is the main course, and VBA/Macro is your dessert.   And your company just gave you an upgraded Microsoft 365 subscription, and a brand new version of Excel is just being served.  You are wondering – “What’s new?”

As an analyst living and breathing with Excel, PowerPivot and PowerQuery are the two killer features, period.  I’d like to share my story on how you can save time and make your spreadsheet work more efficient.

Continue Reading

Building a “digital dashboard” – Part 2 Technical side using Microsoft PowerBI

Building a “digital dashboard” – Part 2 Technical side using Microsoft PowerBI

Introduction

I have been using Microsoft product for over 20 years, starting with MS-DOS, and Windows 3.1. Microsoft PowerBI is my favorite software so far: It is simple, updated frequently, and has the right amount of configuration to “get things done”. The user community used to be small back in 2015, but it is catching up quickly with the forum, free resource (YouTube search “PowerBI”) and paid resource (high-quality material like SQLBI and PowerPivotPro) .

At the same time, as an analytics practitioner, I also understand it is vitally important to keep a mindset of “software independent”. What matters the most is the ability to deliver high-quality deliverable in the most efficient way. A technology tool like PowerBI can help to achieve that, however, we need to be cautious of falling in love with the software, not your own craft and the value delivered.

Continue Reading