Tweet

@Sachintukumar

This Thread may be Removed Anytime!

Twitter may remove this content at anytime! Save it as PDF for later use!

More from @Sachintukumar

Sachin Kumar

@Sachintukumar

Mar 12

Are you a wine enthusiast? If you are, then you’ve probably heard of Wine Magazine.

🔥Let us solve one of the Advanced SQL interview questions on RANK function.

🧵

❓ Question is taken from Wine Magazine that involves clauses like PARTITION BY, UNION ALL, CASE statements, and Window functions.

We will use a 3-step framework to solve the problem that can be used to solve any coding problem.

Find the cheapest and the most expensive variety in each region. Output the region along with the corresponding most expensive and the cheapest variety. Be aware that there are 2 region columns, the price from that row applies to both of them.

Read 6 tweets

Sachin Kumar

@Sachintukumar

Mar 10

How should you 𝐥𝐞𝐚𝐫𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈? 🚀

🧵

It's easy to be overwhelmed by how broad #PowerBI is😖

If you're starting out, here's the path I recommend⏬

📊 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠
Begin by learning to organize data into tables, create relationships, and add calculated columns and measures.

This is the most important part of your journey, as understanding the #data is always the first step in Power BI development.

Read 13 tweets

Sachin Kumar

@Sachintukumar

Mar 10

▶️Practice Writing SQL Queries using Real
Dataset 💯

🧵

“The very first thing, we must do when writing #SQL queries, is to understand the underlying data. Once we understand the data and how this data is stored across different tables, it becomes much simpler to write SQL #Queries to retrieve any information from that data”

✅List of SQL Queries:

We shall write SQL #Queries using this data. For each of these queries, you would find the problem statement and then the screen shot of the expected output. Under each of these 20 problem statement

Read 9 tweets

Sachin Kumar

@Sachintukumar

Mar 8

👨‍💻 10 different ways to remove duplicate records in SQL

🧵

1 - Delete using Unique Identifier.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.

5 - Using backup table.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.

Read 4 tweets

Sachin Kumar

@Sachintukumar

Mar 6

6 Must have line charts for business data analysis 📈👌 💯

🧵

1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do

▶ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.

Read 4 tweets

Sachin Kumar

@Sachintukumar

Feb 19

🚀 You can become a data analyst in 90 days without spending a cent! Yes, you heard that right.

With the right approach and dedication, anyone can become a #dataanalyst . Here are the steps to follow( Make sure the order is maintained)

🧵

Learn Excel - Time : 12 days
🎙️ Tutorials -
lnkd.in/eWmC2vf8
🏗️ Projects -
lnkd.in/ew5y5KP7

Learn Basic Statistics - Time : 3 days
🎙️ Tutorials -
lnkd.in/emKawHBs

Read 10 tweets

Share this page!

Sachin Kumar

People who liked this thread also liked...

Try unrolling a thread yourself!

More from @Sachintukumar

Sachin Kumar

Sachin Kumar

Sachin Kumar

Sachin Kumar

Sachin Kumar

Sachin Kumar

Did Thread Reader help you today?

Don't want to be a Premium member but still want to support us?

Send Email!