r/analytics • • 2d ago

Monthly Career Advice and Job Openings

4 Upvotes
  1. Have a question regarding interviewing, career advice, certifications? Please include country, years of experience, vertical market, and size of business if applicable.
  2. Share your current marketing openings in the comments below. Include description, location (city/state), requirements, if it's on-site or remote, and salary.

Check out the community sidebar for other resources and our Discord link


r/analytics • • 7h ago

Question Agentic capabilities of Power bi

8 Upvotes

I am working on a project in my firm where I created few dashboards. Now the leadership asked me to explore the idea of incorporating an AI agent in the dashboard that will help the client get insights from the report. Agent should navigate through reports and generate insights.

Here are my questions

Is there a way to achieve this goal? If so How?


r/analytics • • 14h ago

Discussion The next data refresh belongs in a junior analytics portfolio

0 Upvotes

A portfolio sales report can look finished as long as it only has to work with the file it was built on. The useful part starts when the next export includes an order from the previous month that has since been refunded. Does the prior month's total change? Can someone looking at the report tell why it changed?

That seems like a good place to spend time on a portfolio project. Keep the same report and show what happens when the updated file comes in. A few lines explaining where the refund shows up would give someone reviewing it a concrete decision to talk through with the person who built it.


r/analytics • • 1d ago

Discussion Put the last 6 weeks of forecast misses under our weekly forecast. 5 weeks in, here's how managers reacted

24 Upvotes

i run reporting for a mid size retail team. every monday we send a demand forecast for the week to store managers and for a long time it was just the number for next week.

in october i added a small section under it with the last 6 weeks: what we forecast, what actually sold, and a one word reason when we were way off (promo, weather, stockout). i expected people to trust it less once they saw the misses.

so far its the opposite, fewer angry emails and two managers started flagging promos to us before they happen, which is half of our big misses.

curious if anyone has done this longer term. did it hold up, or did people stop reading it after a while


r/analytics • • 1d ago

Question any agencies here paying for conversion tracking monitoring tools?

0 Upvotes

Hi, i’ve been looking into how agencies handle the monitoring of tracking issues across multiple Google Ads accounts. many use mmc scripts or manual checks, but I’d like to know if anyone here pays for tools like Trackingplan, ObservePoint, or similar solutions

what led you to choose a paid tool instead of using scripts? is there anything in your current setup that you still find problematic or frustrating?

perhaps issues like duplicate conversions or leads that fail to register in your CRM ??

thanks !!


r/analytics • • 2d ago

Discussion google has only published a yearly search count (5 trillion+). 15 pages quoting a daily one gave 5 different numbers, 3.5 to 22.08 billion

3 Upvotes

We were curious how frequently people cite the daily google search number correctly before they include it in a report. So, on oct 19, 2026, we used google.com with us settings to search for 5 variations of the question, such as "how many google searches per day". We then looked at the first mention of a daily number on the 15 ranking pages with a daily number.

Google has never published a daily number. In march 2025 they stated that they get over 5 trillion searches a year. If you divide 5 trillion by 365 you get about 13.7 billion per day. The annual number is "over" so the actual average is probably a bit more.

On the 15 pages we found 5 different answers. 4 mention 3.5 to 6.7 billion. 5 say 8 to 9.1 billion. 3 give 13.7 to 14 billion. 2 say 16.4 billion. 1 says 22.08 billion. Only 3 out of the 15 start with the number that matches the google number.

the 5 pages at 8 to 9.1 billion work out to about 3.1 trillion searches annually (an older estimate).

16.4 billion is sparktoro's (audience research) march 2025 estimate, based on browsing data of us desktop users.

22.08 billion - one small business site has it (only "research has found" without us being able to trace it back).

one stats page still had 3.1t a year in their post last updated in jan 2026. 10 months after google published its own figure.

5 variations of the phrase. 1 day. us. that's what ranked on oct 19. not the web in general. "where it comes from" is our interpretation of each page.

how far back do you trace a number like this before throwing it in a client's report?


r/analytics • • 2d ago

Question CMU MSBA Interview

2 Upvotes

Hi everyone! I am prepping for my CMU Tepper MSBA interview and was hoping to clarify a few things:

- how long is the interview?
- what kind of questions do they ask?
- is their anything I should focus on specifically?

Thank you!


r/analytics • • 2d ago

