Data Careers Resources & Job Updates | iamrupnath
21.2K subscribers
31 photos
1 video
95 files
2.96K links
๐Ÿ‘‰ Connect LinkedIn :
https://www.linkedin.com/in/rupnath-shaw

Google Search => Techcompreviews
IG: @iamrupnath

Perfect channel for Data Careers, Job Updates

Learn Excel, SQL, Python, Tableau, Power BI, AI tools, AI tips & tricks and many more
Download Telegram
๐Ÿš€ Immediate Joiners Only: Data Engineer | Gurugram / Noida

We're looking for a Data Engineer with expertise in Python/PySpark, Snowflake, SQL, and cloud platforms (AWS/Azure/GCP).

๐Ÿ“ Location: Gurugram / Noida
๐Ÿข Work Mode: Hybrid

Requirements:
โœ… Experience building scalable ETL/ELT pipelines and data warehousing solutions
โœ… Strong data modeling and cloud data engineering skills
๐Ÿ”ด Pharma/Healthcare domain experience is MANDATORY(profiles without Pharma/Healthcare experience will not be considered)
โœ… Strong problem-solving and stakeholder management skills

๐Ÿ“ฉ Interested candidates can share their resume at Charul.chhabra@axtria.com or send me a DM.

https://www.linkedin.com/posts/charul-chhabra-100ab5120_hiring-dataengineer-dataengineering-share-7485562178335305728-Fnky/
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.
๐—œ ๐—ฝ๐—ฟ๐—ฒ๐—ฝ๐—ฎ๐—ฟ๐—ฒ๐—ฑ ๐—ฆ๐—ค๐—Ÿ ๐—ณ๐—ผ๐—ฟ ๐—บ๐˜† ๐—ถ๐—ป๐˜๐—ฒ๐—ฟ๐˜ƒ๐—ถ๐—ฒ๐˜„ ๐—ถ๐—ป ๐Ÿณ ๐—ฑ๐—ฎ๐˜†๐˜€.
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!
๐—ญ๐—ฒ๐—ฝ๐˜๐—ผ ๐—น๐—ผ๐˜€๐—ฒ๐˜€ ๐—ฅ๐˜€.๐Ÿณ๐Ÿต ๐—ผ๐—ป ๐—ฒ๐˜ƒ๐—ฒ๐—ฟ๐˜† ๐—ผ๐—ฟ๐—ฑ๐—ฒ๐—ฟ. ๐—”๐˜€๐—ธ๐—ถ๐—ป๐—ด ๐—ณ๐—ผ๐—ฟ ๐—ฎ ๐—ฅ๐˜€.๐Ÿฒ๐Ÿฏ,๐Ÿฌ๐Ÿฌ๐Ÿฌ ๐—ฐ๐—ฟ๐—ผ๐—ฟ๐—ฒ ๐˜ƒ๐—ฎ๐—น๐˜‚๐—ฎ๐˜๐—ถ๐—ผ๐—ป.

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
๐—œ๐—ก๐—ก๐—˜๐—ฅ ๐—๐—ข๐—œ๐—ก ๐—ถ๐˜€ ๐—ป๐—ผ๐˜ ๐˜๐—ต๐—ฒ ๐˜€๐—ฎ๐—ณ๐—ฒ ๐—ฑ๐—ฒ๐—ณ๐—ฎ๐˜‚๐—น๐˜.
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/