Sign up | Login with →

Posts by Jim King Subscribe

Using esProc to Compute the Online Time of Users [PART 2]

In last part we mentioned that the Operation Department of the Web Company brought about a new demand: adding new conditions to the way the online time are computed. As IT department was using esProc as the tool for computation, it's easy to handle...

Posted September 15, 2014    

Comparison of esProc and R Language in Processing Text Files

As languages for data computations, both esProc and R language have rich functions to process text files. They have many similarities in basic usage, as well as obvious differences, such as in the aspect of processing files with fixed column width...

Posted August 18, 2014    

IDE and Debugging Function Comparison Between esProc, Perl and Python

esProc, Perl, and Python are all the scripting language for data analysis and processing. However, they differ in syntax style, function and features, applicable scenarios, and IDE. Some differences are quite obvious. Of all these differences, IDE...

Posted August 4, 2014    

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    

 

type != 'infographic') ) { ?>