๐จ Most people waste months applying for remote jobs... on the wrong websites.
I analyzed the 8 biggest WFH job platforms and ranked them by real hiring chances, not popularity.
One platform gives you a much better shot at startup jobs.
Another has dollar-paying roles that most Indians ignore.
A few are simply wasting your time.
If you're planning to apply for remote jobs this week, read this first. It could save you hundreds of applications.
๐ Full ranking + reasons:
๐ https://www.linkedin.com/feed/update/urn:li:activity:7487348656522575872/
If this helps, share it with someone who's actively job hunting.
I analyzed the 8 biggest WFH job platforms and ranked them by real hiring chances, not popularity.
One platform gives you a much better shot at startup jobs.
Another has dollar-paying roles that most Indians ignore.
A few are simply wasting your time.
If you're planning to apply for remote jobs this week, read this first. It could save you hundreds of applications.
๐ Full ranking + reasons:
๐ https://www.linkedin.com/feed/update/urn:li:activity:7487348656522575872/
If this helps, share it with someone who's actively job hunting.
LinkedIn
Ranking Remote Job Platforms by Actual Hiring Odds | Rupnath Shaw posted on the topic | LinkedIn
๐ก๐ผ๐ ๐ฒ๐๐ฒ๐ฟ๐ ๐ช๐๐ ๐ท๐ผ๐ฏ ๐ฝ๐น๐ฎ๐๐ณ๐ผ๐ฟ๐บ ๐ฑ๐ฒ๐๐ฒ๐ฟ๐๐ฒ๐ ๐๐ผ๐๐ฟ ๐๐ถ๐บ๐ฒ.
Some get you hired. Some just get you scrolling.
I ranked the 8 most-used remote job platforms based on actual hiring odds, not follower counts.
๐ง๐ผ๐ฝ ๐๐ถ๐ฒ๐ฟ
- Wellfound: if you want to work at a startup, thisโฆ
Some get you hired. Some just get you scrolling.
I ranked the 8 most-used remote job platforms based on actual hiring odds, not follower counts.
๐ง๐ผ๐ฝ ๐๐ถ๐ฒ๐ฟ
- Wellfound: if you want to work at a startup, thisโฆ
โค1
Most freshers write their resume before they even know what role they want.
That's backwards.
I broke down a simple framework, the 3-circle career sweet spot, why applying everywhere beats nothing but strategy beats applying everywhere, how your skills are more transferable than you think, and one networking move that actually gets replies.
Full post here ๐
https://www.linkedin.com/posts/rupnath-shaw_data-analyst-roadmap-ugcPost-7487717090469142528-KLem/
Save it if you're job hunting right now.
That's backwards.
I broke down a simple framework, the 3-circle career sweet spot, why applying everywhere beats nothing but strategy beats applying everywhere, how your skills are more transferable than you think, and one networking move that actually gets replies.
Full post here ๐
https://www.linkedin.com/posts/rupnath-shaw_data-analyst-roadmap-ugcPost-7487717090469142528-KLem/
Save it if you're job hunting right now.
๐ ๐ฝ๐ฟ๐ฒ๐ฝ๐ฎ๐ฟ๐ฒ๐ฑ ๐ฆ๐ค๐ ๐ณ๐ผ๐ฟ ๐บ๐ ๐ถ๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐ ๐ถ๐ป ๐ณ ๐ฑ๐ฎ๐๐.
Cracked it too.
No bootcamp. No paid course.
Just YouTube, docs, and my own notes written by hand.
https://www.linkedin.com/feed/update/urn:li:activity:7488076056520941568/
Cracked it too.
No bootcamp. No paid course.
Just YouTube, docs, and my own notes written by hand.
https://www.linkedin.com/feed/update/urn:li:activity:7488076056520941568/
โ
Top 10 Excel Interview Questions & Answers ๐๐ผ
1๏ธโฃ What is Excel and why is it used?
Excel is a spreadsheet program used for organizing, analyzing, and storing data in tabular form. It's widely used for data analysis, reporting, and financial modeling.
2๏ธโฃ Key Excel components?
- Ribbon: Main menu
- Worksheet: A single sheet
- Workbook: A collection of worksheets
- Cell: Intersection of a row and column
3๏ธโฃ What are Excel Functions?
Predefined formulas that perform specific calculations (e.g., SUM, AVERAGE, IF, VLOOKUP).
4๏ธโฃ VLOOKUP vs. INDEX/MATCH?
- VLOOKUP: Searches for a value in the first column and returns a corresponding value.
- INDEX/MATCH: More flexible and overcomes VLOOKUP limitations, better for larger datasets.
5๏ธโฃ What are Pivot Tables?
Interactive tables that summarize and analyze large datasets, allowing you to easily rearrange and filter data.
6๏ธโฃ Conditional Formatting?
Applies formatting (e.g., colors, icons) to cells based on specific criteria, making it easier to identify trends and outliers.
7๏ธโฃ How to remove duplicates?
Use the "Remove Duplicates" feature in the Data tab to eliminate redundant rows based on selected columns.
8๏ธโฃ What are Excel Charts?
Visual representations of data (e.g., bar charts, line charts, pie charts) that help communicate trends and insights.
9๏ธโฃ How to protect a worksheet?
Use the "Protect Sheet" feature in the Review tab to prevent unauthorized changes to the worksheet structure and content.
๐ What are Macros?
Automated sequences of commands that can be recorded and replayed to perform repetitive tasks efficiently.
๐ React โค๏ธ if you found this helpful!
1๏ธโฃ What is Excel and why is it used?
Excel is a spreadsheet program used for organizing, analyzing, and storing data in tabular form. It's widely used for data analysis, reporting, and financial modeling.
2๏ธโฃ Key Excel components?
- Ribbon: Main menu
- Worksheet: A single sheet
- Workbook: A collection of worksheets
- Cell: Intersection of a row and column
3๏ธโฃ What are Excel Functions?
Predefined formulas that perform specific calculations (e.g., SUM, AVERAGE, IF, VLOOKUP).
4๏ธโฃ VLOOKUP vs. INDEX/MATCH?
- VLOOKUP: Searches for a value in the first column and returns a corresponding value.
- INDEX/MATCH: More flexible and overcomes VLOOKUP limitations, better for larger datasets.
5๏ธโฃ What are Pivot Tables?
Interactive tables that summarize and analyze large datasets, allowing you to easily rearrange and filter data.
6๏ธโฃ Conditional Formatting?
Applies formatting (e.g., colors, icons) to cells based on specific criteria, making it easier to identify trends and outliers.
7๏ธโฃ How to remove duplicates?
Use the "Remove Duplicates" feature in the Data tab to eliminate redundant rows based on selected columns.
8๏ธโฃ What are Excel Charts?
Visual representations of data (e.g., bar charts, line charts, pie charts) that help communicate trends and insights.
9๏ธโฃ How to protect a worksheet?
Use the "Protect Sheet" feature in the Review tab to prevent unauthorized changes to the worksheet structure and content.
๐ What are Macros?
Automated sequences of commands that can be recorded and replayed to perform repetitive tasks efficiently.
๐ React โค๏ธ if you found this helpful!
5 SQL Mistakes That Make Queries 100x Slower
Cover:
https://www.linkedin.com/feed/update/urn:li:share:7488197667341385728/
Cover:
SELECT *, missing indexes, functions in WHERE, unnecessary JOINs, subqueries.https://www.linkedin.com/feed/update/urn:li:share:7488197667341385728/
LinkedIn
๐ฌ๐ผ๐๐ฟ ๐ฆ๐ค๐ ๐๐ผ๐ฟ๐ธ๐. ๐๐๐ ๐ถ๐'๐ ๐ธ๐ถ๐น๐น๐ถ๐ป๐ด ๐๐ต๐ฒ ๐๐ฒ๐ฟ๐๐ฒ๐ฟ.
Here's why.
These 5 mistakes slow down queries
more than most people realize.
Fixโฆ
Here's why.
These 5 mistakes slow down queries
more than most people realize.
Fixโฆ
๐ฌ๐ผ๐๐ฟ ๐ฆ๐ค๐ ๐๐ผ๐ฟ๐ธ๐. ๐๐๐ ๐ถ๐'๐ ๐ธ๐ถ๐น๐น๐ถ๐ป๐ด ๐๐ต๐ฒ ๐๐ฒ๐ฟ๐๐ฒ๐ฟ.
Here's why.
These 5 mistakes slow down queries
more than most people realize.
Fix them once. Never look back.
๐ญ. ๐ฆ๐๐๐๐๐ง *
โ SELECT * FROM orders
โ SELECT order_id, customer, amount FROM orders
Pulling everyโฆ
Here's why.
These 5 mistakes slow down queries
more than most people realize.
Fix them once. Never look back.
๐ญ. ๐ฆ๐๐๐๐๐ง *
โ SELECT * FROM orders
โ SELECT order_id, customer, amount FROM orders
Pulling everyโฆ
๐ญ๐ฒ๐ฝ๐๐ผ ๐น๐ผ๐๐ฒ๐ ๐ฅ๐.๐ณ๐ต ๐ผ๐ป ๐ฒ๐๐ฒ๐ฟ๐ ๐ผ๐ฟ๐ฑ๐ฒ๐ฟ. ๐๐๐ธ๐ถ๐ป๐ด ๐ณ๐ผ๐ฟ ๐ฎ ๐ฅ๐.๐ฒ๐ฏ,๐ฌ๐ฌ๐ฌ ๐ฐ๐ฟ๐ผ๐ฟ๐ฒ ๐๐ฎ๐น๐๐ฎ๐๐ถ๐ผ๐ป.
Broke down Zepto's DRHP: the revenue model, the real cost per order, where the actual profit comes from, and the red flags most people are missing.
Also stacked it against DMart's numbers for context.
A DRHP is a public dataset. Learning to read one is a skill most analysts skip.
Read more: https://www.linkedin.com/feed/update/urn:li:share:7488884143083347968/
Broke down Zepto's DRHP: the revenue model, the real cost per order, where the actual profit comes from, and the red flags most people are missing.
Also stacked it against DMart's numbers for context.
A DRHP is a public dataset. Learning to read one is a skill most analysts skip.
Read more: https://www.linkedin.com/feed/update/urn:li:share:7488884143083347968/
โค1
โ
Power BI Interview Questions ๐ฏ๐
1๏ธโฃ What is Power BI?
A Microsoft tool for data visualization, reporting, and business intelligence.
2๏ธโฃ What are the building blocks of Power BI?
โข Datasets
โข Reports
โข Dashboards
โข Tiles
โข Visualizations
3๏ธโฃ Difference between Power BI Desktop and Power BI Service?
โข Desktop: Used to create and design reports
โข Service: Cloud-based platform to share and collaborate
4๏ธโฃ What is Power Query?
A data transformation tool for cleaning and shaping data before loading into the model.
5๏ธโฃ What is DAX?
Data Analysis Expressions โ a formula language used for calculations in Power BI.
6๏ธโฃ What are measures and calculated columns?
โข Measure: Calculated on aggregation (e.g. SUM of sales)
โข Calculated Column: Row-level computation (e.g. profit = revenue - cost)
7๏ธโฃ What is a slicer?
A visual filter that allows users to dynamically filter data on a report.
8๏ธโฃ How do you handle data refresh in Power BI?
โข Schedule refresh via Power BI Service
โข Use gateways for on-prem data sources
9๏ธโฃ What is the difference between direct query and import mode?
โข Import: Data is loaded into Power BI
โข Direct Query: Queries run directly on the source in real time
๐ What is the Power BI Gateway?
A bridge between on-premise data sources and Power BI cloud service.
๐ฌ Tap โค๏ธ for more
1๏ธโฃ What is Power BI?
A Microsoft tool for data visualization, reporting, and business intelligence.
2๏ธโฃ What are the building blocks of Power BI?
โข Datasets
โข Reports
โข Dashboards
โข Tiles
โข Visualizations
3๏ธโฃ Difference between Power BI Desktop and Power BI Service?
โข Desktop: Used to create and design reports
โข Service: Cloud-based platform to share and collaborate
4๏ธโฃ What is Power Query?
A data transformation tool for cleaning and shaping data before loading into the model.
5๏ธโฃ What is DAX?
Data Analysis Expressions โ a formula language used for calculations in Power BI.
6๏ธโฃ What are measures and calculated columns?
โข Measure: Calculated on aggregation (e.g. SUM of sales)
โข Calculated Column: Row-level computation (e.g. profit = revenue - cost)
7๏ธโฃ What is a slicer?
A visual filter that allows users to dynamically filter data on a report.
8๏ธโฃ How do you handle data refresh in Power BI?
โข Schedule refresh via Power BI Service
โข Use gateways for on-prem data sources
9๏ธโฃ What is the difference between direct query and import mode?
โข Import: Data is loaded into Power BI
โข Direct Query: Queries run directly on the source in real time
๐ What is the Power BI Gateway?
A bridge between on-premise data sources and Power BI cloud service.
๐ฌ Tap โค๏ธ for more
Google, PwC, Salesforce, Adobe, IBM, EY.
All hiring. Right now.
August and September are peak hiring months.
https://www.linkedin.com/feed/update/urn:li:activity:7490613808328224768/
All hiring. Right now.
August and September are peak hiring months.
https://www.linkedin.com/feed/update/urn:li:activity:7490613808328224768/
๐๐ก๐ก๐๐ฅ ๐๐ข๐๐ก ๐ถ๐ ๐ป๐ผ๐ ๐๐ต๐ฒ ๐๐ฎ๐ณ๐ฒ ๐ฑ๐ฒ๐ณ๐ฎ๐๐น๐.
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand what each one does to unmatched rows.
Here's the breakdown that actually matters:
https://www.linkedin.com/feed/update/urn:li:share:7490972311278407680/
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand what each one does to unmatched rows.
Here's the breakdown that actually matters:
https://www.linkedin.com/feed/update/urn:li:share:7490972311278407680/
LinkedIn
๐๐ก๐ก๐๐ฅ ๐๐ข๐๐ก ๐ถ๐ ๐ป๐ผ๐ ๐๐ต๐ฒ ๐๐ฎ๐ณ๐ฒ ๐ฑ๐ฒ๐ณ๐ฎ๐๐น๐.
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand whatโฆ
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand whatโฆ
๐๐ก๐ก๐๐ฅ ๐๐ข๐๐ก ๐ถ๐ ๐ป๐ผ๐ ๐๐ต๐ฒ ๐๐ฎ๐ณ๐ฒ ๐ฑ๐ฒ๐ณ๐ฎ๐๐น๐.
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand what each one does to unmatched rows.
Here's the breakdown that actually matters:
๐๐ก๐ก๐๐ฅ ๐๐ข๐๐ก
Returns only matching rows from both tables.โฆ
It's quietly deleting your data.
Most people learn 4 join types.
Very few understand what each one does to unmatched rows.
Here's the breakdown that actually matters:
๐๐ก๐ก๐๐ฅ ๐๐ข๐๐ก
Returns only matching rows from both tables.โฆ
6 parts to a ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐'s job.
AI is already taking some of them.
Not all.
Some.
It will expose weak ones.
https://www.linkedin.com/feed/update/urn:li:share:7492169595961688064/
AI is already taking some of them.
Not all.
Some.
It will expose weak ones.
https://www.linkedin.com/feed/update/urn:li:share:7492169595961688064/
LinkedIn
๐๐ ๐ฝ๐ฟ๐ผ๐ฏ๐ฎ๐ฏ๐น๐ ๐๐ผ๐ป'๐ ๐ฟ๐ฒ๐ฝ๐น๐ฎ๐ฐ๐ฒ ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐๐.
It will expose weak ones.
Nobody is saying this clearly enough.
6 parts to a ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐'sโฆ
It will expose weak ones.
Nobody is saying this clearly enough.
6 parts to a ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐'sโฆ
๐๐ ๐ฝ๐ฟ๐ผ๐ฏ๐ฎ๐ฏ๐น๐ ๐๐ผ๐ป'๐ ๐ฟ๐ฒ๐ฝ๐น๐ฎ๐ฐ๐ฒ ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐๐.
It will expose weak ones.
Nobody is saying this clearly enough.
6 parts to a ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐'s job.
AI is already taking some of them.
Not all.
Some.
Know the difference before it costs you.
โ = AI handles this nowโฆ
It will expose weak ones.
Nobody is saying this clearly enough.
6 parts to a ๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐'s job.
AI is already taking some of them.
Not all.
Some.
Know the difference before it costs you.
โ = AI handles this nowโฆ
โYour resume says you know SQL.
But can you actually think in SQL?โ
This can become a technical + career post.
Give a simple example:
https://www.linkedin.com/feed/update/urn:li:share:7493510053992439809/
But can you actually think in SQL?โ
This can become a technical + career post.
Give a simple example:
https://www.linkedin.com/feed/update/urn:li:share:7493510053992439809/
LinkedIn
"๐ฌ๐ผ๐๐ฟ ๐ฟ๐ฒ๐๐๐บ๐ฒ ๐๐ฎ๐๐ ๐๐ผ๐ ๐ธ๐ป๐ผ๐ ๐ฆ๐ค๐."
But can you actually think in SQL?
Company revenue dropped last month.
A beginner might immediatelyโฆ
But can you actually think in SQL?
Company revenue dropped last month.
A beginner might immediatelyโฆ
"๐ฌ๐ผ๐๐ฟ ๐ฟ๐ฒ๐๐๐บ๐ฒ ๐๐ฎ๐๐ ๐๐ผ๐ ๐ธ๐ป๐ผ๐ ๐ฆ๐ค๐."
But can you actually think in SQL?
Company revenue dropped last month.
A beginner might immediately write a query.
A stronger analyst first asks:
- Is revenue actually down, or is the dataset incomplete?
- Which productsโฆ
But can you actually think in SQL?
Company revenue dropped last month.
A beginner might immediately write a query.
A stronger analyst first asks:
- Is revenue actually down, or is the dataset incomplete?
- Which productsโฆ