# AnalyticBridge

Jessica May
• Beijing
• China, mainland

# Jessica May's Page

## Latest Activity

"There is statistical software specifically designed for time series analysis, which has simple functions for time transformations and has all the power needed for time series analysis, alas its not free, but its not expensive either.   Doan…"
Nov 9, 2014
Jessica May's blog post was featured

### How to Compute Moving Average in R Language and Python

A moving average is used to smooth out a time series. Computing moving average is a typical case of ordered data computing. Its basic computing method is to create a subset composed of N consecutive members of a time series, compute the average of the set and shift the subset forward one by one. The following example teaches you how to compute moving average in R language.…See More
Oct 15, 2014
Jessica May posted a blog post

### How to Compute Moving Average in R Language and Python

A moving average is used to smooth out a time series. Computing moving average is a typical case of ordered data computing. Its basic computing method is to create a subset composed of N consecutive members of a time series, compute the average of the set and shift the subset forward one by one. The following example teaches you how to compute moving average in R language.…See More
Oct 14, 2014
Jessica May's blog post was featured

### A use case to read and analyze Excel data in Java

Generally, Java programmers use poi or other open source packages to read and compute Excel data. These open source packages support low-level programming, which increases the overall learning cost and complicates the operation. But with the help of esProc, Java can avoid these problems.An example will make the point clearly understood. Read the information of sales orders from the…See More
Oct 8, 2014
Jessica May's blog post was featured

### Data alignment join in Java for easier text analytics

The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, and to compute it in Java alone we need to write a large number of loop statements. This makes the code cumbersome. Using esProc to help with programming in Java can solve the problem easily and quickly. Let’s look at how this works through…See More
Oct 1, 2014
Jessica May posted blog posts
Sep 29, 2014
Jessica May's blog post was featured

### Calculation cases of Link Relative Ratio and Year-on-year Comparison in data analytics

Cross-row and group computation often involves computing link relative ratio and year-on-year comparison. Link relative ratio refers to comparison between the current data and data of the previous period. Generally, it takes month as the time interval. For example, compare the sales amount of April with that of March, and the growth rate we get is the link relative ratio of April. Hour, day, week and quarter can also be used as the time interval. Year-on-year comparison is the comparison…See More
Sep 24, 2014
Jessica May posted a blog post

### Calculation cases of Link Relative Ratio and Year-on-year Comparison in data analytics

Cross-row and group computation often involves computing link relative ratio and year-on-year comparison. Link relative ratio refers to comparison between the current data and data of the previous period. Generally, it takes month as the time interval. For example, compare the sales amount of April with that of March, and the growth rate we get is the link relative ratio of April. Hour, day, week and quarter can also be used as the time interval. Year-on-year comparison is the comparison…See More
Sep 22, 2014
Jessica May's blog post was featured

### Code Examples of cross database relational computing in Java

Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these operations. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat satisfystate=“California”.The data and structure of sales table are as follows:…See More
Sep 10, 2014
Jessica May posted a blog post

### Code Examples of cross database relational computing in Java

Program development for data process often involves cross-database relational operations. The following example will illustrate Java’s method of handling these operations. sales table is in db2 database, employee table is in mysql database. The task is to join sales with employee through sellerid of sales table and eid of employee table, and filter out the data insales and employeethat satisfystate=“California”.The data and structure of sales table are as follows:…See More
Sep 9, 2014
"I Agree with you,…"
Sep 9, 2014
"I recently had to process lots of data on a remote machine, where I could not install anything and where the data was too big to transfer to a more 'friendly' machine. So I became friends with linux out-of-box utilities. Assuming the…"
Aug 30, 2014
Jessica May's blog post was featured

### A Method of Grouping and Summarizing Data of Big Text Files in R Language

It is common to use R language to group and summarize data of files. Sometimes we may find ourselves processing comparatively big files which have smaller computed result and bigger source data. We cannot load them wholly to the memory when we need to compute them. The only solutions could be batch importing and computing as well as result merging. We’ll use an example in the following to illustrate the way of R language to group and summarize data from big text files.Here is a file, sales.txt,…See More
Aug 27, 2014
Jessica May shared their blog post on Twitter

### A Method of Grouping and Summarizing Data of Big Text Files in R Language

Aug 25, 2014
Jessica May shared their blog post on Google +1

### Some Cases illustrating drawbacks of SQL in data computing and analytics

Jul 29, 2014
Jessica May posted a blog post

### Some Cases illustrating drawbacks of SQL in data computing and analytics

The computing power of SQL for mass structured data is complete, that is to say, it is impossible to find anything that…See More
Jul 29, 2014

## Profile Information

Short Bio:
Business analytics and data process software professional, BI technology consultant
My Website or LinkedIn Profile (URL):
http://www.raqsoft.com
Field of Expertise:
Years of Experience in Analytical Role:
11
Professional Status:
Manager
Interests:
Networking
What is your Favorite Data Mining or Analytical Website?
http://www.datasciencecentral.com/
Raqsoft co.,ltd
Industry:
BI

## Jessica May's Blog

### How to Compute Moving Average in R Language and Python

A moving average is used to smooth out a time series. Computing moving average is a typical case of ordered data computing. Its basic computing method is to create a subset composed of N consecutive members of a time series, compute the average of the set and shift the subset forward one by one. The following example teaches you how to compute moving average in R language.…

Continue

Posted on October 14, 2014 at 1:00am — 1 Comment

### A use case to read and analyze Excel data in Java

Generally, Java programmers use poi or other open source packages to read and compute Excel data. These open source packages support low-level programming, which increases the overall learning cost and complicates the operation. But with the help of esProc, Java can avoid these problems.…

Continue

Posted on October 8, 2014 at 12:26am

### Data alignment join in Java for easier text analytics

The join statements of the database can be used conveniently to perform the operation of alignment join. But sometimes the data is stored in the text files, and to compute it in Java alone we need to write a large number of loop statements. This makes the code cumbersome. Using esProc to help with programming in Java can solve the problem easily and quickly. Let’s look at how this works…

Continue

Posted on September 28, 2014 at 8:00am

### Calculation cases of Link Relative Ratio and Year-on-year Comparison in data analytics

Cross-row and group computation often involves computing link relative ratio and year-on-year comparison. Link relative ratio refers to comparison between the current data and data of the previous period. Generally, it takes month as the time interval. For example, compare the sales amount of April with that of March, and the growth rate we get is the link relative ratio of April. Hour, day, week and quarter can also be used as the time…

Continue

Posted on September 22, 2014 at 2:00am

## Comment Wall

Join AnalyticBridge

1

2

3

4