Oracle Community

The social network for Oracle people

Jim King
  • Male
  • Beijing
  • China, mainland
Share on Facebook
Share Twitter

Jim King's Friends

  • HaLiM KHaN
  • Orhan Eripek
  • Divyang Shah
  • Gökhan Atıl

Jim King's Groups

Jim King's Discussions

How to go further computations on grouped data?

How to go further computations on grouped data in spreadsheet? For example, the retail industry will have lots of sales data, and there will be hundreds of groups. In Excel, one has to do further…Continue

Tags: computation, data, grouped

Started Mar 26

Do you think grouping function a problem in your developing processing?

hi, guys, have u ever find group a problem while using statistical tools? what your problem and how do you solve it? please share it here with me!Continue

Tags: analytics, computing, business, function, group

Started Nov 15, 2012

What's your way to implement SQL join and distinct etc. functions?

Let’s talk more today.The example data is from 2 tables of the classical Northwind database:Orders table with the main fields: OrderID, EmployeeID, OrderDate, Freight, CustomerIDCustomer table with th…Continue

Tags: Analytics, esProc, SQL, R

Started Sep 20, 2012

How can your guys implement Basic functions of SQL by other ways?

It is known to us that …Continue

Tags: esProc, R, Analytics, SQL

Started Sep 11, 2012

Gifts Received

Gift

Jim King has not received any gifts yet

Give a Gift

 

Jim King's Page

Latest Activity

Jim King posted a blog post

Why Plug-and-Use Desktop BI Software Is So Powerful?

The basic function of a calculator is computing, which can be as simple as the four arithmetic operations and also as complex as the calculation for the next move in chess with Deep Blue. Among these, esCalc is a desktop data calculation tool for the business users to handle the occasional, complex, and business-related data computation. Such tools are named as the desktop BI software.For example, a stock analyst is required to recommend some stocks to the clients urgently. Among all…See More
Thursday
Jim King posted a blog post

Could Business Computing Be Done by Users without Technical Experience?

The business computing always occurs in enterprises, which plays an important role in enterprises operations, and mainly handled by the business users. The key business computing is usually characterized with timeliness and weak predication. There is no ready answer in the ERP, CRM, and other business systems. For example, find out the materials whose inventory level is below the warning limit for 3 consecutive days in the recent 2 weeks. Among those materials, which are used to produce the top…See More
May 16
Jim King posted a blog post

What Agile Desktop BI Tool Really Means?

BI (Business Intelligence) refers to the intelligence and ability to enhance the enterprises competitiveness, involving report presentation, reporting result calculation, OLAP analysis, business data calculation, data mining and predication. Among these, there are both the technician-oriented high-level systems, and the business user-oriented agile desktop BI tools. In this post, we only talk about agile desktop BI tools. But what is agile …See More
May 8
Jim King posted a blog post

Why the spreadsheet is still ruling the BI world?

"BI is not an upgrade to the spreadsheet", "Stop trying to use spreadsheet as the 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 Microsoft Excel, RaqSoft esCalc, LibreOffice Calc, and OpenOffice Calc tools…See More
Apr 10
HaLiM KHaN and Jim King are now friends
Apr 6
Jim King posted a discussion

How to go further computations on grouped data?

How to go further computations on grouped data in spreadsheet? For example, the retail industry will have lots of sales data, and there will be hundreds of groups. In Excel, one has to do further computations for each group manually even there is formula automatic copy. Anyone tips?See More
Mar 26
Jim King posted a blog post

The Application of esCalc in Retail Industry

The common analytics in retail industry include analysis for finance, market, commodities, customers, vendors, and salesman. The retail data analytics gives a summary on top performers, bottom performers, key value items, sales performance, forecasting, trend and seasonality. Retailers need to make  strategies based on the result of retail data analytics.One of problems that most complained during the retail data…See More
Mar 26
Jim King posted a blog post

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 requirement for every programmer. However, the advantages cannot obscure the disadvantage. SQL is especially designed for technical personnel. SQL syntax is highly abstract, the logic is hard to understand, and only those with strong technical background can…See More
Mar 5
Jim King posted a blog post

Professional Reporting Software Supports for Rapid Report Building

The report is a tool to use the table and statistical chart to present the data. It is the basic need to develop business, the basic means to manage the enterprise, and the basic advantage to enhance the competitiveness. The reporting software is one of the commonest tools for business personnel. What’s such professional reporting software that is ideal for those business personnel lacking the technical experience to develop the static reports by themselves.For example: Bill is the sales…See More
Jan 24
Jim King joined Jimmy Lin's group
Thumbnail

