r/dataanalytics

I've been trying for some time to reach an audience, be it companies, small businesses owners or fellow data analysts for feedback. I've created a small site for my projects, that I use as case studies for anyone interested, showing what I can do. I made a Facebook page, posted in groups (still waiting for approval), on LinkedIn and so on, yet most I had were impressions. I wrote some time ago about my projects, here, and I received good feedback on them. Now, thing is, I don't get feedback anywhere else and can't find the actual people that need this service. The groups and platforms are flooded with everyone promoting their services and no one asking for them. So, where are the people that actually need this? Apart from hiring companies, I'm almost certain there are a lot of business owners that would benefit from this, but I either didn't find them or they don't know how to ask... Where is the demand people were talking about?

I’m currently doing an internship at SAS, and overall it’s been a really positive experience.

That said, I’ve been having some doubts lately. I’m not sure if focusing on SAS is the best use of my time long-term, since it feels quite niche and maybe even a bit “legacy” compared to more widely used tools.

For those with more experience in the field: do you think specializing in SAS is still a solid career move? Do you think I’m wasting my time in this internship

I just finished a Data Analytics course from Rice University. My job paid for it but now I'm stuck. I obviously don't feel skilled enough to apply to jobs right away or even apply to role within the company. What are some resources or websites I can use to practice and build my portfolio? Also my background is in Customer service and onboarding.

Well, this is new. My manager just pulled me into his office to talk about my lunch break. Apparently, I take an hour for lunch when the 'official' policy says the break is only 30 minutes, so I'm considered 'short' on my hours with the company.

I work in the data analytics department, and things are very flexible here. As long as you complete your 8 hours a day, no one cares when you took your lunch break. I come in at 8 AM and leave at 4:30 PM, meaning I'm at work for 8.5 hours. I take about an hour for lunch, which means I work 7.5 hours. So yes, technically I'm short by about 30 minutes.

Most of my colleagues take an hour and a half for their break, which is why they leave later than me. I just don't need all that time. I eat lunch, maybe run a quick errand, and I'm ready to get back to work. The thing is, I submit all my work on time, and often even ahead of schedule. Honestly, there are many times ultimately when I'm looking for tasks to do just to fill my time.

I'm pretty sure I know who complained. There's a colleague who's been here for a very long time and always talks about how stressed and swamped she is with work, probably because she's slow with the new software we're using. And it's very obvious she's annoyed that I arrive at the same time as her but leave before her most days.

My manager wants to talk about this again tomorrow, and I don't know how to answer. I feel like this whole thing is just about office politics. I'm a salaried employee. If the company doesn't pay me overtime when projects run late, I don't feel I should be punished for being efficient and finishing my work early.

How do I explain this without coming across as a lazy or 'entitled' employee? Any advice on what I could say would be great.

I am currently in my last year of bcom. Is it worth learning for business analytics? Like is the future for it especially after bcom.

We all know data analytics change with AI many tasks Ai can do it easly but i would like to know if i learn for example , data scraping,machine learning,databriks...and i add these skills to what we all know ( like python sql excel powerbi) can put some changes in market??

what is the best advice, tip or guidance you received from your boss, team or mentor if you had one, in your professional career in data analytics?

Do you see DA as a profession (like a doctor or engineer, with the autonomy and "expert" status) or is this just a job where you trade SQL queries, Excel, and Power BI skills for a paycheck?

Hey guys,

I got laid off from an MNC around 2 months back, and honestly it’s been a bit rough.

I’ve applied to 100+ jobs (mostly Data Engineer / Data Analyst roles), but barely getting any responses… not even rejections in most cases.

I have ~2 years of experience working on ETL pipelines, SQL, Python, Snowflake, BigQuery, SSIS, and Azure (ADF). Worked with a pretty solid client as well.

At this point, I’m just trying everywhere I can.

If anyone knows about openings in your company or team, or can refer me, it would really help.

I’m open to any location / remote roles. By the way, I'm from Bangalore, India.

Thanks a lot 🙏

