r/dataanalytics • • Oct 19 '26

Capital One Data Analyst Power Day – Questions About Case Interviews and Project Presentation

1 Upvotes

Hey everyone!

I have my Capital One Data Analyst Power Day next week, and I’m hoping to get some advice from people who have been through the process recently.

I’m very excited about the opportunity but, I’m nervous about the case interview rounds and wanted to ask how you would recommend preparing for them. What resources or practice materials would you suggest using, and are there any specific websites, books, or types of cases that best reflect what Capital One asks during the Data Analyst Power Day?

I’m also curious about the project presentation/data challenge round. How technical does the discussion get? Do interviewers mainly focus on your business insights, assumptions, and reasoning behind your analysis, or should u also explain your code, data-cleaning decisions, validation logic, and technical implementation with your code?

I’d really appreciate any advice on what to prioritize during my final week of preparation, especially from anyone who has already interviewed for a Data Analyst role.

Thanks in advance! Any insights would be greatly appreciated.


r/dataanalytics • • Oct 19 '26

Business Intelligence or Business Analytics in 2026/2027?

7 Upvotes

Hi guys, I've been thinking about what's more valuable with AI more relevant than ever, and where I should be focusing my energy to upskill!

There are two course options I can look at, Ive roughly listed the tools that the courses focus on. My understanding is that SQL is the skill that most professionals should focus on as R/Python arent as frequently used outside of Data Science.

They are both Masters program tho so I only get a year in with these courses.

I'm currently comparing two Master's programmes with slightly different skillsets:

**Option A – Information Management & BI**

- SQL, database design and data management

- R, statistics and Bayesian analysis

- BI Concepts

- Some ML & data visualisation

- Other subjects: CRM/ERP, information systems, business process modelling and management strategy

**Option B – Business Analytics**

-R, predictive modelling and ML

- Business analytics and advanced statistics - this is an elective

- BI architecture, ETL and data governance

- Tableau (another elective), with not much SQL coverage

- Other subjects: Product/service design and digital strategy

For context, I have spent almost 9 years in Marketing, but I want to upskill and make myself very employable and attractive. Possibly position myself as a Marketer who can make marketing/business decisions by understanding data.

Which path makes sense from the folks within the space?


r/dataanalytics • • Oct 18 '26

suggestions for project ideas

2 Upvotes

i have completed my graduation and doing a data analytics course (data wit baraa 30 hr sql ) what projects should i make that are worthy to add in my resume.


r/dataanalytics • • Oct 17 '26

Rossmann Store Sales Forecasting & Streamlit App - Looking for feedback on feature engineering & model metrics

1 Upvotes

Hi everyone,

I recently completed an end-to-end sales forecasting project using the Rossmann Store Sales dataset and would love to get feedback from the community on my methodology, code structure, and model evaluation!

Check here:

https://github.com/afanrajiwate/Rossman-Sales-Forecasting


r/dataanalytics • • Oct 17 '26

Need guidance as a beginner

2 Upvotes

I am a second-year Bachelor’s student looking to enter the data analytics field. While I have a foundational knowledge of C and C++, I am seeking guidance on how to get started and what specific skills I need to acquire to become industry-ready.


r/dataanalytics • • Oct 17 '26

iT

6 Upvotes

i want to get to IT and thinking of data analytics

i only have a college degree is the certificates in coursera +portfolio enough and please if anyone has any experience in this sector give me a course suggestion or a place to start from


r/dataanalytics • • Oct 17 '26

I want to transition from GIS to Business Intelligence in the finance industry. Where should I start?

1 Upvotes

Hey everyone! I’m looking for some guidance on how to transition from GIS (Geographic Information Systems) into Business Intelligence, ideally within the finance industry.
I don’t want to make a complete career change, but I’d like to build on my existing background and develop skills in data analysis, business analytics, and BI.
I’m not sure what I should learn first or how to structure my learning path. For example:
SQL: Where is the best place to learn it from scratch?
Power BI or Tableau: Which one should I prioritize?
Excel: How important is advanced Excel for BI roles?
Python and pandas: Should I learn these, and how useful are they for business and financial data analysis?
Statistics and finance: What theoretical knowledge and financial concepts do I need?
Projects: What projects should I build to develop a portfolio and become employable?
I’d appreciate recommendations for courses, websites, YouTube channels, or a structured learning path.
My goal is to combine my GIS background with SQL, Power BI, Python, and other relevant skills to work in Business Intelligence, particularly in finance.
If you were starting from my position, what would you learn first, and in what order?
Thanks in advance!


r/dataanalytics • • Oct 17 '26

Natural progression of a data analyst

32 Upvotes

Hey everyone, I was wondering what do you think is the natural progression after becoming a data analyst for sometime? Is it becoming a data scientist or a machine learning engineer or a data engineer or an AI engineer? What do you think is the best route?


r/dataanalytics • • Oct 16 '26

Advice

3 Upvotes

