#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...
Category: Power Query
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...
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...
Bitcoin What-If Calculator & Regulation News in Power BI – Detailed Version
Some people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is a Power BI tool to play with different...
Bitcoin What-If Calculator in Power BI
Many people will say that 2017 was the year of the Bitcoin. Whether you have invested in cryptocurrency or not, here is your best Power BI tool to play with...
Complex Data Prep: Hawaii Tourism Analysis in #PowerBI
Better late than never. Prior to 2017 Power BI Data Insights Summit, Microsoft published here three challenges, including a complex data preparation. So, I...
Book Excerpt: Appending Worksheets from a Workbook
I am excited to share with you an excerpt from the draft manuscript of my book. You can pre-order the book in Amazon here. I expect to publish more excerpts in...
