# ![@loresowhat Avatar](https://lunarcrush.com/gi/w:26/cr:tiktok::7121788966412026886.png) @loresowhat Self-taught Data Analyst

Self-taught Data Analyst posts on TikTok about tableau, data, python, business the most. They currently have [-------] followers and [---] posts still getting attention that total [-----] engagements in the last [--] hours.

### Engagements: [-----] [#](/creator/tiktok::7121788966412026886/interactions)
![Engagements Line Chart](https://lunarcrush.com/gi/w:600/cr:tiktok::7121788966412026886/c:line/m:interactions.svg)

- [--] Week [-----] -48%
- [--] Month [------] -98%
- [--] Months [---------] +435%
- [--] Year [---------] -62%

### Mentions: [--] [#](/creator/tiktok::7121788966412026886/posts_active)
![Mentions Line Chart](https://lunarcrush.com/gi/w:600/cr:tiktok::7121788966412026886/c:line/m:posts_active.svg)

- [--] Week [--] -10%
- [--] Month [--] +23%
- [--] Months [--] +39%
- [--] Year [--] +119%

### Followers: [-------] [#](/creator/tiktok::7121788966412026886/followers)
![Followers Line Chart](https://lunarcrush.com/gi/w:600/cr:tiktok::7121788966412026886/c:line/m:followers.svg)

- [--] Week [-------] +0.15%
- [--] Month [-------] +0.30%
- [--] Months [-------] +0.04%
- [--] Year [-------] +16%

### CreatorRank: [-------] [#](/creator/tiktok::7121788966412026886/influencer_rank)
![CreatorRank Line Chart](https://lunarcrush.com/gi/w:600/cr:tiktok::7121788966412026886/c:line/m:influencer_rank.svg)

### Social Influence

**Social category influence**
[technology brands](/list/technology-brands)  27% [social networks](/list/social-networks)  6% [stocks](/list/stocks)  1%

**Social topic influence**
[tableau](/topic/tableau) #51, [data](/topic/data) #1759, [python](/topic/python) #292, [business](/topic/business) #4168, [how to](/topic/how-to) 7%, [save](/topic/save) #1718, [if you](/topic/if-you) 4%, [check](/topic/check) 3%, [more than](/topic/more-than) #2061, [matter](/topic/matter) 3%

**Top accounts mentioned or mentioned by**
[@withregram](/creator/undefined)

**Top assets mentioned**
[Uber Technologies, Inc. (UBER)](/topic/$uber)
### Top Social Posts
Top posts by engagements in the last [--] hours

"Take a look at 'A Day in the Life of Americans' 👀 Based on the data from the American Time Use Survey conducted in [----] this simulation represents a typical day for [----] people 👉🏻Share it with your friend if you found it interesting  #datavisualisation #datavisualizations #datavisualizationdesign #datavisualizationtools #datascienceeducation #datavisualization #dataanalytics #dataanalysis #dataanalyst #datascience #careerchange #data #powerbi"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7244883134733454618)  2023-06-15T12:06Z 134.2K followers, 23.8K engagements


"Check my link in bio to get my Resume template for FREE 💯🤩  #datavisualisation #datavisualizations #datavisualizationdesign #datavisualizationtools #datascienceeducation #datavisualization #dataanalytics #dataanalysis #dataanalyst #datascience #careerchange #data #powerbi"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7382699172446735649)  2024-06-20T21:23Z 134.2K followers, 9.6M engagements


"SAVE it to get your perfect laptop🔥  #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7184798274954497285)  2023-01-04T14:06Z 134.4K followers, 48.3K engagements


"If you're working with messy SQL pipelines or chaotic data layers. This one tool will change your life. In this reel Im breaking down dbt the transformation tool that every data analyst and scientist should know in [----]. ✅ Version control for your queries ✅ Auto-generated data lineage ✅ Clean reusable tables ✅ And way fewer wtf is this logic moments If youve ever written the same SQL twice trust me you need dbt in your stack. Watch the full reel to see how it works and follow for the next underrated tool in this series 👇  #dataanalytics #sqltools #dbt #datatransformation #modernstack"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7530398976097455382)  2025-07-23T21:54Z 134.4K followers, [----] engagements


"Your SQL can do way more than SELECT * 💰 Most people stop at basic queries. Here's what actually gets you promoted: RFM customer segmentation. Recency frequency monetary value. Use NTILE to score customers into quartiles. Then case statements to classify them into champions loyal at risk and lost. This turns messy data into actual business strategy. Segment distribution shows where to focus. Actionable recommendations show what to do next. This is the difference between knowing SQL and driving decisions. Save this before your next review 📊 #SQLForBusiness #CustomerSegmentation #RFMAnalysis"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7603018520892411158)  2026-02-04T14:35Z [--] followers, [----] engagements


"SAVE these Tableau time saver tips  [--]. Add Excel Data Source with Copy-Paste [--]. Format at the Workbook Level (Not the Sheet Level) [--]. Quick Copy Fields with Control-Drag Check my profile for more DATA ANALYTICS TIPS😉  #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7196675895493496070)  2023-02-05T14:18Z 134.4K followers, [----] engagements


"❌ Struggling to filter data effectively 👉 Save this post for your ultimate guide on data filtering Filtering data based on conditions is a crucial skill in data analytics. Whether youre using SQL Tableau or Python mastering this can significantly boost your data insights. Ready to enhance your data filtering skills Follow @loresowhat for more data tips 📈  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching #datascience #sqlserver #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7385699486019882272)  2024-06-28T23:26Z [--] followers, 330K engagements


"Watch this reel to get a clear and simple roadmap for learning Tableau perfect for beginners Youll see: 🗺 What to focus on first (no more guessing) 📊 The key features you actually need to know ✅ How to build dashboards that stand out Whether youre building your first portfolio or prepping for interviews this guide will help you learn smarter not harder. ➡ Follow @loresowhat for more easy-to-follow data tool roadmaps #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7500565671294536982)  2025-05-04T12:25Z 134.4K followers, 21.9K engagements


"Want to find totals across categories Thats where grouping comes in. Whether youre using SQL Tableau or Python grouping lets you split data into categories and calculate the sum (or any other metric) for each group. Examples: 🍕 Total sales by product 👩🎓 Average score by class 🏙 Revenue by city Once you master this your analysis instantly becomes more powerful. 👉 Follow for more practical breakdowns like this #datascience #sql #python #tableau #dataanalytics"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7591155584615910678)  2026-01-03T15:20Z [--] followers, 24K engagements


"This is how I do exploratory data analysis with SQL fast This video walks you through my exact EDA process using SQL (step-by-step) Super simple super structured. I break down how to explore your dataset find patterns spot outliers and uncover insights that actually matter. Follow me for more clean walkthroughs like this"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7597093827718991126)  2026-01-19T15:24Z 134.4K followers, [----] engagements


