Table: Overview of business intelligence applications and resources

Excel 2013 Use Excel 2013 to create a wide range of powerful reports, scorecards, and dashboards. You can create a variety of interactive charts and tables, and add timeline controls and slicers to worksheets. What’s new in Excel 2013Create a PivotChart
Excel Services Use Excel Services to share workbooks with others. You can display all or parts of workbooks in a browser window, enabling people to explore and analyze data in the workbook. Business intelligence capabilities in Excel ServicesCreate reports, scorecards, and dashboards by using Excel Services

Share workbooks using Excel Services

Using Excel workbooks in a browser

PowerPivot add-in for Excel Use PowerPivot to create powerful data models that can include calculated fields, reports and scorecards. Get started with PowerPivot for Excel 2013Create a Data Model in Excel
Power View Use Power View to create a variety of interactive reports that include charts, tables, maps, bubble charts, and other views. What’s new in Power View in Excel 2013 and in SharePoint ServerTutorial: Create visualizations in Power View in Excel
PerformancePoint Services Use PerformancePoint Services to create and share centrally managed dashboards that include a variety of up-to-date reports and scorecards. PerformancePoint Dashboard Designer Help
Visio Services Use Visio Services to publish visual diagrams to SharePoint sites. You can create and publish diagrams that are connected to databases to display up-to-date information. Getting started with Visio
SharePoint Server Use SharePoint Server to store, manage, display and share information with people in your organization. Create dashboards that are published to SharePoint ServerExplore and analyze data in reports and dashboards

Use filters and slicers to focus on specific information