1 / 19

virtual techdays

INDIA │ 9-11 February 2011. virtual techdays. Building rich data visualizations using SharePoint and ASP.NET Web Parts. Himani Sharma │ Support Engineer, SharePoint Development, Microsoft IGTSC. INDIA │ 9-11 February 2011. virtual techdays. What is Data Visualization Advantages

sharon-poole
Download Presentation

virtual techdays

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. INDIA │ 9-11 February2011 virtual techdays Building rich data visualizations using SharePoint and ASP.NET Web Parts Himani Sharma│ Support Engineer, SharePoint Development, Microsoft IGTSC

  2. INDIA │ 9-11 February2011 virtual techdays • What is Data Visualization • Advantages • Significance • Rich data visualization components • SharePoint OOB visualizations • Performance Point Services • Alternatives • SharePoint and ASP.NET web parts • MS Chart Controls for RDVs • Demo S E S S I O N A G E N D A

  3. INDIA │ 9-11 February2011 virtual techdays • Definition • Graphical representation of data/information. • Idea communicated more effectively. • Helps analyzing the data and make effective decisions. • Provides useful insights. • Advantages • Large amount of complex data can be presented in a simplified format. • Information can be readily absorbed and understood well. • Provides concise overview. What is Data Visualization

  4. INDIA │ 9-11 February2011 virtual techdays • Examples: What is Data Visualization

  5. INDIA │ 9-11 February2011 virtual techdays • Significance • Legacy data/large amount of data in information systems like DBs, SharePoint lists, warehouses can be analyzed and presented. • Provides business intelligence at a low cost. • Data is summarized, actionable and more personalized. • Dynamic views can help us drill up/down, filter the data. • Rich Data Visualization components • Business Intelligence data, maps based data, customer/products based data. • Rich data grids, dashboards, Maps, Charts, Graphs, reporting tools like SSRS, cube, Pivot views etc. What is Data Visualization

  6. INDIA │ 9-11 February2011 virtual techdays Data Visualization in SharePoint

  7. INDIA │ 9-11 February2011 virtual techdays • Performance Point Services • Enables to collaborate, discover and manage information. • Provides business insights to help make informed decisions. • Helps monitoring performance. • Helps building reports and provides analytic views. • Used to creates Rich interactive dashboards. • Rich Data Visualization components • Provides OOB webparts and components for RDVs. • Include scorecards, KPI lists, excel service reports, report viewer, charts. • Data can be sourced from SP lists, excel services, analysis services. Business Intelligence Centre

  8. INDIA │ 9-11 February2011 virtual techdays Business Intelligence Centre

  9. INDIA │ 9-11 February2011 virtual techdays • Alternatives? • PPS available only with enterprise license of SPS 2010. • For SharePoint Foundation we need to look for alternatives. • Use codeplex. • Third party RDV providers like Bamboo solutions, Component One etc (paid). • Build your own data visualizations using ASP.NET web parts. Business Intelligence Centre

  10. INDIA │ 9-11 February2011 virtual techdays • MS Chart controls • Enables to build robust charting capabilities to your applications. • Little effort involved. • Simple, visually appealing, interactive and dynamic visualizations can be built. • Support all chart types like columns, bars, line charts, graphs, pie charts, doughnuts etc. • Support data series, axes, legends, labels, title tec. • Can be highly customized. • Data binding supported. • Support 3D chart rendering, aliasing, Ajax etc. Rich data visualizations using ASP.NET webparts

  11. INDIA │ 9-11 February2011 virtual techdays • Integration with SharePoint • The ASP.NET webparts can be hosted on SharePoint. • Information/data from disparate environments can be pulled and shown on dashboards. • Charts can be dynamic and interactive. Rich data visualizations using ASP.NET webparts

  12. INDIA │ 9-11 February2011 virtual techdays DEMO: DemoChartCreation Himani Sharma │ Support Engineer, Microsoft IGTSC

  13. INDIA │ 9-11 February2011 virtual techdays • MS Charting controls - http://code.msdn.microsoft.com/mschart. • <System.Web><httpHandlers> <add path="ChartImg.axd" verb="GET,HEAD,POST" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false" /> • <System.Webserver><handlers> <add name="ChartImageHandler" preCondition="integratedMode" verb="GET,HEAD" path="ChartImg.axd" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> • <appsettings> <add key="ChartImageHandler" value="Storage=file;Timeout=20;Url=~/tempImages/;" /> DEMO How to begin

  14. INDIA │ 9-11 February2011 virtual techdays <asp:Chart ID="Chart2" runat="server" ImageLocation="~/TempImages/ChartPic_#SEQ(300,3)" Palette="BrightPastel" ImageType="Png" BorderlineDashStyle="Solid" BackSecondaryColor="White" BackGradientStyle="TopBottom" BorderWidth="2" BackColor="#D3DFF0" BorderColor="26, 59, 105"> <Series> <asp:Series Name="Series1"> </asp:Series> </Series> <ChartAreas> <asp:ChartArea Name="ChartArea1"> </asp:ChartArea> </ChartAreas> </asp:Chart> DEMO Code

  15. INDIA │ 9-11 February2011 virtual techdays SPListItemCollection itmColl = list.GetItems(query); DataTable table = itmColl.GetDataTable(); Chart1.DataSource = table; Chart1.Series["Series1"].XValueMember = "ProductName"; Chart1.Series["Series1"].YValueMembers = "ProductQuantity"; Chart1.Series["Series1"].ChartType = SeriesChartType.Column; Chart1.Series["Series1"]["DrawingStyle"] = "Emboss"; Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; Chart1.Series["Series1"].IsValueShownAsLabel = true; Chart1.DataBind(); DEMO Code

  16. INDIA │ 9-11 February2011 virtual techdays Sample PIE CHARTS using MS Chart controls. Sub Slide Title

  17. INDIA │ 9-11 February2011 virtual techdays SAMPLE FOR SHOWING BAR CHARTS USING MS CHART CONTROLS Sub Slide Title

  18. INDIA │ 9-11 February2011 virtual techdays • Samples for charting controls • http://code.msdn.microsoft.com/mschart • Helps you getting started quickly. • PPS Dashboard • http://blogs.technet.com/b/tothesharepoint/archive/2010/06/30/create-a-corporate-sales-dashboard-with-performancepoint-2010.aspx. • http://msdn.microsoft.com/en-us/library/ff938870.aspx • Visualizing Spatial Data (adding maps to SHAREPOINT using SSRS): http://msdn.microsoft.com/en-us/magazine/ee335706.aspx. http://mosshowto.blogspot.com/2008/12/asp-net-chart-control-sharepoint.html http://msdn.microsoft.com/en-us/library/ms170438.aspx#DataVisualization RESOURCES

  19. THANKS│ 9-11 February2011 virtual techdays himani3@hotmail.com│ http://himanisharma.blogspot.com/

More Related