Now, the users will have a clear idea about general data analysis and report creation, the traditional BI concepts, and especially multidimensional (OLAP) analysis, which have been clearly explained; some typical report explanations have also been given. PowerPivot supports the multidimensional data source which can only be added from Microsoft SQL Server Analysis Services (SSAS).
An OLTP system is nothing but an operational data source from which SQL queries can be used to get millions of rows from/to many tables connected by simple relations. Let's take Point-of-Sale applications ( POS ), wherein, in the operational database, there are around 214 tables and each table has lots of attributes. In order to perform analyses and make reports for these applications, importing all the tables isn't necessary since it's very difficult as all the tables follow a physical design. For these kinds of applications, SQL, the PowerPivot interface's features...