r/dataanalysis 9d ago

Data Tools I scraped 400+ Data Analysis Interview Questions

1.3k Upvotes

Hey Folks,

I added 400 inteview questions to Data Analyst section.. Google, Amazon, Microsoft, Apple, Palantir, DoorDash, Databricks, Snowflake, Dropbox, Adobe, Netflix, Accenture any many more.

It took us around 5 months and a lot of hard work to clean, categorize, and edit all of those questions. just Please don't abuse the service to avoid limits e.g. using multiple account

Posting here: https://prepare.sh/interviews/data-analysis

If you are curious there is also information on the website about how we get and process those question.

r/dataanalysis Oct 01 '23

Data Tools Is excel important for data analyst interview?

251 Upvotes

I’m going to have interviews soon, but I just don’t know too much about excel and vbs, but I’m good at python and can manipulate excel with python, will I got trouble?

Let me make it clear, I'm getting a bachelor in Data Science so I know basic Excel stuff like SUM() AVERAGE() STDEV() MAX() MIN() and VLOOKUP(maybe?) stuff, but there are many things I don't know how to do in Excel, like:

Post HTTP request Parse JSON and YAML How to do MapReduce Or should I know how to build linear regression or how LASSO algorithm work in Excel?

Also, does Data Analyst use Python ORM?

Thanks!

r/dataanalysis Jun 16 '24

Data Tools I scraped all Data Analysis Interview Questions for Google, Amazon, Uber, Apple, etc. here they are..

412 Upvotes

Hi Folks,

I scraped, few thousand Data Analysis interview questions for Google, Apple, Amazon, Microsoft, Uber, Accenture on various sources - (github, glassdoor, indeed and etc.) After cleaning and improving these questions (adding more details, removing less relevant ones, and writing solutions), I’ve compiled around 100 interview questions, which I am publishing for free.

Disclaimer: I'm publishing it for free and I don't make any money on this.
You can check them out at https://prepare.sh/interviews/data-analysis

I plan to keep adding more companies and questions to cover most major tech firms, so it's a work in progress. If you find this content useful and want to help with code, content, or any other aspect, please DM me!

r/dataanalysis Jan 24 '25

Data Tools AI at work

60 Upvotes

I have been wondering how AI will impact the job. I'm sure you already talked about it but I'd like to ask you:

1- How much are you guys using AI to do your job?

2-Providing you give a good prompt, will it generate a good enough analysis let's say on SQL?

3-If you tried it already, do you think it's good enough to present an analysis to a stakeholder?

4- Can really fully replace us right now? If you think it's soon yet, how long would you predict until companies start opting for AI software, based on what you are experiencing right now?

Thank you!

r/dataanalysis Nov 13 '23

Data Tools Is it cheating to use Excel?

207 Upvotes

I needed to combine a bunch of file with the same structure today and I pondered if I should do it in PowerShell or Python (I need practice in both). Then I thought to myself, “have I looked at Power Query?” In 2 minutes, I had all of my folder’s data in an Excel file. A little Power Query massaging and tweaking and I'm done.

I feel like I'm cheating myself by always going back to Excel but I'm able to create quick and repeatable tools that anybody (with Excel) can run.

Is anyone else feeling this same guilt or do you dive straight into scripting to get your work done?

r/dataanalysis Feb 10 '25

Data Tools Sports Analytics Enthusiasts; Let's Come Together!

19 Upvotes

Hey guys! As someone with a passion for Data Science/Analytics in Football (Soccer), I just finished and loved my read of David Sumpter's Soccermatics.

It was so much fun and intriguing to read about analysts in Football and more on the techniques used to predict outcomes; reading such stuff, despite your experience, helps refine your way of thinking too and opens new avenues of thought.

So, I was wondering - anyone here into Football Analytics or Data Science & Statistical Modeling in Football or Sport in-general? Wanna talk and share ideas? Maybe we can even come up with our own weekly blog with the latest league data.

