How to access Power Query User Interface Walkthrough of the key functionalities Basics of M-languagePower Query is a functionality in Excel which allows the user to handle large amounts of data and modify that data so that it is useful for user's reports. Power Query can automate almost all the repeating tasks in Excel so that the time taken to update reports can be reduced from hours to minutes. It is also used via a very easy-to-use user interface so that anyone can learn the basics in just a few hours, unlike macros which are difficult to learn and often very unstable. If you like Excel, Power Query may change that relationship to love.
Power Pivot on the other hand is a tool that allows users to create relationships between different tables, apply formulas and then analyze the data in an Excel pivot. This allows the user to create a model where there is a separate data file and then multiple master data files. Power Pivot uses very efficient data compression method and can thus include much more data than a normal Excel file and still be distributed via email. Power Pivot brings business intelligence capabilities into Excel. If you need a table to analyze the data, Power Pivot is the best choice - if you want to create visual graphs, then you should go for Power BI.
Power BI is not a part of Excel unlike Power Query and Power Pivot, but a separate tool. Still, it is part of the Microsoft Business Intelligence tools and functions quite a lot like both of the previously mentioned Excel tools and is quite easy to learn based on the experiences from them. With Power BI, user can create advanced graphs and dashboards which are not possible in Excel.
The training consists of the following parts:
Morning will be theory training with exercises
1. Power Query
In about 1-2 months, each of the participants has a possibility for a two hour one-to-one coaching session with the trainer where they can find answers to open questions that have arrived when using the tool or get further training & tips to continue learning. It is possible to combine all the coaching sessions to one day and have them face to face or in other cases have them as skype meetings.
Price for the training is 4000 € VAT 0%, which includes an intensive training day and all the necessary training and practise materials customized for each specific training in electronic format. Price includes travel costs of the trainer within Helsinki area. Ask for a specific training for a longer or larger program - for example for multiple groups.
It is also possible to have greater benefits of the training by organizing a workshop day after the training where the training group gathers again to create something truly useful for the company with the tools and learn even more ways to use to tools. The output of the workshop day can be for example a new management dashboard, some complex report or automatization of closing tasks. Price of the additional workshop day is 2000 € VAT 0 %.
All Loistaa Consulting trainings are held in customers' facilities, so that there is no extra travel needed for the customer and that allows the trainings to be split into smaller pieces so that everyone can attend only the trainings relevant for them.
Loistaa Consulting is always bind by a non-closure agreement, so the training can be done on customers' materials which is easier to understand and gives a greater benefit to the trainees. You can take a closer look at the NDA here.