Discover and read the best of Twitter Threads about #dataScientist

" 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

" SQL Puzzle Interview Question "

🧵

Table script:

create table input (
id int,
formula varchar(10),
value int
)
insert into input values (1,'1+4',10),(2,'2+1',5),(3,'3-2',40),(4,'4-1',20);

Youtube Video Link -

#SQL #DataScience #MachineLearning #DataCleaningchallenge #programming #DataEngineering #DataAnalytics #dATAviz #100daysofcodechallenge #100DaysOfCode #dataScientist #Data #DeepLearning #technology #TechNews #techtwitter #Code

" 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

How should you 𝐥𝐞𝐚𝐫𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈? 🚀

🧵

It's easy to be overwhelmed by how broad #PowerBI is😖

If you're starting out, here's the path I recommend⏬

📊 𝐃𝐚𝐭𝐚 𝐌𝐨𝐝𝐞𝐥𝐢𝐧𝐠
Begin by learning to organize data into tables, create relationships, and add calculated columns and measures.

This is the most important part of your journey, as understanding the #data is always the first step in Power BI development.

Read 13 tweets

📊 Hey Folks

✍ So Day - 6 on #powerbi 🚀

🧵👇

⚠ Today I Made a Awesome #America Retail Analysis Dashboard

🎇 The beauty of Power BI is that you can look at each element to make better #decisions. The #dashboard's visual representation allows users to quickly see the #data that's relevant for the choices they have to make

🔥Then, define clear objectives to ensure that the dashboard accurately reflects your desired outcomes. 👇

#PowerBI #100DaysOfCode #100daysofcodechallenge #Data #100daysofcoding #developer #DataScience #dataScientist #DataAnalytics #excel #SQL #tableau #visualization #Dashboard

Rosana Ferrero🕊☮️🏳

@RosanaFerrero

💥14 herramientas secretas impulsadas por #RStats para ahorrar tiempo y esfuerzo en tus proyectos de datos (¡No te lo pierdas!):👀

1️⃣ ¡Edita tus datos de forma interactiva (y guarda el código)! 👀
📦 'editData' es un complemento de RStudio para editar un data.frame o un tibble de forma interactiva
🔗 buff.ly/3U5Tgjy

#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics

2️⃣ ¡Crea gráficos #ggplot de forma interactiva!🚀
📦esquisse es otro de mis addins favoritos de #rstudio
✅ exporta el gráfico o recupera el código para reproducir el gráfico
🔗 buff.ly/3mxLHSo
#DataScience #DataVisualization #dataviz #stats #analytics #RStats #Analytics

Read 17 tweets

Natty Herrera

@_nattyherrera

🤔 ¿Qué es un algoritmo? ¿Cómo resolver problemas con algoritmos? (Aplica hasta para la vida, pero lo estoy estudiando para programación jeje)

🧵 👇

👉 Se denomina algoritmo a un grupo finito de operaciones organizadas de manera lógica y ordenada que permite solucionar un determinado problema. Una serie de instrucciones o reglas establecidas que, por medio de una sucesión de pasos, permiten arrojar a un resultado o solución.

⚙️ ¿Cómo construir un algoritmo?

Lo primero es: Tener claro el requerimiento

💡 Ejemplo: "Quiero encender la luz de la habitación, donde estoy en este momento"

👣 Lo que haremos....

Read 8 tweets

🎯Day -17 on SQL Questions Series📓

▶️Today I Solved the #Olympic Gold Medal
Problem

🧵👇

Q17 ) In problem where we need to find player with no of gold medals won by them only for players who won only gold medals.?

📓Code Snippets :

Day -16 on #Leetcode SQL Questions Series

🎯Today I Take a Question From
@LeetCode Platform 🔥

🧵👇

Q16 ) Write an SQL query to report all customers who never order anything.

Return the result table in any order.

@LeetCode

🙌Thankyou @LeetCode for Providing such a great SQL Questions

📓Code Snippets :

Hey Folks 😃

📗Here are my Last 15 days Of SQL Questions Series Practice

