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

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
Friday
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
Jim King posted a blog post

Headachy vector computing? Easy R project and esProc Helps!

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 agile, that is, only requiring a few lines of codes to implement plentiful functions. For example, both of them allow for composing Vector Computing expression, simplify the judgment…See More
Nov 21, 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

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

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…

Continue

Posted on March 26, 2013 at 10:36pm

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