Data Warehouse Databases with Statistical Software Features!

Posted by Muneeswara C Pandian
Comments (1)
June 15th, 2010

Ease of data handling has been a vital reason for the statistical software platforms like SAS, SPSS to be very popular with the business analyst community. Manipulating data and inferring information is done in a much easier way on these platforms. These statistical software tools have their own proprietary data structures for data storage, but unlike relational database’s ‘Tables-Columns’, these data structures from SAS/SPSS can be easily created by the Business Analyst team themselves, hence in many instances the dependency of the Business team on IT team for these platforms are very minimal.

Some of the key features for the popularity of these platforms are

  • Excellent file data handling capability
  • Flexibility to create unlimited dataset copies
  • Ability to provide quicker statistics on a data file
  • Ready to use wide range of statistical functions
  • Supports programming constructs

Now we are seeing platforms like Teradata, Greenplum supporting these features that are of a statistical software package and trying to get into the desktop of a business user.

Teradata Agile Analytics Cloud provides interface for a business user to create his own datamart, table, load data from a file and start analyzing the data all by oneself, without the support of the IT team. Please refer the link

Greenplum recently launched a product Greenplum Chorus, which supports features to create once own instance of the database, table and use statistical functions for data analysis. Greenplum Chorus also has a web interface with a kind of social network feature for sharing of inferences on data. Please refer the link

Unlike a Reporting tool the data warehouse (Database) platforms have been always an IT focused technology, all the database vendors didn’t have much that can be demonstrated to a Business User. Now vendors like Teradata, Greenplum have products in their stable which will be directly relevant to the Business Team…

Comments (1)

Akanksha - July 21st, 2010

Hey, Just wanted to let you know about an exciting event siliconindia is organizing on July 31st, 2010 in Bangalore. At the SiliconIndia Business Intelligence Conference, you will learn about the challenges, solutions and future of BI from top industry experts and leading-edge peers. There will be exciting technical sessions, delivered by the people who know BI best – the experts who design, build and support the products, the partners and consultants who specialize in deploying Business Intelligence solutions, and the customers who use BI products each and every day. Here's you chance to meet and hear Tech leaders from Microsoft, Microstrategy, Infosys, Aditi Technologies etc. We have lined up some of the best speakers and the sessions & networking will be of the highest order. You'll experience a complete technical immersion, shared with a developer community that is passionate about all exciting developments in the business intelligence world. Limited seats: Register Now : Registration for this Conference is by invitation only. Attendance is limited to maintain an intimate setting and foster dialogue among all participants. We will review your submission and let you know. Once we qualify you, there will be a registration fee of Rs 500 only. This is towards: Access to Sessions, Tea/ Coffee & Refreshments and Lunch. You don't want to miss a power packed day with several BI developers, architects, project managers and teams, IT managers and professionals, analysts and business decision makers coming together to build their BI expertise. Regards Akanksha.R ______________________________ Akanksha.R Events Executive Ph: 91.80. 43402053 ________________________________

Comments are closed.