I am looking to see if it’s even possible to make extra income outside of the normal 9-5!

Advice is well received!

I recently transitioned into a data analytics role where I report directly to the CFO. Before this, I worked in a sustainability consultancy as an analyst/consultant, so I’ve used tools like Power BI and Tableau quite a bit.

At my current company, everything runs on the Zoho ecosystem; CRM, Books (5 - 6 orgs), etc. And they use Zoho Analytics. The problem is it is limiting.

• Data transformation is painful

• Zoho DataPrep is basically unusable at scale because of quota limits (one job eats a huge chunk of the monthly allowance)

• Query tables are restrictive (limited support for CTEs, no real flexibility for complex transformations)

On top of that, we also have multiple external data sources:

• Zoho Marketing and Meta ads, etc.

• Restaurant POS systems

• Other operational tools

Management now wants a unified view across everything. It makes the current setup even more frustrating.

So I’m trying to move us toward a more modern data stack but, I’m a bit overwhelmed. There are so many moving parts: ingestion tools, data warehouses, data lakes, transformation layers, etc.

What I think I want:

• Extract data from Zoho apps (CRM, Books, People, etc.) + external sources

• Load it into a central warehouse

• Do proper transformations + data modeling there

• Then connect it to Power BI for reporting

But I’m not sure what the “right” architecture looks like, especially coming from a BI-first background.

Would really appreciate advice from people who’ve dealt with similar setups:

• What tools would you recommend for ingestion?

• What warehouse would make sense for a mid-sized company?

• How would you structure the transformation layer?

TL;DR:

Moved into a data analytics role using Zoho stack, but it’s too limiting for transformations and scaling. Need advice on building a modern data pipeline (Zoho + other sources → warehouse → transform → Power BI) without overcomplicating things.

im currently diving in learning data analytics, ive learned sql, python, pandas etc, but the things is, this are all just progress i have to myself, sure i post sometimes, so im thinking of doing work for free or is there any advices?

So I am planning to learn excel specifically for data analysis, and this is my roadmap which was based off luke barousse but i also added some extra topics (with the help of ai) that was not included in his course which i think could make the roadmap better.

So I just want to ask if the roadmap for excel is good or sufficient enough (sql and powerbi is separate)

Chapter 1: Introduction to Excel

• What is Excel?
• Installing Excel
• UI Walkthrough
• Worksheets & Workbooks
• Ribbon & Menu
• Keyboard Shortcuts

Chapter 2: Excel Basics

• Data Types
• Adding, Deleting & Editing
• Sorting & Filtering

Chapter 3: Formulas & Functions

• Formulas & Functions Intro
• Basic Formulas
• Conditional Functions
• Logical Operators & IS Functions
• Rounding Functions
• Text Functions
• Date Functions
• Math Functions
• Min, Max & Average

Chapter 4: Statistics

• Mean, Median & Mode
• Distributions
• Standard Deviation
• Percentiles
• Statistical Functions

Chapter 5: Lookups

• Lookups Intro
• VLookup & HLookup
• XLookup
• Index Match
• Lookup Practice

Chapter 6: Conditional Formatting

• Highlight Cells Rules
• Top & Bottom Rules
• Bars, Scales & Sets

Chapter 7: Charts & Visualizations

• Bar & Column Charts
• Line & Combo Charts
• Scatter & Bubble Charts
• Pie & Donut Charts
• Map Charts
• Chart Elements, Styles & Axes
• Chart Layouts & Templates
• Visualization Challenge

Chapter 8: Data Cleaning

• Removing Duplicates
• Flash Fill
• Fuzzy Matching
• Standardizing Data
• Handling Missing Data
• Separating & Combining Columns
• Data Validation
• Data Cleaning Practice

Chapter 9: Spreadsheets Advanced

• Tables
• Formatting
• Named Ranges
• Dynamic Arrays
• FILTER, UNIQUE, SORT
• Collaboration

Chapter 10: Pivot Tables

