Each year, the amount of data your company handles grows exponentially. Your systems must work harder every day to satisfy increased demands for answers, insights, and reports. Data analysis and business reporting are consuming more and more of your systems and staff resources. It’s time to evaluate better alternatives. Traditional RDBMs systems were not designed for the analytic intensive type reporting so moving your data into the right format and right data structure is key to providing the flexibility needed by today’s knowledge worker. This presentation will talk about the various forms of “data warehousing” from data marts to federated “views” of your data and how to get there. We will discuss how to provide relief for state agencies who need to preserve the performance of legacy systems, yet safely serve the increased demands for self-service, real-time business analytics. Additionally we will discuss key success stories which provide insight to actual implementations of data marts or warehouses. As an example, the Dept. of Revenue at the Commonwealth of PA has been mandated to increase annual tax collection revenue. One manner identified to achieve this goal is to provide business analysts within the department better insight into taxpayer status and activity. The solution was to implement a Data Warehouse of taxation information that is capable of meeting the Business Intelligence needs of complex queries and ad-hoc reports, and provide dramatically improved performance, scalability, and usability over their existing legacy systems.
Presenter:
Rich Purcell is the Area Technical Director for Sybase’s Northeast Commercial region.
With over 25 years of experience in the software industry, he has extensive experience in data warehousing implementation, VLDB with both mainframe and Unix environments plus handling of many mainframe integration projects.
