# Most recents (24)

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

Find the links to the questions here
1. leetcode.com/problems/the-n…
2. leetcode.com/problems/prima…

#SQL #DATAANALYSIS #Interviews #lowcode
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,
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.
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..
10 ways to use awk for hackers! 🚀 🧵👇
1️⃣ Extracting Specific Columns from a CSV File

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

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

Filter out sensitive information like passwords from log files.

#LogAnalysis #Security

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

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.
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.
After 12 weeks of using #chatgpt for #datascience, I've learned one thing:

Prompts are ABSOLUTELY critical.

This is why. 🧵

#career #dataanalysis
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. 😡
🤖📈 #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
" 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.
" Data Analyst Project on Hotel Booking "

🧵
◻ 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
" 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.
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
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.
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.

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
Python project ideas for beginners with source code

1. Calculator App
2. Expense Tracker
Python for data science beginners roadmap

1. Python Basics
Python for Everybody Course (py4e.com)
2. Data Analysis Libraries
NumPy User Guide (numpy.org/doc/stable/use…)
Pandas User Guide (pandas.pydata.org/docs/user_guid…)
Matplotlib Tutorials (matplotlib.org/stable/tutoria…)
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.

(1/x)
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.

(2/x)
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.

(3/x)
👨‍💻 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.
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.

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.
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
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”

theguardian.com/uk-news/2023/j…
Thanks to @ByRobDavies @rowenamason @porcelinad via @guardiannews for digging into these important questions and for quoting us.

#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
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