top of page


Mastering Data Integrity: A Comprehensive Guide to Data Constraints in SQL
SQL data constraints emerge as the unsung heroes, silently shaping the foundation of robust database design.
6 views


Understanding Relational Database and Non Relational Database
In the intricate landscape of databases, two fundamental paradigms emerge: relational and non-relational.
3 views


On-premises Data Gateway
This blog focuses on an important concept of On-premises Data Gateway.
13 views


Connect data from files in Power BI.
This Blog focuses on how we can connect PowerBI to our files.
4 views


Data Source Settings
This blog focuses on Data Source settings in PowerBI.
14 views


Unearthing the Golden Years of Video Games
Project Description In this project, I have analyzed video game critic and user scores as well as sales data for the top 400 video games...
12 views


Python Project: Youtube Analysis Part 2: Deeper look into the Channel
We will be importing the libraries that we will need. If you do not have the libraries already installed you can use "pip install" to...
15 views


PowerBI Project: Unveiling YouTube Insights PART 3: A Deep Dive into Viewer Engagement
In the first part of this Project, We did web scrapping using Python and then we explored the data using Python and SQL. In the first...
16 views


Unraveling the Power of SQL: A Beginner's Guide
This blog provides an introduction to SQL, covering its significance in data management and its three core categories DDL, DML & DQL.
10 views


Web Scraping with Python: Comparing my Favorite Youtube Channels Part 1
Introduction Web scraping is a technique used to extract data from websites enabling us to gain insights and conduct analyses. In this...
24 views
bottom of page