"Nobody shows you how statistics actually works in real data analysis (until now) 📊 So everyone says "learn statistics" but then you're stuck with textbook formulas that don't connect to actual work. Here's the exact statistical pipeline I run on every customer dataset: Start with descriptive statistics. Calculate mean median mode standard deviation and variance for transaction amounts. This shows you central tendency and spread. You need to know what "normal" looks like before you find what's weird. Calculate percentiles and quartiles. Use the quantile function to find 25th 50th 75th and"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7602265261089033494)  2026-02-02T13:52Z 134.4K followers, [----] engagements


"The market shifted. Juniors do Phase [--] but seniors They own Phases [--] and [--]. Git CLI dbt Python pipelines. That's what separates the top 1% from everyone else. I learned this the hard way after getting passed over twice. Now I teach all three phases because knowing just analysis isn't enough in [----]. Comment which phase you're working on and save this roadmap 📊 #FullStackDataAnalyst #DataAnalytics #DataCareer #SQLSkills"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7604803156920323331)  2026-02-09T10:00Z [--] followers, [---] engagements


"I spent the first half of last year chasing every new AI tool that dropped thinking I needed to know them all. But here's what I learned. The people winning right now aren't the ones using the most tools. They're the ones who mastered a few core skills that make AI actually work for them instead of just playing around with it. This breakdown covers the six skills that separate people who dabble from people who build. Prompt engineering so you stop getting garbage outputs. Workflow automation that saves you hours every week. RAG systems that turn AI into an expert on your own data. And the"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7605174574036159766)  2026-02-10T10:01Z [--] followers, [----] engagements


"The biggest mistake career transitioners make is trying to pretend they are fresh graduates. You have [--] [--] or [--] years of "soft skills" that a 22-year-old CS graduate does not have. **The "Domain Translation" Strategy:** **1. The Teacher ➡ The Communicator** You aren't "just a teacher." You are an expert in **Data Storytelling** and explaining complex topics to non-technical audiences (students/parents). **2. The Salesperson ➡ The KPI Expert** You aren't "just sales." You understand **Revenue Metrics** CRM data quality and exactly what numbers stakeholders care about. **3. The Chef/Ops ➡ The"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7605242404043558166)  2026-02-10T14:24Z [--] followers, [---] engagements


"Most tutorials skip this part because its not sexy. But heres the truth: messy data is why your analysis breaks at 2am before a presentation. The difference between junior and senior analysts Juniors clean as they go and hope for the best. Seniors have a repeatable system that catches errors before they become problems. I spent way too long learning this the hard way. You dont have to. Save this for your next project 📊 #DataCleaning #PythonForDataScience #DataQuality #DataAnalyticsTutorial"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7605575699205803286)  2026-02-11T11:58Z [--] followers, [----] engagements


"Your portfolio needs this SQL project more than another tutorial 📊 Most people learn SQL then freeze when asked to build something real. Here's the end to end dashboard that actually gets you interviews This isn't just queries. It's a complete business intelligence system that shows you can think like an analyst not just write code. Comment "CODE" for the full SQL code. Save this before you apply to your next job 🎯 #SQLProjects #DataAnalystPortfolio #SQLForBusiness #PortfolioProject"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7605605462444084502)  2026-02-11T13:53Z [--] followers, [----] engagements


"The market split into four tiers. Priority is SQL Python one BI tool and AI as copilot. Growing adds analytics engineering and Git. Emerging is dbt and LLM assisted analysis. Know where you stand 📊 Comment your current tier and save this roadmap. #DataAnalytics2026 #DataSkills #AnalyticsTechStack #DataCareerRoadmap"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7605999099044842774)  2026-02-12T15:21Z [--] followers, [---] engagements


"They scan titles first then problem statements then tools. If your project says "EDA Project" or has no business context they're already gone. Show impact not just visuals 📊 Comment which section you're fixing first and save this for your portfolio audit. #DataPortfolio #DataAnalystPortfolio #PortfolioTips #DataCareer"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7606291097052089622)  2026-02-13T10:14Z [--] followers, [---] engagements


"I had [----] connections but zero recruiter DMs. Changed these [--] things now I get 3-5 messages per week: [--]. Headline (Most Important) ❌ "Data Analyst at XYZ Company" ✅ "Data Analyst SQL Python Tableau Helping Teams Make Data-Driven Decisions Open to Opportunities" Add keywords + "Open to Opportunities" (recruiters search for this) [--]. Profile Photo Professional headshot (not a selfie) Solid background good lighting Smile (approachable = more messages) [--]. Banner Image Don't leave it default blue Use Canva: Add text with your skills "SQL Python Tableau Power BI" [--]. About Section (First [--] Lines"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7606660556166090006)  2026-02-14T10:07Z [--] followers, [---] engagements


"❌ Struggling to calculate the moving average in SQL Tableau or Python 👉 Save this post to master moving averages across these platforms 📊 Understanding moving averages is crucial for data analysis smoothing out fluctuations to reveal trends. Whether you're a beginner or seasoned pro knowing how to implement them in SQL Tableau and Python is a game-changer. 🚀 Each tool offers unique strengths. Watch this reel to see a step-by-step guide on each 🎥 👉 Follow @loresowhat for more data tips and tutorials  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7383864995081162017)  2024-06-24T00:48Z 121.2K followers, 17.8K engagements


"Check my link in bio to get my FREE resume and portfolio templates to help you land your dream job 💯🤩  #datavisualisation #datavisualizations #datavisualizationdesign #datavisualizationtools #datascienceeducation #datavisualization #dataanalytics #dataanalysis #dataanalyst #datascience #careerchange #data #powerbi"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7384163349711342880)  2024-06-24T20:05Z 75.6K followers, 16.4K engagements


"Ready to dive into the world of Python 🐍 Here's a 10-day guide to get you coding like a pro. Don't forget to save for reference and follow 👉@loresowhat for more learning roadmaps 📘 #bigdataanalysis #datasciencetraining #datasciencelearning #datavisualizationtools #learncoding #exceltips #cvtips #dataanalyst #careertips #codingbootcamp #machinelearning #data #datascience"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7391626329046764833)  2024-07-14T22:45Z 115.6K followers, [----] engagements


"❌ Finding data grouping and sum calculations tricky 👉 Save this post for your go-to guide on data grouping and calculations Mastering data grouping and sum calculations is essential for data analysis 📊. In this reel we break down the process step-by-step: [--] SQL: Learn to use GROUP BY and SUM functions to aggregate your data effortlessly. [--] Tableau: Visualize grouped data and create sum calculations with ease. [--] Python: Utilize pandas to group data and compute sums efficiently. Don't miss out on these key skills Follow @loresowhat for more data tips and tricks. 🚀  #pythonlearning"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7399782926767901985)  2024-08-05T22:17Z 134K followers, [----] engagements


