famutimi Ayodamola

Data Analyst Associate(Excel,SQL,Power BI,Tableau) | Freelancer| Black Women in Tech| Gemini Queen| Biologist

[famutimi Ayodamola @Damselyn_]

In the process of sharpening my #powerbi skills, I created this interactive #dashboard
I used different techniques to analyze the dataset of XYZ profit and loss Sales report
your suggestions and corrections are welcomed.
Check out this awesome Report https://t.co/fIfiDJYTOi

[famutimi Ayodamola @Damselyn_]

@realharderonke Why post someone’s AI video and you couldn’t give the owner credit 🙄🙄

[famutimi Ayodamola @Damselyn_]

@faith_adewale_ @BBNaija The foundation himself 💜💜💜

[famutimi Ayodamola @Damselyn_]

@faith_adewale_ The lesson this show taught you faith is bigger than the 150million, I wish you all the best

[famutimi Ayodamola @Damselyn_]

@faith_adewale_ Faith the love doctor 😅, Welcome to the military regime

[famutimi Ayodamola @Damselyn_]

@Tech4DevHQ It was absolutely amazing

[famutimi Ayodamola @Damselyn_]

@Tech4DevHQ I’m ready 💃🏼💃🏼💃🏼

[famutimi Ayodamola @Damselyn_]

#NewProfilePic

[famutimi Ayodamola @Damselyn_]

@Tech4DevHQ I’m so excited and I can’t wait

[famutimi Ayodamola @Damselyn_]

@Tech4DevHQ Congratulations to me, I got a mail 💃🏼💃🏼💃🏼

[famutimi Ayodamola @Damselyn_]

Hello world!!!
Being awhile here 😃😃

[famutimi Ayodamola @Damselyn_]

#NewProfilePic

[famutimi Ayodamola @Damselyn_]

@tohire_ng HI

[famutimi Ayodamola @Damselyn_]

@hermosa_girlll Congratulations girl... looking out for an internship too

[famutimi Ayodamola @Damselyn_]

I am honored and excited to announce that I've been accepted into the Women Techsters BootCamp 3.0! by
@Tech4DevHQ
This is an amazing opportunity for me to further develop my skills as a data analyst and continue my journey in the world of tech.
#WomenInTech #Tech4Dev

[famutimi Ayodamola @Damselyn_]

@LumiTheAnalyst @omoalhajaabiola i swear😂😂😂😂😂😂

[Omoalhaja @omoalhajaabiola]

Here are few Important SQL interview questions with topics

Basic SQL Concepts:

Explain the difference between SQL and NoSQL databases.
What are the common data types in SQL?

Querying:

How do you retrieve all records from a table named "Customers"?
What is the difference between SELECT and SELECT DISTINCT in a query?
Explain the purpose of the WHERE clause in SQL queries.

Joins:
Describe the types of joins in SQL (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN).
How would you retrieve data from two tables using an INNER JOIN?

Aggregate Functions:
What are aggregate functions in SQL? Can you name a few?
How do you calculate the average, sum, and count of a column in a SQL query?

Grouping and Filtering:
Explain the GROUP BY clause and its use in SQL.
How would you filter the results of an SQL query using the HAVING clause?

Subqueries:
What is a subquery, and when would you use one in SQL?
Provide an example of a subquery in an SQL statement.

Indexes and Optimization:
Why are indexes important in a database?
How would you optimize a slow-running SQL query?

Normalization and Data Integrity:
What is database normalization, and why is it important?
How can you enforce data integrity in a SQL database?

Transactions:
What is a SQL transaction, and why would you use it?
Explain the concepts of ACID properties in database transactions.

Views and Stored Procedures:
What is a database view, and when would you create one?
What is a stored procedure, and how does it differ from a regular SQL query?

Advanced SQL:
Can you write a recursive SQL query, and when would you use recursion?
Explain the concept of window functions in SQL.

These questions cover a range of SQL topics, from basic concepts to more advanced techniques, and can help assess a candidate's knowledge and skills in SQL

Share this post if you want the answers in next post ❤️👍

[famutimi Ayodamola @Damselyn_]

@cowrywise I would like to intern as a Data Analyst on your data team
I'm one of your loyal customers and I would love to intern with you

[Omoalhaja @omoalhajaabiola]

If you still have free time today, do this

👇👇

1. Go to LinkedIn, type jobs and look for your target role. Limit your search to the first 3 pages of the result & write down 3 roles that reoccur

2. Next is to search for industry-specific hard skills. We will use ChatGPT to do this but firstly copy the job descriptions, responsibilities and summaries of each of the jobs in the first three pages

Go to ChatGPT and type this prompt

“You have been hired to provide 2 hard skills that are related and highly demanded for the following job descriptions. Also provide the list of the most common keywords and rank them according to their volume”

You now have:

- 2-3 different job titles
- Industry specific hard skills
- Most common keywords

We will use all these to write our headline

There are many ways to write headline but I’ve recorded highest conversion using the following formula

Targeted role as used on LinkedIn | Targeted role | Industry specific requirements | Tell them about your availability

For instance, data analyst can use (based on the info from ChatGPT)

Data Analyst | Business Intelligence| SQL developer & Power BI expert| Solving Business Problems with Data | Seeking Opportunities

This is our first assignment for today’s class. Submit it tomorrow and we will move to

- how to edit your LinkedIn URL
- Writing an optimized Summary section

Sounds like a deal?

[Tina Okonkwo @Rita_tyna]

When you think of #DataFestAfrica what comes to your mind?

For us, it’s a platform to learn, grow and network with likeminded individuals in the data space.

#DataFestAfrica2022 was a blast and it saw people from different career paths in the data space under one roof talking about data and it’s impact.

#DataFestAfrica2023 is a month away and we made a video to show you how it caters to everyone in the data space regardless of the field you are in!

So if you are data analyst, data scientist, data engineer, ML engineer, DBA, Analytics engineer, Power platform developer and any other data related career, you don’t want to miss it. Kindly quote retweet this video with what you do and “I’ll be at #DataFestAfrica2023”

e.g “My name is Tina Okonkwo, I am a data analyst and I’ll be at #DataFestAfrica2023”

Get your #DataFestAfrica2023 tickets here

https://t.co/MOoIrlB5Lw

[famutimi Ayodamola @Damselyn_]

@phaibooboo I'm in!!!