Discover and read the best of Twitter Threads about #dataanalysis

Most recents (24)

#Day5 for Reporting "Crack SQL interview in 50Qs" is hear. Let's rumble

Find the links to the questions here

#SQL #DATAANALYSIS #Interviews #lowcode Image
Let's break them down:
1. Intuition
The query aims to retrieve information about managers in the Employees table, including their IDs, names, the number of employees reporting to them, and the average age of their reports.
The solution involves using a self join. Since we were told that a manager is also an employee, we will join the table to itself, where the employee_id field is equal reports_to field. On this premise, we aggregate the number of employees who report directly to the manager,
Read 6 tweets
Let's break down each question
1. Logic: Show the classes, where the number of student is more than 5. The word "At least" tells us something, we have to include 5 as part of our filtering condition, hence >=5
2. This looks pretty straight forward. For each user, we want to....
..return the number followers, hence the need to use the Group BY clause. This clause allows us to aggregate data against the unique categorical/qualitative values in a field.
3. The given SQL query finds the maximum value (num) from the "mynumbers" table that appears only once.
Read 9 tweets
Let's break down each code
1. The ending part to the question is where the major conditional logic lies. We were told to return the needed columns, and price for the first year of every product sold. Since we do not have distinct column showing min years for each product,
We have to create that with a subquery in the Where clause. We are concerned about the first year of every product sold, so we aggregate the min years for each product. After doing that, we tell SQL to return the prices of products, the year, and qty when the product was first..
Read 10 tweets
10 ways to use awk for hackers! 🚀 🧵👇 Image
1️⃣ Extracting Specific Columns from a CSV File

Quickly extract email addresses and phone numbers from a huge contact list.

#DataExtraction #EthicalHacking Image
2️⃣ Filtering Lines Based on a Pattern

Filter out sensitive information like passwords from log files.

#LogAnalysis #Security Image
Read 11 tweets
📊📅 Get ready for a data-packed week ahead!

In this thread we're breaking down the key coincident and leading economic indicators to watch out for this week.

Stay tuned for insights into May's economic activity.

#EconomicIndicators #DataAnalysis
The week ahead is jampacked with coincident and leading economic indicators.

Keep an eye on May 12 mortgage applications (Wed) and May 13 jobless claims (Thu). They provide up-to-the-minute insights and may impact April's housing starts and existing home sales. Image
On a four-week moving average basis, jobless claims have recently risen to 242,000. This could be a significant signal of a slowing labor market, despite high job openings.
Read 6 tweets
After 12 weeks of using #chatgpt for #datascience, I've learned one thing:

Prompts are ABSOLUTELY critical.

This is why. 🧵

#career #dataanalysis Image
4 weeks ago I made a full chatgpt for data scientists workshop where I showed...

...the MASSIVE amount of debugging I had to do to get ChatGPT to make a data science analysis "work".
Sure, chatgpt still saved me time.

But I was frustrated.

And, debugging was killing me. 😡
Read 10 tweets
🤖📈 #MachineLearning is changing the game for businesses by providing insights that lead to better decision-making. From predicting customer behavior to optimizing supply chains, ML is a game-changer! #AI #BigData
🧠👨‍💻 With its ability to learn and adapt, #MachineLearning is like having a virtual assistant that's always looking for ways to improve your business processes. Say goodbye to manual data analysis and hello to automated insights! #DigitalTransformation
🤝💻 The collaboration between humans and #MachineLearning is the key to unlocking its true potential. We can create more accurate predictions and optimize complex systems by working together. #Teamwork #AI
Read 11 tweets
" SQL Project on Zomato Analytics "

#SQL is the most important tool, a data analyst uses to manipulate and gain insights from the data. In this #project, we will try to process, and analyze the data

SQL is the “meat and potatoes” of #dataanalysis

It’s semantically easy to understand and learn.
Read 4 tweets
" Data Analyst Project on Hotel Booking "

That you can add in your resume or portfolio to showcase your skills 💯

◻ In Recent Year , City Hotel & Resort Hotel have seen High Cancellation Rates. Each Hotel is now Dealing with number of issue as result including Fewer #revenue & Less than ideal Hotel room use.
🔹 Insights :

1️⃣ More Cancellation occur when prices are higher
2️⃣ When there is Longer waiting list , Customer tend to Cancel more frequently
3️⃣ The majority of Clients are coming from a offline #travel agents to make their #reservations
Read 6 tweets
" Exploratory Data Analysis on Terrorism "

We are performed Exploratory Data Analysis on terrorism #dataset to find out the hot zone of #terrorism. #EDA nothing but #analyzing the given data & finding the #trends, patterns & making some assumptions. #DataVisualization #DataScience #MachineLearning
In this #dataset, there are many features including countries, states, regions, gang names, weapon types, target types, years, months, days, and many more features.
Read 8 tweets
Revolutionize your car buying experience with CarEdge and OpenAI! 🚗🤖 Our new chatbot uses cutting-edge AI to help you find the perfect car at the perfect price. Want early access? Reply to this tweet and we'll send you an invite! #CarBuying #OpenAI #Innovation
At @mycaredge, we are working on using data analysis to help car buyers figure out a fair price to pay for any vehicle. Our goal is to empower consumers to make informed decisions and have a successful car buying experience. #carbuying #dataanalysis #fairprice
Are you tired of getting hit with bogus fees when buying a car? CarEdge has got your back! Our chatbot analyzes deals to identify unnecessary fees, so you can save money and have a hassle-free car buying experience. #carbuying #transparency #fairness
Read 6 tweets
It's important to have a roadmap for Data Science and Analysis before starting a career in this rapidly evolving field. In this thread,l'll share the roadmap that has helped me establish a solid foundation, comprehend the entire spectrum, & keep pace with the latest technologies.
Why is it important to have a roadmap?

