Sign up | Login with →

Posts by Jim King Subscribe

Program Language with Agile Syntax to Achieve Better Efficiency and Performance

In the previous article, I’ve shared some experiences in Hadoop coding with the agile esProc syntax. This article is the supplementary and in-depth discussion based on the previous one. Firstly, let’t talk about the Cellset Code. In the...

Posted February 12, 2014    

Hadoop Code Reuse and Step-by-step Ways to Simplify Business Computing

The MapReduce of Hadoop is a widely-used parallel computing framework. However, its code reuse mechanism is inconvenient, and it is quite cumbersome to pass parameters. Far different from our usual experience of calling the library function easily,...

Posted January 9, 2014    

Could Business Computing Be Done by Users Without Technical Experience?

Business computing always occurs in enterprises, which plays an important role in enterprises operations, and is mainly handled by the business users. The key business computing is usually characterized with timeliness and weak predication....

Posted May 18, 2013    

What's the Difference between Desktop BI and Solution BI?

All modern Information Technologies which are capable of improving the enterprise competitiveness fall in the scope of BI, such as ERP, CRM, Reporting tools, Data Computing, Statistical Analysis, Data Mining, OLAP, and ETL, etc. They can be divided...

Posted May 17, 2013    

Spreadsheets: Still the King of Business Intelligence Tools

"BI is not an upgrade to the spreadsheet!" "Stop trying to use the spreadsheet as a BI tool!" BI vendors are frequently heard to make such comments. People may thus assume that the spreadsheet is on the decline, and feel embarrassed by their...

Posted April 9, 2013    

SQL Visualization in the Spreadsheet

SQL is a database query and programming language for retrieving, updating, and managing the data from relational database. SQL was certified to meet ANSI in 1986, and became an international standard in 1987. Nowadays, SQL becomes a basic...

Posted March 3, 2013    

Seven Drawbacks of Traditional OLAP

In 1993, E.F. Codd, the acknowledged founder of relational databases, introduced the term Online Analytical Processing (OLAP). OLAP is intended for the non-data processing professionals like the business expert, and is expected to be intuitive,...

Posted January 17, 2013    

OLAP Cask Principle Reveals the Future for OLAP Tools Manufacturer

This post is originally posted on http://it.toolbox.com/blogs/data-analytics/olap-cask-principle-reveals-the-future-for-olap-tools-manufacturer-54044.Cask principle illustrates this idea: no matter how high the cask is, it is the shortest board of...

Posted December 11, 2012    

Simple Inter-row Computation: esProc Keeps It Simple!

The interrow computation is quite common, such as the aggregate, comparison with same period of any previous year, and link relative ratio in business statistics and analytics. Both R language and esProc provide a pretty good interrow computation...

Posted November 27, 2012    

Vector Computing, Who Is More Powerful, R Language or esProc?

Do you find Vector Computing tiresome while using statistical computing tools? Here we go for a Vector Computing Comparison: R Language vs. esProc. To me, one of the most attractive features of R language and esProc is that their codes are both...

Posted November 27, 2012    

Interactive Analysis Tools Comparison: R Language, Matlab, esProc, SAS, SPSS, Excel, and SQL

The interactive analysis is a circular analytics procedure comprising assumption, verification, and calibration by the analyst to achieve the fuzzy computation goal. For specifics and details, please refer to another article I composed: Interactive...

Posted October 17, 2012    

Interactive Analytics and OLAP - Part III

In the part II of interactive analytics and OLAP, we left a question: Can the narrowed OLAP be used to complete the computation process as follows...

Posted September 6, 2012