Introduction to Power Pivot is a giant leap of Microsoft Business Intelligence. This is analytics without speciality infrastructure or software. It is native to the application after Excel 2013 version. Microsoft has come up with a solid data Modeling/ analysis tool – Power Pivot. With this tool, analytics gets a new dimension. This is Analytical tool – Power Pivot. Impactful MIS reports for Excel can be generated using Power Pivot. Power Pivot is expressed by DAX(Data Analysis Expression) which is a powerful collection of functions, operators, constants that can be used in a formula, or expression to calculate one or more values. You can generate sophisticated data models. You can create simple measures or KPIs (Key performance Indicators) in Power Pivot. You can create visually appealing analytical models. You will encapsulate business logic using calculated columns/ measures.