"❌ Thinking that data analytics is just about learning Python SQL and Tableau Time to adjust your view 👇 👉 Save this post to get a reality check before you leap Entering the field of data analytics involves more than mastering technical tools. It requires awareness of the challenges that arent immediately obvious. Youll need to grasp the importance of data storytelling and the patience necessary for data cleaning among other skills. This journey involves recognizing the demanding aspects of data analytics which include resilience adaptability and a detailed focus beyond just programming and"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7409079328060853537)  2024-08-30T23:31Z 115.6K followers, [----] engagements


"Dealing with missing data driving you crazy Youre not alone 👉 Check out this reel to learn how to handle missing data in SQL Tableau and Python in a super simple way. Missing data can mess up your whole analysis but there are easy tricks to fix it In this video Ill show you how ✅ No more data headaches This is your quick guide to make sure your analysis stays on point. Hit play and lets make this easy 🎥 👉 Follow @loresowhat for more data tips #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7419487882643016992)  2024-09-28T00:42Z [--] followers, [----] engagements


"🚀 SQL Skills Boost: The HAVING Clause 🚀📊 In Part [--] of our SQL series I am talking about the HAVING clause - a key tool for advanced data filtering. Dive in to learn how to effectively filter grouped data in SQL. 🧮 👉 Make sure to SAVE this as part of your SQL learning path and follow @loresowhat for more in-depth SQL tutorials #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltip"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7429472416461606177)  2024-10-24T22:27Z 115.1K followers, [----] engagements


"Python is one of the most in-demand skills for data careers right now and its actually not as tough as you might think In this series Ill show you what Python is all aboutstarting with how its used in real life to find sales trends or even make charts with just a few lines of code. 📊💻 We'll also talk about libraries or pre-made tools in Python that help us get things done faster and easier. From math to data analysis these libraries are like shortcuts to make your life easier 👇 Comment "course" if youre interested in learning Python Excel SQL and Tableau in under [--] days  #datascience"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7435649021663776032)  2024-11-10T13:55Z 115.5K followers, [----] engagements


"🔥 Want to learn Python the easy way Lets do this Python is the #1 programming language everyones talking aboutand for a good reason. If you want better career opportunities this is your sign to start learning 🐍 In this reel Im showing you how to work with your data using pandas: [--] How to quickly check out your data. [--] Use df.describe() to get cool stats like averages and max values. [--] Find missing info in your data. [--] Pick and choose the data you actually need. This is just Part [--] of my Python seriesdont miss the earlier ones 🔥 👉 Comment COURSE for more info and follow me so you dont miss"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7441711361920453920)  2024-11-26T22:00Z 134.3K followers, [----] engagements


"Working with nested data can feel overwhelming especially if you're dealing with JSON or hierarchical data in SQL. But the good news Its easier than it seems when you break it down Nested data doesn't have to be a nightmare anymore watch this reel now and start applying these techniques in your next project 🚀 👀 Want more actionable SQL tips Follow @loresowhat for insights that simplify data analytics  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching #datascience #sqlserver #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7445290983815728416)  2024-12-06T13:31Z 133.3K followers, [----] engagements


"Heres the deal: when your data is split into different tables its hard to see the full picture. Thats where merging DataFrames comes inits like putting puzzle pieces together so everything makes sense. What were covering in Part [--] of my Python series: [--] Why merging tables is super important. [--] How to use the merge() function in Python to combine your data. [--] The difference between joins (inner left and right)and when to use each. [--] A simple example with sales and inventory to show how this works in real life 📌 Dont miss Part 10follow @loresowhat to keep learning Python in the easiest way"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7451747732747750689)  2024-12-23T23:07Z 115.3K followers, [---] engagements


"Want to dive deep into Al & Machine Learning Check my link in bio for a FREE PDF guide where I break down Al explain ML and cover ML algorithms in great detail #datavisualisation #datavisualizations #datavisualizationdesign #datavisualizationtools #datascienceeducation #datavisualization #dataanalytics #dataanalysis #dataanalyst #datascience #careerchange #data #powerbi"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7481756757098876182)  2025-03-14T19:57Z 134.3K followers, [----] engagements


"❌ Struggling to calculate the moving average in SQL Tableau or Python 👉 Save this post to master moving averages across these platforms 📊 Understanding moving averages is crucial for data analysis smoothing out fluctuations to reveal trends. Whether youre a beginner or seasoned pro knowing how to implement them in SQL Tableau and Python is a game-changer. 🚀 Each tool offers unique strengths. Watch this reel to see a step-by-step guide on each 🎥 👉 Follow @loresowhat for more data tips and tutorials  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7487263595311549718)  2025-03-29T16:06Z 121.2K followers, 22.5K engagements


"A lot of people mix up WHERE and HAVING in SQL. and it can break your query 😱 Heres the simple fix: ✅ Use WHERE to filter data before grouping it. ✅ Use HAVING to filter data after grouping it. If you switch them up your results might be totally wrong 🚫 Check out the video to see how it workssuper easy once you get it 👀📊 ➡ Follow @loresowhat for more simple data tips #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching #datascience #sqlserver #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7488734730565864726)  2025-04-02T15:15Z 134.5K followers, 19.3K engagements


"🚨 Still writing long GROUP BY clauses 👉 Save this post if you want to write cleaner SQL in less time In this video Ill show you a simple trick to make your GROUP BY shorter using column positions instead of names. Perfect if you: 🔹 Want to keep your queries clean 🔹 Work with long SELECT statements 🔹 Are tired of repeating yourself Its a tiny change that can make your code easier to read and faster to write 💬 Ever used this trick before Let me know in the comments ➡ Follow @loresowhat for more quick SQL tips that actually make your life easier. #pythonlearning #pythonprojects"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7490220310210350358)  2025-04-06T15:20Z 131.9K followers, [----] engagements


"A lot of people mix up WHERE and HAVING in SQL. and it can break your query 😱 Heres the simple fix: ✅ Use WHERE to filter data before grouping it. ✅ Use HAVING to filter data after grouping it. If you switch them up your results might be totally wrong 🚫 Check out the video to see how it workssuper easy once you get it 👀📊 ➡ Follow @loresowhat for more simple data tips #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching #datascience #sqlserver #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7511346667816226071)  2025-06-02T13:41Z 134.6K followers, [----] engagements


"Want to see how the same analysis looks in SQL Tableau and Python In this reel I show you how to calculate Average Order Value by month using all three tools side by side. Perfect if you're trying to level up your skills across platforms. Tap to watch and follow @loresowhat for more coding breakdowns like this one.  #datascience #dataanalytics #dataanalysis #sqltips #exceltips #pythonlearning #powerbi #dataanalyst #datavisualisation #careerchange #datasciencejobs #learncoding #machinelearning"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7517638248420756758)  2025-06-19T12:35Z 134.5K followers, [----] engagements


