Shakra Shamim

Done with watching videos of SQL? But don't know where to practice SQL? So let me help you in this, Here are 7 websites where you can practice SQL skills:-

1. https://datalemur.com/

2. https://leetcode.com/

3. https://sqlpad.io/

4. https://mode.com/

5. https://lnkd.in/eRCPSmEz

6. https://lnkd.in/eMggeJFV

7. https://lnkd.in/er_bBtRY

🔵 Follow Shakra Shamim for more such posts.

#sql #dataanalyst

🔷 Complete MS Excel (Topic Wise) for data analyst role -

🔹 Basic functions: SUM, AVERAGE, MIN, MAX, COUNT, and COUNTIF etc.

🔹VLOOKUP, HLOOKUP and XLOOKUP: Using these functions to look up data in tables.

🔹Pivot tables: Creating and manipulating pivot tables, formatting pivot tables, and using slicers.

🔹Data cleaning and transformation: Removing duplicates, data sorting and filtering, and using text functions (LEFT, RIGHT, MID, CONCATENATE, etc.).

🔹Conditional formatting: Applying colors, data bars, and icons based on specific conditions.

🔹Charts and graphs: Creating and customizing charts and graphs (bar, line, pie, scatter, etc.).

🔹Macros: Recording and running macros to automate repetitive tasks.

🔹Data validation: Creating drop-down lists and using custom validation rules.

🔹Statistical analysis: Basic statistical functions (STDEV, CORREL, etc.) and using data analysis add-ins (Regression, ANOVA, etc.).

🔹Formula auditing: Tracing formula precedents and dependents, and using the Evaluate Formula tool.

Follow Shakra Shamim for more such posts.

#excel  #dataanalyst

Not just #ChatGPT!! Here is the list of AI tools, which can help in many ways!!



Follow Shakra Shamim for content related to data analyst interview preparation!!

#AI #ML

Dear Hiring Managers!

Give chances, like someone did for you. It makes a difference.

Hire for potential, not just past achievements. The best fit might have a short resume but lots to offer. Job gaps are okay. Look at skills gained, not just time off.

Rethink entry-level requirements. Skip the 2-3 year's experience demand. Focus on potential and eagerness to learn. In short, it's about promise and passion, not years on a resume. Build teams valuing diversity, creativity, and a shared commitment to growth.

#Hiring #Job_seeker