Key Considerations The questions in the following table may help you identify how to make the best use of Excel and Reporting Services Power View for self-service reporting and analysis. Excel Power view What is your We need to We need the primary perform ability to intent? analysis and easily create presentation highly of small to formatted data sized data sets and . Analysis Services data. What is the Users can can use skill level of work with a simple the users complex creating reports with reports? interactive interface to create filtering, sophisticated and they are familiar with . PivotTables and PivotCharts to analyze Analysis Services data. Do you Yes. Yes. require Excel’s In View, asymmetrical flexible users can or highly table and easily create customized chart layout asymmetrical report capabilities and highly layouts? meet our customized needs. report (Note: Excel layouts that reporting are usually requires manual pagination.)
Key Considerations The questions in the following table may help you identify how to make the best use of Excel and Reporting Services Power View for self-service reporting and analysis. Excel Power view What is your primary intent? We need to perform analysis and presentation of small to data sets and Analysis Services data. We need the ability to easily create highly formatted data What is the skill level of the users creating reports? Users can work with complex reports with interactive and they are familiar with PivotTables and PivotCharts to analyze Analysis Services data. can use a simple interface to create sophisticated Do you require asymmetrical or highly customized report layouts? Yes. Excel’s flexible table and chart layout capabilities meet our needs. (Note: Excel reporting usually requires manual pagination.) Yes. In View, users can easily create asymmetrical and highly customized report layouts that are sized filtering, . .