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 between
heterogeneous 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.
During the training, you will use power query to
Beside that you also use power pivot to
This hands-on course demonstrates how to take advantage of self-service business intelligence using Microsoft Power Query and Power Pivot for Excel.
o Client database
o Excel tables
o CSV files
o Calculated columns.
o Measures (Calculated fields)
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.
Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables and Pivot Charts.
FEEL FREE TO ENQUIRE ABOUT OUR RANGE OF TRAINING COURSES