"If you work with data and dont know how to calculate percentage of total sales by category This is your sign to fix that today. Ill show you how to do it in: ✅ SQL ✅ Python ✅ Tableau Side-by-side. No fluff. Just clean code and visual logic. Watch this reel to lock it in and follow for more hands-on breakdowns like this.  #dataanalytics #sqltutorial #pythonforbeginners #tableautips #learnwithme #datascience"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7520975897659280662)  2025-06-28T12:27Z 134.2K followers, [----] engagements


"Natural language + Python = serious time saved 🧠 This tool lets you skip the syntax and ask your data questions directly like whats the average sales per region or plot the top [--] products by revenue Its called PandasAI and its probably the fastest way to explore a dataset youve never seen before I break it down in this video 👇 Then binge the rest of this tool series on my profile If you work in data youll want to keep these in your pocket.  #dataanalytics #dataanalysis #pandasai #datasciencetools #pythontips #aiinanalytics #analyticsworkflow #loresowhat #sqlpythonexcel #businessintelligence"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7527693128279526678)  2025-07-16T14:54Z 134.3K followers, [----] engagements


"If youre still doing [--] joins just to find your top-selling product category Youre overcomplicating it. This reel shows you how to get max sales by category using SQL & Python step-by-step. Super simple super fast. Watch it now and follow for more clean no-fluff walkthroughs like this.  #dataanalytics #sqltutorial #pythonforbeginners #dataanalysis #dataanalysttips #sqlpythonexcel #datasciencelearning #loresowhat"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7529666835667537174)  2025-07-21T22:33Z 134.4K followers, [----] engagements


"Most people build cool stuff with Python Then throw it in a notebook and hope someone cares. But what if you could turn that into a web app your manager actually wants to use Thats Streamlit. Write Python. Click save. Boom: youve got a live interactive app. In this video Ill show you: ✅ What Streamlit is ✅ How to get started in [--] lines ✅ Why it beats screenshots or notebooks for stakeholder projects ✅ The one feature that makes it feel like magic Whether youre in data science analytics or just want your work to look better You need this tool in your stack. 🔥 Watch the full reel 🎯 Save this"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7531489913942871318)  2025-07-26T20:27Z 134.4K followers, [----] engagements


"📍 Check the link in bio to sign up for the full program. This AI agent writes YouTube video descriptions in seconds. Not templates. Not prompts. Just one click. It reads your script or transcript and auto-generates a polished keyword-optimized description ready to publish. This is just one of the many automations I teach inside the Analytics and Automation Academy. The goal To help you build your own AI agents that actually do the boring stuff for you. Youll learn how to: ✅ Automate repetitive tasks ✅ Speed up your analytics workflow ✅ Create smart tools that save hours every week This isnt"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7535260028597521686)  2025-08-06T00:17Z 134.4K followers, [---] engagements


"This reel is Part [--] in my data cleaning series. Same project same messy datasee but now were moving further into the process and tackling the next set of fixes. Still real errors. Still live debugging. Still the exact workflow I use on the job. The full video walks you through the entire thing from start to finish so you can follow along build your skills and add it to your own portfolio work. Watch it now link in bio.  #dataanalytics #pythonforbeginners #datacleaning #pandaspython #analyticsworkflow #sqlpythonexcel #portfolioideas #loresowhat"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7537103346079894806)  2025-08-10T23:30Z 134.3K followers, [---] engagements


"Thinking Kaggle is your only option for Data Analytics projects Think again 👉 Save this post to explore fresh unique data sources for your next project Kaggle has been a go-to for many but to stand out in interviews showing variety in your projects is key. In this post you will find a list of websites offering diverse datasets that can elevate your Data Science skills Swipe now 🚀 Follow @loresowhat for more insights into making your Data Analytics journey unique and successful  #datascience #careerchange #data #datascientist #dataanalytics"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7538052901281877270)  2025-08-13T12:55Z 134.4K followers, [----] engagements


"❌ Tired of spending hours manually cleaning data 👉 Save this post to master removing duplicates in SQL Tableau and Python Duplicate data can skew your analysis and lead to misleading insights. But dont worry Ive got you covered WATCH this reel to learn how to use SQL Tableau and Python to tackle duplicates ensuring your data is pristine and reliable. ✅ Ready to take your data skills to the next level Dive into this reel to learn step-by-step methods for each tool Follow @loresowhat for more tips on mastering data analytics. 🌟  #pythonlearning #pythonprojects #pythoncoder"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7539199991315778838)  2025-08-16T15:06Z 134.3K followers, [---] engagements


"Only [--] in [--] applicants actually send this. But every recruiter Ive spoken to says it makes a huge difference. Im talking about the follow-up email. Not the boring thank you for your time version the one that feels personal enthusiastic and reminds them why youre the right hire. Heres a template you can steal: 📝 Hi Interviewer Name thank you so much for todays interview. I really enjoyed learning more about specific part of the role/project/team. Our conversation confirmed my excitement to contribute to goal they mentioned. Please let me know if theres anything else you need. Id love the"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7539913357701205270)  2025-08-18T13:14Z 134.4K followers, [----] engagements


"Tell me something thats not on your resume. Sounds simple. But its actually one of the hardest questions to answer. Most people freeze and go with: ❌ I like hiking. ❌ Im very organized. ❌ Im a team player. Lets be real interviewers have heard those a hundred times. They dont want clichs. They want something real something theyll remember you by. Here are [--] stronger ways to answer instead: [--] Share volunteer work that shaped you [--] Talk about a passion project or side hustle [--] Mention a personal obstacle you overcame [--] Highlight a self-led learning journey [--] Tell a unique life experience that"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7542155437148245270)  2025-08-24T14:15Z 134.3K followers, [----] engagements


"The email nobody wants to see after applying: Unfortunately weve decided to move forward with an internal candidate. Hurts right But heres the thing youre not the problem. The real mistake is what most people do next: ❌ Ghost the company ❌ Reply with a generic Thanks for letting me know ❌ Close the tab and start doubting themselves Thats the wrong move. Because rejection can actually be the start of your next opportunity. Heres what to do instead: ✅ Reaffirm your interest in the company or mission ✅ Highlight how you could still add value with a specific skill or project ✅ Offer to stay in"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7542393797653646614)  2025-08-25T05:40Z 134.2K followers, [----] engagements


"Stats is the foundation of data science. Without it youre just guessing with numbers. Lets start simple: Population vs Sample 👇 ✅ A population is the entire group you want to study. Think all college students in the US or every Uber ride in NYC last year. ✅ A sample is just a smaller subset of that group. Like [----] randomly chosen students or [---] Uber rides from last year. If the sample is representative you can make solid conclusions about the entire population without studying every single point. This is one of the building blocks every data scientist needs to know. ❤ Follow @loresowhat to"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7547002961877044502)  2025-09-06T15:46Z 134.4K followers, [----] engagements


