Manipulating Big Data using Power Query and Power Pivot in Excel - TED Learning

Big Data is a term that data sets that is large and complex. As big data in company is growing, the challenge of IT personnel, Business Intelligence, Business Analyst and Data Analysts is to analyze big data which is so complex and convert to meaningful information for better decision making. This is two(2) days program help you to gain insights 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 betweenheterogeneous data, create calculated columns and measures using formulas, build PivotTables and pivot Charts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.