
Welcome to TED Learning!
Big Data is a term that has been widely used in the modern days to describe large and complex data sets that require analysis to ease decision making and optimize business performance. 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 two days training program helps you to gain insights out of the Big Data using Power Query and PowerPivot 2010/2013.
Power Query is an ideal data transformation and manipulation tool for Microsoft Excel. If you frequently use Excel to transform, enrich, append or merge data in your daily work, then this tool is right for you.
PowerPivot is an add-on for Microsoft Excel 2010 and 2013. It enables you to import your big data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, calculated columns and measures using formulas, build Pivot Tables 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
Besides that you also use PowerPivot to:
Delegates should be proficient users of Excel and be experienced in creating Excel Pivot Tables and Pivot Charts.
.
.
.
.
.
FEEL FREE TO ENQUIRE ABOUT OUR RANGE OF TRAINING COURSES