"Stats is the foundation of data science. Without it youre just guessing with numbers. In Part [--] we talked about Population vs Sample. Now in Part [--] lets break down one of the most important ideas in statistics: the Normal Distribution 📊 ✅ A normal distribution shows how likely different values of a variable are. ✅ Its the famous bell curve the peak is where most values lie and as you move away from the peak values become less common. ✅ Roughly: 68% of data falls within [--] standard deviation of the mean 95% within [--] 99.7% within [--] Examples Heights of adults exam scores or even measurement"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7549576867938880771)  2025-09-13T14:14Z 134.4K followers, [----] engagements


"Stop saying this in interviews 👇 ❌ Im a hard worker. (too generic) ❌ I really need this job. (sounds desperate) ❌ I dont know (instant deal breaker) The move Show how your skills solve their problems. Youre not chasing a paycheck: youre bringing measurable impact. Heres a template you can steal: 👉 You should hire me because I have the skills youre looking for AND Ive already proven I can apply them. For example at X company I specific result: boosted efficiency 20% cut costs streamlined reporting. I know I can bring the same results here especially since I see company goal/initiative and Id"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7551054066504387843)  2025-09-17T13:46Z 134.4K followers, [----] engagements


"The middle of your data isnt always the same thing. 📊 Mean = the average (good for balanced data) 📊 Median = the middle value (better when outliers exist) 📊 Mode = the most common value (great for categories) Each one tells a different story about your data. Thats why analysts dont just look at the mean. This is Part [--] of the Statistics Series. 👉 Watch Part [--] & Part [--] if you missed them then follow so you dont miss Part [--].  #statistics #datascience #analytics #datatips #sql"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7552201075089018134)  2025-09-20T15:57Z 134.4K followers, [---] engagements


"📊 Variance & Standard Deviation explained in [--] seconds Both measure how spread out your data is: ✔ Variance: average of squared differences from the mean ✔ Standard Deviation: square root of variance (same units as your data) Why it matters: Two groups can have the same average but VERY different spreads and that changes the whole story. 👉 Check out my profile for Parts [--] of this Statistics series 👉 Follow so you dont miss Part [--]  #datascience #statistics #analytics #python #sql"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7553687918422854934)  2025-09-24T16:07Z 134.4K followers, [----] engagements


"The Central Limit Theorem (CLT) is the secret reason the normal distribution shows up everywhere in data science 📊 Even if your raw data isnt normally distributed repeated sample averages will form a bell curve. Thats why its so powerful it lets us apply statistical methods with confidence. 👉 Check out my profile for Parts [--] of this statistics series. 👉 Follow for Part [--] coming soon  #datascience #statistics #dataanalysis #python #sql"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7556054439727992086)  2025-10-01T01:10Z 134.4K followers, [----] engagements


"Want to dive deeper The Channel link is in my bio 🔗 This is Part [--] of my 5-part data series. Were starting with the foundation: the [--] main categories of data structured semi-structured and unstructured. Getting these basics right is key before moving into cleaning analyzing and building real portfolio projects. The full video on YouTube walks you through everything step by step so you can learn apply and level up your skills. 👉 Channel links in my bio to watch the full breakdown #datascientist #data #datasciencetraining #datascientists #datasciencejobs #datascienceeducation"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7556252190227172630)  2025-10-01T14:15Z 134.4K followers, [----] engagements


"Want to make sense of messy data One of the most powerful skills is grouping data and calculating totals for each category. 💡 Example: You have sales data for multiple regions. Instead of looking at raw numbers group by region and sum the sales instant clarity ✅ This technique works in Excel SQL Python (pandas) and basically every analytics tool. Its the foundation for reporting dashboards and insights that actually drive decisions. Start thinking in groups not rows and youll see patterns you never noticed before. 👉 FOLLOW ME for more practical data analytics tips 🚀 #dataanalytics"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7558080961741671702)  2025-10-06T13:30Z 134.4K followers, [---] engagements


"Want to dive deeper The Channel link is in my bio 🔗 This reel is Part [--] of my 5-part data series. Were breaking down how data is stored: database data lake data warehouse and data mart. Knowing when and how to use these is key to building scalable data solutions working on real-world projects and standing out in interviews. The full video shows practical examples so you can clearly understand how each one works in business settings. 👉 Channel links in my bio to watch the full breakdown #datascientist #data #datasciencetraining #datascientists #datasciencejobs #datascienceeducation"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7558846500592209174)  2025-10-08T13:45Z 134.4K followers, [---] engagements


"If I had to break into DATA from scratch in [----] heres what Id actually do 👇 Forget the endless apply wait hope cycle. Id flip the script. STEP 1: Pick ONE role and learn the core skills recruiters actually care about (e.g. SQL Excel Power BI Communication Problem Solving). STEP 2: Build a small but powerful portfolio. Not perfect just real - dashboards case studies quick wins. STEP 3: Turn my learning into content. [--] days learning SQL or How I built this dashboard using a free dataset. This is what makes you discoverable. STEP 4: Talk to the community. Comment on posts. Ask smart"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7559597576287309078)  2025-10-10T14:19Z 134.4K followers, [---] engagements


"Most people miss this simple step but it could be the one thing that gets you hired 👏 Only [--] in [--] applicants actually do it and every recruiter says it makes a big difference 👀 Before you scroll away save this post or send it to yourself youll thank yourself after your next interview 💌 Its a follow-up email but not the boring thank you for your time kind. Make it sound personal confident and excited thats what stands out 💪 Heres what to say: Hi Interviewer Name thank you so much for todays interview. I really enjoyed learning more about specific part of the role/project/team. Our chat"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7560708878514588951)  2025-10-13T14:12Z 134.4K followers, [---] engagements


"SAVE this cheat sheet to learn data analytics 🔥  #dataanalytics #dataanalysis #dataanalyst #datavisualization #careertips #careeropportunities #datavisualisation #datavisualizations #pythonlearning #sql #careeradvice #python #data"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7179604566860647686)  2022-12-21T14:12Z 134.5K followers, [----] engagements


"FOLLOW me for weekly Data and AI posts 🔥  #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7195570831454506245)  2023-02-02T14:49Z 134.2K followers, [----] engagements


"SAVE THESE steps to learn SQL🔥  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching #datascience #datascience #datascience"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7198573469297052934)  2023-02-10T17:01Z 133.9K followers, 27.5K engagements


"Are you a student or professional looking to start a career in analytics 👉🏻SAVE this informative reel for later and learn the distinctions between data and business analysts.  #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7205938070150073606)  2023-03-02T13:20Z 134.4K followers, 10.6K engagements


"The job market is not in its best shape right now BUT this is what you can do to get closer to an offer in the data analytics space ✨ FOLLOW me if you want to land a job in data #dataanalyst #datascience #dataportfolio #tableau #python #sql #datacareers"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7223766429068233989)  2023-04-19T14:23Z 134K followers, [----] engagements


