I got to participate in the Dundas Chart for SharePoint beta recently and have a few screens to show you. SharePoint has generally lacked a good charting component that is not only feature rich, but LOOKS GOOD. I have a few screenshots of what it takes to setup a chart within SharePoint and I didn’t even need to go to the HELP manual! Rock on!
Note: For the Microsoft people that read this blog, would you take a little piece of that $50 billion and go buy this company? You really need to embed this in all your Reporting and Business Intelligence applications. [:D]
1. The first thing you need to do is setup a data connection. Now I didn’t look around the application, but I didn’t see the ability to setup just one data connection and use it throughout the SPS site. I’m sure this feature exists, but I didn’t look for it. The only thing is you need to know how to TYPE a data connection. So if you are like me, you’ll have some spelling errors but it the application points them out to you.
2. Next you need to input your SQL Query, Stored Procedure, View, etc. So you do need to be good at the old query designer. This is not end-user friendly, but when you are doing BI, sometimes you just need to have a sql developer involved. Just cut and paste and hit the next button.
3. If you click the PREVIEW DATA button, it will run the query so you can make sure you are returning the correct data.
4. Here you put the data on the correct axis and you are set to display your chart. Note, you create the chart first and then once you FINISH, you can edit it to apply styles, etc.
5. See how pretty my charts look?! [:D] Much better than good old OWC chart controls…
6. Now if you edit the existing chart, you can choose Customize Your Chart and you can change the chart type, colors, 3d, etc. This part is really good because Dundas has just a TON of great looking web chart for you to choose from.
7; See, I chose a funky donut chart.
Basically for the Mid and Enterprise space, this is a must have chart control if you are using SharePoint within your organization. Hope you find this preview article useful.