TGViewer
Channel Public Channel
Analytics and growth mindset ๏ธ

Analytics and growth mindset ๏ธ

@thinkbroadly

๐Ÿ”ฅ Free data analytics courses with certificates, hot internships and jobs - everything that needed data analyst.

Contact me to buy ads: hello@tghero.pro
Promote and monetize your Telegram Channel effectively: https://tghero.pro/telegram
Subscribers
6.71K
Photos
47
Videos
2
Links
45

Showing posts older than #21 ยท Back to latest

Older Posts 12 shown
Post #20 15.4K
๐Ÿง‘โ€๐Ÿ’ป What laptop should a data analyst choose?


This question often comes up in the comments. Let's break it down๐Ÿ‘‡๐Ÿป.


โšก๏ธ Can you work on the simplest laptop?

In many companies, analysts work with small datasets and perform simple operations, so basic configurations are sufficient.

Even if you have a cheap laptop and need more computing power, you can solve this problem with a remote desktop. This allows you to use the computing resources of a remote device while staying on your own.


โšก๏ธ Can you work on a tablet?

Even powerful tablets like the Apple iPad Pro are not suitable for data analysis. They do not have enough power and compatibility with the necessary software (Python, Power BI, Tableau, and Excel).


โšก๏ธ What to look for when choosing a laptop?

๐Ÿ‘‰ Processor power. An Intel Core i7 or i9, or an AMD Ryzen 7 or 9, will provide fast data processing and complex computations.

๐Ÿ‘‰ RAM. At least 16 GB of RAM for working with large datasets and multitasking. For more demanding tasks, 32 GB or more is recommended.

๐Ÿ‘‰ Display. High resolution (Full HD or higher) and good color reproduction. For comfortable work, a screen size of 15 to 17 inches is better.

๐Ÿ‘‰ Support for the necessary operating system (Windows, macOS, Linux). For example, the visualization tool Power BI does not have a full version that works on macOS (though this problem can be solved with a virtual machine).


When it comes to specific brands, one of the most popular among data analysts is the Apple MacBook Pro (M2).


What laptop do you use? And what other factors should be considered when choosing a laptop?

โ—๏ธSubscribe: Analytics and growth mindset
  • ๐Ÿ‘ 32
  • โค 8
  • ๐Ÿ”ฅ 7
Post #19 13.7K
๐Ÿ‘จโ€๐Ÿ’ป 3 Free Services for Practicing SQL and Python



When you start learning SQL and Python, you need lots of practice. It's great if you have real tasks at work, but if not, I recommend these free services. They will help you get the practice you need and improve your skills.


1. HackerRank

โšก๏ธ You can practice many different languages, including SQL and Python.

โšก๏ธ You can get certified in technical skills by taking the HackerRank Skills Certification Test.

โšก๏ธ HackerRank is completely free.


2. StrataScratch

โšก๏ธ It's a data science platform with over 1,000 real interview questions (coding and non-coding) from top companies like Google, Netflix, Apple, Airbnb, and Spotify.

โšก๏ธ New interview questions come out every month, and many are free.


3. LeetCode

โšก๏ธ It has lots of coding challenges from big companies like Google, Facebook, Amazon, and Microsoft to help you get better at algorithms and data structures.

โšก๏ธ New problems are added all the time, and many are free.


Watch my video๐Ÿ‘ to see how it works.


If you find this useful, give it a๐Ÿ”ฅ
  • ๐Ÿ‘ 24
  • ๐Ÿ”ฅ 23
  • โค 7
  • โคโ€๐Ÿ”ฅ 2
  • ๐Ÿ‘Ž 2
  • ๐Ÿฅฐ 1
Post #17 13.5K
๐Ÿค“ How to Prepare for a Data Analyst Interview?



For example, take a mock interview or at least watch one.

A mock interview is a practice interview that closely mimics a real one. In a mock interview, an experienced data analyst tests a less experienced person's knowledge and skills.

Benefits of a Mock Interview:

โšก๏ธ Feedback and Evaluation: It's hard to get this in a real interview.
โšก๏ธ Understanding Weaknesses: You'll know what areas you need to improve.
โšก๏ธ Increased Confidence: You'll feel more prepared for the real interview.


๐Ÿ‘‰ Find a Mentor

It's best to do a mock interview with an experienced mentor. To find a mentor you can try platforms like Preplaced, interviewing.io, mentorcruise.com


๐Ÿ‘‰ Watch Mock Interviews Online for free

If you can't find a mentor, there are many mock interview videos online. These can give you a good understanding of the process and questions and help you avoid mistakes.

Examples:
- Mock Interview & Feedback: Data Analyst
- Analyze a User's Posts - Data Analyst SQL Mock Interview
- SQL Mock Interview (Data Analyst): Departments with the Highest Revenues


๐Ÿ‘‰ Practice with Google for free

Google offers Interview Warmup. You can practice answering questions and get quick feedback on your answers. This helps you get better and feel more confident for real interviews.



#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst

