Data integration to support modern BI and advanced analytics programmes

Data integration and preparation are the unsung heroes of modern BI and advanced analytics. More so than ever, it would seem, due to the ever-increasing volume and variety of data.

The traditional paradigm of feeding a data warehouse with data that had been extracted from source systems, including transactional databases, then transformed to be loaded for subsequent analysis, using BI tools or statistical analysis software – that paradigm is not History, but it is being complemented with newer models. These latter are more about analysing real-time data, using fast, in-memory databases on the back end. And there is a raft of data preparation tools now available to get the data spruced up and ready for analysis quicker.

Some of these tools have come out of Silicon Valley, where much of the relatively recent wave of back end big data technologies, too, have been invented – originally to serve the needs of Google, Facebook, Amazon, and the rest. We look at some of these data integration and preparation technologies, as show-cased on press trips to Silicon Valley. The most recent of these brought to the fore the need for CIOs to get more economic value from their investments in big data technologies through data integration, including data catalogues.

Dave Wells, practice director, data management at the Eckerson Group puts these more recent approaches in perspective, in a spirited blogpost that argues that the “traditional” data warehouse is not dead.

We also look, in this e-guide, at how British Airways has brought its international business-to-business sales under Salesforce Sales Cloud to bust its data silos. The self-service BI that BA is enabling for its sales professionals is an ambition for many companies. Consultant Rick Sherman, in an interview with SearchDataManagement’s Jack Vaughan, explains how understanding the data integration process is central to such self-service BI and data architecture design.

Vendor:: TechTarget ComputerWeekly.com
Posted:: Feb 8, 2021
Published:: Aug 7, 2018
Format:: PDF
Type:: eGuide

Already a Bitpipe member? Log in here

Download this eGuide!

Corporate Email Address:
You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

Please provide a Corporate Email Address.

This email address is already registered. Please log in.
First Name:
You forgot to provide your first name.
Last Name:
You forgot to provide your last name.
Company Name:
You forgot to provide a company name.
Job Title:
You forgot to provide a job title.
Seniority:
You forgot to select your seniority.
Job Function:
You forgot to select your job function.
# of employees:
You did not select the number of employees at your company.
Industry:
You did not select which industry you are in.
Sub-Industry:
You did not select which industry you are in.
Address 1:
You did not provide a full local address.
Address 2:
City/Town:
You did not provide a full local address.
Country:
You did not select the country you are from.
State/Province:

You did not provide a full local address.
Zip/Postal Code:
You did not provide a full local address.
Phone:
You forgot to provide a phone number.

This phone number format is not recognized. Please check the country and number.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.