Preserving context from multiple worksheets – Bonus Exercise – Chapter 5 – #PowerQuery Book
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Today's bonus exercise takes...
Text Analytics Power BI Template – All In One
In Chapter 12 of my book, I published detailed walkthroughs that cover Translator Text API, Sentiment Analysis, Key Phrase extraction and the detection of...
Cyber Monday on DataChant: 30% Discount
Happy holidays! You can get a 30% discount when purchasing any of DataChant products (and help me keep funding my blog) in a special offer for Cyber Monday...
Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to...
The potential impact of #PowerQuery – Your story can be featured
Earlier this year I published a survey to assess the impact of Power Query in organizations. I have decided to publish this survey again, and share the results...
My #PowerQuery book has arrived
If you are following me on social media, this video will not be new. Two days ago I received my print copy of the book. The book is real :) I was so excited...
Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book
This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power...
Reader’s Corner for the new #PowerQuery Book
A quick update: The print version of the book will be released by October 30 (originally I wrote October 23, sorry guys). From then it may take few extra days...
The Digital Version of the New #PowerQuery Book is Ready
This is exciting! The digital version of the book "Collect, Combine and Transform Data Using Power Query in Excel and Power BI" is out. You can purchase it...
The Momentum of Power BI vs. Tableau based on Google Search
Last year I compared between Power BI and Tableau here and here, and eventually decided to stop it. There was no point for me to look back at Tableau and...
