Pinnacle Logo

www.pddi.ca
info@pddi.ca


BI / DW Architecture and Design

Our collaborative services and solutions break down data silos and allows organizations to access, analyze and share data from disparate sources. Our resource pool and our focused BI Practice provides customers insights into latest advancements in BI and DW technology, industry best practices, established methodologies, and proven processes that are engineered to reduce latency in information availability, improve collaboration between business functions and enable right time decision capability.

Whether you are building a large data warehouse for your enterprise or a series of small data marts for your organization, we can assist your team with the analysis, design, implementation, and training. It is a common misconception that to have successful data warehouse you need lots of expensive tools. While some tools can indeed provide value, they do not always provide clear ROI. A more valuable data mart can often be developed with nothing more than a good design and simple tools like PL SQL. PDDI has a team of experienced resources to meet with you and help you move towards a data warehouse solution that will provide optimal value within your organizations budget. Implementing data warehouse, data marts, operation data stores, along with data integration and consolidation are some of the services we provide.


ETL Development & Implementation

If you already have a data warehouse, chances are you have some type of Extraction, Transformation and Loading (ETL) processes to move data from your source systems to your staging database then into your data warehouse. There are many tools on the market that provide this functionality, and PDDI has the experience resources to assist with these tasks. Whether you are building data mappings, job streams, or PL/SQL packages we can help you design and build an efficient structure for you ETL and help you put in place a quality delivery mechanism for you data warehouse.


BI / DW Assessment

Is your organization ready for a business intelligence or data warehouse solution? Is there an initiative underway, does your project have the ability to succeed? These projects are sometimes large and expensive and require a certain degree of readiness and commitment to ensure their success. PDDI can complete an evaluation to determine if your organization is ready and provide a complete assessment document such. PDDI helps our client become successful from any point in the project life cycle by determining factors of risk within your organization.


BI / DW Readiness Assessment

<insert text here>


Metadata Management

PDDI is experienced in creation, configuration and implementation of metadata management tools. A single repository of business and technical definitions is critical for design, development, and implementation of any data warehouse. Metadata management is the first step in defining a solid foundation upon which to build, scale and implement the data warehouse.


Data Model Review

Do you already have a data mart or data warehouse? Trying to figure out why performance is slow or why you cannot get the right information from it? One of our consultants can review what you currently have in place and make recommendations on how to make it better. Consulting firms routinely take their designs and conduct peer reviews to come up with the best solution. Our philosophy is to take a collaborative approach to understand what you have done so far and make suggestions for improvements in the future. We will not criticize what has been done so far, but we will often challenge the status quo and challenge you to take the steps necessary to put an improved design in place for the benefit of your business and your data warehouse business users.


Report Development & Implementation

If you own or plan to buy some of the leading BI tools, such as Cognos or Business Objects or Microsoft, PDDI can leverage the power of these tools for immediate value. PDDI consultant resource pool is experienced in delivering reports and OLAP analysis capability to every level of an organization. We are also experienced in the installation and configuration of leading business intelligence software vendors.


Multi Dimensional OLAP Development & Implementation

Using the right tool for the job is sometime not an obvious choice. PDDI can assist you with determining which tool should be leveraged for which BI delivery component. A picture says a thousand words and you want to ensure when management is reading the graphic report you have placed in front of them it is conveying the correct information.


Dashboard Development & Implementation

<insert text here>