Question MSDA Eastern University

2 Upvotes

Is there anybody here who has graduated from the MSDA program at Eastern University? I just want to know what the program is like, how difficult are the courses, if there are proctored exams, etc


r/analytics • • 2d ago

Discussion MLBB Draft Analysis Spreadsheet

1 Upvotes

Hey everyone, I put together an interactive MLBB Draft Analysis workbook in Google Sheets to analyze pick/ban meta, side bias, hero synergies, and team tendencies across 6 major regional tournaments.
Dataset & Scale:

  • Sources: Combined tournament statistics pulled from Liquipedia across 6 leagues:

    • MCT AMER 2026 Split 2
    • MPL Indonesia Season 18
    • MPL Philippines Season 18
    • MPL Malaysia Season 18
    • MLBB Continental Championships Season 8
    • MTC Turkiye Championship Season 8
  • Data Structure: ~546 hero/tournament summary rows, ~2,000+ team tendency rows, and ~7,280+ hero-level pairing/matchup detail rows consolidated into hidden backend tabs (Summary_Stats, Team_Tendencies, Details_Data) with dedicated calculation sheets (Calc_Hero, Calc_Role).

What’s in the Dashboard:

  • Hero Dashboard: Dynamic hero selector showing Blue vs. Red side picks, win rates, WR delta, top team usage, best hero synergies, and toughest opponent matchups.
  • Role Dashboard: Position-level meta breakdown (total picks, bans, side win rates) plus a ranked hero tier table.
  • LINK TO SHEET

r/analytics • • 2d ago

Discussion Shopify store owners, where are you seeing the biggest conversion drop-offs?

1 Upvotes

TL;DR: Are Shopify stores losing more customers on product pages, in the cart or during checkout? And are we spending too much time fixing the biggest drop-off percentage rather than finding out what's actually costing us sales?

I'm curious where Shopify stores are losing the most customers lately. Is it getting people to add something to their cart, or are they making it all the way to checkout and then leaving?

What interests me is that the stage with the highest drop-off rate isn't always the one worth fixing first.

For example, a product page might have a fairly low add-to-cart rate, but if it’s one of the store’s most visited pages, even a small improvement could make a noticeable difference to sales. Meanwhile, a checkout issue might look worse in percentage terms but affect far fewer customers.

Of course, the numbers alone don't explain why people are leaving.

On Shopify, I'd be interested in what's happening between the product page and checkout. Customers are having trouble picking sizes or variants on mobile? In the cart drawer, is the delivery cost visible? Are discount codes working as expected, or are customers only finding out about shipping charges once they've started checkout?

I've also wondered how many stores are making changes based on funnel reports without checking whether the tracking is reliable.

Shopify and GA4 can show different conversion figures for several reasons, including consent settings, attribution and how events are collected. That doesn't automatically mean something is broken, but I'd still want to compare the trends with actual orders before deciding there's a serious conversion problem.

Session recordings can help explain what happens on product pages and in the cart, although they won't always show what customers experience inside Shopify checkout. Sometimes customer feedback or testing the purchase journey yourself tells you more than another dashboard.

Then there's the stock availability issue, which becomes particularly pertinent during peak shopping periods.Even if the site is functioning flawlessly, customers may abandon the purchase if popular sizes are out of stock or if delivery estimates have shifted.

I’d be cautious about making big changes just because a certain funnel step has a high abandonment rate, with Black Friday traffic. I'd rather understand how many customers are affected, what might be causing the problem and whether there's enough evidence to justify changing anything.

A checkout redesign might sound like a worthwhile improvement, but if customers are leaving because shipping costs are higher than expected, it's probably not where I'd spend the team's time.

For those managing Shopify stores, where have you found the biggest conversion problem recently, and was the actual cause what you initially expected?


r/analytics • • 2d ago

Question For people who struggled to learn DAX-what actually made it finally click?

0 Upvotes

I've been trying to get my head around DAX (especially CALCULATE and filter context) and watching 2-hour YouTube tutorials is putting me to sleep.

For those of you who went from Excel to Power BI: what did you actually use (or pay for) that worked? And what was the most frustrating part about how it's usually taught?


r/analytics • • 2d ago

Question Need help deciding between two jobs

0 Upvotes

r/analytics • • 3d ago

Question i'm(20f) looking for an internship in data analytics and operations /supply chain management. what should i be doing¿?

