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โฆ
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐e๐ฟ:
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee Department Salary
John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000
How would you find the second highest salary in the IT department?
๐ ๐ฒ: Challenge accepted! ๐ช
=LARGE(FILTER(C2:C6,B2:B6="IT"),2)
๐ก Explanation:
This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.
- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.
The result is 75,000.
This challenge tests your understanding of: โ FILTER()
โ LARGE()
โ Conditional Filtering
โ Combining Excel Functions
๐ Bonus (Without FILTER)
For older Excel versions, you can use:
=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)
Here:
14 represents LARGE.
6 ignores errors.
B2:B6="IT" filters the calculation to the IT department.
2 returns the second largest value.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
You have 2 minutes to solve this Excel problem.
You have the following data:
Employee Department Salary
John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000
How would you find the second highest salary in the IT department?
๐ ๐ฒ: Challenge accepted! ๐ช
=LARGE(FILTER(C2:C6,B2:B6="IT"),2)
๐ก Explanation:
This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.
- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.
The result is 75,000.
This challenge tests your understanding of: โ FILTER()
โ LARGE()
โ Conditional Filtering
โ Combining Excel Functions
๐ Bonus (Without FILTER)
For older Excel versions, you can use:
=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)
Here:
14 represents LARGE.
6 ignores errors.
B2:B6="IT" filters the calculation to the IT department.
2 returns the second largest value.
โค๏ธ React with โค๏ธ for more Excel interview challenges!
Notion is hiring Software Engineer (Developer Expereince)
For 2015, 2016, 2017 grads
Location: Hyderabad
https://jobs.ashbyhq.com/notion/49bdf081-6e20-4323-8c73-6d6b19544ff5
For 2015, 2016, 2017 grads
Location: Hyderabad
https://jobs.ashbyhq.com/notion/49bdf081-6e20-4323-8c73-6d6b19544ff5
Ashbyhq
Software Engineer, Developer Experience
WHO WE ARE
Notion is the collaborative AI workspace where teams and agents think together https://www.youtube.com/watch?v=vkpYpWfEK5s. We're building one place where your knowledge, projects, meetings, and AI tools live side by side, so work is faster, clearerโฆ
Notion is the collaborative AI workspace where teams and agents think together https://www.youtube.com/watch?v=vkpYpWfEK5s. We're building one place where your knowledge, projects, meetings, and AI tools live side by side, so work is faster, clearerโฆ
Arcadis is hiring Graduate Engineer
For 2022, 2023, 2024, 2025 grads
Location: Bangalore
https://jobs.arcadis.com/careers/job/563671532643966?domain=arcadis.com
For 2022, 2023, 2024, 2025 grads
Location: Bangalore
https://jobs.arcadis.com/careers/job/563671532643966?domain=arcadis.com