• Pivot Table Intro
• Creating Your First Pivot Table
• Formatting
• Working with Dates
• Calculated Fields
• Sorting & Filtering
• Pivot Charts
• Pivot Tables Advanced
• Practice Challenge

Chapter 11: Advanced Data Analysis

• Analysis Add-ins
• Solver
• Scenario Manager
• Goal Seek
• Data Tables
• Correlation & Regression

Chapter 12: Power Query

• Power Query Intro
• Power Query Editor
• Power Query M Language
• Power Query Advanced

Chapter 13: Power Pivot

• Power Pivot Intro
• Power Pivot DAX
• Data Models

Chapter 14: Macros & Automation

• Recording Macros
• VBA Intro
• Automating Repetitive Tasks

Chapter 15: Storytelling with Data

• Choosing the Right Chart
• Designing for Insight
• Building Dashboards
• Presenting Findings
• Capstone Project

Finishing up my MS in Data Science and Analytics and honestly the job market is stressing me out. Had a solid summer internship doing applied AI and data engineering work, and now I'm in full send mode applying for data analyst and business analyst roles starting May.

Just feels like applications go into a black hole most of the time. Is anyone else in the same boat? Any advice on what's actually working right now?

https://preview.redd.it/k2x129q6f0vg1.jpg?width=1046&format=pjpg&auto=webp&s=a466d766879d631018a92dbf81d2ca042abc7949

I just finished an internship at an environmental government-contracted consulting firm, but most roles got outsourced, so there was no return offer. Since then, I haven’t been able to get a job and have had barely any interviews.

Everyone keeps saying my experience is good, just that I don’t have one clear goal on my resume. So I refined my search into three paths:

• marketing & growth analytics
• data / AI analyst
• sustainability / ESG consulting and analytics

I also have really strong connections at tech companies who refer me, and I get through multiple rounds of interviews… then something happens at the end every time.

I really really really really really want to live in LA, that’s where most of my experience and network are. But I just moved back to Maryland because my mom lives here, and people keep saying there are better opportunities here (for tech in the DMV) , which doesn’t really align with where my connections are.

I don’t want to give myself excuses, but I did just get diagnosed with ADHD and started medicating this year. I have a very high processing, systems-oriented brain, it’s just that sometimes my mouth can’t catch up, so I end up thinking while I’m speaking and processing in real time. I’m wondering if that’s something recruiters pick up on.

At the same time, all my mentors at high levels say my issue is getting in the door, and that once I actually meet recruiters, my personality and intelligence carry me.

So now I’m confused about what I’m actually doing wrong and how to fix it.

WOULD LOVE FEEDBACK

Thank you for listening to the diary of a stressed Black woman 😭

Hey, I am looking for junior data analyst roles in Australia with my experience as part time data analyst (remote) and hospitality management experience. How does my resume look? Am I a strong candidate for entry level roles? I am open to learning new tools to improve my chances. Please share your feedbacks. I appreciate your inputs.

Cheers

https://preview.redd.it/ih1hypx18bvg1.png?width=1114&format=png&auto=webp&s=c5ed739b9a0c8f7d992dc6fbebf283c9413ad4ec

I’m currently studying for the COMPTIA Data + 002 certification that released in around Nov 2025. The 001 version is retiring sometime this month since the curriculum needed to be changed and adjusted to the times of AI/machine learning which is included in 002 material. Anyone familiar with WGU know if their class curriculum has modified because of this ?

Currently doing a wet-lab microbio PhD in the UK and have got into learning python/SQL as I’m enjoying analysing the data I get from experiments (mainly just growth curves though so not a big range). Saw that there’s data analyst jobs but think I’d want to try the career first before properly pursuing it, especially as I’m not a confident or competent coder, so are there any internships in this field for PhD students with limited coding knowledge who are willing to learn?

Hi everyone, I am currently considering LSE Data Analytics Career Accelerator

. Does it really make the career switch and getting a job easier than if I had applied to say coursera? I have been working part time teaching mathematics for about 2 years, and my past experience is almost all either geology or teaching. My degree was in Maths.