17:00 - Andrew Waring
An Introduction to Power Query and Power BI for Data Validation
- Training Room
Data doesn’t suddenly appear fully correct. It takes time and effort to collate, produce and format. Too often is time and money spent producing information that is ultimately rejected. Pre-validation and iterative tracking of progress is paramount to ensure program, cost and efficiency targets are met, but where to begin? What tools to use? How much will it cost? I will demonstrate a cost effective, fully bespoke process for information validation and progress tracking using power query and power bi. The class will cover a beginner’s crash course in power query, how to reference information, transform it and validate it against some typical rule sets. It will then cover how to effectively communicate this to staff through dashboard created in Power BI. Finally, will end on some examples from Andrew’s experience in using power query and Power BI in practice to get everyone thinking about what they can do with these accessible tools that you already have.
Unit 201 Q-House 76 Furze Road, Sandyford, Dublin D18VHK2, Ireland