Data Analytics & AI | SQL Interviews | Power BI Resources
25.2K subscribers
304 photos
2 videos
151 files
316 links
๐Ÿ”“Explore the fascinating world of Data Analytics & Artificial Intelligence

๐Ÿ’ป Best AI tools, free resources, and expert advice to land your dream tech job.

Admin: @coderfun
Download Telegram
How to be a Prompt Engineer 101

The shortest and most comprehensive guide

1. start with an explanation

Make a description and character situation at the beginning of the Prompt

Error example:

Please help me read the following code:

{your input here}

Correct example:

Now let's play the role, you are a senior information security engineer, I will give you a piece of code, please help me read the code and point out where there may be security vulnerable.



Text: """

{your input here}

"""


2. Prompt to describe the situation

In the prompt, it is necessary to describe the context, result, length, format and style as much as possible

Error example:

Write a short story for kids

Correct example:

Write a funny soccer story for kids that teaches the kid that persistence is the key for success in the style of Rowling.

3. gives output in the format

If you are doing data analysis, please give the input template of the format

Error example:

Extract house pricing data from the following text.

Text: """

{your text containing pricing data}

"""

Correct example:

Extract house pricing data from the following text.

Desired format: """

House 1 | $1,000,000 | 100 sqm

House 2 | $500,000 | 90 sqm

... (and so on)

"""

Text: """

{your text containing pricing data}

"""


4. Add some example questions and answers

Sometimes adding some question and answer examples can make GPT more intelligent

Correct example:

Extract brand names from the texts below.

Text 1: Finxter and YouTube are tech companies. Google is too.

Brand names 2: Finxter, YouTube, Google

###

Text 2: If you like tech, you'll love Finxter!

Brand names 2: Finxter

###

Text 3: {your text here}


Brand names 3:

The question and answer example is also a standard template example in fine-tune


5. Simplify the sentence and clarify the purpose


Keep your words as short as possible and don't say useless content


Error example:

ChatGPT, write a sales page for my company selling sand in the desert, please write only a few sentences, nothing long and complex

Correct example:

Write a 5-sentence sales page, sell sand in the desert.

6. Good at using introductory words

Error example:

Write a Python function that plots my net worth over 10 years for different inputs on the initial investment and a given ROI

Correct example:

# Python function that plots net worth over 10

# years for different inputs on the initial

# investment and a given ROI


import matplotlib


def plot_net_worth(initial, roi):
๐Ÿ‘2
Most Demanding Data Analytics Skills!

โ†ณ Dive into the essential skills and tools that are shaping the future of data analytics. From SQL and Python to Tableau and PowerBI, discover which technologies are crucial for advancing your data analysis capabilities.

โ†ณ Explore the importance of machine learning techniques like linear regression, logistic regression, SVM, decision trees, random forests, K-means, and K-nearest neighbors, and how they can enhance your analytical prowess.

โ†ณ Understand why soft skills such as communication, collaboration, critical thinking, and creativity are just as important as technical skills in the data analytics field.

โ†ณ Get a comprehensive overview of the skills and technologies that can propel your career forward and make you a standout in the competitive world of data analytics.
๐Ÿ‘2
๐ŸŽ“ Build Your Career In Data Analytics! ๐Ÿ“Š

๐ŸŒŸ 2000+ Students Placed
๐Ÿ’ฐ 7.4 LPA Average Package
๐Ÿš€ 41 LPA Highest Package
๐Ÿค 500+ Hiring Partners

Registration link: https://tracking.acciojob.com/g/PUfdDxgHR

Limited Seats, Register Now! โœจ
๐Ÿ‘2
How to become a Data Analyst in 2025
๐Ÿ”ฅ1
In Excel, you can create ๐—ฐ๐—ผ๐—น๐—ผ๐—ฟ-๐—ฐ๐—ผ๐—ฑ๐—ฒ๐—ฑ ๐—ฐ๐—ต๐—ฒ๐—ฐ๐—ธ๐—ฏ๐—ผ๐˜…๐—ฒ๐˜€ ๐˜‚๐˜€๐—ถ๐—ป๐—ด ๐—–๐—ผ๐—ป๐—ฑ๐—ถ๐˜๐—ถ๐—ผ๐—ป๐—ฎ๐—น ๐—™๐—ผ๐—ฟ๐—บ๐—ฎ๐˜๐˜๐—ถ๐—ป๐—ด ๐—ฎ๐—ป๐—ฑ ๐—™๐—ผ๐—ฟ๐—บ ๐—–๐—ผ๐—ป๐˜๐—ฟ๐—ผ๐—น๐˜€. Hereโ€™s how:
๐Ÿ‘‡๐Ÿ‘‡
https://t.iss.one/excel_data/123
Proficiency in data science skills by job role
๐Ÿ”ฅ1
๐Ÿ˜‚๐Ÿ˜‚
๐Ÿ‘6
Please go through this top 10 SQL projects with Datasets that you can practice and can add in your resume

๐Ÿ“Œ1. Social Media Analytics:
(https://www.kaggle.com/amanajmera1/framingham-heart-study-dataset)

๐Ÿš€2. Web Analytics:
(https://www.kaggle.com/zynicide/wine-reviews)

๐Ÿ“Œ3. HR Analytics:
(https://www.kaggle.com/pavansubhasht/ibm-hr-analytics-
attrition-dataset)

๐Ÿš€4. Healthcare Data Analysis:
(https://www.kaggle.com/cdc/mortality)

๐Ÿ“Œ5. E-commerce Analysis:
(https://www.kaggle.com/olistbr/brazilian-ecommerce)

๐Ÿš€6. Inventory Management:
(https://www.kaggle.com/datasets?
search=inventory+management)

๐Ÿ“Œ 7.Customer Relationship Management:
(https://www.kaggle.com/pankajjsh06/ibm-watson-
marketing-customer-value-data)

๐Ÿš€8. Financial Data Analysis:
(https://www.kaggle.com/awaiskalia/banking-database)

๐Ÿ“Œ9. Supply Chain Management:
(https://www.kaggle.com/shashwatwork/procurement-analytics)

๐Ÿš€10. Analysis of Sales Data:
(https://www.kaggle.com/kyanyoga/sample-sales-data)

Small suggestion from my side for non tech students: kindly pick those datasets which you like the subject in general, that way you will be more excited to practice it, instead of just doing it for the sake of resume, you will learn SQL more passionately, since itโ€™s a programming language try to make it more exciting for yourself.

Join for more: https://t.iss.one/DataPortfolio

Hope this piece of information helps you
๐Ÿ‘3