Discover and read the best of Twitter Threads about #dataanalytics

Most recents (24)

SQL BASICS Image
SQL JOINS Image
POWER BI CHEAT SHEET Image
Read 9 tweets
🎉 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
🔧 Integration:

- 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
Read 7 tweets
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. Image
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!
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.
Read 12 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
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.🧵👇 Image
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. 🤔
¿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 Image
Read 26 tweets
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 Image
1/20 Image
2/20 Image
Read 6 tweets
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 🧵
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
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-…
Read 9 tweets
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😁 ImageImage
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 😊 ImageImage
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
Read 5 tweets
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
If you have not received any DM from me that means your Inbox is disabled.

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 🙏
Read 4 tweets
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
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
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
Read 15 tweets
📊 [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 Image
[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 Image
[3/4] Liquidity insights:
@Uniswap played a crucial role in providing liquidity. The majority of liquidity flowed into UniSwap, with the $WTH pair being prominent.
Notably, liquidity also moved towards @coinbase , potentially indicating a trend of users seeking stability. ImageImage
Read 4 tweets
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.
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 .
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 .
Read 13 tweets
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. 📅
Read 8 tweets
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. 📅
Read 8 tweets
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 Image
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.
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
Read 5 tweets
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… Image
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 Image
3) Now let's get into what this unlocks in #Web3

Undercollateralized or variable rate lending in #DeFi

Borrower reputation can be established via private data such as credit history

Those with a good reputation can get loans using less collateral &/or lower interest rates
Read 23 tweets
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… Image
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 Image
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… Image
Read 26 tweets
#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
✅ 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.
Read 11 tweets
"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
For a start, it is good that @slidegpt warns you that you should have a critical look at the content.

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
Read 15 tweets
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🌹 Image
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 Image
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 Image
Read 28 tweets
Day9⃣ of #100dayswithMachineLearning

Topic - Machine Learning Development Life Cycle

🧵
#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
Read 6 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
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
Read 4 tweets
" 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
Youtube Video Link -
Read 4 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!