3 Upvotes

what are things i should be knowledgeable about and what should my projects demonstrate?


r/analytics • • 3d ago

Question What jobs can you get woth a business analytics masters degree?

23 Upvotes

I am currently looking for MSBA Programs, I don't know what a real day to day workday for an Analyst looks like, so I'm not wire which of all these offers would be worth my time investing into. I see a lot of titles like "Data Insights Analyst" or "Business Intelligence Consultant" being thrown around, but I don't understand if they are completely different career paths. Like, what do these jobs actually look like on any random tuesday at 2 pm?

What is the job realky like, so I get into a real MSBA an not a degree mill university. Like, is the job mostly cleaning messy data and building dashboards all day? Or are you advising on strategies? What skills are really useful and you use the most in your job vs what you were taught in school? I am trying to figure out if the degree is even worth it beofre incurring into debt for it.


r/analytics • • 3d ago

Support Looking to work as a shadow analyst for a professional in the field that needs to offload some of his work to freelancers.

0 Upvotes

Im from the 3rd world and trying to sustain a family with piling up medical bills, so even a tiny fragment of your western salaries, would be an immense help for the family. looking to do shadow work for you without my name on it for 1-2 grands a month. I'm proficient in Excel, SQL, and Python through Jupyter notebooks. Got a mind for statistics and an eye for details. Willing to output quality work that will never insult your name in front of your companies and customers. Thanks a lot for your consideration. DM me if interested.


r/analytics • • 3d ago

Question Rotman MMA-AI Program

2 Upvotes

Has anyone been successfully through the program assessments? I have received the written assessment link what should i expect? Any suggestions would be appreciated.


r/analytics • • 3d ago

Discussion my 3-week Omni alternative and Sigma Computing alternative test (Omni vs Sigma vs Hex vs Cube) when finance won't leave Excel and AI guesses churn

7 Upvotes

3 weeks into comparing Omni, Sigma, Hex & Cube dev for our 150-person SaaS team on Snowflake and dbt, the biggest surprise had nothing to do with chart libraries. Every dashboard vendor demoed cleanly on Tuesday, and by Friday our finance team was exporting CSVs back into Excel anyway while Claude kept guessing wrong churn formulas against raw warehouse tables

half the people searching for an omni alternative or sigma computing alternative are stuck in that exact spot. our data team needed BI tool selection to solve three conflicting workflows at once: board reporting, self-serve exploration, and customer-facing product metrics later this year

omni clicked fastest with analysts who already miss LookML. Its shared model and workbook layers handle dbt syncing smoothly, and it beats legacy BI on UI speed. Still, once you put all your joins and metrics inside Omni, you are back inside a commercial-only vendor where AI features live on top of their BI layer. then Sigma won finance kinda immediately because pivot formulas directly over Snowflake feel like cloud spreadsheets. Then two ops leads stacked 14 nested workbook calculations on top of our base orders table, numbers diverged from dbt, and Sigma's single-tenant roots felt awkward when product asked to embed multi-tenant views. Hex went the opposite direction: data scientists loved mixing Python and SQL apps, yet its semantic layer is too thin to serve as a single governed source across other competitor alternatives.

testing Cube felt backwards at first because you model cubes, joins, and view_groups in YAML before drawing a single chart. Cube Core gives us an Apache-2.0 SQL-first context layer in Git, and Cube Cloud sits over that foundation with Analytics Chat, workbooks, dashboards, and MCP endpoints. Two secondary details changed our vote: finance kept their Monday Excel habits through Cube's live MDX and Google Sheets add-ins with identical numbers, and whenever our AI chat bot misread a status filter, we saved the correction into Git as a Markdown Certified Query and rule file so workbooks and Claude MCP both inherited the fix

i also think that the trade-off is simple enough as Cube connects downstream of Snowflake without replacing your warehouse, and small teams without someone owning Git-reviewed YAML will move faster in Sigma. and, now, anyone else picking from the best business intelligence tools right now and did you force finance off spreadsheets into one BI suite, or put a SQL-first context layer underneath?


r/analytics • • 3d ago

Question Amazon gift card for an aspiring analyst: what to buy besides books?

2 Upvotes

Hello! I am studying analytics and recently received an Amazon gift card. I want to use it to get something that would make me a better analyst, but I can't really think of any sort of physical product that would fit the bill besides yet another book (which I'm fine to buy more of). Any recommendations? Even books if you think they are exceptional.