"Posted @withregram @loresowhat FOLLOW me for weekly Data analytics stories 🔥  #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7238334002329914651)  2023-05-28T20:32Z 134.5K followers, [----] engagements


"Want more job application tips 🤔 Check my profile for more👆🔗  #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7245263167679466779)  2023-06-16T12:41Z [--] followers, 120K engagements


"Access ALL Coursera Courses for only 1$ using my link in bio Dont miss this offer 🚀 #coursera #courserapartner"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7277572875144514849)  2023-09-11T14:19Z 28K followers, [----] engagements


"Dive into these essential resources every data analyst should bookmark 🚀 🐍 Python Your coding foundation starts here: python.org 🔄 Algorithms Dive into visualized algorithms at Algoanim.ide.sk 📊 Data Modeling Master the art of structuring data: learndatamodeling.com 🌐 Data Analysis Roadmap Your comprehensive guide to data analysis: shorturl.at/dCNT3 🔬 Data Science in Python [--] libraries every data scientist needs: mydataroad.com/37-libraries-of-python 🌟 Elevate your data analytics journey with these resources Don't forget to bookmark for reference & for more insights into the data"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7301409949832301856)  2023-11-14T19:59Z [--] followers, [----] engagements


"🚀 Mastering Data Cleaning: Handling Missing Data 🚀 👉 SAVE this for your data toolkit 👈 Diving deeper into data cleaning we're tackling one of the most common issues: Missing Data. In this part of the series learn to identify and fix the 'leaks' in your data. Missing data can take many forms from empty spaces and zeroes to 'N/A' or 'NaN'. Learning to spot these is vital. We'll explore tactics like removing unnecessary rows interpreting empty data for useful insights or using sophisticated methods to estimate missing values. 🔄 Check out this reel for a detailed walkthrough on managing"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7311722593453624609)  2023-12-12T14:58Z 134.4K followers, [----] engagements


"These are easy Python projects that you can create with less than [--] lines of code 📑 Merge Multiple PDF using Python 🎥 Youtube Downloader 🔲 QR Code generator 🎵 Extract mp3 to mp4 🔗 Link Shortener 👉🏻 Check @loresowhat for similar content #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltip"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7322515969966869792)  2024-01-10T17:01Z 134K followers, [----] engagements


"🚀 Master Data Partitioning 👉 SAVE this if you want to learn advanced SQL techniques 👈 Ever felt overwhelmed by handling massive datasets in SQL That's where the Data Partitioning comes in This advanced technique is crucial for anyone dealing with large datasets. It's not just about handling data; it's about doing it smartly. 🔄 Dive into the reel for a hands-on example and see how partitioning can transform your data analysis workflow. 👉 Follow @loresowhat for more insights on SQL and data strategies 👈  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7329958433778634016)  2024-01-30T18:22Z 134.4K followers, [----] engagements


"M❌ Struggling to filter data effectively 👉 Save this post for your ultimate guide on data filtering Filtering data based on conditions is a crucial skill in data analytics. Whether youre using SQL Tableau or Python mastering this can significantly boost your data insights. Ready to enhance your data filtering skills Follow @loresowhat for more data tips 📈  #pythonlearning #pythonprojects #pythoncoder #datasciencelearning #bigdataanalysis #sql #dataanalytics #dataanalysis #dataanalyst #careercoaching #datascience #sqlserver #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7474285926789696790)  2025-02-22T16:46Z 134K followers, 460.9K engagements


"🚨 Check the link in my bio to get my FREE AI guide 🤖✨ Ever wondered how AI actually works in real life I got you 🙌 Im talking about my ultimate AI guide simple clear and packed with everything you need to know. 💡 Heres whats inside: 👁 How AIs used every day from self-driving cars to your phones face ID. 💬 How computers see and talk yup they kinda get it now. 🎨 How AI creates stuff like art stories and even music. 🛠 The coolest AI tools the ones experts cant stop using. plus a bunch more to help you actually get how AI works. 💡 Hit the link in my bio and grab the guide now 🚀"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7474706199091498262)  2025-02-23T19:57Z 133.5K followers, [----] engagements


"✨ Want to try a tool that makes data pipelines way easier Check the link in my bio to explore Fivetran the tool data teams love for automating workflows (without all the messy code). #datascience #careerchange #data #datascientist #dataanalytics #dataanalysis #dataanalyst #newcareer #datasciencetraining #datascientists #datasciencejobs #datasciencelearning #datavisualisation #sqltips"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7502176791147089174)  2025-05-08T20:37Z 134K followers, [----] engagements


"How to calculate Year-over-Year Growth % in SQL Tableau & Python If youre trying to break into data this is one of those fundamental skills you NEED to know. Why Because businesses run on growth metrics. If you can measure YoY growth you can tell a story about whether a company is winning or losing. ✅ In SQL Use LAG() to compare current vs previous year ✅ In Tableau Quick Table Calculation does the heavy lifting ✅ In Python pct_change() in Pandas gets it done in seconds [--] tools. [--] concept. Master this and youll stand out in any analytics interview. 📌 Save this for your next project 👀 Follow"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7549512969663696150)  2025-09-13T10:06Z 134.1K followers, 51.8K engagements


"Grab them here 👉 Save this post for career options you didnt know you could explore. SQL opens doors to more than just one path. Consider these roles where your skills can shine: [--] Business Analyst: Use SQL to extract data and support key business decisions. [--] Business Intelligence: Turn data into dashboards and reports that drive insights. [--] Risk Analyst: Analyze data to identify risks and develop mitigation strategies. [--] Product Analyst: Dive into user behavior and product performance with SQL. [--] Operations Analyst: Optimize processes by managing operational data. [--] Market Analyst: Analyze"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7549948413232680214)  2025-09-14T14:15Z 134.2K followers, [----] engagements


"Ever wondered how we measure if two variables move together Thats where covariance and correlation come in: ✅ Covariance tells you if they move in the same direction (positive) or opposite (negative). ✅ Correlation tells you the strength of that relationship always between [---] and [--]. +1 Perfect positive [---] Perfect negative [--] No relationship Examples 📈 Height & weight positive correlation 🍦 Ice cream sales & temperature move together 👉 Check my profile for Parts [--] 👉 Follow to catch Part [--] of this series #datascience #statistics #machinelearning #python #analytics"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7555161863055510806)  2025-09-28T15:26Z 134.4K followers, [----] engagements


"How to Combine Multiple Datasets in SQL Tableau & Python In real projects data is rarely in one place so you NEED to know how to bring it together. ✅ SQL UNION ALL stacks rows from different tables ✅ Tableau Drag tables into the Union area on the Data Source page ✅ Python Use pd.concat(df1 df2 df3) to merge DataFrames [--] tools. [--] concept. Master this and youll handle messy real-world data like a pro. 📌 Save this for your next project 👀 Follow @loresowhat for more SQL Python & Tableau breakdowns #datascience #sqltips #tableau #python #dataanalysis #dataanalytics #dataanalyst #careerchange"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7557001196716969219)  2025-10-03T14:24Z 134K followers, [----] engagements


