Data Wrangling with Power Query

Navigating Analysis with Orderly Data

Facing a mountain of data can be a daunting task, especially when it arrives in a jumbled and voluminous state. Yet, take heart, for there's a method to untangle the threads and bring order to the chaos. Embark on a journey of discovery as you embark on a one-day exploration, where the secrets to turning unruly data into a comprehensible and organized terrain will be unveiled.

Unveiling the Art of Data Transformation: From Disorder to Insight

Have you heard of data wrangling? It's akin to the meticulous process of assembling a puzzle; each piece must fit perfectly to reveal the bigger picture. This process entails untangling knots, correcting discrepancies, and assembling fragments into a seamless whole. With the right techniques, you'll emerge equipped to conquer data intricacies. Furthermore, the course will extend to mastering the art of reshaping data to illuminate hidden insights. Step into this voyage of knowledge and equip yourself with the tools to tame the complexities of data, fostering understanding and fostering meaningful analysis.

Upon completion of the course, learners will be able to:

• Clean and transform raw data into usable formats for analysis.
• Gain knowledge of common data wrangling techniques, such as data filtering, merging, and reshaping.
• Understand how to handle missing data and deal with data outliers.
• Work with large datasets and optimize performance using parallel processing.
• Understand data quality issues and how to address them.
• Communicate effectively about data wrangling and its role in the data analysis process.

• Data analysts with data analytical responsibilities
• Business analysts who needs to clean and transform data for business intelligence purposes
• Data engineers who need to extract, transform and load (ETL) data warehouses or data lakes
• Researches who work with data in various fields, such as social science, economics and health
• All professionals who works with data with a keen interest to improve their data wrangling skills
• No prior knowledge needed

Paul is a certified trainer with over 15 years of experience training corporate professionals in financial analysis, data modelling, and data visualization using advanced BI platforms. He is also an acquainted risk analyst and possesses rich domain knowledge in developing and deploying business insight with major analytical tools such as Power BI, Tableau, Qlik Sense, and Python for business analyses. As a well-versed practitioner and trainer in data analytics, several of his course plans using advanced BI platforms have been adopted by major learning hubs for both their public and corporate runs. Paul has a Bachelor of Business degree with distinction and holds double Master degrees in both Applied Finance and Accounting.