Complete roadmap to learn data science in 2024 ๐๐
1. Learn the Basics:
- Brush up on your mathematics, especially statistics.
- Familiarize yourself with programming languages like Python or R.
- Understand basic concepts in databases and data manipulation.
2. Programming Proficiency:
- Develop strong programming skills, particularly in Python or R.
- Learn data manipulation libraries (e.g., Pandas) and visualization tools (e.g., Matplotlib, Seaborn).
3. Statistics and Mathematics:
- Deepen your understanding of statistical concepts.
- Explore linear algebra and calculus, especially for machine learning.
4. Data Exploration and Preprocessing:
- Practice exploratory data analysis (EDA) techniques.
- Learn how to handle missing data and outliers.
5. Machine Learning Fundamentals:
- Understand basic machine learning algorithms (e.g., linear regression, decision trees).
- Learn how to evaluate model performance.
6. Advanced Machine Learning:
- Dive into more complex algorithms (e.g., SVM, neural networks).
- Explore ensemble methods and deep learning.
7. Big Data Technologies:
- Familiarize yourself with big data tools like Apache Hadoop and Spark.
- Learn distributed computing concepts.
8. Feature Engineering and Selection:
- Master techniques for creating and selecting relevant features in your data.
9. Model Deployment:
- Understand how to deploy machine learning models to production.
- Explore containerization and cloud services.
10. Version Control and Collaboration:
- Use version control systems like Git.
- Collaborate with others using platforms like GitHub.
11. Stay Updated:
- Keep up with the latest developments in data science and machine learning.
- Participate in online communities, read research papers, and attend conferences.
12. Build a Portfolio:
- Showcase your projects on platforms like GitHub.
- Develop a portfolio demonstrating your skills and expertise.
Resources for Projects
https://t.me/codingdidi
ENJOY LEARNING ๐๐
1. Learn the Basics:
- Brush up on your mathematics, especially statistics.
- Familiarize yourself with programming languages like Python or R.
- Understand basic concepts in databases and data manipulation.
2. Programming Proficiency:
- Develop strong programming skills, particularly in Python or R.
- Learn data manipulation libraries (e.g., Pandas) and visualization tools (e.g., Matplotlib, Seaborn).
3. Statistics and Mathematics:
- Deepen your understanding of statistical concepts.
- Explore linear algebra and calculus, especially for machine learning.
4. Data Exploration and Preprocessing:
- Practice exploratory data analysis (EDA) techniques.
- Learn how to handle missing data and outliers.
5. Machine Learning Fundamentals:
- Understand basic machine learning algorithms (e.g., linear regression, decision trees).
- Learn how to evaluate model performance.
6. Advanced Machine Learning:
- Dive into more complex algorithms (e.g., SVM, neural networks).
- Explore ensemble methods and deep learning.
7. Big Data Technologies:
- Familiarize yourself with big data tools like Apache Hadoop and Spark.
- Learn distributed computing concepts.
8. Feature Engineering and Selection:
- Master techniques for creating and selecting relevant features in your data.
9. Model Deployment:
- Understand how to deploy machine learning models to production.
- Explore containerization and cloud services.
10. Version Control and Collaboration:
- Use version control systems like Git.
- Collaborate with others using platforms like GitHub.
11. Stay Updated:
- Keep up with the latest developments in data science and machine learning.
- Participate in online communities, read research papers, and attend conferences.
12. Build a Portfolio:
- Showcase your projects on platforms like GitHub.
- Develop a portfolio demonstrating your skills and expertise.
Resources for Projects
https://t.me/codingdidi
ENJOY LEARNING ๐๐
Telegram
@Codingdidi
Free learning Resources For Data Analysts, Data science, ML, AI, GEN AI and Job updates, career growth, Tech updates
๐9โค4
Complete Python topics required for the Data Engineer role:
โค ๐๐ฎ๐๐ถ๐ฐ๐ ๐ผ๐ณ ๐ฃ๐๐๐ต๐ผ๐ป:
- Python Syntax
- Data Types
- Lists
- Tuples
- Dictionaries
- Sets
- Variables
- Operators
- Control Structures:
- if-elif-else
- Loops
- Break & Continue try-except block
- Functions
- Modules & Packages
โค ๐ฃ๐ฎ๐ป๐ฑ๐ฎ๐:
- What is Pandas & imports?
- Pandas Data Structures (Series, DataFrame, Index)
- Working with DataFrames:
-> Creating DFs
-> Accessing Data in DFs Filtering & Selecting Data
-> Adding & Removing Columns
-> Merging & Joining in DFs
-> Grouping and Aggregating Data
-> Pivot Tables
- Input/Output Operations with Pandas:
-> Reading & Writing CSV Files
-> Reading & Writing Excel Files
-> Reading & Writing SQL Databases
-> Reading & Writing JSON Files
-> Reading & Writing - Text & Binary Files
โค ๐ก๐๐บ๐ฝ๐:
- What is NumPy & imports?
- NumPy Arrays
- NumPy Array Operations:
- Creating Arrays
- Accessing Array Elements
- Slicing & Indexing
- Reshaping, Combining & Arrays
- Arithmetic Operations
- Broadcasting
- Mathematical Functions
- Statistical Functions
โค ๐๐ฎ๐๐ถ๐ฐ๐ ๐ผ๐ณ ๐ฃ๐๐๐ต๐ผ๐ป, ๐ฃ๐ฎ๐ป๐ฑ๐ฎ๐, ๐ก๐๐บ๐ฝ๐ are more than enough for Data Engineer role.
โค ๐๐ฎ๐๐ถ๐ฐ๐ ๐ผ๐ณ ๐ฃ๐๐๐ต๐ผ๐ป:
- Python Syntax
- Data Types
- Lists
- Tuples
- Dictionaries
- Sets
- Variables
- Operators
- Control Structures:
- if-elif-else
- Loops
- Break & Continue try-except block
- Functions
- Modules & Packages
โค ๐ฃ๐ฎ๐ป๐ฑ๐ฎ๐:
- What is Pandas & imports?
- Pandas Data Structures (Series, DataFrame, Index)
- Working with DataFrames:
-> Creating DFs
-> Accessing Data in DFs Filtering & Selecting Data
-> Adding & Removing Columns
-> Merging & Joining in DFs
-> Grouping and Aggregating Data
-> Pivot Tables
- Input/Output Operations with Pandas:
-> Reading & Writing CSV Files
-> Reading & Writing Excel Files
-> Reading & Writing SQL Databases
-> Reading & Writing JSON Files
-> Reading & Writing - Text & Binary Files
โค ๐ก๐๐บ๐ฝ๐:
- What is NumPy & imports?
- NumPy Arrays
- NumPy Array Operations:
- Creating Arrays
- Accessing Array Elements
- Slicing & Indexing
- Reshaping, Combining & Arrays
- Arithmetic Operations
- Broadcasting
- Mathematical Functions
- Statistical Functions
โค ๐๐ฎ๐๐ถ๐ฐ๐ ๐ผ๐ณ ๐ฃ๐๐๐ต๐ผ๐ป, ๐ฃ๐ฎ๐ป๐ฑ๐ฎ๐, ๐ก๐๐บ๐ฝ๐ are more than enough for Data Engineer role.
๐29โค6๐2๐1
Hiring for Computer Vision Professionals with the below skills
Required Skills :-
(i) 4 to 7 years of experience in Image processing and image analytics with computational capabilities, Scalable CV architecture with strong understanding of Image acquisition system (Camera, Lighting etc).
(ii) Tech Enthusiastic with signs of continuous learning of industry best practices in the domain of Image / Video processing.
(iii) Minimum 2 to 5 years of experience in C++ development.
Mandatory Skills :-
(i) C++
(ii) OpenCV
(iii) Keras, Tensorflow, Pytorch, Scikit-learn, Scikit-image
Interested candidates can share their profiles on the below email IDs,
omnishishankar.mishra@neilsoft.com
abhijeet.gupte@neilsoft.com
vaishnavi.rakhunde@neilsoft.com
Required Skills :-
(i) 4 to 7 years of experience in Image processing and image analytics with computational capabilities, Scalable CV architecture with strong understanding of Image acquisition system (Camera, Lighting etc).
(ii) Tech Enthusiastic with signs of continuous learning of industry best practices in the domain of Image / Video processing.
(iii) Minimum 2 to 5 years of experience in C++ development.
Mandatory Skills :-
(i) C++
(ii) OpenCV
(iii) Keras, Tensorflow, Pytorch, Scikit-learn, Scikit-image
Interested candidates can share their profiles on the below email IDs,
omnishishankar.mishra@neilsoft.com
abhijeet.gupte@neilsoft.com
vaishnavi.rakhunde@neilsoft.com
๐7โค1
How to enter into Data Science
๐Start with the basics: Learn programming languages like Python and R to master data analysis and machine learning techniques. Familiarize yourself with tools such as TensorFlow, sci-kit-learn, and Tableau to build a strong foundation.
๐Choose your target field: From healthcare to finance, marketing, and more, data scientists play a pivotal role in extracting valuable insights from data. You should choose which field you want to become a data scientist in and start learning more about it.
๐Build a portfolio: Start building small projects and add them to your portfolio. This will help you build credibility and showcase your skills.
๐Start with the basics: Learn programming languages like Python and R to master data analysis and machine learning techniques. Familiarize yourself with tools such as TensorFlow, sci-kit-learn, and Tableau to build a strong foundation.
๐Choose your target field: From healthcare to finance, marketing, and more, data scientists play a pivotal role in extracting valuable insights from data. You should choose which field you want to become a data scientist in and start learning more about it.
๐Build a portfolio: Start building small projects and add them to your portfolio. This will help you build credibility and showcase your skills.
๐13โค1
๐๐จ๐ฐ ๐ญ๐จ ๐๐ง๐ญ๐ซ๐จ๐๐ฎ๐๐ ๐๐จ๐ฎ๐ซ๐ฌ๐๐ฅ๐ ๐ข๐ง ๐ ๐๐ก๐จ๐ง๐ ๐๐ง๐ญ๐๐ซ๐ฏ๐ข๐๐ฐ? [ Part-1]
๐๐: Hello, am I speaking with [Your Name]?
[Your Name]: Yes, this is [Your Name] speaking.
[Your Name]: May I know who is calling, please?
๐๐: Hi [Your Name], this is [HR's Name] from XYZ Company.
๐๐: I'm calling because you applied for the Data Analyst role at our company.
[Your Name]: Yes, that's correct. Thank you for reaching out.
๐๐: [Your Name], could you tell me a bit about yourself?
[Your Name]: Sure! I recently graduated with a bachelor's degree in [Your Degree] from [Your University]. During my studies, I developed a strong interest in data analytics, particularly in how data can drive decision-making and improve business outcomes.
In college, I took courses in statistics, data visualization, and programming, which gave me a solid foundation in data analytics concepts. I also completed an internship at [Internship Company], where I worked on [specific project or task], honing my skills in data analysis and gaining hands-on experience with tools like Excel, SQL, and Python.
Now, I'm eager to apply my knowledge and skills in a professional setting and contribute to XYZ Company's success. I'm particularly drawn to your company's innovative approach to [specific area related to the company's work] and believe that my background and enthusiasm for data analytics would make me a valuable addition to your team.
๐๐: That sounds great, [Your Name]! Thank you for sharing.
[Your Name]: Thank you for giving me the opportunity!
Like this post if you want me to continue this ๐โค๏ธ
๐๐: Hello, am I speaking with [Your Name]?
[Your Name]: Yes, this is [Your Name] speaking.
[Your Name]: May I know who is calling, please?
๐๐: Hi [Your Name], this is [HR's Name] from XYZ Company.
๐๐: I'm calling because you applied for the Data Analyst role at our company.
[Your Name]: Yes, that's correct. Thank you for reaching out.
๐๐: [Your Name], could you tell me a bit about yourself?
[Your Name]: Sure! I recently graduated with a bachelor's degree in [Your Degree] from [Your University]. During my studies, I developed a strong interest in data analytics, particularly in how data can drive decision-making and improve business outcomes.
In college, I took courses in statistics, data visualization, and programming, which gave me a solid foundation in data analytics concepts. I also completed an internship at [Internship Company], where I worked on [specific project or task], honing my skills in data analysis and gaining hands-on experience with tools like Excel, SQL, and Python.
Now, I'm eager to apply my knowledge and skills in a professional setting and contribute to XYZ Company's success. I'm particularly drawn to your company's innovative approach to [specific area related to the company's work] and believe that my background and enthusiasm for data analytics would make me a valuable addition to your team.
๐๐: That sounds great, [Your Name]! Thank you for sharing.
[Your Name]: Thank you for giving me the opportunity!
Like this post if you want me to continue this ๐โค๏ธ
๐43โค10๐ฅ6
Company: Gainwell Technologies!
Position: Data Analyst
Experienc๏ปฟe: Freshers/ Experienced
https://jobs.gainwelltechnologies.com/job/Bangalore-Data-Analyst-KA-560100/1150924900/
Position: Data Analyst
Experienc๏ปฟe: Freshers/ Experienced
https://jobs.gainwelltechnologies.com/job/Bangalore-Data-Analyst-KA-560100/1150924900/
โค4๐3
One day or Day one. You decide.
Data Science edition.
๐ข๐ป๐ฒ ๐๐ฎ๐ : I will learn SQL.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Download mySQL Workbench.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will build my projects for my portfolio.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Look on Kaggle for a dataset to work on.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will master statistics.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Start the free Khan Academy Statistics and Probability course.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will learn to tell stories with data.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Install Tableau Public and create my first chart.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will become a Data Scientist.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Update my resume and apply to some Data Science job postings.
Data Science edition.
๐ข๐ป๐ฒ ๐๐ฎ๐ : I will learn SQL.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Download mySQL Workbench.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will build my projects for my portfolio.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Look on Kaggle for a dataset to work on.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will master statistics.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Start the free Khan Academy Statistics and Probability course.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will learn to tell stories with data.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Install Tableau Public and create my first chart.
๐ข๐ป๐ฒ ๐๐ฎ๐: I will become a Data Scientist.
๐๐ฎ๐ ๐ข๐ป๐ฒ: Update my resume and apply to some Data Science job postings.
๐15โค6
Here's the good news for you all .!
I'm starting two series on my Instagram channel from Wednesday 24th July.
1. SQL - reel will be at 11:00 am
2. Statistics -- reel will be posted at 6:30 pm
I need your support to make it โ ๐ more engaging.
I'm starting two series on my Instagram channel from Wednesday 24th July.
1. SQL - reel will be at 11:00 am
2. Statistics -- reel will be posted at 6:30 pm
I need your support to make it โ ๐ more engaging.
๐27โค5
Another good news is
From coming weekend
โ Starting a logic building series on yt
โ Along with the tableau series.
Let me know what you think or if there's something you wanna add on.
From coming weekend
โ Starting a logic building series on yt
โ Along with the tableau series.
Let me know what you think or if there's something you wanna add on.
โค5๐2
Swiss Re is hiring!
Position: Data Analyst
Qualification: Bachelorโs/ Masterโs Degree
Salary: 8 LPA (Expected)
Experienc๏ปฟe: Freshers/ Experienced
Location: Bangalore, India
๐Apply Now: https://careers.swissre.com/job/Bangalore-Data-Analyst-KA/1050003301/
Like for more โค๏ธ
All the best ๐ ๐
Position: Data Analyst
Qualification: Bachelorโs/ Masterโs Degree
Salary: 8 LPA (Expected)
Experienc๏ปฟe: Freshers/ Experienced
Location: Bangalore, India
๐Apply Now: https://careers.swissre.com/job/Bangalore-Data-Analyst-KA/1050003301/
Like for more โค๏ธ
All the best ๐ ๐
๐7
Below is a list of companies that are offering internships in the United Kingdom:
SLB โ Data Science Intern
Tencent โ NLP Research Intern
Cohere โ Research Intern
Viridien โ ML Intern
Tencent โ Data Product Intern
Watchfinder โ Data Engineer Intern
SLB โ Data Science Intern
Tencent โ NLP Research Intern
Cohere โ Research Intern
Viridien โ ML Intern
Tencent โ Data Product Intern
Watchfinder โ Data Engineer Intern
๐3โค2
-------------Day-1 SQL----------
SQL is a standard language for accessing and manipulating databases.
โ What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
โ What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can set permissions on tables, procedures, and views
โ โ What Is a SQL Dialect, and Which one Should You Learn?
-----MySQL-----
MySQL is often compared to a handy free tool you might find in a toolbox. Imagine having a gadget that doesn't come with a price tag, yet is loved and recommended by many. That's MySQL for the digital world.
https://www.instagram.com/reel/C9y0R6uyXxw/?igsh=dW5zZGNxbmRkcXUw
Like for moreโค๏ธ๐
Happy learning ๐!
SQL is a standard language for accessing and manipulating databases.
โ What is SQL?
- SQL stands for Structured Query Language
- SQL lets you access and manipulate databases
- SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
โ What Can SQL do?
- SQL can execute queries against a database
- SQL can retrieve data from a database
- SQL can insert records in a database
- SQL can update records in a database
- SQL can delete records from a database
- SQL can create new databases
- SQL can create new tables in a database
- SQL can create stored procedures in a database
- SQL can create views in a database
- SQL can set permissions on tables, procedures, and views
โ โ What Is a SQL Dialect, and Which one Should You Learn?
-----MySQL-----
MySQL is often compared to a handy free tool you might find in a toolbox. Imagine having a gadget that doesn't come with a price tag, yet is loved and recommended by many. That's MySQL for the digital world.
https://www.instagram.com/reel/C9y0R6uyXxw/?igsh=dW5zZGNxbmRkcXUw
Like for moreโค๏ธ๐
Happy learning ๐!
โค26๐13๐ฅฐ2
-------- Day-1 Statistics ---
Day-1 Statistics
โ What is statistics?
Statistics is the study of the collection, analysis, interpretation, presentation, and organization of data. In other words, it is a mathematical discipline to collect, summarize data. Also, we can say that statistics is a branch of applied mathematics.
โ Why study statistics?
statistics is one of the most important things that you can study.
To be more specific, here are some claims that we have heard on several occasions. (We are not saying that each one of these claims is true!)
- 4 out of 5 dentists recommend Dentine.
- Almost 85% of lung cancers in men and 45% in women are tobacco-related.
- People tend to be more persuasive when they look others directly in the eye and speak loudly and quickly.
- Women make 75 cents to every dollar a man makes when they work the same job.
โ Common terms in Statistics!
1. Population
A population is a selected individual or group representing the full set of members of a certain group of interest.
2. Sample
A sample is a subset drawn from a larger population. If this drawing is accomplished in such a manner that each member of the population has an equitable chance of selection, the result is referred to as a random sample.
3. Parameters
A parameter is a value which is generated from a population. If I had all the data of all humans on Earth and generated the mean age, this value would be a parameter.
4. Statistics ๐
A statistic is a value which is generated from a sample
https://www.instagram.com/reel/C9zmyXfyJa1/?igsh=bm1ncWxvMnVkZWhx
Like for more!
And don't forget to comment ๐
Day-1 Statistics
โ What is statistics?
Statistics is the study of the collection, analysis, interpretation, presentation, and organization of data. In other words, it is a mathematical discipline to collect, summarize data. Also, we can say that statistics is a branch of applied mathematics.
โ Why study statistics?
statistics is one of the most important things that you can study.
To be more specific, here are some claims that we have heard on several occasions. (We are not saying that each one of these claims is true!)
- 4 out of 5 dentists recommend Dentine.
- Almost 85% of lung cancers in men and 45% in women are tobacco-related.
- People tend to be more persuasive when they look others directly in the eye and speak loudly and quickly.
- Women make 75 cents to every dollar a man makes when they work the same job.
โ Common terms in Statistics!
1. Population
A population is a selected individual or group representing the full set of members of a certain group of interest.
2. Sample
A sample is a subset drawn from a larger population. If this drawing is accomplished in such a manner that each member of the population has an equitable chance of selection, the result is referred to as a random sample.
3. Parameters
A parameter is a value which is generated from a population. If I had all the data of all humans on Earth and generated the mean age, this value would be a parameter.
4. Statistics ๐
A statistic is a value which is generated from a sample
https://www.instagram.com/reel/C9zmyXfyJa1/?igsh=bm1ncWxvMnVkZWhx
Like for more!
And don't forget to comment ๐
๐8โค3๐ฅ1
---------Day-2 of SQL-------------
โ What is a Database?
- Definition: A database is an organized collection of structured information or data, typically stored electronically in a computer system.
- Purpose: Databases are used to store, manage, and retrieve data efficiently.
โ What is DBMS?
- Definition: DBMS (Database Management System) is software that interacts with end-users, applications, and the database itself to capture and analyze data.
- Function: It provides a systematic way to create, retrieve, update, and manage data.
โ Features of DBMS
1. Data Integrity: Ensures accuracy and consistency of data.
2. Data Security: Protects data from unauthorized access.
3. Data Recovery: Provides mechanisms for data backup and recovery.
4. Data Independence: Separates data from application programs.
5. Concurrency Control: Manages simultaneous data access by multiple users.
6. Data Management: Facilitates data storage, retrieval, and update.
โ How Can We Interact with DBMS?
- SQL (Structured Query Language): The most common language used to interact with a DBMS for querying, updating, and managing data.
- Database Interfaces: Tools and applications (e.g., phpMyAdmin, pgAdmin) that provide a graphical interface to interact with the database.
- APIs: Application Programming Interfaces that allow software applications to interact with the DBMS programmatically.
โ What is a Query and Why is it Used?
- Definition: A query is a request for data or information from a database table or combination of tables.
- Purpose: Used to extract specific data by filtering, sorting, and presenting it based on certain conditions.
Example of a Query on Amazon
Extracting product details for all items in the "Electronics" category with ratings above 4 stars.
- SQL Example:
- Usage: This query helps Amazon identify and display high-rated electronic products to customers, enhancing user experience and satisfaction.
https://www.instagram.com/reel/C91ZVGZyjyq/?igsh=MWJjaml1N3ZvdGd2dQ==
Like for more posts like these and drop your question on Instagram reel.
โ What is a Database?
- Definition: A database is an organized collection of structured information or data, typically stored electronically in a computer system.
- Purpose: Databases are used to store, manage, and retrieve data efficiently.
โ What is DBMS?
- Definition: DBMS (Database Management System) is software that interacts with end-users, applications, and the database itself to capture and analyze data.
- Function: It provides a systematic way to create, retrieve, update, and manage data.
โ Features of DBMS
1. Data Integrity: Ensures accuracy and consistency of data.
2. Data Security: Protects data from unauthorized access.
3. Data Recovery: Provides mechanisms for data backup and recovery.
4. Data Independence: Separates data from application programs.
5. Concurrency Control: Manages simultaneous data access by multiple users.
6. Data Management: Facilitates data storage, retrieval, and update.
โ How Can We Interact with DBMS?
- SQL (Structured Query Language): The most common language used to interact with a DBMS for querying, updating, and managing data.
- Database Interfaces: Tools and applications (e.g., phpMyAdmin, pgAdmin) that provide a graphical interface to interact with the database.
- APIs: Application Programming Interfaces that allow software applications to interact with the DBMS programmatically.
โ What is a Query and Why is it Used?
- Definition: A query is a request for data or information from a database table or combination of tables.
- Purpose: Used to extract specific data by filtering, sorting, and presenting it based on certain conditions.
Example of a Query on Amazon
Scenario
Extracting product details for all items in the "Electronics" category with ratings above 4 stars.
- SQL Example:
SELECT product_name, price, rating
FROM products
WHERE category = 'Electronics' AND rating > 4;
- Usage: This query helps Amazon identify and display high-rated electronic products to customers, enhancing user experience and satisfaction.
https://www.instagram.com/reel/C91ZVGZyjyq/?igsh=MWJjaml1N3ZvdGd2dQ==
Like for more posts like these and drop your question on Instagram reel.
๐8โค5
Those who are looking for the tutorials to learn tableau!!
Check out the video ๐ธ ๐๐
https://yt.openinapp.co/l3963
Check out the video ๐ธ ๐๐
https://yt.openinapp.co/l3963
yt.openinapp.co
Introduction to Tableau | How Tableau Works | Tableau Courses | codingdidi
๐ Introduction to Tableau | How Tableau Works | Tableau Courses | codingdidi In this engaging and informative video, we dive into the fascinating world of Tableauโa powerful data visualization tool trusted by companies like Amazon and Unilever. Whether youโreโฆ
๐ Day-2 of statistics ๐
Read caption and join telegram channel.
๐๐ป๐๐ป Statistics have majorly categorised into two types:
โ Descriptive statistics
โ Inferential statistics
๐Descriptive Statistics
In this type of statistics, the data is summarised through the given observations. The summarisation is one from a sample of population using parameters such as the mean or standard deviation.
Descriptive statistics is a way to organise, represent and describe a collection of data using tables, graphs, and summary measures. For example, the collection of people in a city using the internet or using Television.
๐ Inferential Statistics
This type of statistics is used to interpret the meaning of Descriptive statistics. That means once the data has been collected, analysed and summarised then we use these stats to describe the meaning of the collected data. Or we can say, it is used to draw conclusions from the data that depends on random variations such as observational errors, sampling variation, etc.
Read caption and join telegram channel.
๐๐ป๐๐ป Statistics have majorly categorised into two types:
โ Descriptive statistics
โ Inferential statistics
๐Descriptive Statistics
In this type of statistics, the data is summarised through the given observations. The summarisation is one from a sample of population using parameters such as the mean or standard deviation.
Descriptive statistics is a way to organise, represent and describe a collection of data using tables, graphs, and summary measures. For example, the collection of people in a city using the internet or using Television.
๐ Inferential Statistics
This type of statistics is used to interpret the meaning of Descriptive statistics. That means once the data has been collected, analysed and summarised then we use these stats to describe the meaning of the collected data. Or we can say, it is used to draw conclusions from the data that depends on random variations such as observational errors, sampling variation, etc.
๐3โค1