"Get this strategy When I first started out I thought you needed to be a math wizard or a hardcore coder to break into data analytics. Turns out thats not true at all. What actually helped me land my first role were a mix of practical tools + soft skills that I built step by step: 📊 **Excel** gave me the foundation cleaning messy data pivot tables and formulas. 🗄 **SQL** opened the door to real company data. 🐍 **Python** helped me automate and go deeper into analysis. 📈 **Tableau / Power BI** allowed me to actually *show* insights in a way people understood. 🗣 And most importantly:"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7557740203704700182)  2025-10-05T14:12Z 134.1K followers, [----] engagements


"💬 Video linked at my bio In this video Ill show you exactly how I use statistics as a Data Analyst from understanding central tendency and variability to applying them in Excel for real business insights. ✅ Save this if youre ready to make statistics your strongest data skill 👀 Follow for more practical data career tips #DataAnalytics #Statistics #DataAnalysis #Excel #DataScience #LearnData #AnalyticsCareer #DataForBeginners #BusinessAnalytics #loresowhat"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7568483668876954902)  2025-11-03T13:02Z 134.4K followers, [----] engagements


"🚫 Still wasting hours cleaning messy data 👉 Save this post to learn how to remove duplicates in SQL Tableau and Python the smart way Watch this reel to see how each tool handles duplicates so your data stays clean consistent and reliable. Master this one skill and instantly upgrade your data workflow ✨ Follow @loresowhat for more practical data analytics tips in SQL Tableau and Python. #DataAnalytics #DataCleaning #SQL #Python #Tableau #DataScience #DuplicateRecords #DataPreparation #AnalyticsTips #DataWrangling #LearnDataScience #DataAnalyst #UpSkillIndia #BigDataAnalysis #CareerInTech"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7570000034645740822)  2025-11-07T15:06Z [--] followers, [----] engagements


"📊 Want to see the bigger picture in your data One of the most powerful techniques is calculating percentage of total - it instantly shows you what really matters 💡 Example: You have sales data by region. Instead of just looking at raw numbers calculate each region's percentage of total sales to see which markets are actually driving your business. ✅ This technique works in SQL Tableau and Python - perfect for executive dashboards performance reports and spotting trends that raw numbers hide 📈 Start thinking in percentages not just totals and you'll uncover insights that drive real business"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7572254342166744342)  2025-11-13T16:54Z 134.4K followers, [---] engagements


"📊 Want to uncover hidden patterns in your data One of the most revealing techniques is calculating averages by group - it shows you what's really happening beneath the surface 💡 Example: You have employee salary data across departments. Instead of looking at one overall average group by department to see which teams are paid above or below average - instant insights for HR decisions. ✅ This technique works in SQL Tableau and Python - essential for benchmarking performance analysis and spotting trends that total averages completely miss 📈 Start thinking in group averages not just overall"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7577778020472196374)  2025-11-28T14:09Z 134.2K followers, [----] engagements


"Please dont miss this opportunity. The holiday season can actually be your advantage in todays job market heres why: ✅ Most applicants slow down or stop completely ✅ Recruiters continue shortlisting quietly in December ✅ January brings a hiring wave ✅ Staying active now puts you ahead of everyone restarting late Heres your holiday hiring plan: ✅ December [---] Focus: LinkedIn Optimization + Networking Why: Recruiters browse more during quiet weeks and engagement is higher. Action Steps: ✨ Refresh your headline About skills achievements 🗂 Add projects and measurable results 🤝 Connect with"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7581102122578480406)  2025-12-07T13:08Z 134K followers, [----] engagements


"🧩 Why Your Data Insights Are Wrong (and How to Fix It Fast) Because youre ignoring missing values 😩 💡 Example: Your dataset has blanks or NaN entries. Instead of deleting rows handle them smartly with: ✅ This small step keeps your dashboards clean and your analysis accurate - no more misleading results 🔄 Save this post to reference as you clean your data. 💡 Follow @loresowhat for more practical data analytics tips using SQL Tableau and Python #DataAnalytics #DataCleaning #SQL #Python #Tableau"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7565896887044214038)  2025-10-27T13:44Z [--] followers, [----] engagements


"Elevate your Pandas game with these powerful functions 🛠 [--] quantile(): Computes the quantiles of values in a column. [--] to_datetime(): Converts a column to a datetime data type. [--] to_numeric(): Converts a column to a numeric data type. [--] set_option(): Adjusts the display settings for the DataFrame. [--] reset_option(): Resets display settings to default values. [--] std(): Computes the standard deviation of a column. [--] rolling(): Applies a rolling window function on a column. [--] shift(): Shifts column values by a specified row count. [--] diff(): Computes differences between consecutive values. 🔟"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7282865406493084961)  2023-09-25T20:37Z 134.1K followers, [----] engagements


"🚀 Master SQL Window Functions 👉 Don't forget to SAVE this 👈 Eager to boost your SQL skills It's time to explore the world of Window Functions a must-know for data analysts. In this reel I'll guide you through the practical uses of SQL Window Functions enhancing your data analysis toolkit. We'll cover: [--] Running Total: Effortlessly monitor sales trends over time. [--] Moving Average: Simplify calculating averages for set intervals. [--] Sales Ranking: Use the RANK() function to spot your top sellers. 👉 Stay tuned to @loresowhat for more in-depth SQL tutorials and data analytics strategies 👈 "  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7325909628422737185)  2024-01-19T20:31Z 134.1K followers, [----] engagements


"Get my Resume template for FREE 💯🤩 Just click the link in my bio   #datavisualisation #datavisualizations #datavisualizationdesign #datavisualizationtools #datascienceeducation #datavisualization #dataanalytics #dataanalysis #dataanalyst #datascience #careerchange #data #powerbi Alfies DNA test came back His nose is just a birth defect Alfies DNA test came back His nose is just a birth defect"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7476736012316642583)  2025-03-01T07:14Z 134.1K followers, 3M engagements


"Learning dbt from scratch This is the exact 14-day roadmap Id follow if I had to start today no fluff just the steps that actually matter in the real world. 📦 Project setup Jinja models ✅ Testing and docs that build trust 🧠 Best practices for team workflows 🚀 Scheduling deployment and real collaboration If youre tired of scattered tutorials and want a clean plan that gets you job-ready with dbt. this reel is it. 🎯 Watch the full breakdown and follow @loresowhat for the next roadmap drop. 👇 Drop a comment if I missed something you'd include. #datascience #careerchange #data #datascientist"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7510331741203123478)  2025-05-30T20:02Z 134.2K followers, [----] engagements