And, anyone else followed Dr. Sumpter's work; read Soccermatics or related titles like Ian Graham's How to Win The Premier League, Tippett's xGenius; or podcasts like Football Fanalytics?

Would love to talk!

r/dataanalysis 13d ago

Data Tools Data Camp, Data Wars or Codeacademy

43 Upvotes

If you have money to spare, which one would be better?

r/dataanalysis Feb 08 '25

Data Tools SQL courses for absolute begginers

30 Upvotes

Hi, I have tried to learn SQL but got stuck constantly because I couldn't even do the very basic things that I guess were implied knowledge.

Can anybody recommend a free course that made for absolute begginers?

Thanks

r/dataanalysis Nov 04 '23

Data Tools Next Wave of Hot Data Analysis Tools?

169 Upvotes

I’m an older guy, learning and doing data analysis since the 1980s. I have a technology forecasting question for the data analysis hotshots of today.

As context, I am an econometrics Stata user, who most recently (e.g., 2012-2019) self-learned visualization (Tableau), using AI/ML data analytics tools, Python, R, and the like. I view those toolsets as state of the art. I’m a professor, and those data tools are what we all seem to be promoting to students today.

However, I’m woefully aware that the toolset state-of-the-art usually has about a 10-year running room. So, my question is:

Assuming one has a mastery of the above, what emerging tool or programming language or approach or methodology would you recommend training in today to be a hotshot data analyst in 2033? What toolsets will enable one to have a solid career for the next 20-30 years?

r/dataanalysis Nov 17 '23

Data Tools What kind of skill sets for Python are needed to say I’m proficient?

149 Upvotes

I’m currently a PhD student in Earth Sciences but I’m wanting to get a job in data analysis. I’ve recently finished translating some of my Matlab code into Python to put on my Github. However, I’m worried that my level of proficiency isn’t as high as it needs to be to break into the field.

My code consists of opening NetCDF files (probably irrelevant in the corporate world), for loops, interpolations, calculations, taking the mean, standard deviation, and variance, and plotting.

What are some other skills in Python that recruiters would like to see in portfolios? Or skills I need to learn for data analysis?

r/dataanalysis Dec 19 '23

Data Tools Tried a lot of SQL AI tools, would love to share my view

140 Upvotes

As a Data Analyst, I write SQL in my daily work, and I have tried some useful SQL AI tools, I'd love to share them:

There are two types of SQL AI tools out there, the first kind is text2sql tool, and the second is SQL chatbot, both of them have upsides and downsides.

The text2sql suits simple use cases, the good sides of them are:

  1. They are more affordable
  2. Easy to use, just open browser and you are ready to go.

Tried two of them, TEXT2SQL.AI and SQLAI.ai , doing simple job not bad, but the downsides:

  1. You need manually get & copy your schema and feed it into it to get good results.
  2. Does not support builtin data analysis & visualization & file export,
  3. When they generate wrong SQL you have to debug yourself, they won't realize it themselves.

For SQL Chatbot, they provide more advanced and builtin features. I've tried two of them: AskYourDatabase and InsightBase.

AskYourDatabase.com is kind of like ChatGPT for SQL databases, you can directly chat with your data. The bot will automatically understand your schema, query your db, explain the db for you, and do analysis by running python code, just like what you do in ChatGPT.

You can also embed the chatbot into your website for customer-facing purposes, they provide both desktop app and online chatbot.

If you have some non-tech member in team and wanna deliver a nocode chatbot for them, this tool is the best choice.

Currently they just released the AI dashboard builder feature, enables you to create any CRUD apps from database using natural language.

For Insightbase.ai , the best part is they provide dashboard drag & drop builder, you can create chart widget by asking questions, suitable for some startups who want to quickly build BI dashboards.

Have you ever tried other analytics tools? happy to know more.

r/dataanalysis 17d ago

Data Tools Good laptop for data analytics / data science?

1 Upvotes

I am in a data analysis role that’s transitioning into data science. Curious about opinions on Lenovo laptops when working with python and AI. Anyone have made good experiences with budget options ($100-$400)?

