PinnedPublished inAnalytics VidhyaOLTP, OLAP database system.For those new to database systems and data modelling, this article provides an easy and simple introduction to OLTP and OLAP database…May 13, 2022May 13, 2022
Published inAnalytics VidhyaSTAR Schema basics.Star schemas are mostly used in data warehouses. Star schema is a type of data model made up of two groups namely fact and dimension. Star…Jun 22, 2022Jun 22, 2022
Published inAnalytics VidhyaImporting CSV and Excel files into Pandas data-frame while addressing some common issues.Sometimes cleaning the data while importing into the pandas data-frame can be more beneficial as it will reduce the effort spent to clean…Dec 2, 2021Dec 2, 2021
Published inAnalytics VidhyaMySQL- Inner Join simplified for beginner.While studying the topic on SQL INNER JOIN, I made some brief notes that I am sharing here.Nov 23, 2021Nov 23, 2021
Published inAnalytics VidhyaStudy Notes on understanding Cloud Computing in its simplest form.What is cloud computing?Sep 24, 20212Sep 24, 20212
Published inAnalytics VidhyaWeb development basics -Part 2. How to Search, Update and Delete form data from MySQL database.Original DatabaseDec 11, 2020Dec 11, 2020
Published inAnalytics VidhyaWeb development basics -How to connect HTML Form to MySQL using PHP on Apache web-server Part-1.A step by step guide to create a very basic dynamic web page. I am using Ubuntu 16.04 machine.Dec 10, 2020Dec 10, 2020
Git commands to push python code to remote repository on Github.I have struggled a lot in understanding how Git and Github works. Recently I came across the freecodecamp git and github crash course on…Nov 13, 2020Nov 13, 2020
Published inAnalytics VidhyaHow to pd.merge() two data-frames on a common date column.One of the main challenge while doing data analysis using Covid-19 Cases and Deaths data, was to merge these two data-frames together on…Nov 3, 20201Nov 3, 20201
Published inAnalytics VidhyaLets get to know you! Understanding your data-set using Python Pandas.The most important thing that I have learned from this mini project is that:Oct 22, 2020Oct 22, 2020