Company blog and SharePoint Tricks and Tips
This blog contains news such as new product releases and updates along with hints, tips and ideas about how to use SharePoint more effectively in your organisation.
The best way to get these updates is via RSS, alternatively you can subscribe to our email newsletter containing a summary of these posts that is sent out a maximum of once a month.
We understand you're busy and this blog will only contain relevant posts, no idle chatter!
0
|
One of our New Years Resolutions for 2010 was to: “find out how people really use our stuff”. We really want to understand how people use our Planner, Reminder and Pivot Point in the real world. We know we have clients from a huge range of industry sectors, so it will be great to see how our software helps with the special challenges of your area. And we know that some of you use 2 or 3 of our products together: we would love to know what you are doing there. So this year we want to find out how you use our products in your SharePoint environment. If we know how you use them it will help us to improve them! Just send us a quick email telling us a bit about your business and how you use our products and we will enter you into our free prize draw for the chance to win a funky Flip video camera. We would really appreciate your help on this one, so if you have a minute free please send us a quick email. |
 |
Terms and Conditions
- You must be a user of Pentalogic Technology Software in order to enter (free trial users are welcome to enter.)
- Entries must be sent to clare.stone@pentalogic.net with the subject line “Case Study”
- The draw will take place at 12 noon GMT on Monday 1st March, you entry must be submitted by 12 noon GMT Sunday 28th February to qualify.
- All entrants agree to take a 30 minute phone call from Pentalogic Technology, to clarify details of your case study.
- All entrants agree to their case study being published by Pentalogic Technology, on line or in print.
|
Some of you may have noticed that with the introduction or our new website we also seen to have lost a product – CrossTab. Don’t Panic! It’s still there, we just changed the name. And why have we done that? Well with the exception of us here at Pentalogic, and a few hard core number crunchers out there no one seemed to understand the old name. Not that many people seemed to know what a Cross Tab is. And if you Google it this is what you get:
|
 |
 |
|
|
Phew, sounds like hard work! Actually it’s pretty simple – it’s just what an Excel Pivot Table does – which is why we have changed the name to “PivotPoint” – which we hope will make sense to a lot more people. Like a Pivot Table, Pivot Point is one of the handiest little data analysis tools you could wish for. Use it to get a quick a quick and easy to interpret summary of the numerical data in your SharePoint lists. Since we were somewhat lacking in inspiration when it came to finding a new name we picked the brains of lots of SharePoint users and experts. The suggestions for PivotPoint came from Kirill Kirg in the MOSS group on LinkedIn. So many thanks to Kirill! And as always, if you have any comments or suggestions please do get in touch. |
|
Our newest web part for SharePoint is a data analysis tool called “CrossTab”
We really like it: it works a bit like an Excel pivot table but has some extra functionality that helps you to unlock the data patterns and trends in SharePoint lists.
But nobody except us seems to get it. So we have prepared a quick video demo to show you how it works.
Have a look at it and let us know if you “Get” CrossTab, or if we are on our own on this one!
This web part gives a CrossTab view of a SharePoint® list helping you to summarize and analyze data.
(CrossTabs are more commonly known from Microsoft Excel® as a Pivot Tables – http://en.wikipedia.org/wiki/Pivot_table)
There are almost limitless ways to use a CrossTab – here is one quick example
CrossTab - Sales example
We take a Sales list and first generate a CrossTab showing sales by product over time. We can see a big increase in sales from £11,000 in October to £70,000 in November and most of that increase is due to sales of the “Can-o-matic” product.
The next CrossTab shows the same data by Product/Sales Team expressed as a percentage of total sales. We can immediately see that the Regional sales team and the “Can-o-matic” are a winning combination generating 65.4% of revenue.
Previously you would have to export this data to Excel or use MOSS Enterprise Excel Services to perform the same sort of analysis. Now using the CrossTab web part you can summarize and cross tabulate your data for easy analysis in all versions of SharePoint.
This is one of several new products in the pipeline that we are very excited about – if you would like to help with Beta testing then please get in touch
Back to top
