Discover and read the best of Twitter Threads about #Datafam
Most recents (24)
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.
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
2022 adalah salah satu tahun menyenangkan bagi gue. Belajar data science adalah satu hal yg nggubah hidup banget, dapet skill baru, sampe ikutan kompetisi dan dapet penghargaan kecil-kecilan.
#DataFam
Gue share ya, apa yg ngubah gue saat belajar Data Science / Data Analytics.
#DataFam
Gue share ya, apa yg ngubah gue saat belajar Data Science / Data Analytics.
Disclaimer
Gak cuma belajar Data Science atau Data Analytics bisa mengubah hidup kok. Belajar apapun yg kontributif tentu bisa. Untuk thread ini gue cerita apa adanya berdasarkan pengalaman selama ini.
Apa aja? Simak ya.
Gak cuma belajar Data Science atau Data Analytics bisa mengubah hidup kok. Belajar apapun yg kontributif tentu bisa. Untuk thread ini gue cerita apa adanya berdasarkan pengalaman selama ini.
Apa aja? Simak ya.
Bantu gue memahami dan menganalisis data dengan lebih baik.
Captain obvious. Walau terdengar standrat, saat gue bisa menganalisis data dengan baik, masalah bisa dipahami lebih dalam, dan tentunya juga bisa dipertanggungjawabkan. Tidak banyak loh orang yang bisa melakukan ini.
Captain obvious. Walau terdengar standrat, saat gue bisa menganalisis data dengan baik, masalah bisa dipahami lebih dalam, dan tentunya juga bisa dipertanggungjawabkan. Tidak banyak loh orang yang bisa melakukan ini.
In #DataAnalytics, it's impossible to remember everything you need to know about #Python.
Fortunately, there are amazing cheat sheets so you don't have to memorize the basics.
Here are 12 Python Data Cheat Sheets for you to download now.⤵
#DataFam #AllAboutTheData 🐍
Fortunately, there are amazing cheat sheets so you don't have to memorize the basics.
Here are 12 Python Data Cheat Sheets for you to download now.⤵
#DataFam #AllAboutTheData 🐍
1. Python Crash Course Cheat Sheet by @ehmatthes
A mega-collection of Python cheatsheets! 🤩
Provides an overview of the basics of Python including variables, lists, dictionaries, functions, classes, Matplotlib, Plotly, and more.
Download now: twtr.to/pccb 👇
A mega-collection of Python cheatsheets! 🤩
Provides an overview of the basics of Python including variables, lists, dictionaries, functions, classes, Matplotlib, Plotly, and more.
Download now: twtr.to/pccb 👇
2. Python Data Nine-in-One by @DataCamp
A great collection of 9 super-detailed Python cheatsheets geared towards #data professionals.
Includes cheat sheets for Python basics, Jupyter, NumPy, scipy, pandas, and more.
Download now: twtr.to/9in1 👇
A great collection of 9 super-detailed Python cheatsheets geared towards #data professionals.
Includes cheat sheets for Python basics, Jupyter, NumPy, scipy, pandas, and more.
Download now: twtr.to/9in1 👇
#DataAnalytics 101:
Start with the basics this month:
1. SQLBolt: practice #SQL
2. TableauPublic: data visualization
3. AutomateExcel: guided Excel practice
4. LearnPython: #Python tips for every level
5. Start Writing Online: the ultimate guide to writing
#DataFam
Start with the basics this month:
1. SQLBolt: practice #SQL
2. TableauPublic: data visualization
3. AutomateExcel: guided Excel practice
4. LearnPython: #Python tips for every level
5. Start Writing Online: the ultimate guide to writing
#DataFam
1. SQL Bolt:
SQL is king in the data analytics world. It's a critical skill.
SQLBolt is a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser.
Learn the basics or level up your skills today.
👉twtr.to/sqlbolt
SQL is king in the data analytics world. It's a critical skill.
SQLBolt is a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser.
Learn the basics or level up your skills today.
👉twtr.to/sqlbolt
2. Tableau Public:
Tableau Public is a free version of Tableau that allows you to visualize data on the web or on your computer and upload it to a public Tableau profile.
Tableau is my absolute favorite data tool! Try it for free today.
👉twtr.to/tableaupublic
Tableau Public is a free version of Tableau that allows you to visualize data on the web or on your computer and upload it to a public Tableau profile.
Tableau is my absolute favorite data tool! Try it for free today.
👉twtr.to/tableaupublic
Hi #datafam, here’s a sunburst chart I made using Excel. This #viz shows how each economic sector contributed to Nigeria’s GDP in 2020. Data was obtained from CBN. Here's a thread with instructions on how to create this #viz in Excel.
🧵🧵
🧵🧵
@IbukunOshiga @Talktomissbela @HappyAdejoh @volkaseezn_ @IAGeographer1 @Angiepresh1 @el_victoriaa @_Promise_Nonso @agboolar3 @malcom_okonkwo @saltypip @Bawzz_lady
A Sunburst Chart is made up of an inner circle encircled by rings representing higher degrees of hierarchy. Each segment's angle is proportionate to a value or split evenly under its parent node.
The sunburst chart is best used for presenting hierarchical data.
The sunburst chart is best used for presenting hierarchical data.
7 things you must absolutely avoid as a data analyst when creating a report for your boss or clients.
#DataFam #DataAnalytics #AllAboutTheData
#DataFam #DataAnalytics #AllAboutTheData
1. Data confusion
There's nothing worse than looking at a dashboard or report and being confused:
• Where did the data come from?
• When was it last updated?
• Any additional context?
These questions will come up so include the answers directly in your analysis.
There's nothing worse than looking at a dashboard or report and being confused:
• Where did the data come from?
• When was it last updated?
• Any additional context?
These questions will come up so include the answers directly in your analysis.
2. Not telling a story
Your analysis has to have a point.
Otherwise, it's a waste of time and money.
Instead, spell out exactly why your audience should care about the work you've done.
Don't make the mistake of "letting the work stand on its own". Nobody's got time for that!
Your analysis has to have a point.
Otherwise, it's a waste of time and money.
Instead, spell out exactly why your audience should care about the work you've done.
Don't make the mistake of "letting the work stand on its own". Nobody's got time for that!
The #1 way to get noticed during the hiring process, is to have an awesome #DataAnalytics portfolio.
Unfortunately, most aspiring analysts don't know where to start.
Here are 10 data analytics portfolios that will inspire you to take the first step: ⤵
#DataFam #AllAboutTheData
Unfortunately, most aspiring analysts don't know where to start.
Here are 10 data analytics portfolios that will inspire you to take the first step: ⤵
#DataFam #AllAboutTheData
1) Ger Inberg – Data Science Developer
Ger's portfolio showcases data viz, machine learning, and web dev projects. Each project includes a brief overview and link for details.
👉 gerinberg.com
Ger's portfolio showcases data viz, machine learning, and web dev projects. Each project includes a brief overview and link for details.
👉 gerinberg.com
2) James Le
James's portfolio focuses on data analyst projects, using Jupyter and R notebooks. Definitely check this out if you want to showcase your coding skills.
👉 jameskle.com/data-portfolio
James's portfolio focuses on data analyst projects, using Jupyter and R notebooks. Definitely check this out if you want to showcase your coding skills.
👉 jameskle.com/data-portfolio
In #DataAnalytics, it's impossible to memorize everything you need to know about #Tableau.
Fortunately, there are amazing cheat sheets so that you don't have to memorize the basics.
Here are 7 Tableau Cheatsheets for you to download now:⤵
#DataFam #AllAboutTheData
Fortunately, there are amazing cheat sheets so that you don't have to memorize the basics.
Here are 7 Tableau Cheatsheets for you to download now:⤵
#DataFam #AllAboutTheData
1) DataCamp
In this Tableau Cheat Sheet, you'll learn how to create your first visualization, top visualizations in Tableau, creating dashboards, stories, and more.
Download now: twtr.to/r6am
In this Tableau Cheat Sheet, you'll learn how to create your first visualization, top visualizations in Tableau, creating dashboards, stories, and more.
Download now: twtr.to/r6am
2) Intellipaat
This cheat sheet will provide you with all the basics of the Tableau desktop that you need to know to get started with Tableau
Download now: twtr.to/xqR-
This cheat sheet will provide you with all the basics of the Tableau desktop that you need to know to get started with Tableau
Download now: twtr.to/xqR-
Hi #datafam, here’s a radial bar chart I made using Excel. This viz summarizes the top 10 nations by annual nominal minimum wage in USD in 2022. This chart was made using data scraped from a Wikipedia table. Here's a thread with instructions on how to create this #viz in Excel
🧵
🧵
@saltypip @seyiflawless @malcom_okonkwo @JAEmmanuel9 @el_victoriaa @TheApollo47 @Haffiz_Anoze @BolajiO_ @Xionne_ @AndrewAjir @toohodtotrot @Aboki_Esq @fahiemad @FavourFae
Note: You need to have basic knowledge of Excel and making charts in Excel to follow this thread
Knowing #Excel is absolutely critical for anyone that works with data on a regular basis.
Fortunately, there are places online where you can learn these essential skills – without paying a penny.
Use these 7 websites to sharpen your Excel skills today.👇
#DataFam #DataAnalytics
Fortunately, there are places online where you can learn these essential skills – without paying a penny.
Use these 7 websites to sharpen your Excel skills today.👇
#DataFam #DataAnalytics
1) SFiddle
The goal of SSFiddle is to make working with spreadsheets as fast and convenient as possible, similar to CodePen and DBFiddle.
Learn more: ssfiddle.com
The goal of SSFiddle is to make working with spreadsheets as fast and convenient as possible, similar to CodePen and DBFiddle.
Learn more: ssfiddle.com
2) FormulaBoost
Format and analyze Excel formulas to check for errors, validate results, and more.
Learn more: formulaboost.com
Format and analyze Excel formulas to check for errors, validate results, and more.
Learn more: formulaboost.com
A workshop student asked me for places to go to see collections of great data viz (he said he goes to Reddit's dataisbeautiful 🫤). I asked my LinkedIn followers for their suggestions and this is a thread of their go-to viz inspo spots.
There are so many ways to visualize data. How to select one that is suitable for your dataset and the message you want to convey?
Here are some tools that can help you choose the right chart type – right in time for the #30DayChartChallenge 🧵[1/9]
#DataViz #DataVisualization
Here are some tools that can help you choose the right chart type – right in time for the #30DayChartChallenge 🧵[1/9]
#DataViz #DataVisualization
The Visual vocabulary from the Financial Times (@FinancialTimes) provides a great overview and some general information about each chart type. Very useful for getting inspiration. [2/9]
ft-interactive.github.io/visual-vocabul…
ft-interactive.github.io/visual-vocabul…
@FinancialTimes If you already have a specific goal or message that you want to communicate, then tools that allow you to filter charts based on their function come in handy: [3/9]
Thread 🧵-
Here's how you can produce a clean chart that your audience can easily read and understand, without much ado.
Follow along 🤗
#RStats #DataScience #dataviz #DataAnalytics #DataFam
Here's how you can produce a clean chart that your audience can easily read and understand, without much ado.
Follow along 🤗
#RStats #DataScience #dataviz #DataAnalytics #DataFam
1. Remove gridlines and axis lines from your chart, unless it's difficult to track the points you've plotted without them.
#RStats #tidyverse #datafam #dataviz #DataScience
#RStats #tidyverse #datafam #dataviz #DataScience
2. Add trend lines/reference lines to guide the audience on what the numbers were expected to look like vis-a-vis what they actually look like.
Ensure the color scheme of the trend lines doesn't overshadow the plot. Keep them subtle, probably in grey
#RStats #dataviz #tidyverse
Ensure the color scheme of the trend lines doesn't overshadow the plot. Keep them subtle, probably in grey
#RStats #dataviz #tidyverse
It is Estimated to have 11,000,000+ job openings 🚀in Data Science industry by 2026.
Building is portfolio to stand out is absolutely necessary.
Tips to build your #datascience portfolio. A Thread 🧵
Building is portfolio to stand out is absolutely necessary.
Tips to build your #datascience portfolio. A Thread 🧵
1. GitHub Profile - @github
▶️Over 65 million developers and more than 3 million companies use GitHub . GitHub says that 72% of Fortune 50 companies use the site.
▶️ There is always debate about GitHub over blog. I started with blog and later created GitHub profile
▶️Over 65 million developers and more than 3 million companies use GitHub . GitHub says that 72% of Fortune 50 companies use the site.
▶️ There is always debate about GitHub over blog. I started with blog and later created GitHub profile
Continuing the #learningpath series
⭐Next skill in #DataScience industry is R programming (One of the most important and my favorite)
⭐There always been a debate around R v/s Python
⭐Step by step learning path for R programming
A Thread 🧵
⭐Next skill in #DataScience industry is R programming (One of the most important and my favorite)
⭐There always been a debate around R v/s Python
⭐Step by step learning path for R programming
A Thread 🧵
1. Introduction to R
⭐Introduction to R
⭐Arithmetic operation
⭐Variable assignment
⭐Basic Data types
⭐Vectors, Matrix, List, Array and Data Frames
⭐Factors, Factor levels, Ordered factors
⭐Introduction to R
⭐Arithmetic operation
⭐Variable assignment
⭐Basic Data types
⭐Vectors, Matrix, List, Array and Data Frames
⭐Factors, Factor levels, Ordered factors
2. Data Input and Output in R
⭐Intro to import data
⭐Reading csv, txt, flat and excel files
⭐Saving output
⭐Intro to import data
⭐Reading csv, txt, flat and excel files
⭐Saving output
Continuing the #learningpath series
⭐Next skill in #DataScience industry is @MSPowerBI (One of the fastest growing #skills 🚀)
⭐Power BI is one of the leaders in Analytics and BI platforms in @gartner magic quadrant
⭐Step by step learning path for Power BI
A Thread 🧵
⭐Next skill in #DataScience industry is @MSPowerBI (One of the fastest growing #skills 🚀)
⭐Power BI is one of the leaders in Analytics and BI platforms in @gartner magic quadrant
⭐Step by step learning path for Power BI
A Thread 🧵
1- Getting Started with @MSPowerBI
⭐Power BI Interface
⭐Design flow
⭐Type of data sources
⭐Data Terminology
⭐Power BI Interface
⭐Design flow
⭐Type of data sources
⭐Data Terminology
2.1- Connecting to Data and Intro to Query Editor
⭐Type of Data Sources
⭐Intro to the @MSPowerBI Query Editor
⭐Table Transformations
⭐Text, Number & Date calculations
⭐Index & Conditional Columns
⭐Grouping & Aggregating Data
⭐Pivoting & Unpivoting
⭐Type of Data Sources
⭐Intro to the @MSPowerBI Query Editor
⭐Table Transformations
⭐Text, Number & Date calculations
⭐Index & Conditional Columns
⭐Grouping & Aggregating Data
⭐Pivoting & Unpivoting
Continuing the #learningpath series.
Next skill in #DataScience industry is SQL (One of the most In-Demand Skills )
⭐There are 1,000,000+ jobs available in USA with requirement of SQL as a skill
Step by step learning SQL for data scientists
A thread🧵
#data #datascience #sql
Next skill in #DataScience industry is SQL (One of the most In-Demand Skills )
⭐There are 1,000,000+ jobs available in USA with requirement of SQL as a skill
Step by step learning SQL for data scientists
A thread🧵
#data #datascience #sql
1. SQL Basics
⭐ Creating Tables
⭐ Inserting values
⭐ Adding a New column in the existing Table
⭐ Deleting a Column from a Table
⭐ Deleting the Table
⭐ Creating Tables
⭐ Inserting values
⭐ Adding a New column in the existing Table
⭐ Deleting a Column from a Table
⭐ Deleting the Table
2. SQL start with Commands
⭐ Learn basic SQL commands: SELECT, FROM and WHERE
⭐ Learn logical operators in SQL
⭐ Learn commands: IN , AND, OR, NOT, LIKE, NULL, ISNULL, BETWEEN
⭐ Learn basic SQL commands: SELECT, FROM and WHERE
⭐ Learn logical operators in SQL
⭐ Learn commands: IN , AND, OR, NOT, LIKE, NULL, ISNULL, BETWEEN
Continuing the #learningpath series.
Next skill in #DataScience industry is @tableau.
Industry leader in Business intelligence and data visualization (one of the most demanding skill)
Step by step learning @tableau
#datafam #dataviz
A thread 🧵
Next skill in #DataScience industry is @tableau.
Industry leader in Business intelligence and data visualization (one of the most demanding skill)
Step by step learning @tableau
#datafam #dataviz
A thread 🧵
Thread 🧵-
Creating a good #dataviz with the right colours might seem like a herculean task, but it's not.
So, here are six pointers that might help ease your process. Follow along 🤗
#datafam #DataAnalytics #RStats #DataScience
Creating a good #dataviz with the right colours might seem like a herculean task, but it's not.
So, here are six pointers that might help ease your process. Follow along 🤗
#datafam #DataAnalytics #RStats #DataScience
1. Use as few colours as possible to convey your idea - try & look for means to group your variables in such a way that fewer colours can be used to convey your point better.
Eg: Top N products in one colour & the others in another, instead of one colour for each product
Eg: Top N products in one colour & the others in another, instead of one colour for each product
I am so so incredibly proud of @LisaTrescott! [a thread]
When the #IronViz feeders launched this year I wanted to encourage participation, particularly from first-time entrants. Every year, I hear from people who are apprehensive about entering #IronViz for various reasons
1/n
When the #IronViz feeders launched this year I wanted to encourage participation, particularly from first-time entrants. Every year, I hear from people who are apprehensive about entering #IronViz for various reasons
1/n
Perhaps it's imposter syndrome, perhaps they feel like they don't have the skills or experience required. Regardless of the reason, when the feeder entries start to come through on social media, it is intimidating...for all of us!
2/n
2/n
That's one of the main drivers that led me to launch #IronQuest in 2019. I wanted to provide people with a platform to practice #IronViz-style skills in a safe environment, all year round. A key element of IronQuest is feedback, which all participants can opt-in for.
3/n
3/n
TIPS FOR BUILDING YOUR TECH RESUME
In one month I’ve gotten over 20 interview requests from various companies thanks to my awesome resume & God 😊. If you are a recent graduate or transitioning to Tech, this THREAD would be useful
#100DaysOfCode #TechTwitter #DataFam #jobsearch
In one month I’ve gotten over 20 interview requests from various companies thanks to my awesome resume & God 😊. If you are a recent graduate or transitioning to Tech, this THREAD would be useful
#100DaysOfCode #TechTwitter #DataFam #jobsearch
1/ BEFORE WE BEGIN
Some Tech roles that have low barrier to entry include Data Analyst, Data Scientist, Front End Developer, Product Manager or UI/UX Designer etc. You can be self-taught in any of this & land your dream job. Don't forget to RT or LIKE so others can learn too.
Some Tech roles that have low barrier to entry include Data Analyst, Data Scientist, Front End Developer, Product Manager or UI/UX Designer etc. You can be self-taught in any of this & land your dream job. Don't forget to RT or LIKE so others can learn too.
2/ RESUME SECTIONS
Your resume should have these sections
• Basic Information: Name, Email, Phone Number, LinkedIn URL, Portfolio Website & Location
• Skills: Technical skills (70%) & Soft skills (30%)
• Projects
• Work Experience
• Education/Certifications
• Volunteering
Your resume should have these sections
• Basic Information: Name, Email, Phone Number, LinkedIn URL, Portfolio Website & Location
• Skills: Technical skills (70%) & Soft skills (30%)
• Projects
• Work Experience
• Education/Certifications
• Volunteering
