by Balaswamy Kaladi
In today’s world of big data, analytics, and data warehousing, data volumes continue to grow, seemingly only matched by businesses’ appetite to exploit data for commercial advantage, and do so ever more quickly.
Historically, to deal with the kind of large data volumes that are now becoming commonplace, expensive and heavyweight technologies from vendors such as Teradata, Netezza and Vertica were needed. These typically cost millions of dollars, and required hardware, software, and consulting.
Read More
Tags:
Data Warehousing,
Blog,
AWS,
Amazon Redshift
Thinking of moving to a cloud based data warehouse platform? Here’s what you need to evaluate and learn how to do it.
Read More
Tags:
Data Warehousing,
Cloud,
Ron Cruz,
Blog
by Jeremiah Johnson
Data scientists are master communicators. They speak fluently with people in operations areas and those in information technology departments. They understand technical jargon, business lingo and are information experts. Unlike a jack-of-all-trades, who knows a lot but masters nothing, data scientists know plenty and often are experts in many fields. Most importantly, they find solutions for business problems.
Read More
Tags:
Data Warehousing,
Database,
Data Scientist,
Big Data,
Data Discovery,
Business Intelligence,
ETL,
Jeremiah Johnson,
Data Integration,
Blog,
Datastax
Migrating Code from Development to Production in the Cloud
The cost of cloud migration is not cheap but the promise is that the company will acheive a significant return on investment over the long haul. The objective of this article is to help us understand how to setup Development and Production environments in the cloud, specifically regarding these components of a data warehouse (DW):
Read More
Tags:
Data Warehousing,
Cloud Services,
SQL Server,
Database,
Ksheetij Dongre,
Oracle,
Informatica,
Cloud Master Data Management,
ETL,
Blog
Adoption of "The Cloud" is growing significantly as more a enterprises start to see and experiencing the value in agility, scalability, and cost savings.
Read More
Tags:
Data Warehousing,
Cloud Services,
Potnuru Hatakesh,
Informatica,
Cloud Master Data Management,
ETL,
Data Integration,
Cloud Application Integration,
Blog
Exploring the different ways Tableau connects to data and whether dimensional modeling is necessary when using Tableau’s architecture.
Architecture
Tableau has two primary ways to connect to data sources and work with them as shown in this simplified architecture diagram shown below .
Read More
Tags:
Data Warehousing,
Real-Time BI,
Cache,
Avinash Mohan,
Data Discovery,
Business Intelligence,
Tableau,
Data Integration,
Book,
Blog
by Parul Singh
The need for robust reporting and a structured enterprise data warehouse for educational institutions is becoming a necessity. This type of modern architecture empowers academic institutions with best-in-class reporting and analytic capabilities to increase faculty, staff and student productivity; streamline operations and institutional advancement; and ensure student success.
There are a few key star schemas that can aid universities and their stakeholders to make informed decisions and deliver a better student experience:
Read More
Tags:
Student Information Analytics,
Campus Analytics,
Data Warehousing,
Higher Education BI,
Business Intelligence,
Education,
Banner
Many customers have real-time reporting requirements that are analytic in nature. Essentially, they have a real-time report as a starting point for a more detailed real-time analysis which can go a few levels deep. Shown below is a generic example of one such requirement for Account Analysis.
Read More
Tags:
Data Warehousing,
Oracle E-Business Suite,
Real-Time BI,
Training,
Real-Time Supply Chain and Inventory Analytics,
Oracle,
Business Intelligence,
Tutorial,
Puneet Aggarwal,
Oracle BI,
Oracle BI Applications,
Real-Time Financial Analytics,
Blog
A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.
Read More
Tags:
Data Warehousing,
Oracle,
Informatica,
Business Intelligence,
Sridhar Kasthuri,
Oracle BI,
Oracle BI Applications,
Examining OBIA 11g,
Oracle Data Integrator (ODI),
Blog
_3-resized-600.gif)
