Subscribe to DSC Newsletter

Daisy Ding's Blog (4)

How to Analyze Data Without SQL Experience

“What is the sales value in this month? What is the increased percentage compared with the previous month? Which sales persons are among the top 10?” – The similar data analysis is mostly required in the sectors like commerce, finance, government, and scientific research. SQL usually is the only choice for such kind of analysis.

As a query language initially developed in early 70s, SQL has a relatively higher technical requirement on analysts. Lacking of…

Continue

Added by Daisy Ding on July 12, 2012 at 6:24pm — 3 Comments

How to Solve Complex Computations in the Report

Reporting tool is good at chart & form design, style of landscaping, query interface, entry & report, and export & print. It is one of the tools that are applied most extensively. However, there are quite often complex computations in the report, which raises a very high requirement for technical capabilities of report designers, and is one of the biggest barriers in report design. This article will introduce to ways to solve the complex computations in the report.…



Continue

Added by Daisy Ding on July 5, 2012 at 5:23pm — 2 Comments

Interactive Analysis and Related Tools

Definition

Interactive analysis is a cycle analysis procedure of assumption, validation, and adjustment to achieve the fuzzy computation goal.

The interactive analysis is the real on-line analysis to solve the complex computation problem in the real world, and it is one of the key points in the business computation.

Example of Case

Let us explain the interactive analysis with a common example in the…

Continue

Added by Daisy Ding on July 5, 2012 at 1:06am — 2 Comments

What is real OLAP for practical use?

OLAP is an important constituent part of BI (business intelligence).

Understood literally, OLAP is online analytical processing, that is, users conduct analytical operation on real-time business data.

But, currently the concept of OLAP is seriously narrowed, and only it refers to operations such as conducting drilling, aggregating, pivoting and slicing based on multi-dimensional data, namely, multi-dimensional interaction analysis.

To apply this kind of…

Continue

Added by Daisy Ding on July 2, 2012 at 5:12pm — 2 Comments

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service