home.social

#dataanalyst — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #dataanalyst, aggregated by home.social.

  1. MySQL vs PostgreSQL vs SQLite

    Recommendation requested!

    Use case — personal data analytics projects, querying practice, and better understanding of setting up an RDBMS, schemas, data models, etc.

    My experience — 1 year in a true data analyst role using SQL. (9 years sorta hacking through data in spreadsheets in the ads world prior to that)

    Machine I’d local host on — MacBook Air (M3 chip)

    #sql #sqlite #mysql #postgresql #mysqlworkbench #dataanalyst #dataanalytics #dataanalysis #database

  2. MySQL vs PostgreSQL vs SQLite

    Recommendation requested!

    Use case — personal data analytics projects, querying practice, and better understanding of setting up an RDBMS, schemas, data models, etc.

    My experience — 1 year in a true data analyst role using SQL. (9 years sorta hacking through data in spreadsheets in the ads world prior to that)

    Machine I’d local host on — MacBook Air (M3 chip)

    #sql #sqlite #mysql #postgresql #mysqlworkbench #dataanalyst #dataanalytics #dataanalysis #database

  3. MySQL vs PostgreSQL vs SQLite

    Recommendation requested!

    Use case — personal data analytics projects, querying practice, and better understanding of setting up an RDBMS, schemas, data models, etc.

    My experience — 1 year in a true data analyst role using SQL. (9 years sorta hacking through data in spreadsheets in the ads world prior to that)

    Machine I’d local host on — MacBook Air (M3 chip)

    #sql #sqlite #mysql #postgresql #mysqlworkbench #dataanalyst #dataanalytics #dataanalysis #database

  4. MySQL vs PostgreSQL vs SQLite

    Recommendation requested!

    Use case — personal data analytics projects, querying practice, and better understanding of setting up an RDBMS, schemas, data models, etc.

    My experience — 1 year in a true data analyst role using SQL. (9 years sorta hacking through data in spreadsheets in the ads world prior to that)

    Machine I’d local host on — MacBook Air (M3 chip)

    #sql #sqlite #mysql #postgresql #mysqlworkbench #dataanalyst #dataanalytics #dataanalysis #database

  5. MySQL vs PostgreSQL vs SQLite

    Recommendation requested!

    Use case — personal data analytics projects, querying practice, and better understanding of setting up an RDBMS, schemas, data models, etc.

    My experience — 1 year in a true data analyst role using SQL. (9 years sorta hacking through data in spreadsheets in the ads world prior to that)

    Machine I’d local host on — MacBook Air (M3 chip)

    #sql #sqlite #mysql #postgresql #mysqlworkbench #dataanalyst #dataanalytics #dataanalysis #database

  6. #TheOneBroadband, can I help (in the longer run)? I've got a #DegreeApprenticeship #Training programme in #Software or #Networking available as well as #DataAnalyst and #DataScience programmes, perhaps we can talk about getting some additional skills capacity in to your workforce?

  7. 🚀 CrowdSec is hiring!

    We’re growing our data team and looking for:
    • Data Analyst
    • Data Analyst Intern

    If you enjoy working with data, uncovering patterns, and contributing to real-world security, this is your chance to make an impact.

    🔗 Apply now:
    👉 Data Analyst: lnkd.in/e7_qrxDu

    👉 Data Analyst - Internship: lnkd.in/evavHewv

    #Hiring #DataAnalyst #CyberSecurity #OpenSource #Infosec #Careers

  8. Want to become a Data Analyst in the UAE?The demand is growing fast—and so are the opportunities

    Learn the key skills you need:
    1.SQL & Excel
    2. Python for data analysis
    3.Power BI & Tableau
    4.Strong business understanding

    If you're serious about building a career in analytics, this guide breaks it all down
    alifbyteedu.com/how-to-become-

    #DataAnalytics #UAEJobs #CareerGrowth #LearnData #TechCareers #DataAnalyst

  9. Want to become a Data Analyst in the UAE?The demand is growing fast—and so are the opportunities

    Learn the key skills you need:
    1.SQL & Excel
    2. Python for data analysis
    3.Power BI & Tableau
    4.Strong business understanding

    If you're serious about building a career in analytics, this guide breaks it all down
    alifbyteedu.com/how-to-become-

    #DataAnalytics #UAEJobs #CareerGrowth #LearnData #TechCareers #DataAnalyst

  10. Want to become a Data Analyst in the UAE?The demand is growing fast—and so are the opportunities

    Learn the key skills you need:
    1.SQL & Excel
    2. Python for data analysis
    3.Power BI & Tableau
    4.Strong business understanding

    If you're serious about building a career in analytics, this guide breaks it all down
    alifbyteedu.com/how-to-become-

    #DataAnalytics #UAEJobs #CareerGrowth #LearnData #TechCareers #DataAnalyst

  11. Want to become a Data Analyst in the UAE?The demand is growing fast—and so are the opportunities

    Learn the key skills you need:
    1.SQL & Excel
    2. Python for data analysis
    3.Power BI & Tableau
    4.Strong business understanding

    If you're serious about building a career in analytics, this guide breaks it all down
    alifbyteedu.com/how-to-become-

    #DataAnalytics #UAEJobs #CareerGrowth #LearnData #TechCareers #DataAnalyst

  12. Want to become a Data Analyst in the UAE?The demand is growing fast—and so are the opportunities

    Learn the key skills you need:
    1.SQL & Excel
    2. Python for data analysis
    3.Power BI & Tableau
    4.Strong business understanding

    If you're serious about building a career in analytics, this guide breaks it all down
    alifbyteedu.com/how-to-become-

    #DataAnalytics #UAEJobs #CareerGrowth #LearnData #TechCareers #DataAnalyst

  13. E estudiado varias cosas buscando conocerme , no sabría cómo etiquetarme ,solo busco pertenecía y no siento que buscando consumir para ayar mi lugar me funcione, aparte de buscar quien soy, me gusta #anime #videojuegos #matematicas #programacion #dataanalyst #brandonsanderson #ciencia #rock #electronica , espero encontrar en este sitio un lugar para dialogar sin atacar al individuo #presentación

  14. Got a new #apprenticeship programme approved last week!

    L4 #DataAnalyst is available for learners to start in September this year (and is taking applications now) and covers #AI #MachineLearning#scripting and tools and mechanisms for effective #DataManagement and control in the modern workplace.

    This is a fully funded (essentially free) #training (for employers in #England) it's based on our existing #DataScience #degree apprenticeship course, where 86% of participants have achieved a 1st!

  15. Want to break into Data Science?

    Here are 12 key roles you can explore:
    - Data Scientist
    - Data Analyst
    - Data Engineer
    - AI Specialist
    - Statistician
    - Machine Learning Engineer
    - Data Architect
    - Data Product Manager
    - BI Analyst
    - Database Administrator

    Each role needs different skills. Explore your path!

    Top 6 Data Science eBooks V1
    ebokify.com/6-data-science-ebo

    #DataScience #Analytics #MachineLearning #AI #SQL #Python #CareerGrowth #BigData #DataEngineer #DataAnalyst #PowerBI

  16. Top SQL interview tips: master JOINs, use GROUP BY with HAVING, practice window functions, understand primary and foreign keys, write clean CTEs, handle NULLs correctly, and learn indexing basics. Strong fundamentals help you solve business problems with clarity.

    📕 ebokify.com/sql

    📕 ebokify.com/data-analysis

    #SQL #DataAnalyst #DataAnalytics #TechCareers

  17. 8 data analytics terms every aspiring analyst should know, from skewness and correlation to ETL, regression, causation, outliers, descriptive statistics, and ELT. Mastering these fundamentals strengthens your analytical thinking and decision making.

    📕 ebokify.com/data-analysis

    #DataAnalytics #DataAnalyst #ETL #Statistics

  18. Want to become a data analyst? Build strong foundations in statistics, Excel, SQL, and Python. Learn data preparation, EDA, and dashboards with Power BI or Tableau. Add machine learning basics and sharpen storytelling skills to turn insights into impact.

    📕 ebokify.com/data-analysis

    📕 ebokify.com/python

    #DataAnalyst #DataAnalytics #SQL #Python

  19. Serious about SQL?
    Start with structure, not random tutorials.

    I’ve created 65 structured SQL lessons covering:
    • Fundamentals
    • Joins & Advanced Queries
    • CTEs & Window Functions
    • Query Optimization
    • BI Concepts
    • Interview Preparation

    Each lesson builds on the previous one.
    Clear. Practical. Designed for data analysts.

    📕 ebokify.com/sql

    📕 ebokify.com/data-analysis

    #SQL #DataAnalytics #DataAnalyst #DataEngineering #BusinessIntelligence #AnalyticsCareers #TechEducation #DataScience

  20. "What do you do for fun?"

    Well, last night I downloaded a copy of Lotus 1-2-3 to my blank hard drive. Which I've previously put Linux on and took off. Which I put a copy of Windows 98 and Office 98 on. Which I just put random 90s programs on to relive my nerdy, isolationist childhood.

    So...relatively fun for an information systems analyst.

    #MIS #ISM #DataAnalyst #DataAnalytics #Lotus #Windows98 #OfficeSuite #Spreadsheets

  21. "What do you do for fun?"

    Well, last night I downloaded a copy of Lotus 1-2-3 to my blank hard drive. Which I've previously put Linux on and took off. Which I put a copy of Windows 98 and Office 98 on. Which I just put random 90s programs on to relive my nerdy, isolationist childhood.

    So...relatively fun for an information systems analyst.

    #MIS #ISM #DataAnalyst #DataAnalytics #Lotus #Windows98 #OfficeSuite #Spreadsheets

  22. "What do you do for fun?"

    Well, last night I downloaded a copy of Lotus 1-2-3 to my blank hard drive. Which I've previously put Linux on and took off. Which I put a copy of Windows 98 and Office 98 on. Which I just put random 90s programs on to relive my nerdy, isolationist childhood.

    So...relatively fun for an information systems analyst.

    #MIS #ISM #DataAnalyst #DataAnalytics #Lotus #Windows98 #OfficeSuite #Spreadsheets

  23. "What do you do for fun?"

    Well, last night I downloaded a copy of Lotus 1-2-3 to my blank hard drive. Which I've previously put Linux on and took off. Which I put a copy of Windows 98 and Office 98 on. Which I just put random 90s programs on to relive my nerdy, isolationist childhood.

    So...relatively fun for an information systems analyst.

    #MIS #ISM #DataAnalyst #DataAnalytics #Lotus #Windows98 #OfficeSuite #Spreadsheets

  24. "What do you do for fun?"

    Well, last night I downloaded a copy of Lotus 1-2-3 to my blank hard drive. Which I've previously put Linux on and took off. Which I put a copy of Windows 98 and Office 98 on. Which I just put random 90s programs on to relive my nerdy, isolationist childhood.

    So...relatively fun for an information systems analyst.

    #MIS #ISM #DataAnalyst #DataAnalytics #Lotus #Windows98 #OfficeSuite #Spreadsheets

  25. Great article if you're a data analyst wondering how to use R on Fedora! We appreciate the extra insight that Hank brings to the role as it has evolved.

    ➡️ fedoramagazine.org/creating-da

  26. I am thinking of transitioning to a role which I'd consider more aligned with my moral and ethical values than my present corporate job is, and I'm thinking to start learning stuff for becoming a junior #dataanalyst especially with relation to #foss - as I consider it important to my worldview and values.
    Has anyone here walked the same - or similar - path? learning #SQL , #python etc and achieved some success, if only on personal level?
    Any insights or advice would be much appreciated.

    #dataanalysis #career #jobchange

  27. 3 Mistakes Stopping YOU as Data Engineer

    Day 3: 3 mistakes holding you back in your career as a data engineer What else you would add to the list? #dataanalyst ... source

    quadexcel.com/wp/3-mistakes-st

  28. Again, whenever people post about how old they are based on the tech that they grew up with, I would like to remind everyone that I still have rabbit ears on my television and I still regularly code on a Windows 93 that uses 3.5 floppy disks.

    #DataAnalyst #DataAnalytics #OldTech #VintageTech #FloppyDisks #I_Have_No_Life

  29. We're also working on a standalone L4 #DataAnalyst course for firms that need #AI #MachineLearning and computational #Statistics skills in their workforce but can't commit folk to a full degree programme.

    Course will be fully funded and predominantly delivered online (with a short 'Bootcamp' activity in #Cambridge #UK

    Let me know if you want to find out more.

  30. Common Mistakes New Data Analyst Make #dataanalytics #dataanalyst #datajobs @AnmolPowerBICorner

    From BSC- MSC to Power BI Developer | Story of Youtuber Anmol Malviya @AnmolPowerBICorner Common Mistakes New Data ... source

    quadexcel.com/wp/common-mistak

  31. Power BI Dashboard in 30min #dataanalyst #excelcourse #dataanalytics #datascience

    Can you build a Power BI dashboard in 30 minutes? I just did! Took on a quick challenge this afternoon and got this beauty ... source

    quadexcel.com/wp/power-bi-dash

  32. Data Analyst Job Updates for Freshers #dataanalyst #shorts

    In this video, I have explained all data analyst-related jobs. In this video, I have explained how to apply and how to apply for MNC ... source

    quadexcel.com/wp/data-analyst-

  33. (Sorry in advance for bombarding with hashtags, but..)

    Yet again I plead to the #Fediverse to get #Fedihired as a paid or unpaid #DataAnalyst #intern. I'm not formally trained but (as uncomfortable as it is for me to boast) I truly feel that I have the cognitive *capability* of learning as I go. I want to see whether I actually *can* do so.

    Unfortunately I'm guessing this is probably the worst possible time to try and break into the industry, however I am desperate and hoping for a miracle.

    I've always been "self-taught" because I've never been an ideal student. It's how I learned to program #PHP, #SQL, and how I learned to work with #spreadsheets.

    I might not be an expert with any of those topics but I usually managed to stumble my way through, and accomplish the goal I needed, serving my purpose for a previous employer for 8½ years, until their financial position necessitated my layoff.

    I need real-life experience working with #Data and hopefully build a portfolio I can use for #gig work or a job or something.

    So I'm reaching out to #selfemployed any #Data experts to ask if they might need help. Let me take a stab at some non-critical things.

    If I suck, you're not out more than just a little bit of your time interacting with me; you were going to do it yourself anyway, right?

    If I do it *well*, then you just got free labor, I get experience and potential portfolio fodder.

    Plus you get the sense of pride from helping someone struggling to survive, and helping a #neurodivergent, #LGBTQ couple who both struggle with #MentalIllness and #poverty.

    Obviously I will take *paid* work as well; remember, #MinimumWage in my state is still a measly seven dollars and twenty-five goddamned cents per hour, so you can go super cheap.

    Think of it like you're rummaging through the bargain bin for temp workers and you decide to give some no-name brand a try: Me!!

  34. (Sorry in advance for bombarding with hashtags, but..)

    Yet again I plead to the #Fediverse to get #Fedihired as a paid or unpaid #DataAnalyst #intern. I'm not formally trained but (as uncomfortable as it is for me to boast) I truly feel that I have the cognitive *capability* of learning as I go. I want to see whether I actually *can* do so.

    Unfortunately I'm guessing this is probably the worst possible time to try and break into the industry, however I am desperate and hoping for a miracle.

    I've always been "self-taught" because I've never been an ideal student. It's how I learned to program #PHP, #SQL, and how I learned to work with #spreadsheets.

    I might not be an expert with any of those topics but I usually managed to stumble my way through, and accomplish the goal I needed, serving my purpose for a previous employer for 8½ years, until their financial position necessitated my layoff.

    I need real-life experience working with #Data and hopefully build a portfolio I can use for #gig work or a job or something.

    So I'm reaching out to #selfemployed any #Data experts to ask if they might need help. Let me take a stab at some non-critical things.

    If I suck, you're not out more than just a little bit of your time interacting with me; you were going to do it yourself anyway, right?

    If I do it *well*, then you just got free labor, I get experience and potential portfolio fodder.

    Plus you get the sense of pride from helping someone struggling to survive, and helping a #neurodivergent, #LGBTQ couple who both struggle with #MentalIllness and #poverty.

    Obviously I will take *paid* work as well; remember, #MinimumWage in my state is still a measly seven dollars and twenty-five goddamned cents per hour, so you can go super cheap.

    Think of it like you're rummaging through the bargain bin for temp workers and you decide to give some no-name brand a try: Me!!