Data Wrangling with Power Query and Data Analysis with Power Pivot

This comprehensive 2-day course is dedicated to the mastery of Power Pivot and Power Query, two indispensable tools for data analysis.

Power Pivot empowers Excel users to construct intricate data models and execute advanced calculations, elevating their analytical capabilities to new heights. By enrolling in this course, you'll unlock the potential to handle extensive datasets with ease, establish relationships between tables, and craft compelling reports and dashboards. The acquisition of Power Pivot skills promises not only enhanced productivity but also heightened relevance in any data-centric organization.

Meanwhile, Power Query stands as a pivotal business intelligence instrument embedded within Microsoft Excel and Power BI. With its prowess in importing, cleansing, and reshaping data from diverse sources, Power Query is indispensable for refining datasets to meet specific analytical needs.

Geared towards individuals seeking to deepen their proficiency in Power Query, this course offers invaluable insights and techniques for optimizing its utility in both professional and personal contexts. Whether for workplace efficiency or entrepreneurial ventures, mastering Power Query is a transformative investment in bolstering data-driven decision-making capabilities.

Day 1: 

Power Query is a business intelligence tool available in Microsoft Excel and Power BI that allows you to import data from many different sources and to clean, transform and reshape them as needed. At the end of this interactive and high impact two-day workshop, learners will be able to:

1. extract data from text/csv, excel workbook and folder
2. transform and shape the data as needed
3. Load and apply them for data analysis and insight derivation

Day 2: 

Power Pivot is a powerful tool for data analysis in Excel, allowing you to create sophisticated data models and perform advanced calculations. If you're looking to take your Excel skills to the next level, a Power Pivot course can be a great investment. At the end of this interactive and high impact two-day workshop, learners will be able to:

1. Get started with Power Pivot 
2. Visualise Power Pivot data 
3. Work with advanced functionality with Power Pivot

This course is perfect for:

• 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
• Researchers 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

Note:

• No prior knowledge is needed
• Learners are required to bring their own laptop

"Trainer was very clear in his explanation and encouraged us to apply put knowledge into our work. Trainer was also patient when guiding us through our challenges. I enjoyed all of it!" 

Mr Tan, Singapore Police Force 

"He could answer all my queries to real work examples. I learnt more about the tools available in Power Query function."

Rui Fen, Singapore Police Force

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 applied 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.

In addition to the specialist training in Applied Data Analytics, Financial Analytics, Python Programming, Machine Learning, Paul holds a Bachelor of Business degree with distinction and double Master degrees in both Applied Finance and Accounting. 

Paul Lee graduated from the University of Adelaide and Curtin University of Technology with an Applied Finance and Accounting degree respectively. He has more than 20 years of working experience in accounting, credit risk management, BPO management and data analytics training. He held several management positions with large MNCs. 

Paul is very passionate in training and is always ready to share his knowledge with others. He adopts a pragmatic real-world approach during training and believes in life-long learning and having fun in the pursuit of continuing education and training.