"🚀 Want to compare date differences fast One powerful concept every data analyst should know DATEDIFF 💡 Example: You have a start and end date. Instead of manually counting days use DATEDIFF to instantly calculate the time between them whether in SQL Tableau or Python. ✅ Perfect for tracking project timelines customer churn delivery delays and more across any tool you use Think in date differences not just dates and watch your insights multiply 📈 👉 FOLLOW @loresowhat for more real-world data analytics tips #dataanalytics #sql #tableau #python #pandas #dataanalyst #analytics #datediff"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7563684020660309270)  2025-10-21T14:37Z 134.1K followers, [----] engagements


"🧹 Tired of messy customer data ruining your analysis Heres how to build a complete data cleaning pipeline in SQL that transforms chaos into crystal-clear insights 💡 Example: You have customer records with mixed case names inconsistent phone formats duplicate emails and missing values. Instead of manual cleanup use SQL to automate the entire process and get analysis-ready data in minutes. Stop wasting hours on manual data cleanup. Build this pipeline once and transform any messy dataset into gold. 👉 FOLLOW @loresowhat for more practical data analytics tips 🚀 #dataanalytics #dataanalysis"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7594483475286117654)  2026-01-12T14:34Z 134.1K followers, 20K engagements


"📊 Part [--] of our SQL series is here. Watch to learn how to summarize and analyze data using powerful aggregation functions. 🧮 [--] Getting Started with Aggregations: Learn how tools like SUM AVG and COUNT can provide key insights from big datasets. [--] SUM: Tallying Everything: Discover how to use SUM to add up numbers in your data. Swipe for a hands-on example 📈 [--] AVG: Calculating the Mean: Find out how AVG helps you figure out average values. Watch a real SQL example to see how it works. 🌟 [--] COUNT: Measuring Quantity: See how COUNT can tell you how many items you have in your data. Swipe to"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7427631230146923809)  2024-10-19T23:22Z [--] followers, [----] engagements


"This Python EDA framework literally changed how I analyze data 📊 I used to spend hours just staring at datasets trying to figure out where to even start. Then I built this system and now every e-commerce analysis takes me like [--] minutes max. Here's the exact order I run everything: Dataset overview first. Descriptive stats data types missing values date ranges. You need to know what you're working with before you do anything else. Sales by category next. Group by product category calculate revenue and AOV then visualize it. This shows you where the money actually is. Temporal patterns are"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7599667769562467606)  2026-01-26T13:52Z 134.4K followers, [---] engagements


"Just spotted these on LinkedIn and this is what companies are looking for RIGHT NOW Are you applying Drop a 🔥 below Tag someone who needs to see this 👇 #DataAnalyst #JobAlert #DataJobs #DataAnalytics #CareerOpportunity"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7597759067834076438)  2026-01-21T10:25Z [--] followers, [---] engagements


"Ive mapped out every essential SQL clause you need to master. This is the exact roadmap I followed to become proficient in SQL. My SQL Foundation: 🔍 WHERE Clauses - I filter data with LIKE IN BETWEEN ANY EXIST AND OR NOT 🧮 FUNCTIONS - I calculate values using AVG SUM COUNT MIN MAX 🔗 JOINS - I combine tables with INNER LEFT RIGHT FULL joins 📊 GROUP BY - I aggregate data and use COLUMN + HAVING to filter groups 📋 ORDER BY - I sort my results with ASC/DESC 🏷 ALIAS & AS - I rename columns for clarity I didnt learn SQL randomly. I followed this exact structure from basic filtering to complex"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7598546935284239638)  2026-01-23T13:23Z [--] followers, [---] engagements


"I wasted months doing things the hard way. These tricks wouldve saved me countless hours. Here are the [--] game-changers I use every single day Save this for your next analysis 💾 Which trick surprised you most Let me know 👇 #DataAnalyst #DataAnalytics #DataTips #DataScience #AnalyticsTricks"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7598934298628033814)  2026-01-24T14:26Z [--] followers, [---] engagements


"Heres the path most professionals follow: [--] Junior Data Scientist [--] to [--] years [--] Associate Data Scientist [--] to [--] years [--] Senior Data Scientist [--] to [--] years [--] Product Manager [--] to [--] years [--] Lead Data Scientist [--] to [--] years [--] Director / VP / SVP 15+ years At every stage the skills you build matter more than the title you hold. From SQL and data cleaning early on to project leadership and strategic decision-making later your growth is about learning to combine technical depth with business impact. 📌 Save this post to keep the roadmap handy 👀 Follow @loresowhat for more data career"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7601159708744879382)  2026-01-30T14:21Z [--] followers, [---] engagements


"I was doing everything wrong. Heres what actually got me interviews: [--]. Stop applying on LinkedIn Easy Apply 500+ people apply in [--] hours Your resume gets buried instantly ✅ Instead: Find the companys career page and apply directly. Add a cover letter. Takes [--] extra minutes but cuts competition by 80%. [--]. The 2-Hour Rule Apply within [--] hours of job posting Recruiters review the first [--] applications most carefully ✅ Set up job alerts on Google (data analyst jobs your city site:greenhouse.io) [--]. Customize for ATS keywords Copy 5-7 keywords from the job description Paste them naturally into"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7601559716967353622)  2026-01-31T16:14Z [--] followers, [---] engagements


"Most Data Analyst roadmaps tell you what to learn but not how much of each skill actually matters. I used to think I needed to be equally good at everything. SQL Python dashboards statistics communication. But when I started tracking what I actually used in real projects the distribution was wild. I was spending 40% of my time on business thinking and product strategy 30% writing SQL queries and only 10% on the stuff people obsess over like advanced Python or A/B testing. This roadmap shows you the actual breakdown. Where to focus your energy based on what the job really demands not what"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7602631077202791703)  2026-02-03T13:31Z [--] followers, [----] engagements


"They don't. And picking the wrong architecture will cost you weeks of debugging and frustration. I learned this the hard way when I tried forcing a GPT model to handle tasks it was never designed for only to realize months later I should've been using a completely different structure. This carousel breaks down the four main LLM architectures. GPT for generative text MoE for scaling efficiently VLM for vision and language tasks and the actual layers that make them tick. It's not just theory. It's the blueprint you need before you commit to building anything serious. Knowing this saves you from"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7602635968738331906)  2026-02-03T13:50Z [--] followers, [---] engagements


"I used to run a few SELECT statements and call it analysis. But real EDA The kind that gets you hired Thats different. This 7-step SQL framework is what I use on every project now. From CTEs to RFM segmentation it turns raw data into a story worth telling. Comment your favorite step and save this for your next project 📊 #SQLProjects #DataAnalytics #ExploratoryDataAnalysis #SQLPortfolio"  
[TikTok Link](https://www.tiktok.com/@loresowhat/video/7602942890247064854)  2026-02-04T09:41Z [--] followers, [---] engagements

Limited data mode. Full metrics available with subscription: lunarcrush.com/pricing