If you have a premium Telegram account, please give a free boost to my channel: https://t.me/boost/thinkbroadly.
  • ๐Ÿ‘ 22
  • โค 9
  • ๐Ÿ”ฅ 6
  • ๐Ÿ˜ 1
Post #16 11.5K
๐Ÿ”ฅ 19 Step-by-step Data Analysis Projects with SQL



Below are popular data projects from Kaggle, GitHub and Medium and YouTube. They will:

- Help you gain skills in working with real data
- Introduce you to SQL for data analysis
- Inspire you to undertake your own data analysis projects



๐Ÿ—บ Real World Fake Data Analysis

๐Ÿ  Housing sales in Nashville

๐Ÿ›’ Walmart Sales Analysis SQL Project

๐Ÿงณ Alex the Analyst SQL Project

๐ŸŒณ NYC Tree Census and Income project

โŒจ๏ธ Building SQL Project With E-Commerce Dataset From Kaggle

๐Ÿฆ  Covid19 Exploratory Analysis

โšฝ๏ธ European Soccer Database Analysis Using SQL

๐Ÿค‘ Superstore Sales Analysis using SQL

๐Ÿ›ฃ UK Road Safety Analysis Project 2015

๐Ÿ’ธ International Debt Analysis using SQL

โšฝ๏ธ Soccer Game Analysis using SQL

๐ŸŒ World Population Analysis 2015 using SQL

๐Ÿ“‰ SQL Project for Data Analysis

๐Ÿš Public Transportation Data Analysis using SQL

๐Ÿ“ธ Instagram User Data Analysis using SQL

๐Ÿ™Œ HR Data Analysis using SQL

๐ŸŽฌ Data Analyst Project: Step-by-step analysis with SQL

๐ŸŽผ Music Store Data Analysis Project Using SQL


Other posts:

๐Ÿ”ฅ 20 Step-by-Step Data Analysis Projects with Python Code
๐Ÿ”ฅ Free Data Job Simulation Programs with Certificate


#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst #sql

If you find this useful, give it a
๐Ÿ”ฅ
  • ๐Ÿ”ฅ 24
  • โค 12
  • ๐Ÿ‘ 12
Post #15 11K
๐Ÿ“‰ Free Data Analysis Course with Certificate


Recently, I noticed freeCodeCamp.org has a course called "Data Analysis with Python". This course teaches Python specifically for data analysis.

๐Ÿ”ฅ The course covers the entire data analysis process, explaining how to use libraries like Numpy, Pandas, Matplotlib, and Seaborn.

๐Ÿ”ฅ In the practical part, you get 5 projects to work on independently, with all the necessary information and examples provided. The projects include demographic data analysis, medical data visualization, sea level predictor, deviation calculator, and time series visualization.

๐Ÿ”ฅ You can get a certificate for free upon completion.


freeCodeCamp.org also has other free courses with certificates to further expand your knowledge:

- Algebra with Python (which gives a deeper understanding of math and data science)
- Machine Learning (which is useful for data analysts since many companies now require machine learning skills).


#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst

If you like this type of content, hit ๐Ÿ”ฅ.
  • ๐Ÿ”ฅ 54
  • ๐Ÿ‘ 23
  • โค 12
  • โšก 5
Post #14 12.5K
๐Ÿ‘จโ€๐Ÿ’ป 5 Platforms to Get Your First Experience as a Data Analyst


What is IT volunteering?
It's about helping non-profit organizations that can't afford to hire IT specialists for tasks like data analysis, programming, and marketing. Usually, this work is project-based rather than a permanent job.

Benefits:

1. Gain experience and add to your portfolio
2. Get recommendations for your resume
3. Help others at the same time


Here is the list of platforms where you can volunteer your data analytics skills:

ะกatchafire

Datakind

Statisticswithoutborders

Vizforsocialgood

Technologyvolunteers

If you can't find the right tasks on websites, you can take the initiative and offer your skills directly to a non-profit organization you know.


#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst


If you find this content useful, give it a๐Ÿ”ฅ!
  • ๐Ÿ”ฅ 40
  • ๐Ÿ‘ 20
  • โค 9
  • ๐Ÿ’ฏ 6
  • ๐Ÿ‘Œ 1
Post #11 9.91K
๐Ÿ”ฅ Learn Python for Data Analysis: Easy Self-Study Roadmap

I made 2 diagramsโ˜๏ธto help beginners who want to learn Python for data analysis on their own.

_____________________________________


#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst #python


If you like this type of content, hit ๐Ÿ”ฅ.

Give a FREE BOOST to My Channel https://t.me/boost/thinkbroadly
  • ๐Ÿ”ฅ 34
  • ๐Ÿ‘ 13
  • โค 9
Post #9 11.3K
๐Ÿ”ฅ 20 Step-by-Step Data Analysis Projects with Python Code


Below are popular data analysis projects from Kaggle, Github, and Medium users. They will:

- Help you gain skills in working with real data
- Introduce you to Python libraries for data analysis
- Inspire you for your own data analysis projects


#data_analyst #data_analysis #data_projects


โ˜• Coffee Shop Sales Analysis

โšฝ FIFA World Cup Data Analysis

โšก๏ธADIDAS Sales Analysis

