Data Modeling and Reporting for the Business User with Excel and SharePoint
Play Data Modeling and Reporting for the Business User with Excel and SharePoint
PowerPivot, first released with SQL Server 2008 R2, is how now a native add-in for Excel 2013 that empowers business users to create their own tabular data models. In this session, you will learn about how the new add-in has been enhanced to include numerous new modeling features. Available also in SQL Server 2012, Power View is an interactive data exploration, visualization, and presentation experience that provides intuitive reporting for business users. It delivers this experience directly in the new Excel 2013 client as well as in the web browser by using SharePoint, and must be based on a tabular BI Semantic Model (either a published PowerPivot workbook or a tabular database). Ordinarily, the tabular BI Semantic Model will need to be prepared and optimized for the Power View experience, and the theory on how to achieve this will be introduced and demonstrated in this session.