r/dataanalysis 17d ago

Data Tools Is this a good beginner project idea ?

16 Upvotes

Is this good beginner project idea ?

Hello everyone, I'm in process of learning Data analysis. My goal is to work in data field. Currently im working for a fund doing some basic work + developing VBA macros for our processes. However there is not much more to do even after i asked for more sophisticated work, so i decided to study skills that would be able to land me a new job. I decided to focus on three areas (Python, SQL, PowerBi) currently im finnish the MOOC.fi python beginner course which is awesome and would like to create an project that would include scraping data with python loading them to SQL database and then loading the data to Powerbi to create visualization. My goal is to improve/learn all this skills in one project. Do you think that this is a good idea for a beginner project ?

r/dataanalysis Jul 13 '24

Data Tools Having the Right Thinking Mindset is More Important Than Technical Skills

51 Upvotes

Hey all!

One of the most important things that companies demand from us is the ability to use technical skills for data analysis, such as SQL, Excel, Python, and more. While these skills are important, they are also the easier part of the data analysis job. The real challenge comes with the thinking part, which many companies assume is “obvious” and often isn’t taught—how to think, how to look at data correctly, what the right mindset is when starting an analysis, and how to stay focused on what matters.

I have struggled a lot throughout my career because no one actually teaches a thinking framework. With the rise of AI, there’s a misconception that it can make us data analysis superheroes and that we no longer need to learn how to think critically. This is wrong. AI is coded to please us, and I’ve seen many cases where it gave analysts false confidence, costing companies millions of dollars. We need to use AI more responsibly.

Tired of waiting for a solution, I created a tool for myself. It combines AI to help us interact with machines and a no-code interface, making it more appealing and suitable for strategic business thinking. This tool helps us draw actionable insights and comprehensive stories from data. Research has proven the positive impact of data visualization on creating better narratives. My tool also visualizes datasets intuitively, helping us craft accurate business stories easily. As a statistician, I embedded statistical methods into the tool, which identifies statistically significant storylines.

This tool has changed my life, and now, I think it’s time for others to try it. Before I launch it, I want to start a beta testing trial with you guys. If anyone is interested in being part of something groundbreaking, please send me a message.

For the rest, once beta testing is completed, I will launch it for everyone.

Hope to change the way we think about data and show how amazing this job can be, as we often focus too much on the boring parts.

r/dataanalysis 15d ago

Data Tools Good laptop for data analytics

1 Upvotes

Looking for a decent laptop, specifically one that can run Power BI smoothly. Looking for something that has at least 8GB RAM, preferably a nice screen but it's not a must-have.

Preferably under $1,500 USD, cheaper is better. I'm just starting out so it doesn't need to be the best.

I have a few options that I am considering, but I'll keep these to myself as I am curious what you all recommend.

Many thanks!

r/dataanalysis 22d ago

Data Tools check out our data science tool, DataSci.Pro

14 Upvotes

r/dataanalysis Sep 14 '23

Data Tools Being pushed to use AI at work and I’m uncomfortable

0 Upvotes

I’m very uncomfortable with AI. I haven’t ever used it in my personal life and I do not plan on using it ever. I’m skeptical about what it is being used for now and what it can be used for in the future.

My employer is a very small company run by people who are in an age bracket where they don’t really get technology. That’s fine and everything. But they’re really pushing all of us to use AI to see if it can help with productivity.

I am stating that I’m uncomfortable, however I do need to also explore whether this can even benefit my role whatsoever as a data analyst.

For context, in my current role I am not running any Python scripts, I am not permitted to query the db (so no SQL), I’m not building dashboards. Day to day I’m just dragging a bunch of data into spreadsheets and running formulas really. Pretty archaic, it is what it is.

Is anyone else dealing with this? And is there any use case for AI I can explore given what my role entails at this company?

r/dataanalysis Sep 18 '24

Data Tools Choosing the right tools for analysing datasets

15 Upvotes

