Krishna N Bharatula
Projects Blog About
Global CO2 Emissions & Tree Cover Loss
Global CO2 Emissions & Tree Cover Loss

Analyzed GHG emissions and Tree Cover Losses from more than 200 countries. Solely scraped data from various government web sources and reports to perform analysis & created an interactive dashboard in Tableau.

TableauData Analysis

Commodities & Pesticides Data Project
Commodities & Pesticides Data Project

An analysis on ~11000 food commodity samples collected by USDA approved agencies to monitor the residue of pesticides concentration before the commoditiy reaches consumers. Analysed over 2 million test results of the samples, tracking key parameters such as origin, pesticide tolerance levels etc.

MySQLTableauDashboardsData AnalysisArticle Writing

Unveiling Massachusetts Schools - A Quick look
Unveiling Massachusetts Schools - A Quick look

Created interactive Dashboard in Tableau highlighting key performance metrics for 1,800+ of Massachusetts school systems allowing at-a-glance understanding of the entire program.

TableauData AnalysisData Visualization

Shaly-Sand Analysis
Shaly-Sand Analysis

A petrophysical evaluation of shaly-sands formations by leveraging R & MySQL to derive water saturation of the formations. Utilized publicly available sources of well data. Created a bespoke mini well-log viewer in R.

RMySQLQuarto DocumentationTechnical Writing

Braniac-Discord Bot

A Discord Bot specifically developed for the share-market. This discord bot can define several technical terms involved or currently used in share-market.

DiscordPythonRepl IDE

Pressure-losses across BHA & Wellbore Cleaning Efficiency
Pressure-losses across BHA & Wellbore Cleaning Efficiency

A comprehensive spreadsheet to calculate the pressure losses, transport ratio (hole cleaning performance) and graphically show sensitivity analysis by considering multiple factors involved while drilling.

ExcelTechnical Writing

Steam Game Data Analytics
Steam Game Data Analytics

The purpose of this project is to identify game development opportunities and sales. Extracted & analysed steam game data from the game reviews and publisher's comments in the dataset comprising of 71700games.

RMySQLTableau

Unleashing Flavorful Insights-Doordash Project
Unleashing Flavorful Insights-Doordash Project

Analyzed 2,000+ rows of customer behavioral marketing data in Excel using VLOOKUPS, Pivot Tables, and charts to evaluate campaign success levels.

ExcelArticle Writing

The World Bank's Aid in Sri Lanka's Economic Meltdown
The World Bank's Aid in Sri Lanka's Economic Meltdown

Conducted comprehensive financial analysis for the World Bank's aid during Sri Lanka's economic crisis, & identified the financial & accounting landscape during the period.

MySQLData AnalysisArticle Writing

Hospital Data Analysis - Using MySQL
Hospital Data Analysis - Using MySQL

Explored 100,000+ patient healthcare data set, assessing key factors such as hospital equality & duration of hospital stay.

MySQLArticle Writing

with by Krishna Nischal Bharatula
theme portfolYOU