Data Analytics Using Power Query and Power Pivot

Topic 1: Introduction to the Modern Data Analysis Tools in Excel

• Understanding how data can be imported, analysed, and displayed in Excel.

Topic 2: Connect Data from Multiple Sources

• Creating and editing a simple query to start Query Editor.
• Getting external data from common data import sources.
• Importing data from CSV files, text files, Excel files, other file types.
• Working with folders and multiple files.

Topic 3: Transform and Shape Data with Power Query

• Prepare data for analysis.
• Shape the initial data.
• Clean-up messy data.
• Combine data.

Topic 4: Loading Data

• Close & Load to Settings.

Topic 5: Modeling Data with PowerPivot

• Create table relationships.
• Create calculated columns, measures and KPI.
• Create hierarchies.

Topic  6: Building Interactive Report Visualizations

• Key features of data visualization tools.
• Create and manipulate Pivot Tables and Pivot Charts.
• Add slicer and timeline filters.
• Create dashboards.

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

• Positive Learning Attitude
• Enthusiastic Learner

Experience

• Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

• Python 3.x https://www.python.org/downloads/

Hardware: Window or Mac Laptops

• Quantum Scientists
• Quantum Computing Pogrammers
• IT Developers

Dr. Alfred Ang is the founder of Tertiary Courses. He is a serial entrepreneur. He founded OSWeb2Design Singapore Pte Ltd in 2007 offering web development, e-commerce store development, graphics design, ebook publishing, mobile apps development, and digital marketing services. He established the first online gardening store in Singapore, Eco City Hydroponics Pte Ltd in 2000, offering a wide range of gardening products such as seeds, plant nutrients, hydroponics kits etc. Eco City Hydroponics has become the most popular and successful gardening store in Singapore. He founded Tertiary Infotech Pte Ltd in 2012 and transformed the business to a training platform, Tertiary Courses in 2014. Tertiary Courses offers a wide range of SkillsFuture courses for PMETs to upgrade their skills and knowledge. He also established Tertiary Courses Malaysia in 2016. He also founded Tertiary Robotics in 2015 offering Arduino, Raspberry Pi, Microbit and Robotics products

Dr. Alfred Ang earned his Ph.D. from National University of Singapore in 2000, majoring in Electrical and Electronics Engineering. He also completed an online MBA course with U21 Global based in Australia. He obtained his B.Sc (Hons) from National University of Singapore in 1992, majoring in Physics. He topped his Physics cohort for 3 consecutive years and funded his degree study with Book price, awards and tuition. He has worked in Defence, Electronics and Semiconductor Industries. His current interests include Machine Learning, Deep Learning, Artificial Intelligence, Internet of Things, Robotics and Programming.

Dr. Alfred Ang is a ACTA certified trainer. He was Distinguished Toastmasters (DTM) and Senior Member of IEEE. He has published more than 20 peer reviewed papers and co-inventors for more than 20 inventions.

Suchit is a Theoretical Physicist who’s area of focus is Quantum Electrodynamics. He applies the principles of physics to build workable models and has built his own proprietary trading algorithm. He graduated with a bachelor degree in Electrical and Electronics Engineering, which he completed in 3.5 years; 6 months ahead of his peers. He is very analytical and good with numbers.