Discover and read the best of Twitter Threads about #dataanalytics
Most recents (24)
🎉 Exciting news, Shopify merchants!
We're launching a comprehensive Shopify GA4 Course – your ultimate guide to mastering Google Analytics 4.
Buckle up for the journey! (1/7) #Shopify #GA4 #Ecommerce
We're launching a comprehensive Shopify GA4 Course – your ultimate guide to mastering Google Analytics 4.
Buckle up for the journey! (1/7) #Shopify #GA4 #Ecommerce
🔧 Integration:
- Google Analytics 4 Ecommerce Events & Data
- Detailed overviews of integration solutions
Outcome?
Seamless GA4 integration with your store. (2/7) #ShopifyAnalytics #DataAnalytics
- Google Analytics 4 Ecommerce Events & Data
- Detailed overviews of integration solutions
Outcome?
Seamless GA4 integration with your store. (2/7) #ShopifyAnalytics #DataAnalytics
📈 Migration:
- Creating standard UA reports in GA4
- Importing audiences and goals
Outcome? A smooth transition from UA to GA4. (3/7) #GoogleAnalytics #Migration
- Creating standard UA reports in GA4
- Importing audiences and goals
Outcome? A smooth transition from UA to GA4. (3/7) #GoogleAnalytics #Migration
A few days back, 2 Data Analyst newbies showed me mistakes they encountered during their analysis process. It dawned on me that lots of times, we don't diligently follow through the data analysis process, especially the cleaning phase.
In this short🧵, I break down this process.
In this short🧵, I break down this process.
PHASE 1: ASK QUESTIONS
The first step in the analysis process is to formulate a problem to solve or a question to answer, such as: are customers aged 21 to 30 more likely to churn than customers aged 41 to 50? As analysts, we must be very curious, we must ASK QUESTIONS!
The first step in the analysis process is to formulate a problem to solve or a question to answer, such as: are customers aged 21 to 30 more likely to churn than customers aged 41 to 50? As analysts, we must be very curious, we must ASK QUESTIONS!
PHASE 2: Collect & Store Data
Next, we need to collect and store the necessary data, which could require the use of a database or a spreadsheet. For large datasets, we store them in a database. For datasets shy of a million records, spreadsheet software like Excel can be used.
Next, we need to collect and store the necessary data, which could require the use of a database or a spreadsheet. For large datasets, we store them in a database. For datasets shy of a million records, spreadsheet software like Excel can be used.
#Day3 for Reporting "Crack SQL interview in 50Qs" is hear. Let's rumble
Find the links to the questions here
1. leetcode.com/problems/produ…
2. leetcode.com/problems/not-b…
3. leetcode.com/problems/avera…
#SQL #DATAANALYSIS #Interviews #lowcode
Find the links to the questions here
1. leetcode.com/problems/produ…
2. leetcode.com/problems/not-b…
3. leetcode.com/problems/avera…
#SQL #DATAANALYSIS #Interviews #lowcode
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,
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..
TEN HAG CHATEANDO CON HØJLUND 👀
La idea que te había planteado de optar por jóvenes menos "famosos" pero con potencial, esperando poder contar con 2 atacantes nuevos en lugar de pagar una cantidad alta por uno solo, por ahora parece ser el camino que quiere seguir el #MUFC.🧵👇
La idea que te había planteado de optar por jóvenes menos "famosos" pero con potencial, esperando poder contar con 2 atacantes nuevos en lugar de pagar una cantidad alta por uno solo, por ahora parece ser el camino que quiere seguir el #MUFC.🧵👇
Pero...¿esto puede funcionar? Con los perfiles correctos me parece que hay buenas chances de contar con 3-4 jugadores con más de 10 G+A en la 23/24.
Si vemos el fútbol como roles que se complementan, deberemos ubicar los perfiles que suenan para el #MUFC y así tener una idea. 🤔
Si vemos el fútbol como roles que se complementan, deberemos ubicar los perfiles que suenan para el #MUFC y así tener una idea. 🤔
¿QUIÉN ES RASMUS HØJLUND?
Debo iniciar siendo sincero contigo, solo he visto 3 partidos de él 😅 así que mucho de lo que te muestro está basado puramente en #DataAnalytics, en lo poco que vi debo decir que está MUY VERDE. Pero el potencial también es alto, así que veamos👇 #MUFC
Debo iniciar siendo sincero contigo, solo he visto 3 partidos de él 😅 así que mucho de lo que te muestro está basado puramente en #DataAnalytics, en lo poco que vi debo decir que está MUY VERDE. Pero el potencial también es alto, así que veamos👇 #MUFC
The basics of R to Advance for Beginners.
Bookmark this Tweet and Follow me
COMMENT PDF - and I will send you the compiled PDF of more than 10 Cheat Sheets
If your inbox is disabled please DM me.
#DataAnalytics #DataScience #rstats #data #BigData
Bookmark this Tweet and Follow me
COMMENT PDF - and I will send you the compiled PDF of more than 10 Cheat Sheets
If your inbox is disabled please DM me.
#DataAnalytics #DataScience #rstats #data #BigData
1/20
2/20
Hello Datafam,
So someone asked me where they can get to practice SQL so I would dropping links to platforms where you can practice SQL
Thread 🧵
So someone asked me where they can get to practice SQL so I would dropping links to platforms where you can practice SQL
Thread 🧵
1) Hackerrank @hackerrank
I have used this platform and I really loved using it. I also love that they reward with badges and stars as you make progress
check it out here: hackerrank.com/domains/sql
I have used this platform and I really loved using it. I also love that they reward with badges and stars as you make progress
check it out here: hackerrank.com/domains/sql
2) DataLemur @DataLemurHQ
I personally love this because they give standard interview questions that cuts across various industries. There are also level such as Easy, Medium and Hard so if you want to prepare for technical interviews, check it out
datalemur.com/sql-interview-…
I personally love this because they give standard interview questions that cuts across various industries. There are also level such as Easy, Medium and Hard so if you want to prepare for technical interviews, check it out
datalemur.com/sql-interview-…
Happy Sunday Everyone,
I think I am feeling well enough to make this tweet
So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors
Top of the table😁
I think I am feeling well enough to make this tweet
So I want to share a small win here. I am participating in the Data Analytics Super League organized by @lighthall_co and I want to share that I advanced to level 3 in flying colors
Top of the table😁
The Level 2 challenge was a murder mystery challenge to find who the killer is and we were to solve the challenge using SQL
If you dug deeper you'd find out that there was someone who hired it.
Nothing complex but it was fun, felt like a detective 😊
If you dug deeper you'd find out that there was someone who hired it.
Nothing complex but it was fun, felt like a detective 😊
My submission: drive.google.com/drive/folders/…
If you want to try it out yourself and have fun with SQL, check here
lighthall.co/challenge/cd01…
Thank you @lighthall_co and @thenaijacarguy for the challenge
it is getting really interesting and level 3 is not easy
If you want to try it out yourself and have fun with SQL, check here
lighthall.co/challenge/cd01…
Thank you @lighthall_co and @thenaijacarguy for the challenge
it is getting really interesting and level 3 is not easy
The basics of R for Beginners.
Bookmark this Tweet and Follow for More
COMMENT PDF - and I will send you the compiled PDF of more than 10 Cheat Sheets
#DataAnalytics #DataScience #rstats #data #BigData
Bookmark this Tweet and Follow for More
COMMENT PDF - and I will send you the compiled PDF of more than 10 Cheat Sheets
#DataAnalytics #DataScience #rstats #data #BigData
If you have not received any DM from me that means your Inbox is disabled.
Follow me so that I can Inbox you.
Follow me so that I can Inbox you.
Don't forget to:
✅ Follow
@dr_abdulali125
🔥
✅Like the first tweet in the thread
✅ Retweet this post to share with the world.
Have an amazing day 🙏
✅ Follow
@dr_abdulali125
🔥
✅Like the first tweet in the thread
✅ Retweet this post to share with the world.
Have an amazing day 🙏
MA businesses + companies #discover & #SAVEMONEY with Brian Plain's 25 ways Marlborough & Boston MA area business can save money + #reducecosts & corporate expenditures:
1. Embrace cost reduction strategies to optimize your business operations. #ReduceCosts #BusinessOptimization
1. Embrace cost reduction strategies to optimize your business operations. #ReduceCosts #BusinessOptimization
2. Focus on delivering exceptional service to your customers while minimizing expenses. #ServiceExcellence #CostReduction
3. Cultivate an agile workforce that can adapt to changing market demands and drive cost savings. #AgileWorkforce #ReduceCosts
3. Cultivate an agile workforce that can adapt to changing market demands and drive cost savings. #AgileWorkforce #ReduceCosts
4. Invest in team development to enhance skills and productivity, leading to efficient cost management. #TeamDevelopment #CostManagement
5. Implement streamlined systems and processes to improve operational efficiency and reduce costs. #Systems #ProcessImprovement #CostReduction
5. Implement streamlined systems and processes to improve operational efficiency and reduce costs. #Systems #ProcessImprovement #CostReduction
📊 [1/4] Analyzing Memecoin Trends: $PEPE vs. $SHIB 🚀
❓Does PEPE follow SHIB's path❓
- Data provider: @flipsidecrypto
- Analysis for: @MetricsDAO
- Dashboard Link:
flipsidecrypto.xyz/Ario/does-pepe…
#Memecoins #BTC #DataAnalytics
❓Does PEPE follow SHIB's path❓
- Data provider: @flipsidecrypto
- Analysis for: @MetricsDAO
- Dashboard Link:
flipsidecrypto.xyz/Ario/does-pepe…
#Memecoins #BTC #DataAnalytics
[2/4] 1️⃣ Price trends:
Both $PEPE and $SHIB experienced remarkable price surges within short periods.
🚀 $PEPE reached its price ceiling within a month, while $SHIB witnessed a surge of over 136,000 times in approximately 454 days.
#CryptoNews
Both $PEPE and $SHIB experienced remarkable price surges within short periods.
🚀 $PEPE reached its price ceiling within a month, while $SHIB witnessed a surge of over 136,000 times in approximately 454 days.
#CryptoNews
1. ) @AnnieJacobsen vindicates my research in many ways.
We really need to connect with each other and get @twilabrase , @dougvalentine77 and host a space.
With that, let's begin these short but information-dense tweets that will be the basis for much lengthier posts.
We really need to connect with each other and get @twilabrase , @dougvalentine77 and host a space.
With that, let's begin these short but information-dense tweets that will be the basis for much lengthier posts.
2.) Operation Igloo White is the start ( for all intents and purposes) of ALL modern day Spyware / mass-surveillance programs ; only preceded by the PROMIS software and it's many interations.
PRISM
PEGASUS
FAIRVIEW
MUSCULAR
OAKSTAR
STORMBREW
... To name a few .
PRISM
PEGASUS
FAIRVIEW
MUSCULAR
OAKSTAR
STORMBREW
... To name a few .
3. ) For many years I've spoken about the unseen influence of MAXIMUS upon the population of US and the countries they operate programs in , and have essentially subverted entire countries' governments through privatization .
David Vincent Mastran . Remember that name .
David Vincent Mastran . Remember that name .
Hey folks, let's talk about one of the most important concepts in Power BI that you won't want to filter out: FILTER CONTEXT! 😎
Filter context is like a bouncer at a club - it determines which data gets in and which data gets kicked out. 🕺
For example, if you want to know the total profit for a specific month, you need to create filter context by selecting the month you want to see. 📅
Hey folks, let's talk about one of the most important concepts in Power BI that you won't want to filter out: FILTER CONTEXT! 😎
Filter context is like a bouncer at a club - it determines which data gets in and which data gets kicked out. 🕺
For example, if you want to know the total profit for a specific month, you need to create filter context by selecting the month you want to see. 📅
Day 20 of the Data Analyst Bootcamp by @Alex_TheAnalyst !
Data cleaning is an important step in the data analytics process.
It involves identifying and correcting inaccuracies, inconsistencies, and errors in the data to ensure reliable decision-making.
#Dataanalytics #SQL
Data cleaning is an important step in the data analytics process.
It involves identifying and correcting inaccuracies, inconsistencies, and errors in the data to ensure reliable decision-making.
#Dataanalytics #SQL
Today, I completed an SQL data cleaning project using the Nashville housing dataset.
This dataset was a bit messy, with multiple duplicate entries, blank cells, and incorrect data types.
This dataset was a bit messy, with multiple duplicate entries, blank cells, and incorrect data types.
I used these queries to fix the data:
1⃣ CONVERT and ALTER TABLE to change data formats
2⃣ JOIN to populate missing values
3⃣ SUBSTRING and PARSENAME to separate columns
1⃣ CONVERT and ALTER TABLE to change data formats
2⃣ JOIN to populate missing values
3⃣ SUBSTRING and PARSENAME to separate columns
Some believe #privacy in #Web3 stops at anonymous transactions, which couldn't be further from the truth
@OasisProtocol have built a solution to propel #blockchain adoption to areas that were not previously possible 🌹
Mega thread🧵⬇️
Don't miss this one
❤️/RT/Follow for more twitter.com/i/web/status/1…
@OasisProtocol have built a solution to propel #blockchain adoption to areas that were not previously possible 🌹
Mega thread🧵⬇️
Don't miss this one
❤️/RT/Follow for more twitter.com/i/web/status/1…
2) @OasisProtocol will be imminently releasing the Oasis Privacy Layer (OPL) to all major #EVM chains, allowing any #dApp to integrate customisable, compliant confidentiality to any existing dApp
With OPL and their #privacy paratime Sapphire, a new era is coming to #Web3
With OPL and their #privacy paratime Sapphire, a new era is coming to #Web3
Identificar proyectos que serán integrales para el futuro de #Web3 & #Crypto es vital para tu portafolio 🔥
@OasisProtocol @OasisNetwork_ES $ROSE 🌹 y su fundadora @dawnsongtweets tienen asociaciones, patrocinadores y conexiones que te dejarán boquiabierto 🥰
Hilo a… twitter.com/i/web/status/1…
@OasisProtocol @OasisNetwork_ES $ROSE 🌹 y su fundadora @dawnsongtweets tienen asociaciones, patrocinadores y conexiones que te dejarán boquiabierto 🥰
Hilo a… twitter.com/i/web/status/1…
2. @MetaAI X @OasisProtocol
Durante más de 2 años han trabajado en el desarrollo de la equidad en su #AI 🤖
@OasisNetwork_ES es el socio tecnológico elegido por @MetaAI y vale la pena recordar que $META se acercó a Oasis 🤝
$ROSE #ChatGPT
Durante más de 2 años han trabajado en el desarrollo de la equidad en su #AI 🤖
@OasisNetwork_ES es el socio tecnológico elegido por @MetaAI y vale la pena recordar que $META se acercó a Oasis 🤝
$ROSE #ChatGPT
3. @googlecloud X @OasisProtocol
Aportar lo mejor en tecnología de #privacidad de datos de empresas que manejan esencialmente información confidencial en grandes volúmenes.
Fomentará y ampliará el apoyo a las aplicaciones innovadoras que hacen uso de la informática y la… twitter.com/i/web/status/1…
Aportar lo mejor en tecnología de #privacidad de datos de empresas que manejan esencialmente información confidencial en grandes volúmenes.
Fomentará y ampliará el apoyo a las aplicaciones innovadoras que hacen uso de la informática y la… twitter.com/i/web/status/1…
#DataScience #DataAnalytics #DataScientists #programming #Python #100DaysOfCode
Simple Thread 🧵🧵🧵
A data analyst is a professional who works with data to uncover insights and help businesses make informed decisions. Here are the steps to becoming a data analyst
Simple Thread 🧵🧵🧵
A data analyst is a professional who works with data to uncover insights and help businesses make informed decisions. Here are the steps to becoming a data analyst
✅ Obtain a degree: While it is possible to become a data analyst without a formal degree, having a degree in a related field, such as statistics, mathematics, computer science, or data science, can be beneficial.
✅ Learn programming languages: Programming languages such as Python, R, SQL, and Java are commonly used in data analysis. Learning these languages can help you analyze data more effectively.
"The future of #ChemicalEngineering"
I asked @slidesgpt to create a slide deck on the topic with #AI.
Some might say "pretty generic" again but let me tell you:
At every conference, there are presentations looking at least partially like this.
Let's go through it.
1/15
I asked @slidesgpt to create a slide deck on the topic with #AI.
Some might say "pretty generic" again but let me tell you:
At every conference, there are presentations looking at least partially like this.
Let's go through it.
1/15
For a start, it is good that @slidegpt warns you that you should have a critical look at the content.
2/15
2/15
If you want to talk about the future, start with the past. Okay.
It also gives you a comment so that you can just make a karaoke session out of it:
"[...] Understanding this history is important for understanding the current state of the field and predicting its future."
3/15
It also gives you a comment so that you can just make a karaoke session out of it:
"[...] Understanding this history is important for understanding the current state of the field and predicting its future."
3/15
Identifying projects that will be integral to the future of #Web3 & #Crypto is vital for your portfolio
@OasisProtocol, $ROSE & founder Dawn Song, have partnerships, backers and connections that will blow your mind
Mega Thread below🧵✏️⬇️
Like, RT, Follow and @ tag friends🌹
@OasisProtocol, $ROSE & founder Dawn Song, have partnerships, backers and connections that will blow your mind
Mega Thread below🧵✏️⬇️
Like, RT, Follow and @ tag friends🌹
2) @Meta X @OasisProtocol
For over 2 years they have worked on developing fairness in their #AI
@OasisProtocol is @Meta's chosen technology partner & worth remembering that Meta approached Oasis
I'd be confident in saying this runs deeper than just AI 👀
$ROSE #ChatGPT
For over 2 years they have worked on developing fairness in their #AI
@OasisProtocol is @Meta's chosen technology partner & worth remembering that Meta approached Oasis
I'd be confident in saying this runs deeper than just AI 👀
$ROSE #ChatGPT
3) @Google X @OasisProtocol
Bringing the best in data #privacy technology to companies who essentially deal with sensitive information in large volumes
It will encourage & expand support for innovative applications that are computing & memory-intensive
#BigData #AI $ROSE
Bringing the best in data #privacy technology to companies who essentially deal with sensitive information in large volumes
It will encourage & expand support for innovative applications that are computing & memory-intensive
#BigData #AI $ROSE
#Machinelearning has given the computer systems the abilities to automatically learn without being explicitly #programmed. But how does a machine learning system work? So, it can be described using the #lifecycle of machine learning.
#Machinelearning life cycle is a cyclic process to build an efficient machine learning #project. The main purpose of the life cycle is to find a solution to the problem or project.
Machine learning life cycle involves seven major steps, which are given below:
#DataScience
Machine learning life cycle involves seven major steps, which are given below:
#DataScience
" Data Analyst Project on Hotel Booking "
That you can add in your resume or portfolio to showcase your skills 💯
🧵
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
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
SQL Interviews Question for Product companies
👇
👇
create table entries (
name varchar(20),
address varchar(20),
email varchar(20),
floor int,
resources varchar(10));
#SQL #DataScience #DataAnalytics #MachineLearning #Deeplearning
name varchar(20),
address varchar(20),
email varchar(20),
floor int,
resources varchar(10));
#SQL #DataScience #DataAnalytics #MachineLearning #Deeplearning
" SQL Interview problem "
🧵
🧵
This is a REAL SQL Interview question that might seem impossible to solve just by using SQL at first. But during the video the problem by breaking it into multiple parts
#SQL #DataScience #DataCleaningchallenge #DataAnalytics #dataviz #MachineLearning #deeplearning
#SQL #DataScience #DataCleaningchallenge #DataAnalytics #dataviz #MachineLearning #deeplearning
Youtube Video Link -
