Manipulating Big Data Using Power Query & Power Pivot (Level 1)

Analyse big data which is so complex and convert to meaningful information.


2 days
All levels
0 lessons
0 quizzes
0 students

Course Info

The Big Data using Power Query and Power Pivot 2010/2013 tools. Power Query is simply the best transformation and data manipulation tool for Excel. If you use Excel to transform, enrich, append or merge your data then this tool is what you need. Power Pivot is an add-in for Microsoft Excel 2010 and 2013 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyse the data so that you can make timely business decisions without requiring IT assistance.

What Will I Learn From This Course?

Users should be comfortable with navigating the Power Pivot and Power Query applications, manipulating data, creating queries and reports, using DAX functions, and distributing and visualizing data.


Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables and Pivot Charts

Course Outline for This Programme

a. Introduction to Power Query
b. Appending data
c. Merging Table
d. Transforming Data
e. Power Query Formulas
f. Cleaning Dirty Data
g. Databases as sources
h. Exchange as a data Source

Curriculum is empty

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications