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?
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