Solved

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

Posted on 2014-11-13
4
63 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
There are many benefits to finding online courses that align with your personal or career goals. Read more about our reasons for continuing your education in technology.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

856 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