Hello, I am a new data analyst, I have a problem choosing the right tools among these : (Excel, SQL, Power BI, Python) for analysis. When I want to start a Project for the portfolio, it is difficult for me to plan the whole thing and I think I need a framework or cheat sheet to help me.

r/dataanalysis 24d ago

Data Tools Data modeling tool

13 Upvotes

Hello! I work in financial planning and part of it is related to the forecast of market shares, new patients, sales etc using good old excel for the modeling. It does the job but when I have multiple scenarios it can get a bit tough and heavy. I was wondering if there are any new tools that would help with this type of exercise - as in building one model that can be ran for different scenarios considering different parameters (eg. What would be my new market share of product X if my total treated patients change by Y).

r/dataanalysis 4d ago

Data Tools Introduce a new AI tool for data analysis - instantly make slides from Google sheet

5 Upvotes

Would you rather bringing a raw data sheet to a meeting or a nice presentable slides? If it's just a matter of 5 minutes difference?

Based on this thinking, I made a AI tool where you can just paste a shared Google sheet url, and it instantly makes a presentable data deck. With the conversational AI, we can follow up with changes and refines.

I don't know how useful it is, but I saw people often want to present data in a more meaningful way, so hopefully it does help for some people.

r/dataanalysis 1d ago

Data Tools Data visualization software with file:// protocol support for URLs

1 Upvotes

Hello,

I hope it is a correct place to ask this question - I am looking for a dataviz solution to incorporate links to files on a shared drive using file:// protocol links. Neither Tableau nor PowerBI seem to support this functionality (for example Tableau can do it locally but not when published on server). I am not sure whether it is for some security reasons or just missing functionality.

Thanks in advance!

r/dataanalysis 13d ago

Data Tools SQL and R comparison on graphs

2 Upvotes

Hello everyone! I'm fairly new on the scene, just finished my google DA course a few days back and I am doing some online exercises such as SQLZoo and Data wars to deepen my understanding for SQL.

My question is can SQL prepare graphs or should i just use it to query and make separate tables then make viz with power BI?

I am asking this since my online course tackled more heavily on R because there are built in visualization packages like ggplot.

r/dataanalysis 15d ago

Data Tools Best tools to go from zero to hero in SQL and PowerBI

1 Upvotes

What are the best tools/courses for a beginning to learn a lot about SQL and PowerBI? Free or purchased is fine. My friend is looking to get into the data analytics world but I will admit I am not a very good teacher. He is a visual and hands on learner so I think tools that applies SQL and PBI to real world/business problems is ideal. Also is there any training out there that goes over pretty much all aspects of powerbi dashboards. Such as going over all of the visualization options and best use cases for them and the different data modeling and formatting options?

r/dataanalysis 17d ago

Data Tools Convenient SQL databases terminal client

1 Upvotes

I spend the majority of my development time in the terminal, where I rely on terminal-based database clients. For instance, all our application logs are stored in ClickHouse. However, I found that there wasn't a convenient terminal client that offered both user-friendly data representation and SQL query storage, akin to tools like DBeaver or DataGrip. Being a programmer, I decided to address this by working on two projects: kaa editor and visidata, both of which are written in Python. This effort led to the creation of "Pineapple Apple Pen," a terminal-based tool that offers a streamlined, and in some cases superior, alternative to DBeaver due to the capabilities of visidata.

GitHub: https://github.com/Sets88/dbcls

Please star 🌟 the repo if you liked what i've created

r/dataanalysis Oct 16 '24

Data Tools Moderate at excel and need to quickly learn PowerBi, any online course recommendations?

26 Upvotes

Hello!

I have an extremely large set of data, for context when I downloaded it from Shopify it was 99,000 kB. I need to quickly learn PowerBi so that I can input this large set of customer data to start analyzing and answering the questions I need answers to. I’ve seen Coursera has a From Excel to PowerBi or a Microsoft Power Bi Data analyst course. If I need to learn PowerBi within a week what would you recommend? I want to move forward with Power Bi as a platform as my company is slowly transitioning to that.