Power Query in practice: business cases
Scheduling, test plans, reconciliations, SUMIF between tables, stock management: real-world cases solved step by step.
Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.
What you will be able to do
- Track a project in working days and check delays in Power Query
- Generate every combination for a test plan and assign tasks with a modulo
- Schedule tasks over working days according to each member's capacity
- Compute a SUMIF across two tables and group matching items on a single row
- Reconcile two databases automatically and build a search bar across all columns
- Automate stock management from a folder of CSV files
Who it is for
Project managers, controllers and analysts who already have the basics of Power Query.
Prerequisites
The “Power Query: the fundamentals” course; some knowledge of the M language (each, lists, records) is useful.
Included
- Video with chapters
- PDF slides
- Marked quiz
- Verifiable certificate
Programme
Intermediate
- 01Project tracking: dates, working days and delays
- 02Test plan: generating every combination
- 03Allocating tasks between members with a modulo
- 05Calculating a SUMIF between two tables
Advanced
- 04Scheduling tasks on working days
- 06Grouping the matching items on one row
- 07Reconciling two databases automatically
- 08Search bar: one keyword across every column
- 09Live project: automating stock management
Training a team? Access for several employees, on quotation. admin@axent-consulting.com