Sign up | Login with →

SQL

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]

Next query: NoSQL and Business Intelligence

May 17, 2012 by Barry Devlin
1

...whatever the rationale, the association of BI and SQL is deeply embedded in the minds of most practitioners. So, the question arises--what about NoSQL; how does this relate to BI? Can it be of use in data warehousing?[read more]

An Analysis of A NASA Dbase Hack-and-Dump

February 8, 2012 by Bryan Halfpap

Recently, some news of a NASA hack-and-dump passed my twitter deck. I decided after watching a few of my friends re-tweet the news that it might be worth checking out. At least I’d see if I could perform some password analysis on any dumped credentials, or even test out the new Crucialpoint Cloudera Hadoop password cracker on any leftover hashes.[read more]

Only 18% of Software Apps Pass Security Tests

December 12, 2011 by Alex Olesker

"Over the past 18 months, almost 10,000 software applications from the government and private sector were submitted to Veracode’s online security testing platform for independent security auditing and 8 out of 10 failed to achieve an acceptable level of security on their first try."[read more]