๐Ÿ“ฑ Netflix Data Analysis (1)

โšก๏ธ Zomato Data Analysis

๐Ÿซ Product Sales Analysis

๐Ÿš• Uber Rides Data Analysis

๐Ÿ‘€ Smartwatch Data Analysis

๐Ÿค‘ Financial Budget Analysis

๐Ÿ“ฑ Netflix Data Analysis (2)

๐ŸŽฎ Video Game Sales Analysis

๐Ÿค“ Is There a Trend of Increasing Geek Girls?

๐Ÿ† Let's Discover More About the Olympic Games!

๐Ÿ“‰ Marketing Analysis

๐Ÿถ Animal Shelter Data Analysis

๐Ÿ“ฑ Amazon Data Analysis

๐Ÿ’ฒ Billionaire Data Analysis

๐Ÿ“ฑ Credit Card Data Analysis

๐Ÿ˜ Pokemon Data Analysis

๐Ÿ“ฑ Spotify Data Analysis. What Does It Take to Hit the Charts


#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst #python


If you find this content useful, give it a๐Ÿ”ฅ!
  • ๐Ÿ”ฅ 44
  • ๐Ÿ‘ 26
  • โค 15
  • ๐Ÿ†’ 1
Post #7 14.5K
๐Ÿ”ฅ Free Data Job Simulation Programs with Certificate

I completed one of the simulators to recommend it to you.

These simulators are suitable for those who want to practice on real tasks and understand what a data analyst does at leading companies.

- Online simulators imitate a workday at top companies
- No prior knowledge is required โ€“ the necessary information is provided for task completion
- In the end, you receive a certificate and the opportunity to connect with recruiters

Register โžก๏ธ Receive video instructions from real employees โžก๏ธ Complete the task โžก๏ธ Compare your work with the companyโ€™s example โžก๏ธ Upload your resume โžก๏ธ Receive a certificate and the opportunity to connect with recruiters.

๐Ÿ˜ŽSimulators:

1. Data Analytics & Visualization at Accenture (a leading consulting firm from the Fortune Global 500 list)
2. Power BI at PwC (a consulting firm from the "Big Four")
3. Data Analytics at Quantium (a company specializing in data science and AI)
4. Data Visualisation: Empowering Business with Effective Insights at Tata (a multinational conglomerate operating in 150 countries)

All data-related simulators are here.
Simulators for other skills (marketing, project management, consulting, etc.) are here.

#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst

If this was helpful, subscribe for even more insights๐Ÿ”ฅ
  • ๐Ÿ”ฅ 91
  • ๐Ÿ‘ 49
  • โค 24
  • ๐Ÿ™ 1
Post #6 12.4K
SimilarWeb can significantly overstate website visit statistics, so:

1. Don't fully trust when someone shows you statistics from SW
2. Don't use SW for the analysis of your website; use Google Analytics.

GA collects more accurate data. Similarweb collects data from available sources and makes estimates and predictions using machine learning.

Anyway, it's a good tool for competitor analytics.

A visit can be roughly equated to a session start in Google Analytics.

#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst
  • ๐Ÿ‘ 13
  • โค 2
  • ๐Ÿ‘Ž 1
  • ๐Ÿ”ฅ 1
Post #5 12.1K
3 Trends in Data Analytics: From 2023 to 2024

Hello, friends! I hope you're well-rested and ready to work? Today, let's talk about what made 2023 memorable and what will continue to gain momentum in 2024.

#1 Artificial Intelligence in Analytics

The combination of "Analytics + AI" seems to be with us forever now.

๐Ÿ”ธ PowerBI, Tableau, and others have implemented AI
๐Ÿ”ธ ChatGPT released Data Analyst
๐Ÿ”ธ Numerous startups with analytics and AI

#2 Self-Service Analytics and "Data Democratization"

People without a technical background and without the help of an analyst can now:

๐Ÿ”ธ Access data quickly (using natural language database queries)
๐Ÿ”ธ Perform simple analysis in seconds

All this is thanks to AI and intuitive interfaces.

Despite the disappointment with AI in 2023 and the realization of its limitations, ignoring this trend would be a mistake. Gartner predicts that by 2024, 75% of organizations will use AI for analytics.

#3 Embedded Analytics

Analytics is being integrated into various applications and processes, improving decision-making and allowing users to independently find and solve problems, as well as find ways to improve. Examples:

๐Ÿ”ธ Kodak has embedded analytics in its software for printing machines, allowing for tracking of ink usage efficiency
๐Ÿ”ธ Shopify offers analytics tools on its dashboard for merchants to track sales, customer behavior, and other key business metrics.

In conclusion, all these processes will not replace an analyst. They are just a powerful tool for in-depth work and reducing manual labor.

Wishing everyone successful analysis in 2024!

#DataAnalyst #DataAnalytics #DataAnalysis #data_analyst
  • ๐Ÿ‘ 28
  • ๐Ÿ”ฅ 7
  • โค 3
  • ๐Ÿ‘ 2
  • ๐Ÿ˜ 1
Post #1
Channel created
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook โ†’Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 โ†’