Leadle

• Wrote SQL queries to extract data from databases efficiently. Developed, maintained, and optimized SQL Queries and stored procedures.
• Collaborated with RevOps team and maintained live prospects dashboard on Google Looker Studio, connected with Google Sheets
• Prepared and cleaned data for analysis, including data normalization, aggregation, and transformation. (SQL, Excel and Tableau)
• Ensured accurate data by performing thorough validation and quality checks. Worked together with business and data teams to comprehensively grasp the data requirements and objectives.
• Leveraged the power of data visualization using sophisticated tools like Tableau to create captivating and informative reports and dashboards. Presented the findings to stakeholders in a visually engaging and interactive manner, unleashing the full potential of data-driven insights. Translated complex data into clear and understandable visual representations.

Data Analyst

5X your AI & Data Science skills. Get free AI guides and resources ⬇️

Hey, fellow LinkedIn folks, Curious Data Analyst here. I write content on Artificial Intelligence and Data Science. I have experience in SQL, Python, Machine Learning and Tableau. 

I love playing with data and transforming it into powerful insights and beautiful visualizations. 
From data manipulation to storytelling and creating interactive dashboards, I've got you covered : )

Bar chart or pie chart?

How to choose right chart type 🤔 

Check out this amazing #datavisualization guide by Andrew C. Madson

includes:
- How to pick the perfect chart to present insights clearly.
- 15 chart types and their ideal use cases.
- Learn how to avoid common pitfalls
- How to craft impactful visualizations

PS: Share your tips in the comments

----------------------------------------------
📍 Follow ----> Leon Jose 👋

Set the 🔔 notification on my page, don’t miss a post!

#data #dataanalyst

Leon Jose

Data Visualization Guide

Pandas interview questions:

What are the basic data structures in pandas?
How do you create a DataFrame in pandas?
How do you read a CSV file in pandas?
How can you select specific columns from a DataFrame in pandas?
How do you filter rows in a DataFrame based on a condition in pandas?
How do you handle missing values in a DataFrame using pandas?
How do you merge two DataFrames in pandas?
How do you perform groupby operation in pandas?
How do you rename columns in a DataFrame using pandas?
How do you sort a DataFrame by a specific column in pandas?
How do you aggregate data using pandas?
How do you apply a function to each element in a DataFrame in pandas?
How do you perform data visualization using pandas?
How do you handle duplicate data in a DataFrame using pandas?
How do you calculate descriptive statistics for a DataFrame using pandas?
How do you set the index of a DataFrame using pandas?
How do you reset the index of a DataFrame in pandas?
How do you concatenate multiple DataFrames in pandas?
How do you pivot a DataFrame in pandas?
How do you melt a DataFrame in pandas?
How do you calculate the correlation between columns in a DataFrame using pandas?
How do you handle outliers in a DataFrame using pandas?
How do you extract unique values from a column in a DataFrame using pandas?
How do you calculate cumulative sum in a DataFrame using pandas?
How do you convert data types of columns in a DataFrame using pandas?
How do you handle datetime data in a DataFrame using pandas?
How do you resample time-series data in pandas?
How do you merge and append DataFrames with different column names in pandas?
How do you handle multi-level indexing in pandas?
How do you drop columns from a DataFrame in pandas?
How do you create a pivot table in pandas?
How do you calculate rolling statistics in pandas?
How do you concatenate strings in a DataFrame column using pandas?
How do you create a cross-tabulation in pandas?
How do you handle categorical data in pandas?
How do you calculate cumulative percentage in a DataFrame column using pandas?
How do you handle data imputation in pandas?
How do you calculate percentage change in a DataFrame column using pandas?
How do you calculate the rank of values in a DataFrame column using pandas?
How do you calculate the difference between consecutive values in a DataFrame column using pandas?
How do you drop duplicate rows based on a specific column in pandas?
How do you calculate the mean, median, and mode of a DataFrame column using pandas?

