Solved

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

Posted on 2014-11-13
4
72 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DB migration from Mssql to 12c oracle , data not loading. 3 52
plsql job on oracle 18 108
Oracle programming for starter 14 74
Using Sum with Case When within a query 9 47
OnPage brings Secure Critical Messaging to Telemedicine.
Building a successful professional career is a long and difficult journey, especially in case if your decisions are not chosen carefully. For example, if you think that you can get to the desired position without experience and apply for it, your ch…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

734 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