Microsoft Power Query is Excel-like software from Microsoft that helps you gather, transform and analyse data from a wide variety of sources. In our webinar we explained how to use Power Query in your daily work by guiding you through some examples
Microsoft Power View is a useful add-on for Excel that helps you to visualize your data so that you can share and interpret information and present it to your customers. Check out our webinar replay with lots of demo's.
Some time ago I gave a session on SQL Server Days about Power Query. I really enjoyed speaking there. The title of the session was “Power Query Beyond The Ribbon”. I have to admit a major strength of Power Query is that you can do pretty much everything only by using the ribbon. However this doesn’t mean that learning something about M, the Power Query Formula Language, is a waste of time. With M you can solve some complex problems, automate parts or simplify your solution.
A while ago, our DAX Diviner at The Kingdom of Wizards, Ken Geeraerts, has been interviewed for a whitepaper on Big Data and AI for the company Nimbuz. Download a free copy of the whitepaper "How Big Data and AI can help your business move forward" here.