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.
Pre-requisites
Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables and Pivot Charts
Course Outline for This Programme
Module: Power Query Overview
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
