Data visualization & reporting in Microsoft SharePoint Server

50 %
50 %
Information about Data visualization & reporting in Microsoft SharePoint Server
Technology

Published on September 9, 2010

Author: FusionCharts

Source: slideshare.net

Description

Screenshot preview of FusionCharts for SharePoint. Showcases how you can add interactive charts & graphs to your Microsoft SharePoint pages for extensive reporting. These data visualization components can be connected to various sources like SharePoint lists, CSV files, MS SQL, Oracle, Excel and BDC.

Screenshot Preview (Public Beta to be released in Oct 2010. Participation details in last slide) www.fusioncharts.com

What’s covered in this Preview? 1 slide overview of FusionCharts for SharePoint Actual Screenshots from a running instance of FusionCharts for SharePoint Details on how to request beta version or submit feature request

1 slide overview of FusionCharts for SharePoint

Actual Screenshots from a running instance of FusionCharts for SharePoint

Details on how to request beta version or submit feature request

What is FusionCharts for SharePoint? Data visualization component for Microsoft SharePoint Server Works with WSS 3.0, MOSS 2007 & MOSS 2010 on Windows Server 2008 No coding required. Charts are created using visual wizard Extensive chart types including basic charts (pie, bar, line, area etc.), combination charts, zoom & scroll charts, sales & marketing charts (Marimekko, Pareto etc.) Connects to SharePoint Lists, CSV, MS SQL, Oracle, Excel & BDC Data can be filtered & grouped with drill-down capabilities Extensive cosmetic and functional customization of each chart possible Ability to export charts as image, PDF or CSV

Data visualization component for Microsoft SharePoint Server

Works with WSS 3.0, MOSS 2007 & MOSS 2010 on Windows Server 2008

No coding required. Charts are created using visual wizard

Extensive chart types including basic charts (pie, bar, line, area etc.), combination charts, zoom & scroll charts, sales & marketing charts (Marimekko, Pareto etc.)

Connects to SharePoint Lists, CSV, MS SQL, Oracle, Excel & BDC

Data can be filtered & grouped with drill-down capabilities

Extensive cosmetic and functional customization of each chart possible

Ability to export charts as image, PDF or CSV

FusionCharts can be added to your SharePoint installation as a web part. Edit the page to add a new web part. In the FusionCharts for SharePoint section of web parts dialog, the first web part allows to batch export all the charts in the page. The second web part renders the charts in your page.

FusionCharts for SharePoint web part added to page. The default screen shows a message to connect it to live data sources. This can be done by editing the web part and then launching FusionCharts Wizard.

FusionCharts for SharePoint Wizard. This wizard helps you visually connect to your data sources and build the charts in your page. Hundreds of customizations options are available for each chart type.

Example of what a Column 2D chart would look inside the page after configuring data sources and parameters.

List of data sources that FusionCharts for SharePoint can connect to. FusionCharts can connect to SharePoint Lists, CSV data, MS SQL, Oracle, BDC and Excel.

After selecting SharePoint List as data source, you can then select the list from which you wish to build the chart from

Once the list is selected, the wizard lets you choose the columns from list to be plotted on the chart

3.-Data_Source_Select_Fields_And_Clicked_On_Apply.jpg A combination of numeric filters can be applied on data to show a subset of data

Data can be grouped on any field using multiple functions and then plotted on chart

Over 50 chart types are available including basic charts (pie, area, line, column, scatter, bubble etc.), combination charts, scroll charts, zoom charts and sales & marketing charts (Funnel, Pyramid, Marimekko, Pareto etc.). Charts can be plotted in 2D and 3D.

Example of 2D Pie Chart

Customization of data series. Each field chosen in data source is converted to a data series. Each series allows extensive customization like visual cosmetics, label, anchor and border properties.

Customizing x-axis title, sorting order and font properties

Setting chart & axis titles. Each title object allows extensive customization for font properties, effects (shadow, bevel, blur) and animation

Extensive customization is possible for data plot

Customizing line and anchor properties for a series

Configuring labels & values on charts. Multiple rendering options are possible for labels including wrap, rotate, stagger etc. If values are to be shown, they can then be placed inside a column and even rotated.

Detailed font customization for any chart text

Each object on the chart can have custom font, effects and animation applied to it

Customization of how numbers appear on the chart. You can prefix and suffix, format using thousand and decimal separators, scale down the numbers to known units (like 1000=1K, or 60 minutes=1 hour)

Chart background and border customization

Canvas Customization for both 2D and 3D charts

Customizing chart axis & grid lines

Customization options for fonts, logo, margin & padding and zero plane

All the charts in FusionCharts for SharePoint support customizable tool-tips

Customization of Chart Legend

Custom Trend lines can be added on chart. Each trend line offers multiple customization options.

FusionCharts for SharePoint supports automatic drill-down on charts

The charts can be exported as image, PDF or CSV

Batch export functionality is also available that allows all the charts present in the page to be downloaded as a single image or PDF. This can be done by adding the batch export component web part to the page.

Beta request and additional information To get a beta of FusionCharts for SharePoint, please send us an email at [email_address] with details of your SharePoint and Windows Server version To submit a feature request, please mail us at [email_address] If you wish to use FusionCharts for your Web or Enterprise application, please download the no-restriction evaluation from www.fusioncharts.com To have a sales representative contact you, please contact [email_address] Thank you for viewing!

To get a beta of FusionCharts for SharePoint, please send us an email at [email_address] with details of your SharePoint and Windows Server version

To submit a feature request, please mail us at [email_address]

If you wish to use FusionCharts for your Web or Enterprise application, please download the no-restriction evaluation from www.fusioncharts.com

To have a sales representative contact you, please contact [email_address]

Add a comment

Related presentations

Related pages

Microsoft® SQL Server® 2016 Reporting Services Add-in for ...

... for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, ... Microsoft SQL Server 2016 Reporting ...
Read more

Data Visualization (Reporting) Options – Data > Knowledge ...

Data Visualization (Reporting) ... Data Visualization tool is ... Visio Services in Microsoft SharePoint Server 2013 enables you to ...
Read more

Power BI | Interactive Data Visualization BI Tools

... Microsoft Power BI. ... Server Analysis Services you can easily build robust, reusable models over your data to provide consistency across reporting ...
Read more

Power View (SSRS) - technet.microsoft.com

... aspx on office.microsoft.com. Power View is now ... Microsoft SQL Server 2012 Reporting Services ... from a data model in SharePoint Server ...
Read more

Power View: Explore, visualize, and present your data - Excel

Power View is an interactive data ... and of Microsoft SharePoint Server 2010 and 2013 as part ... Optimize your Data Model for Power View reporting.
Read more

SQL SERVER REPORTING SERVICES 2012 (POWER VIEW)

SQL SERVER REPORTING SERVICES 2012 (POWER ... Add-in for Microsoft SharePoint Server 2010 ... Data Alerts Reporting Services data alerts ...
Read more

Download Microsoft® SQL Server® 2014 SP2 Reporting ...

... Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, ... Microsoft SQL Server 2014 SP2 Reporting ...
Read more

Reporting Services (SSRS) - msdn.microsoft.com

Reporting Services is a server ... or to a SharePoint ... and export reports to other applications such as Microsoft Excel. Create data ...
Read more

Business Intelligence and Data Visualization: Microsoft ...

DBI206 The new Business Intelligence and Data Visualization ... Data Visualization: Microsoft SQL Server ... in Microsoft SharePoint.
Read more