Data Analyst Duo

Cracking the code to healthier lifestyle 💪🏻

Last week, our goal was to budget our oil intake. So in this week's "Roz Ka Healthy Step," we are focusing on reducing our sodium intake by cutting down on breads and biscuits since they come with hidden salts. This will help us in reducing bloating and face puffiness.

I’m replacing these biscuits and breads with the creamy saffola oats and honey. 😀

It’s perfect mix of healthy and tasty breakfast. 💪🏻

Join me in this journey and take your Saffola Lifestyle Score now
To help you get started on this journey, Saffola is giving you a Tata 1MG full body check-up @449 only & a diet consultation at 50% off with NHS after the lifestyle score.

I had the pleasure of diving into the 'Data Wrangling with SQL' book authored by my friends Raghav and Shivangi, this book takes you on an exciting adventure into the realm of data manipulation, providing a comprehensive toolkit for working with data.

From the very start, the book exudes a sense of purpose. As someone deeply rooted in the world of data analytics, I understand the significance of SQL in extracting meaning from vast data oceans. 'Data Wrangling with SQL' not only underscores the importance of SQL in modern analytics but also emboldens readers to harness its power.

The two weeks I spent engrossed in the book were nothing short of enlightening. Each chapter, infused with practical examples, felt like a guided tour through the intricacies of SQL. Both Raghav and Shivangi have done a commendable job of demystifying complex concepts and translating them into relatable scenarios. It's not just about learning SQL; it's about understanding how to wield it to turn raw data into insights.

I wholeheartedly recommend 'Data Wrangling with SQL' to anyone eager to take command of their data. Whether you're a data analyst, a budding data scientist, or anyone looking to uncover the potential within data, this book will empower you.

Cheers to Raghav and Shivangi aka for a job well done!

| SQL Case Statements

"Unlocking the Power of SQL 💪💻✨

SQL, the language of data management and stream processing, is a programming gem used by various database systems like MySql, SQL Server, PostgreSQL, and more. 🗂️💡

Discovering the Magic of SQL Commands:
🔹 DDL (Data Definition Language): Creating and modifying database structures with commands like CREATE, DROP, ALTER, TRUNCATE, and RENAME. Let's dive in! 🏗️🔧

🔹 DML (Data Manipulation Language): Inserting, deleting, and updating data in a database. It's all about retrieval and manipulation. Get ready for INSERT, UPDATE, and DELETE! 🔄📝

🔹 DQL (Data Query Language): Fetching data from a relational database. SELECT, the star of the show, allows you to retrieve attributes based on conditions. 📊💡

🔹 DCL (Data Control Language): Accessing stored data, granting or revoking user access. Remember, no rollbacks here! 🔒🚫

🔹 TCL (Transaction Control Language): Managing changes made by DML statements, adding that extra layer of control. Let's COMMIT and ROLLBACK! 🔄✅

Get ready to unleash the power of SQL and conquer your data challenges! 💪🔥

Follow

✅ Uniform Distribution: A distribution where all values within a given range are equally likely; it can be used to model scenarios such as random number generation or selecting items from a set with equal probabilities.

✅ Normal Distribution: A symmetric bell-shaped distribution that is widely used in statistical analysis to represent a variety of natural phenomena such as heights, weights, IQ scores, and measurement errors.

✅ Bernoulli Distribution: A distribution representing the probability of success (1) or failure (0) in a single experiment or trial, often applied in areas like binary classification, coin flipping, or success/failure events.

✅ Binomial Distribution: A distribution that counts the number of successes in a fixed number of independent Bernoulli trials, commonly used for analyzing repeated experiments with two possible outcomes like the number of heads in multiple coin tosses.

✅ Poisson Distribution: A discrete distribution that models the number of events occurring in a fixed interval of time or space, often utilized in areas such as modeling rare events, traffic flow analysis, or accident prediction.

✅ Exponential Distribution: A continuous distribution that models the time between independent events in a Poisson process, frequently used in reliability analysis, queueing theory, or survival analysis.

Follow

 

I built a basic course on SQL for data analytics. It’s complete beginner friendly.

Comment below if you want the link to the course.

Follow

As I reflect on these 100 days, I see how moving out has transformed me. It has been a journey of self-discovery, growth, and embracing the independence that comes with it.

🔸 Moving out taught me the true meaning of responsibility. From paying bills to managing household chores, and grocery shopping to fixing household issues, I've grown into a responsible adult.
🔸 Living on my own has its perks, but I can't deny the moments when I miss my family. Distance has made me cherish our time together even more.
🔸 Managing finances has been a significant part of my journey. Budgeting, saving, and making wise financial decisions have become crucial skills these days.
🔸 Now, I and Aditi get more time to spend and get to know each other. This has helped our relationship to grow stronger.

I'm grateful for the support and encouragement I've received along the way. Your presence has made this transition smoother, and I look forward to sharing more experiences with you.

Follow

How to find a job through Linkedin 🔵

Follow

Common causes of outliers in a dataset.

Follow

Python for data visualisation 📊
1 - Matplotlib
2 - Seaborn
3 - Plotly
4 - Bokeh

Follow

If you want to learn how descriptive statistics can be used to solve the real world problem then join our 2-day Statistics for data analysis workshop.

300+ folks have already completed the workshop. This will be the last batch of the level 1. We are soon going to start level 2.

Overall ratings - 4.8/5

Check the link in the bio to register.

Follow