Posts

Showing posts from February, 2023

Business Analysis - Resources

Image
If you're looking to learn Business Analysis, 𝐘𝐨𝐮𝐓𝐮𝐛𝐞 is a great place to start with as it is a great source of free videos that can help you learn BA skills and increase your knowledge. I have compiled some very useful 𝐲𝐨𝐮𝐭𝐮𝐛𝐞 𝐯𝐢𝐝𝐞𝐨𝐬 in a sequential manner. Do watch the videos in sequence and tag me if it helped you. 1. Software Development Life Cycle: https://lnkd.in/g5sj7uYX 2. Role of Business Analyst in each phase of SDLC: https://lnkd.in/gJ6ymEU2 3. Difference between Agile and Waterfall: https://lnkd.in/gAhQ55yQ 4. Understanding Scope of the Project: https://lnkd.in/gt4iawKt 5. How to create Use Case Diagram for Scope Modelling: https://lnkd.in/gS3UkGGd 6. Stakeholder Analysis and Mapping: https://lnkd.in/gaHFpxYR 7. Types of Requirements: https://lnkd.in/gzmjJFPQ 8. Difference between Functional and Non-Functional Requirements: https://lnkd.in/garfYP8h 9. How To Gather Requirements: https://lnkd.in/g4khWeMY 10. Business Process Flow Modelling: https://ln...

SQL - Cheat sheet

Image
99% of the SQL you write as a data analyst is not complex. Most of it comes from a short list of simple skills. Here is cheat sheet I assembled of must know SQL for analytics… SELECT: The foundation of all SQL queries - Allows you to retrieve the data - Choose the columns you want to display in the SELECT statement - Separate columns with a comma WHERE: Filter your results based on criteria - AND - OR - NOT - IN (list) - =, <, >, etc. GROUP BY: Group rows that have the same values and aggregate data using aggregate functions - COUNT - SUM - AVG - MIN - MAX JOINS: Combine data from multiple tables to form a single output - INNER JOIN - LEFT JOIN   CASE WHEN: Allows you to perform conditional logic - Example: CASE WHEN animal_type = 'Lion' THEN 'Carnivore' WHEN animal_type = 'Giraffe' THEN 'Herbivore' ELSE 'Omnivore' END AS diet_type WINDOW FUNCTIONS: Perform calculations across rows rather than just within a group by - ROW_NUMBER - RANK - DE...