Sign up | Login with →

SQL

The Road to Success with Big Data: A Closer Look at Expectations vs. Reality

June 8, 2013 by Farnaz Erfan

Big Data road to success

Big Data is complex. The technologies in Big Data are rapidly maturing, but are still in many ways in an adolescent phase. With all the hype around big data, it is easy to expect Hadoop to do anything and everything. However, the road to success with Hadoop is full of both opportunities and obstacles.[read more]

Data Variety: What It's All About

May 14, 2013 by Ling Zhang
1

data variety / shutterstock

Data variety stands out from the three Vs of big data from the report of the big data survey conducted by NewVantage Partners in 2012. One of the survey results shows companies focusing more on data variety instead of data volume both now and in the next three years.[read more]

Real-Time Access to SaaS Data

May 8, 2013 by Gadi Yedwab

Data stored in SaaS applications is often inaccessible to BI tools. This is a major headache to early adopters of SaaS applications. With on-premise applications, IT departments can bypass the application and access data directly from the underlying database.[read more]

A Unified Environment For Big Data Analytics

April 11, 2013 by Bill Franks

Big Data Analytics

We are reaching a crossroads in the world of analytics. Over the years, we have seen analytic environments and data environments begin to merge through the advent of in-database processing within relational database engines. But is this causing a case of "2 steps forward, 4 steps back"?[read more]

Spreadsheets: Still the King of Business Intelligence Tools

April 9, 2013 by Jim King
1

Spreadsheets and BI / shutterstock

The year of 2012 witnessed a sharp and substantial increase of BI. Unexpectedly, the spreadsheet turns out to be the one developed and welcomed most, instead of other more sophisticated BI tools like SAP BusinessObjects or Qlikview. Why is the spreadsheet still ruling the BI world?[read more]

Zynga: A Big Data Company Masquerading as a Gaming Company

April 5, 2013 by Mark van Rijmenam

Big data gaming

Online game developer Zynga operates at such a large scale that on a regular day, Zynga delivers one petabyte of content. They have built a flexible cloud server center that can easily add up to 1,000 servers in just 24 hours. So, big data is truly big at Zynga, but how do they cope with it?[read more]

Business Intelligence Maturity Assessment: Data Visualization and Data Strategy Services

March 26, 2013 by Raghu Akkapeddi

Business Intelligence

How do you assess the overall health and maturity of your Business Intelligence Initiative? This article is the first in a series that reviews the topics to be considered when reviewing the current status of a traditional Business Intelligence initiative.[read more]

SQL Visualization in the Spreadsheet

March 3, 2013 by Jim King

SQL is a database query and programming language for retrieving, updating, and managing the data from relational database. Nowadays, SQL is a basic requirement for every programmer. However, there's a disadvantage: SQL is especially designed for technical personnel.[read more]

Decision Management: Business Intelligence's Missing Piece

February 27, 2013 by Carole-Ann Matignon

The whole idea behind business intelligence is to try to make something meaningful out of the gigantic tables of data, in order to reach, ultimately, a number of informed decisions based on that data. Hoping, of course, that those decisions will have the expected impact.[read more]

New Trends in BI, Analytics and Social Media

January 27, 2013 by Timo Elliott

It seems that there might sometimes be a clash between “analytics” and “social.” For example, today’s airlines have great analytics, and they seem to have concluded that, for whatever reason, people generally prefer low prices instead of a pleasurable flight. After all, it IS possible to have a wonderful flying experience: just travel in first class, or jump in a private jet.[read more]

NoSQL, NewSQL... NonplussedSQL

October 26, 2012 by Barry Devlin
1

For some time now, I've been taking an interest in NoSQL because of its positioning in the Big Data space. I've always had a real problem with the term - whether it means Not SQL or Not Only SQL - because defining anything by what it's not is logical nonsense.[read more]

exclusive

5 Rules for Better Sales Analytics

September 6, 2012 by Bruno Aziza

Sales performance isn’t just about sales numbers and sales activities. Sure, trends in sales success are deeply tied to sales information, but many other actions support the impact of your sales team: from prospect behavior in the marketing funnel to sales development performance to the processes applied in the company’s financial and customer support practices.[read more]

exclusive

Interactive Analytics and OLAP - Part III

September 6, 2012 by Jim King

Wikipedia image

Although the current OLAP tools are splendid regarding its look and feel, few on-line analysis capabilities powerful enough are provided actually. Then, what kind of OLAP do we need? What kind of OLAP tools we need?[read more]

Teradata Aster Standardizes Access to Hadoop with SQL-H

June 13, 2012 by Mark Smith

The need to extract and store data from Hadoop into other database systems and thereby lose the computing power of Hadoop has been the Achilles heel of this big data technology. Analysts who want interactive and iterative discovery of their data now do not have to depend on the Hadoop Hive query language interface and can use more familiar tools like MicroStrategy and Tableau for analytics.[read more]

How NASA Tackles Big Data with MySQL

June 4, 2012 by Lawrence Schwartz

Tackling machine data for an 800M+ record database.[read more]