- Clear understanding of the field: Data science & analysis is a multidisciplinary field encompassing statistics, machine learning, programming, & data visualization. It helps in understanding skills required for each domain, & how they fit
- Setting clear goals: Having a roadmap helps in setting clear goals & objectives for your career. It allows you prioritize the skills to learn & which projects to work on to achieve those goals. It also helps in defining a path to success & a timeline to reach those milestones.
Read 25 tweets
Roadmap to becoming Data Analyst in three months absolutely free. No need to pay a penny for this.

I have mentioned a roadmap with free resources.

A thread🧵👇
1. First Month Foundations of Data Analysis

A. Corey Schafer - Python Tutorials for Beginners:
B. StatQuest with Josh Starmer - Statistics Fundamentals:
C. Ken Jee - Data Analysis with Python
2. Second Month - Advanced Data Analysis Techniques

A. Sentdex - Machine Learning with Python
B. StatQuest with Josh Starmer - Machine Learning Fundamentals
C. Brandon Foltz - Business Analytics
Read 6 tweets
Python project ideas for beginners with source code

A thread 🧵👇
1. Calculator App
Source Code Link:…
2. Expense Tracker
Source Code Link:…
Read 7 tweets
Python for data science beginners roadmap

A thread 🧵👇
1. Python Basics
Codecademy's Python Course (…)
Python for Everybody Course (
2. Data Analysis Libraries
NumPy User Guide (…)
Pandas User Guide (…)
Matplotlib Tutorials (…)
Read 7 tweets
the Pnictogen Wing has a hypothesis about @elonmusk's decision to ruin the public @Twitter API—it's not a hypothesis we've too much confidence in, but still we offer it: we think ONE of the purposes of doing this was to make Musk's own Twitter activities harder to analyze.

yes, there's lots of other reasons that the @elonmusk / @mtaibbi / @GOP #Twitter fash gang would have for destroying the ability of outsiders to write Twitter applications. the fash crowd themselves make heavy use of bots, sock-puppet accounts, and other Twitter trickery.

and of course there's also the fact that @elonmusk's been destroying @Twitter's ability to make money, long-term. he's in "vulture capitalist" mode—squeezing as much short-term money as he can from his own cultish #Twitter fandom before he finally auctions off the corpse.

Read 21 tweets
👨‍💻 10 different ways to remove duplicate records in SQL

1 - Delete using Unique Identifier.
2 - Using SELF join.
3 - Using Window function.
4 - Using MIN function. This delete even multiple duplicate records.
5 - Using backup table.
6 - Using backup table without dropping the original table.
7 - Delete using CTID.
8 - By creating a temporary unique id column.
Read 4 tweets
6 Must have line charts for business data analysis 📈👌 💯

1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
▶ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets

As a large language model, CHATGPT can be an incredibly useful work tool in a variety of settings. Here are 10 different ways CHATGPT can be put to work:
1/ #CustomerService: CHATGPT can help businesses handle customer inquiries and support requests quickly and efficiently. With its natural language processing capabilities, it can understand customer needs and respond in a conversational and human-like manner.
2/ #ContentCreation: CHATGPT can help content creators come up with ideas for blog posts, articles, social media posts, and more. With its vast knowledge base and ability to generate text, CHATGPT can be a great resource for brainstorming and generating fresh ideas.
Read 13 tweets
Data driven community empowerment is possible with community-based monitoring systems! #CBMS #communityempowerment #datadriven
It's easier than ever for communities to collect and analyze data in order to improve service delivery. #communityengagement #datacollection #policydecisions
From health and education to employment and housing, community-based monitoring systems provide valuable information on a range of socio-economic indicators. #socioeconomicindicators #communitydatabase #dataanalysis
Read 5 tweets
With the deadline tomorrow, thousands of offshore companies with UK property are still not stating their real owners

Quoted in @guardian is our head of tech, @stephen_abbott: “the public still aren’t able to... discover the people behind those companies”…
Thanks to @ByRobDavies @rowenamason @porcelinad via @guardiannews for digging into these important questions and for quoting us.

Also in the series:…

#beneficialownership #transparency #offshore #followthemoney
@ByRobDavies @rowenamason @PorcelinaD @guardiannews If you're on the lookout for more analysis of the data:

After tomorrow's Register of Overseas Entities declaration deadline, we will be repeating our #DataAnalysis to show overall trends in this new #BeneficialOwnership data source - produced w. @LewisSpurgin from @opendatacoop
Read 3 tweets
Everyone's talking about #ChatGPT. ⚡️But 90% of you are missing out on the AI revolution.
Here are the top AI tools🔥 you NEED to know about.🏆🏆
1. Krisp: Krisp's AI removes background voices, noises, and echo from your calls, giving you peace of call

2. Beatoven: Create unique royalty-free music that elevates your story
3. Cleanvoice: Automatically edit your podcast episodes

4. Podcastle: Studio quality recording, right from your computer

5. Flair: Design branded content in a flash
Read 29 tweets
Learn SQL projects for Data Analysis and add to your portfolio for free 🥳

Projects for the portfolio are very important. These projects will improve your skills

A thread 🧵👇
Read 9 tweets
𝟱 𝗿𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝘁𝗼 𝗹𝗲𝗮𝗿𝗻 𝘁𝗵𝗲 𝗯𝗮𝘀𝗶𝗰𝘀 𝐒𝐐𝐋 𝗳𝗼𝗿 𝗳𝗿𝗲𝗲🔥

Credit : Shri Harshit Ahluwalia

Read 3 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!

This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!