dheerajy blog

Write

Ingest, Explore & Visualize Air pollutants data from Our World in Data

Aug 4, 202417 min read23

Ingest, Explore & Visualize AirQuality data from NYC OpenData

Jul 23, 20241 min read30

Ingest, explore & visualize crop yields data from our world in data

This article talks about the performing data ingesting, exploration, analysis and building data visualizations for crop yields across the world. 5 august 1. Data Source Data for crop yields across the world. [Link] 2. Ingest Data fetchUrl = async (...

Aug 19, 20245 min read47

Data visualization through code using Observablehq notebook

Jul 21, 202410 min read40

Ingest data of Power plants from US EIA Open Data

Jul 11, 20246 min read44

Ingest data of Meteorite Landings from NASA Open Data Portal

This article will demonstrate the data ingestion and exploration for Meteorite Landings dataset provided by NASA Open Data Portal. NASA Open Data Portal 1. Import libraries import requests import pandas as pd import copy import pyodbc from sqlalchemy...

Jul 4, 20247 min read65

Ingest data of World Development Indicators from The World Bank Open Data

This article will demonstrate the data ingestion and exploration for World Development Indicator datasets like World Bank Country & World Bank CO2 emissions (kt) & World Bank GDP & World Bank Life expectancy provided by The World Bank Open Data. The ...

Jun 29, 202414 min read74

Ingest & transform wheat data from US DA NAAS

This article mentions how to ingest and transform wheat data obtained from US DA NAAS. United States Department of Agriculture (US DA) National Agricultural Statistics Service (NAAS) 1. Import libraries import requests import sqlalchemy, pyodbc, os i...

Jun 9, 20246 min read89

Ingest data from NYC OpenData FHVS & OPCV

This article will demonstrate the data ingestion and exploration for datasets For Hire Vehicles (FHVS) & Open Parking and Camera Violations (OPCV) provided by NYC OpenData. 1. Import libraries import requests import sqlalchemy, pyodbc, os import pand...

Jun 4, 202410 min read59

Building my portfolio website using Next js, Framer Motion, TypeScript, Tailwind CSS

This article is about the code used to build my portfolio project. 1. Setup npx create-next-app@latest npx create-next-app@latest . to install in the current directory. to run server npm run dev To remove the favicon.ico: stop the server using ct...

May 29, 20246 min read164

10 Power BI dev Interview questions

This article contains info about the Power BI dev Interview questions. Q1: Total = a ** b / c \ d. How do you optimise this dax? Calculate each multiplication individually. Use divide function. Optimizing steps: identify the areas of use of function...

May 18, 20246 min read11

Command Palette

Latest articles