🧵👇

Day 1 -

https://twitter.com/Sachintukumar/status/1605603807710351361?s=20&t=9YVcKIfafNdIe5TTZSh1ow

Day 2 -

https://twitter.com/Sachintukumar/status/1605928162503888898?s=20&t=9YVcKIfafNdIe5TTZSh1ow

Read 17 tweets

Dr. Khulood Almani | د.خلود المانع #CES2023

@LeetCode

Day -15 on #Leetcode SQL Questions Series

🎯Today I Take a Question From @LeetCode Platform 🔥

🧵👇

Q15) A company's executives are interested in seeing who earns the most money in each of the company's departments. A high earner in a department is an employee who has a salary in the top three unique salaries for that department.

--- Write an SQL query to find the employees who are high earners in each of the departments.

Read 5 tweets

@Khulood_Almani

@TMI_Insights

💥What are the8⃣Benefits of Using Workforce #Analytics❓ 👌

v/@TMI_Insights
#FutureOfWork #Innovation #technology #coding #Digital #Blockchain #MachineLearning #Robotics #AI #Python #web3 #dataScientist #Bigdata #cloud #Fintech #IoT #womenintech #Flutter #CES #CES2023 #MWC2023

@sonu_monika

👆Pls See Post
@sonu_monika @enilev @Jagersbergknut @chidambara09 @EvaSmartAI @PDH_Metaverse @labordeolivier @bimedotcom @BetaMoroney @tlloydjones @bulbi59 @tobiaskintzel @danfiehn @mikeflache @Nicochan33 @TylerCohenWood @SabineVdL @jeancayeux @RLDI_Lamy @vanivina9 @Victoryabro

@Fabriziobustama

👆Pls See Post
@Fabriziobustama @MaiaGabunia @amalmerzouk @NewsNeus @Analytics_699 @baski_LA @KanezaDiane @mary_gambara @HakomTimeSeries
@Sharleneisenia @1OFFGINGER @smaksked @CurieuxExplorer @LavaletteAstrid @arlenenewbigg @RosyCoaching @FrRonconi @mdrechsler @TheAdityaPatro

Read 6 tweets

Day -12 on #JPMorgan SQL Questions Series

🧵👇

Q12) Write a query that outputs the name of each credit card and the difference in issued amount between the month with the most cards issued, and the least cards issued. Order the results according to the biggest difference.

@DataLemurHQ

🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform
@DataLemurHQ For SQL & Data Science Learners

🖍️Code Snippet :

Aishwarya Nevrekar

@nevrekaraishwa2

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

Day -11 on #TikTok SQL Questions Series

🧵👇

Q11) New TikTok users sign up with their emails & each user receives a text confirm to activate their Acc. Assume you r given below tables about email & text

Write query to display the id of the users who didn't confirm on the first day of sign-up but confirmed on the second day

@DataLemurHQ

🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners

🖍️Code Snippet :

▶️You want to reach an intermediate SQL level inside a week 🔥

💯 I have the recipe for it

Yeah, no kidding. Seriously🫡

Source - Sidharth Kriplani Sir

🧵👇

1⃣Day One:
SQL Bolt (sqlbolt.com)
Data science skill (bit.ly/3i6obPg)

2⃣Day Two:
Average post hiatus (bit.ly/3WRPv2I)
Teams power users (bit.ly/3jCIggI)
Cards issued difference (bit.ly/3YUdhgi)

Read 13 tweets

@facebook

Day -🔟 on @facebook SQL Questions Series 🚀🎯

& Extremely sorry guys🙏 from last 2 days I am not posted but now onward i will Continue these series 😃🔥

🧵👇

Q10) Assume you have an events table on app analytics. Write a query to get the app’s click-through rate (CTR %) in 2022. Output the results in percentages rounded to 2 decimal places.

@DataLemurHQ

🫡Thankyou Shri @NickSinghTechSir For Creating Such a Great Platform @DataLemurHQ For SQL & Data Science Learners

🖍️Code Snippet :