Subject: Power Query for Excel
For: Business analysts, Excel aficionados, financial experts, controllers, …
Run your own advanced analyses, reports and dashboards: With Power BI, Microsoft has created a series of software tools for self-service business intelligence. Power BI consists of add-ons that you can add for free to your Microsoft Excel software. With Power BI, any business user can create its own analyses, reports and dashboards, independently from the IT department.
This is interesting for checking hypotheses, creating personal reports that you will not use very often, testing the possibilities of a new report that you have in mind, or quickly looking up extra detail on existing reports.
How to collect data with Power Query: This webinar replay gives you a quick and concrete overview of what Power Query does. It’s a tool for discovering, combining and refining data from different internal and external sources, such as web pages, Excel files, email, Facebook and Wikipedia data, text files, Microsoft databases (SQL Server, Access and Azure SQL), IBM and Oracle databases, open source SQL databases, and so on.
Webinar hosted by