China ORACLE Users

China Oracle User
Jan 15
Jim King updated their profile
Jan 15
Jim King posted a blog post

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, rapid, and flexible.   Intuitive user interface: clear a technical roadblock for business personnel to operate freely   Rapid analysis procedure: accommodate the fast-changing business environment to seize opportunities and make    decisions   Flexible…See More
Jan 15
Jim King posted a blog post

Facing OLAP's Shortest Board, What's the Remedy From BI Industry?

10 years ago, OLAP ushered the brilliant age of business intelligence. In the global market, it keeps growing at double digits. Enterprisers hope this new technology will help them implement the flexible and free data analysis, providing the truly valuable business decision, and telling them which are their cash cows and stars types businesses. With 10 years passed by, up to now, the splendid prospect of OLAP…See More
Dec 11, 2012
Jim King posted a blog post

Get Rid of Mistaken Thoughts of OLAP in Your Mind

OLAP is a type of BI software that emerged and gradually developed 20 years ago. OLAP can be used to handle the complex computation flexibly and rapidly according to the requirements of analyzers and present the result to the decision-makers in an intuitive and understandable style. The decision-makers can thus grasp the enterprise operating status accurately, understand the object requirements, and set the right scheme. The original intention of OLAP is the arbitrary…See More
Dec 5, 2012
daisy vennewald commented on Jim King's blog post Does R project Save You out of Endless Debugging?
"Debug is quite a common and frequently happening to analysts and any other IT tool users. Jim has provided good suggestions to us, quite helpful! "
Nov 28, 2012
Jim King posted a blog post

Does R project Save You out of Endless Debugging?

As is well known, in the development process of a program, the time consumed to remove and correct the error is usually greater than time spent on coding. Therefore, a friendly debug environment can save a lot of time. In this respect, VB.NET and SQL are two extremes, that the former provides almost a perfect Debug environment, while the latter nearly provides no error debugging tool.As powerful statistical computing tools, R and esProc support…See More
Nov 28, 2012

Profile Information

About Me:
Focus on business intelligence over 10 years for raqsoft, master for business computing softwares, data mining, report tools, structured data analytics; Senior consultant for esProc, esCalc.

Now working on research and develop more agile business intelligence tools for big data.
My Blog:
http://datakeyword.blogspot.com
My Website:
http://www.raqsoft.com

Jim King's Blog

Why Plug-and-Use Desktop BI Software Is So Powerful?

The basic function of a calculator is computing, which can be as simple as the four arithmetic operations and also as complex as the calculation for the next move in chess with Deep Blue. Among these, esCalc is a desktop data calculation tool for the business users to handle the occasional, complex, and business-related data computation. Such tools are named as the desktop BI software.



For example, a stock analyst is required to recommend some stocks to the clients urgently. Among…

Continue

Posted on May 22, 2013 at 10:48pm

Could Business Computing Be Done by Users without Technical Experience?

The business computing always occurs in enterprises, which plays an important role in enterprises operations, and mainly handled by the business users. The key business computing is usually characterized with timeliness and weak predication. There is no ready answer in the ERP, CRM, and other business systems. For example, find out the materials whose inventory level is below the warning limit for 3 consecutive days in the recent 2 weeks. Among those materials, which are used to produce the…

Continue

Posted on May 16, 2013 at 7:33pm

What Agile Desktop BI Tool Really Means?

BI (Business Intelligence) refers to the intelligence and ability to enhance the enterprises competitiveness, involving report presentation, reporting result calculation, OLAP analysis, business data calculation, data mining and predication. Among these, there are both the technician-oriented high-level systems, and the business user-oriented agile desktop BI tools. In this post, we only talk about agile desktop BI tools. But what is agile …

Continue

Posted on May 8, 2013 at 2:39am

Why the spreadsheet is still ruling the BI world?

"BI is not an upgrade to the spreadsheet", "Stop trying to use spreadsheet as the 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 Microsoft Excel, RaqSoft esCalc, LibreOffice Calc, and OpenOffice Calc tools…

Continue

Posted on April 10, 2013 at 10:42pm

Comment Wall

You need to be a member of Oracle Community to add comments!

Join Oracle Community

  • No comments yet!
 
 
 

© 2013   Created by Eddie Awad.

Badges  |  Report an Issue  |  Terms of Service