What did I learn today: Power Query Preview Hyperlink
What a brilliant feature, which was lying right in front of me for months, but I did not notice it. In Power Query Preview dialog, every field name has a
What a brilliant feature, which was lying right in front of me for months, but I did not notice it. In Power Query Preview dialog, every field name has a
This is a series of articles about people like me who deliver demos, conduct workshops and speak at keynotes. I will share what I have learnt about delivering high-impact demos
In the previous article we saw the problem with importing CSV files. Here is how the new Power Query can be used to clean the data while importing. Estimated reading
Recently I conducted a session for BI team of a large customer. This introduces the concept of end user BI to hard core developers. Have a look. It will give
Reports generated from business applications often become inputs to new reports. You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of
This is a log of what I explore and learn. Power Query – Unpivot Other Columns
The query keeps cropping up very often while I work with customers. There are many ways to handle it. Here are three ways to do it. Simple Copy Paste, using
Power Query is undergoing rapid enhancements based upon feedback received from users. On 29th May another new update was announced. If you are using Power Query, please update it to
This is a common activity. Go to a browser page, find some tabular data or report and copy-paste it into Excel. Now you waste a lot of time cleaning up
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