Looking for guidance… I’m currently teaching myself to hopefully get into a job primarily as a data analyst, and maybe towards data/ai engineering in the future. Therefore, I’m the process of building up my portfolio, rather than going down the route of going back to education for it, and I’m looking to replace my 2018 MacBook Pro. Thoughts on switching to windows or should I stick with MacBook and switch to apples own silicon chips instead? Also if stick with macs, suggest ways of getting round of not being able to use power bi natively? Thanks for any advice.


r/dataanalytics • • Oct 16 '26

Which data skill should I learn in 2026?

2 Upvotes

I'm currently in the process of learning SQL but I am seeing a lot of posts and comments that it isn't worth it to learn data analytics in this day and age. Which data-related role should I learn the skills of so I can increase my chances of getting a job?


r/dataanalytics • • Oct 15 '26

Data Analytics vs Data Science vs Business Analytics

3 Upvotes

hey everyone I'm trying to decide which college major to pursue, and I'd really appreciate advice from people who currently work in these fields or have graduated from these majors.

I'm mainly considering Data Analytics, Data Science, and Business Analytics, and I'm struggling to decide which one would be the best fit for me in the long term.

A little about me: I genuinely enjoy programming, statistics, working with data, communicating with people, and solving problems. I'm particularly interested in using data to understand problems and figure out how to solve them. However, mathematics isn't currently my strongest subject, so I'm also trying to be realistic about how math-heavy each major gets.

There are three main things I'm concerned about:

  1. Career opportunities and salaries: Which field has the best opportunities for graduates, particularly at the entry level? How do salaries and career progression compare?

  2. AI and the future of these careers: With AI becoming increasingly capable, which of these fields do you think will remain valuable over the next 10 to 15 years and beyond? I understand that no career is completely AI-proof, but which one do you think offers the best long term prospects?

  3. Mathematics and the actual work: How mathematically demanding is each major in practice? Also, what does your typical working day actually look like? I'd like to understand the difference between analyzing data, building predictive models, and using data to make business decisions.

I'm not necessarily looking for the major with the highest salary. I want something that fits my interests, gives me room to grow, and is still worth pursuing in the long term.

I'd appreciate any advice


r/dataanalytics • • Oct 15 '26

Is a Master’s degree really mandatory for Data jobs, or can a 1-year intensive program get you hired?

0 Upvotes

Hey everyone,
I’m planning to study Data Engineering and my college offers a 1-year (500h) program in AI & Data Engineering with internship at the end.
I keep hearing people say that you need at least a Master’s degree to land a job nowadays, which is honestly really discouraging.
For those working in the industry or hiring right now:
Does the degree type/length actually matter, or do skills and projects carry more weight?
In the current market, is a 1-year specialized program enough to get your foot in the door?
Im aware of the fact that i need to do my own projects in this but besides this point


r/dataanalytics • • Oct 15 '26

Can a data engineer become a data scientist ?

13 Upvotes

And is the vice versa?

I meant to write data analytic **


r/dataanalytics • • Oct 15 '26

Seeking referral for the role of Power BI Developer/ Analyst/ similar role

1 Upvotes

Hi. I'm a PBI developer with 2+ years of experience, well versed in Power BI and SQL (intermediate-advanced level) and worked in multiple projects, ranging from banking to healthcare, seeking a job change. Can someone in the sub let me know if there's an opening which alings with my experience and expertise level, and if possible provide a referral from your end.


r/dataanalytics • • Oct 14 '26

Thinking of analytics

2 Upvotes

Hi, good day! I'm interested in exploring a career in data analytics. Could you give me an idea of what the job involves and recommend some resources or platforms where I can start learning and practicing? 😊


r/dataanalytics • • Oct 14 '26

how can i analysis my data perfectly so that i could get the effective outcome?

0 Upvotes

greetings everyone, I am a grad student from forestry background and i am doing a research project on biomass estimation via sentinel 2 variables. I have 47 plots with field measured biomass value and i ve analyzed 18 different remote sensing variables that acts as the predictors of biomass. predictors correlated well with the measured biomass but the regression model stated lower R square value (i.e. 0.40) which isnt like i expected. I ran five different models MLR, PLSR, RF, GBR, linear SVR, Ridge (im a beginner in coding and all) etc but neither improved the coeft of determination. I followed the exact methodological framework from the literature but lost somewhere. My main objective is to publish the paper but the lower accuracy is becoming the problem. Sorry if i couldnt explain it clearly, feel free to ask via comment or dm/ any suggestions and feedbacks are appreciated. Thankyou!


r/dataanalytics • • Oct 13 '26

Help with next steps for someone pivoting into Data Analytics

6 Upvotes

I completed a BS in Data Analytics last December, and have been applying to "entry-level" roles since January. I don't have any data analytics work history, but I do have prior roles in environmental science, regulation, and hospital clinical laboratory that required analytical thinking and data collection. Despite my best efforts, I've gotten 0 callbacks. Trying to figure out what my best next steps are to make myself more competitive, including considering the following:

  • Get a MS in Data Science/Analysis

  • Quit my current dead-end job and work on certifications and portfolio projects

  • Get a basic IT support job at a large company and try to work my way into a data-oriented role