r/analytics • • 3d ago

Question Is a masters degree in Business Analytics worth it

14 Upvotes

I was accepted to Quinnipiac for MS Applied AI and Business Analytics degree. I have 8 years of qualitative research experience and some mixed-method research background. I'm looking to gain harder skills in the quant/analytics field as the roles are changing and I figure this will diversify my skillset quite a bit. UX Research is taking a huge hit in the market (jobs down 66% since 2022) and I'm seeing market research roles require strong quant and qual skills.

I'm not pursuing a Masters of Market Research because I have a good amount of experience in the field and see it as potentially redundant.

Main concerns:

-It's a hefty price tag (~30k)

- AI is taking over! AHHH.

- I'm seeing universities are closing down because of low attendance. Have we learned that degrees don't do much after all? Plenty of qualified people are in the market right now......

Help


r/analytics • • 3d ago

Question When do you stop showing rates for low-volume campaigns?

2 Upvotes

I help with ad reports at an agency and I'm trying to work out when a conversion rate is too shaky to show. With low conversion volume it can swing sharply, but the count on its own doesn't say much either. Do you show the rate with the count and a caveat, or leave it out until there's more volume?


r/analytics • • 4d ago

Support Depressed, stuck in a hellhole of a job that tracks every movement

40 Upvotes

I’ve been a data engineer for over 10 years and I think I’m at low point in my career. Total comp is pretty good for my area but the job is just a toxic hellhole. AI productivity trackers that track our computer movements and uses AI to score you, constant layoffs, toxic backstabbing culture caused by stack ranking and toxic management, always having to meet deadlines. Every day I come home feeling like I got out of a war zone lol.

Looking for jobs has been depressing as hell and it feels like I’m just throwing resumes into a black hole. It seems like most employers are low balling these days and I hardly see jobs that can even match my salary and I worry I fall into yet another toxic environment because it seems like so many companies are going this direction…
Is there still hope out there? I’m so over it and I can’t even quite quit much because of the AI trackers otherwise I’ll show up on some report and PIPed…


r/analytics • • 4d ago

Discussion Three spellings of the same traffic source split my pivot table into three rows

6 Upvotes

Spent an evening wondering why a source looked so small in the pivot. Links in client posts were tagged by different people as instagram, ig and insta, so the totals sat in three rows. Merged them with a mapping column and a short list of allowed names.


r/analytics • • 5d ago

Question Does university research experience count as relevant experience for data analyst/data scientist roles?

3 Upvotes

I’m having a tough time breaking into the data field. I have industry experience, personal projects, technical skills, and I’m currently pursuing an MS in Data Science. My previous degrees are non-STEM, which is one of the reasons I decided to pursue the MSDS.

My university is local, but since I work full-time, I take my classes online. I’m considering joining a research team at my university to gain some experience working with data that I can add to my resume. My degree is in the Electrical Engineering and CS department, if that matters so it’s all CS courses.

There are several interesting research teams involving data science, machine learning, and AI that accept part-time students. The commitment would be around 5-10 hours per week, which I could manage alongside my full-time job since I also work remote.

Would employers consider university research experience relevant professional experience in data?


r/analytics • • 5d ago

Question 4 YOE in Analytics, Now Working in Data Science, But I Cant Code Without Al. What Should I Do?

58 Upvotes

Hi everyone,

I have 4 years of experience, including the past year in analytics at a big tech company. Recently, I got an opportunity to work with a data science team.

The work involves modern tools and technologies such as AWS Bedrock, LLM invocation, Lambda, and Step Functions. The solutions are eventually productized by separate engineering teams.

My challenge is that I rely heavily on AI to write code and deliver projects. I understand what the code does and take the time to learn how the solutions work, but my independent coding skills are weak. I struggle with Python fundamentals and solving even basic coding problems.

My current skills are intermediate SQL, beginner to intermediate Pandas, and strong dashboarding skills.

My question is, what should I focus on learning to build a sustainable career in data science?

Should I prioritise Python and programming fundamentals, statistics and traditional ML, or modern AI/LLM engineering on AWS?

Or with my weak coding skills should I just stick to Analytics/Dashboarding??

I would especially appreciate advice from people working in data science or ML teams at big tech companies. How would you approach upskilling in my position?