#PowerQuery is Back!
It was a long weekend, and I am still working on the final chapter of the book. Taking the latest screenshots for the first chapter, Introduction to Power...
Book Excerpt: Loops, Recursions, Fibonacci and more from Chapter 9: M #PowerQuery
The draft of my book is almost ready (I even have few Excel formulas that are showing me, that I have already wrote 93% of the books, and a total of 359 draft...
Goodbye Tesla Facebook Page
In a tweet storm, Elon Musk said he's deleting Tesla and SpaceX Facebook accounts (Source here). Tesla Facebook page is indeed out. Luckily, I have recently...
Facebook, we have a problem
Facebook is facing great challenges lately here. The latest privacy scandal, involving Trump campaign consultants who allegedly stole data on 50 million users...
Influencers on Twitter and @IRE_NICAR
For the last two days, I have been with Microsoft Data Journalism Team in CAR conference. If you are a data journalist, Microsoft can help you (for free, by...
[Featured] The Business Intelligence Discipline: A Primer
In order to deliver Business Intelligence (BI), one must understand what BI is comprised of. Yet, there seems to be a lot of dissonance on what BI really...
Webinar Followup: Be a Full Stack #PowerBI Jedi
In today's post, I am sharing a follow-up to my webinar, that will allow you to refresh the queries, and enjoy the support of scheduled refresh on Power BI...
Webinar: Be a Full Stack #PowerBI Jedi
If you missed my webinar today, here it is: https://www.youtube.com/watch?v=r0Qk5V8dvgg Download the solution file (.pbix) here. More resources: Star...
Split CamelCase headers in M (And a fix for the Record of Promises)
How many times did you have to work with tables that had headers like these? Client_ID, Transaction_ID, Product_Name,...
Book Excerpt: Basic Text Analytics using Power BI and Power Query in Excel
Today I am excited to share a second excerpt from the draft manuscript of my book. Today's excerpt is the first part of chapter 11, which discusses basic text...
