Date: 20-10-2023
Company : Tiger Analytics
Role : Data Analyst
Topic : Tableau extract, tableau parameter, freeze pane, vlookup

1. What is a Tableau extract?
A Tableau extract is a compressed file that contains a subset of data from a larger data source. Extracts can be used to improve performance by reducing the amount of data that needs to be loaded into Tableau. Extracts can be created by selecting the "Extract" option when connecting to a data source, and can be refreshed on a schedule or on demand.

2. What is a Tableau parameter?
A Tableau parameter is a dynamic input that allows users to change the behavior of a visualization. Parameters can be used to create dynamic filters, switch between views, or adjust calculations. Parameters are created by defining a data type, range of allowable values, and a default value. Parameters can be used in calculations, filters, and other parts of a Tableau workbook.

3. What is conditional formatting in Excel?
Conditional formatting allows you to apply formatting rules to cells based on specific conditions, such as highlighting values greater than a certain threshold or applying color scales.

4. What is the purpose of the VLOOKUP function in Excel?
The VLOOKUP function is used to search for a value in the leftmost column of a table and retrieve a corresponding value from a different column within the same row.

————————————————————-

Date: 10-12-2023
Company Name: LinkedIn 
Role: Data Analyst 
Topics asked from: Social Network Analysis, Data Visualization, User Engagement 

Q1: How would you analyze data to understand user connection patterns on a professional network? 

Ans: I'd use graph databases like Neo4j for social network analysis. By analyzing connection patterns, I can identify influencers or isolated communities.

Q2: Describe a challenging data visualization you created to represent user engagement metrics. 

Ans: I visualized multi-dimensional data showing user engagement across features, regions, and time using tools like D3.js, creating an interactive dashboard with drill-down capabilities.

Q3: How would you identify and target passive job seekers on LinkedIn? 

Ans: I'd analyze user behavior patterns, like increased profile updates, frequent visits to job postings, or engagement with career-related content, to identify potential passive job seekers.

Q4: How do you measure the effectiveness of a new feature launched on LinkedIn? 

Ans: I'd set up A/B tests, comparing user engagement metrics between those who have access to the new feature and a control group. I'd then analyze metrics like time spent, feature usage frequency, and overall platform engagement to measure effectiveness.

public static List<Integer> findDistinctDuplicates(int N, int[] arr) {
        HashSet<Integer> seen = new HashSet<>();
        HashSet<Integer> duplicates = new HashSet<>();
        
        for (int num : arr) {
            if (!seen.add(num)) {  
                duplicates.add(num);
            }
        }

        if (duplicates.isEmpty()) {
            // No duplicates found
            return List.of(-1);
        } else {
            // Convert set to list and sort it
            List<Integer> result = new ArrayList<>(duplicates);
            result.sort(null);
            return result;
        }
    }

Array of Duplicate Elements ✅

def is_prime(num):
    if num < 2:
        return False
    for i in range(2, int(num**0.5) + 1):
        if num % i == 0:
            return False
    return True

def nth_prime_number(n):
    count = 0
    candidate = 1

    while count < n:
        candidate += 1
        if is_prime(candidate):
            count += 1

    return candidate

Prime Numbers ✅

Walk in Interviews at Dukaan office, this Saturday.

Type : Full time
Role :  backend developers.
Stack : Python (Django) and NodeJs

Freshers must have proof of work (Working projects).

https://x.com/subhashchy/status/1735234217142010069?t=aaIdM3BLv6Hgbfet9o-QGQ&s=35

Zappian is hiring for Intern role (2024 and 2025 grads can apply)

Link to apply: https://career.zappian.com/

Give.do is hiring for Analyst role (0-1 year of experience)

https://docs.google.com/forms/d/e/1FAIpQLScumc_PLlTNZLfmr5oih9TQbgwJpnnbpQjZeQLXnZ42cW35Gw/viewform

Work is purely based on SQL, only apply if you have decent knowledge of SQL

One of the candidate from this group got offer letter ✌🏻

Accenture is Hiring for a premium process

#walkindrive at Gurgaon for fresher

Hiring Criteria:

Exp - 0 -1yrs
Shift - 24x7 with 5days working
Qualification - Graduates/Post Graduates (Non-tech)

Date - 18-Dec at 11AM
Venue - Accenture DDC5, Building No.7, Candor Tech Space, Kapashera-samalkha road, Sector-21, Gurugram

Contact :  harjit.a.kaur@accenture.com

Any one interested send your resume @sachdevlaksh

️

------ Internships ------

🔷 Company Name - Ripple
🎓 Batch - 2024
💎 Job Type - Hiring
🏠 Location - Bengaluru
🔗 Apply Link - https://ripple.com/careers/all-jobs/job/5568637/?gh_jid=5568637&gh_src=79e001831us

Wealthy is hiring SDE -> Backend

https://www.linkedin.com/posts/vijay-kumar-15253b186_wealthyis-hiring-sde-backend-responsibilities-activity-7141635785136422912-nEQy?utm_source=share&utm_medium=member_ios

❗️ Amazon Off Campus Drive Hiring As Customer Service Associate | 2.4 LPA ❗️

👨‍💻Job Role : Customer Service Associate
🎓Qualification : Any Degree
🎖Experience : Freshers
💰Salary : 2.4 LPA

⭕️ Apply Fast : https://csalgo.us/2023/12/16/amazon-off-campus-drive-customer-service-associate/