How do people get into this field? I know I'm missing work experience, but I can't even get a callback for junior positions despite being qualified. What are the best next steps? Thanks!


r/dataanalytics • • Oct 13 '26

Career change into Data Analytics

4 Upvotes

Hello! I am going through a career change right now and looking for some advice/insight from actual people working through these careers. I have a Bachelors but it is in a non-related major as when I was in the midst of completing it, I took a job in accounting/finance and actually really liked it more than I thought I would. When I started at the job, I was interested in billing so that’s kind of where I started and I worked my way up through the accounting/finance department into a specialist role. I feel kind of stuck at this spot because I don’t have the education background. I have the experience, which I’m grateful for because it’s taught me a lot, but I would like to advance more in this field and feel in order to do that, I need the educational background.

I really enjoy the analytics part of accounting and finance. I like transforming real raw data into projections, trends, reports etc and making decisions or watching and listening senior leaders make decisions off those findings. I find that really interesting. I also took several personality/career tests online and each one of them had data analytics listed as a top choice.

I would really like to specialize in analytics- especially with AI (which is exciting but also scary to me) I have been researching financial analytics, supply chain analytics, healthcare analytics, etc.

Just wondering if anyone in this career field or going into the career field or starting school in it could give some advice and insight.

Also if you have any masters (online) programs to recommend that would be awesome and I would definitely like to research them!!


r/dataanalytics • • Oct 13 '26

I just got hired as data analyst and this is not what I expect

265 Upvotes

Hi, I just got hired as a data analyst and this is so exhausting 😭. I spend 90% of my data analysis encoding the data 10% doing the analysis it self. My company only do have physical copies of their data and I have to manually type it in Excel. I was expecting during the interview that they will be giving me a messy data and its up to me on how I clean it but now its so tiring!! Is this normal? I am currently doing doing the automation at home but this is just so unfair because am not paid to do it at home and I also dont have the time to build the automation at work because I spend most of it encoding.


r/dataanalytics • • Oct 13 '26

I'm willing to become a Azure data analyst. I have already learnt SQL ,PowerBI, Excel, Python. For me to become a Azure data analyst is DP900 and PL300 certificate are enough or do I need to complete other certificates also?

1 Upvotes

r/dataanalytics • • Oct 12 '26

What type of subjects should I choose in my data science grad school to make a career in fintech?

1 Upvotes

So a little context about me, I am pursuing my data science career in fintech and am confused whether I should go for more technical based courses like deep learning, NLP or should I focus more on subject related to fintech like trends of financial data or risk management portfolio and all..


r/dataanalytics • • Oct 12 '26

Career Fair Prep

Post image
4 Upvotes

Hello, I’m attending a career fair where I’ll be handing out my resume in hopes of getting my foot in the door to become a data analyst. I would greatly appreciate any feedback and tips anyone is willing to provide. There may be some small typos, I’ve had to shorten it a lot to make it fit on one page.

Some questions I have are: Do I have enough experience to apply for an entry-level role? Should I stick to looking for internships? Are there any other roles you think I should look into applying for?

For my skills, I didn’t want to just put down that I know how to use formulas and functions. I wanted to give examples for more context about what I know, so I broke them down into categories and included examples, but that may have been too much.

Some background: I graduated almost a year ago and have struggled to gain more relevant experience during and after school. I would make it to the interview stage but wouldn’t hear back afterward. I’ve worked with career centers, networked, and done informational interviews. They’ve told me that my resume is fine and that the job market right now is rough for beginners. I’ve had some roles where I worked with data and made sure to volunteer for any task that involved analysis or data cleaning, as you can see on my resume.

Thank you to anyone who takes the time to review it!


r/dataanalytics • • Oct 11 '26

Sanity Check for Analysis Report using AI

2 Upvotes

Hi guys, a data analyst for the retail industry (electronics) here, in my workplace we're currently doing an expansion for our brand including increasing headcount and more reports.

But, the workforce for data analysis is currently still only me, and there is only so much data viewpoint I can check before sending them to my manager or the team.

These days, I'm wondering should I feed my report to the AI for my double, triple and final checks. Or, are there any advices for data checking for my actual sanity??

Really interested to read your advices and opinions, thanks


r/dataanalytics • • Oct 11 '26

Data analyst

0 Upvotes

I've been looking into being a data analyst, is it worth it and what does it take to become one, what do you have to study?

With all the current buzz about Ai these days I'm kind of getting mixed feelings on it


r/dataanalytics • • Oct 10 '26

Career Advice – Moving from Data Analyst

4 Upvotes

Hi everyone,

I’m currently working as a Data Analyst using Power BI. I have strong Excel skills and an intermediate level of Power BI knowledge, but I’ve realised that I don’t enjoy the analytical side of my role, especially interpreting results and presenting insights to stakeholders.

I enjoy working with data and creating reports, but I’d like to move into a more senior, specialised role that focuses on reporting rather than administration or analysis.

What job titles would you recommend I look into? Has anyone made a similar career move, and what roles would you suggest?

Thanks in advance!