In focus

    About Power Pivot

    PowerPivot is the main feature of Microsoft Excel 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. Via these formulas are used for build PivotTables and PivotCharts and then further analyze the data so that you can make timely business decisions without requiring IT assistance. PowerPivot have one more wizard which is you used to import data from different sources, ranging from large corporate databases on your intranet. Data is imported into PowerPivot for Excel as tables. These tables are shown as separate sheets in the PowerPivot window, similar to worksheets in an Excel workbook. There graphical tools which help you to analyze your data, PowerPivot includes Data Analysis Expressions (DAX) it is a new formula language which enhance the data manipulation capabilities of Excel to enable more sophisticated and complex grouping, calculation, and analysis.