The Fill Down Hierarchies Challenge
A weekend challenge I hope you are enjoying your second weekend of 2019. I was helping a friend recently figuring out the following data challenge: You...
Power BI Consulting Firms and Their Services – As Seen on AppSource
Are you looking for a Power BI consulting service from one of Microsoft's Gold or Silver partners? You can find such services on the Microsoft AppSource...
The Impact of Power Query – Survey Results
Recently I shared with you a survey here and asked you to estimate the impact of Power Query: How much time does Power Query save you in a year? How much...
Sneak Peek at the book: A PASS BI Webinar
Earlier this week I presented a sneak peek at my book at a PASS BI webinar. You can download the deck here, and watch this video if you missed...
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...