𝗕𝗼𝗻𝘂𝘀: Download Pandas Guide for Data Cleaning ⬇
(https://lnkd.in/gZKqbQmn)

---------------------------------------------------
Follow Leon Jose for deep dives into Data Science.

Like 👍 and Repost ♻ if you found this helpful

#pandas #datascience 

71% of Data Scientists use this programming language.

It is not Python!

it's - SQL 👑 

SQL is the language of databases.

➡️ SQL simplifies data retrieval and manipulation. 

🎯 Its SELECT statement, filtering, and sorting capabilities 
make it a helpful tool.

♐ SQL functions like COUNT(), AVG(), and SUM() summarizes and calculates values.

📊 JOIN function combines information from different sources, creating a comprehensive dataset.

👨‍💻 The WHERE clause acts like a data filter, allowing analysts to focus on specific criteria. 

🔰 Analytical functions like WINDOW functions and GROUP BY take SQL for more deeper analysis.

Here's an amazing cheat sheet by Steve Nouri

Follow Leon Jose for more helpful content 👋 

#sql #database #datascience

SQL Cheat Sheet

Complete topics of Excel with subtopics for data analyst interview :

Excel Basics:
- Understanding the Excel interface
- Keyboard shortcuts
- Working with workbooks and worksheets
- Basic functions and formulas
- Formatting data and cells

Data Entry and Data Validation:
- Entering data into Excel
- Using Data Validation to control data input
- Using drop-down lists to select data

Sorting and Filtering Data:
- Sorting data by multiple columns
- Using the Filter function to filter data by multiple criteria
- Advanced filtering techniques such as date range filtering and text filtering

Pivot Tables:
- Creating pivot tables
- Using pivot tables to summarize and analyze data
- Filtering pivot tables
- Formatting pivot tables

Advanced Formulas and Functions:
- IF, SUMIF, COUNTIF, and other conditional functions
- VLOOKUP, XLOOKUP and HLOOKUP functions
- INDEX and MATCH functions
- Working with date and time functions

Charts and Graphs:
- Creating charts and graphs to visualize data
- Selecting the right type of chart for the data
- Formatting charts and graphs

What-If Analysis:
- Using Goal Seek to achieve a desired output
- Using Scenario Manager to compare different scenarios
- Using Solver to find an optimal solution for a problem

Macros:
- Recording macros to automate repetitive tasks
- Writing macros using VBA
- Editing and running macros

Data Cleaning and Transformation:
- Identifying and fixing errors in data
- Using text functions to clean and transform data
- Splitting and combining data using text functions

Advanced Excel Features:
- Conditional Formatting to highlight important data
- Array Formulas to perform complex calculations
- Power Query to transform and load data
- Power Pivot to create advanced data models and calculations

Follow Leon Jose for more such posts 👋 

#interview #dataanalyst #excel

Preparing for data analyst role as a fresher? Not getting calls from recruiters? Here are some tips 💡(according to my experience) -

1. Don't focus much on big company name, as a fresher you should get into industry first. So keep applying to each and every openings.

2. Try to start as an intern data analyst in any company. Usually companies hire freshers as an intern.

3. Start building connections on linkedin. Don't hesitate to ask for referral in companies where you can see that they are hiring. And try to connect with analytics managerial level people.

4. Make your resume attractive. Highlight your project's outputs in bold letters in resume. And try to give some quantitative values as output like "increased ROI by 11℅".

5. As you are a fresher don't take more than one page to make your resume.

6. Make your profile stronger on job portals.
Some famous job portals are - linkedin, naukri, instahyre, iimjobs and indeed etc.

7. Regularly update your profile on naukri in a day. Also re-upload your resume between 8AM - 9 AM.

Let me know in comments if you have anything else to add in the list.

Follow Leon Jose for more such posts 👋 

Like 👍 and Repost ♻ if you found this helpful

#fresher #dataanalyst #jobs

What is the no 1 Data Science skill?

It is not Python.

You guessed wrong, not Statistics!

Machine Learning is cool. But it is not the top data skill.

It's - PROBLEM SOLVING

Why is it number one skill?

1. Identifying Core Issues: Problem-solving begins with the ability to identify the core questions and challenges within a dataset.

2. Formulating Solutions: Once the problem is clear, the data scientist's role is to formulate effective solutions. 

3. Adapting to Challenges: Problem-solving extends beyond the initial analysis to adapting strategies as challenges evolve.

4. Collaboration and Communication: Problem-solving often involves collaboration with stakeholders and proper communication.

5. Continuous Improvement: Data Scientists must continuously refine their problem-solving skills. It's an ongoing process of learning and adapting to new scenarios.

Share your opinion in the comments. 

Follow Leon Jose for more helpful content 👋 

#datascience 

Underfitting VS Overfitting in 𝗠𝗮𝗰𝗵𝗶𝗻𝗲 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴 ▶ 

✅ 𝗨𝗻𝗱𝗲𝗿𝗳𝗶𝘁𝘁𝗶𝗻𝗴: Your model is underfitting the training data when the model performs poorly on the training data.

✅ 𝗢𝘃𝗲𝗿𝗳𝗶𝘁𝘁𝗶𝗻𝗴: When a model performs very well for training data but has poor performance with test data, it is known as overfitting.

👉 How to Spot Underfitting Issues 

- High bias
- Simple model
- Poor performance on all data

👉 How to spot Overfitting Issues 

- High variance
- Complex model
- Poor performance on test data

👉 Techniques to prevent overfitting and underfitting 

- Increase data amount and variety.
- Encourage focus on general patterns.
- Balance simplicity and complexity based on data and task.
- Evaluate performance on unseen data to prevent overfitting.

--------------------------

Follow Leon Jose for deep dives into Data Science 👋 

Set the 🔔 notification on my page, don’t miss a post!

#datascience #machinelearning 

Taplio

Leon Jose's Linkedin Analytics

Leon Jose

Leon Jose's Best Posts (last 30 days)

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Leon Jose's Linkedin Analytics

Leon Jose

Leon Jose's Best Posts .css-qqfgvy{font-size:var(--chakra-fontSizes-md);}(last 30 days)

Want to drive more opportunities from LinkedIn?

Leon Jose's Linkedin Analytics

Leon Jose's Best Posts (last 30 days)