A Design Of A Data Warehouse And Use Of Data Mining Techniques For Analysis Of Risk Factors Affecting Agriculture In India

We published a paper titled "A Design Of A Data Warehouse And Use Of Data Mining Techniques For Analysis Of Risk Factors Affecting Agriculture In India" in the IOSR Journal of Agricultural and Veterinary Sciences.

Here is the link to the published paper: A Design Of A Data Warehouse And Use Of Data Mining Techniques For Analysis Of Risk Factors Affecting Agriculture In India

The Journal issue can be found here: IOSR Journal of Agricultural and Veterinary Sciences Volume 8 Issue 10

Abstract: In this paper, data made available in public domain by the Government of India, under the Open Government Data Initiative is analysed using data warehouse design and data analysis techniques. A data model is developed to analyse risks in agriculture. Regression analysis and K-Means Clustering are used as analysis techniques to derive insights from the available data and identify potential risk factors.

The datasets used in this paper can be accessed here:

SOURCE DATASETS DOWNLOADED FROM DATA.GOV.IN    DOI: 10.13140/RG.2.1.1557.2566

SCHEMA TABLE DATASETS GENERATED BY TRANSFORMING THE INPUT DATA:  DOI: 10.13140/RG.2.1.3654.4087

SELECTED PIVOT CHARTS USED FOR FINAL ANALYSIS: DOI: 10.13140/RG.2.1.4178.6966

Impact Of Rupee Exchange Rate On Business Opportunities In India

We published a research paper titled "Impact Of Rupee Exchange Rate On Business Opportunities In India" in the IOSR Journal of Economics and Finance and the paper can be accessed here: Link to the journal

In this paper, we have presented the impact of Rupee exchange rate on business opportunities in India from a macro economic perspective considering the indicators such as Consumer Price Inflation, Gross Domestic Product and Index Of Industrial Production.

Abstract: In this paper, we present an analysis of the macro economy in India with respect to the exchange rate of the Rupee and de regulation of oil prices. These 2 factors have been critical in deciding the business competitiveness of the economy and their individual effects are studied. Various business competencies arising from strong and weak Rupee as well as de-regulated prices of oil are discussed. 

In continuation with the analysis expressed in this paper, we would like to share the following analysis:

The Rupee exchange rate in India is linked to the trade deficit (imports - exports). Higher trade deficits lead to a weaker Rupee. Considering an economy which has certain total imports x and certain total exports y, if the exports start dropping and imports (of consumer goods) start increasing, it might be a cause of concern (on the competitiveness of the economy). A currency depreciation might boost the exports in the short run, by making them cheaper. 

But consider the case of India. Here the primary imports are all in energy: oil, natural gas and coal. When the imports increase, we are importing more energy, and that is because the economy is doing well  and we are producing and selling more (domestically and internationally). In this case, should the Rupee depreciate with increased imports? Think about it.

(Petroleum accounts for 34% of India's imports. Data source at tradingeconomics.com)

On another note, Japan manages to import energy (oil) to meet 42% of its energy needs, but does not see any inflation even if the Yen depreciates from 75 to a US Dollar to 100 to a US Dollar. This is not the case with India. As is evident from the above research paper, a depreciation of the Rupee vs US Dollar will lead to higher inflation in the country (data from 2010 to 2014).

The below graph shows the energy imports in India as a percent of total (Data from: tradingeconomics.com)

source: tradingeconomics.com

Differential Snap-Shot Algorithms For Data Extraction From Data Sources And Updating A Centralized Data Warehouse

 A paper with the above title was published in the IOSR Journal of Engineering in their October 2015 issue.

Abstract: An in-depth review of existing techniques for loading a data warehouse using differential snapshot algorithms is presented. Further, certain performance bottlenecks have been identified and improvements to the existing state of the art are suggested.

The full paper can be downloaded here: IOSR Journal Of Engineering

The journal issue can be accessed here: IOSR Journal Of Engineering

Graph Based Verification And Identification Of Defects By Binary Search On A Graph

Here are the slides from the paper presented at the IEEE Conference on Computing, Communications and Automation organised by the Galgotias University, Gurgaon on 15 May 2014:




The full paper can be downloaded here on IEEE Xplore Digital Library