Category Archives: Data Analysis

Using FIRST_VALUE & LAST_VALUE in Oracle Analytic Functions

In this blog, we will see how to use FIRST_VALUE & LAST_VALUE in Oracle with simple examples. FIRST_VALUE and LAST_VALUE in Oracle These are Oracle analytical functions used to return the first value or the last value from a set of ordered rows. These functions can get the first value or the last value within a […]
Read More »

Introduction to Rank Function in Oracle

In this blog, we will see how to use the RANK analytical function in an Oracle database and how it helps us in an analysis. What is the RANK function? The RANK function is an Oracle analytical function which calculates the rank of values which are retrieved, or against a set of rows. The same […]
Read More »

Partition By Clause in Oracle

An introductory discussion about how to use Partition by Clause in Oracle. What is a “partition by” clause in Oracle? It is used to break the data into small partitions and is been separated by a boundary or in simple dividing the input into logical groups. The analytical functions are performed within this partitions.  So […]
Read More »

Analytic Functions in Oracle

An introductory discussion about Oracle Analytic Functions which are used to calculate or compute Aggregate values, based on a group of rows. Analytic functions are used to calculate or compute aggregate values based on a group of rows, it is also called as a Window. This determines the range of rows used to perform the […]
Read More »

This article will show the step by step guide to install Tableau Business intelligence tool on Windows operating system.

Tableau is another powerful business intelligence application or tool which is used by many business users to represent the date virtually to get more inside on it. This tool can be connected to any type of data source, it can be live or an extract like CSV, Excel, text files etc… There are other tools […]
Read More »

Getting monthly data with latest records in oracle

In this blog I am going to show how we can get monthly data for a given set of records. In many cases we try to get the data into reports with monthly , weekly etc. To achive this we can use N number of tools which are provided but sometime we have to write […]
Read More »

Data Mining for Predictive Social Network Analysis

Social networks, in one form or another, have existed since people first began to interact. Indeed, put two or more people together and you have the foundation of a social network. It is therefore no surprise that, in today’s Internet-everywhere world, online social networks have become entirely ubiquitous. Within this world of online social networks, […]
Read More »

Installing RStudio & R on Windows 8 Operating System

  RStudio integrated development environment is used for the user interface for R. To install “RStudio” first open URL: http://www.rstudio.com/ide/ Now click on the Download button.  The latest version of RStudio is v0.98 Once you click on download it will ask you to choose one option out of two i.e. to Download RStudio desktop or […]
Read More »