Solved

How do I Consolidate Data Pulled from Multiple Sources into a Single Customer Issues Database?

Posted on 2014-11-13
4
51 Views
Last Modified: 2016-05-12
I am currently analyzing the best approach to accomplish the following:

Consolidate up to four data sources into one area or database to be able to pull reports, perform analyses, create dashboards, etc.
All four sources exist as Excel files that are posted monthly to an internal SharePoint site
Would need the following capabilities (at the least)
Eliminate Categories and/or subcategories I don't need
Create a top 20-30 list of the major items based on their count totals
Consolidate source data into a digestable report with predetermined KPIs

My preliminary questions include (but are not limited to):

What is the best approach that can be a repeatable process?
How match up the data from all the various and disparate sources
Text analytics would be amazing to have but where do I start with that?
0
Comment
Question by:fergusoncg
4 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 500 total points
ID: 40442272
>>What is the best approach that can be a repeatable process?

As you said you have 4 excel files which would act as a source

First step towards consolidation would be to bring those excel files in a single format so that you can upload them to a single database(I assume that you load the excel data is loaded into database and you would not store the file separately)

Single format will help in loading the data, this can be a scheduled job which can either run in synchronous mode or in batch mode

>>How match up the data from all the various and disparate sources

There are various ways to match up data, if you are using only oracle database tables then by going at granular level you can merge(update existing record and insert new record) the records at row level

If you are after maintaining history and versions then you have to look out for storing the monthly data in different tables and write a view which would consolidate the data on year-to-date basis

There are other ways too, but it will depend upon how you want to view the data

>>Text analytics would be amazing to have but where do I start with that?

There are various products in oracle around this like BI Publisher, Oracle Text Indexes(Inside Oracle Database)

as you have source data in excel file you could also look at solutions from emerging technologies like Big Data or NoSQL Products

Go through this white paper presentation of managing the big data/unstructured data and analytics of the data using Oracle Cloud

http://www.oracle.com/us/solutions/social/social-engagement-monitoring-cloud-service/social-cloud-text-analytics-1870526.pdf
0
 

Author Comment

by:fergusoncg
ID: 40498614
Thanks for the insight!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s an age old story, whether you’re looking for full-time employment or contract work. In order to land a job, you must have experience.
OnPage brings Secure Critical Messaging to Telemedicine.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question