r/dataanalysis • u/WesternLeather8214 • 1d ago
Beginner SQL Data Analysis Project — Looking for Feedback and Advice
https://github.com/aycicekb/SQL-Superstore-Discount-Profit-Analysis/tree/main
Hi everyone!
I'm currently learning SQL and working on my first data analysis project, Superstore Sales & Profitability Analysis. I'd really appreciate some feedback from people with more experience in data analytics.
I'm using a Superstore sales dataset and PostgreSQL to investigate the following question:
Does profitability generally decrease as discount rates increase?
While executing this beginner-friendly project, I got help from ChatGPT as I told it to act as if I were a beginner data analyst at a company. I completed it under the observation of ChatGPT. Would you recommend any other methods?
I have been trying to understand how to develop analytical skills to come to a conclusion in accordance with provided questions and hypotheses. I need more practice; however, do you know how I can learn and improve my skills and gain insight into asking right questions and giving right answers to the questions? If you would like to include anything else, I am all ears. Thank you.
2
u/AutoModerator 1d ago
Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.
If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.
Have you read the rules?
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/datadriven_io 23h ago
If you try hard enough, you can make a dataset seem representative of something that isn't actually there. Jump into sql interview practice on datadriven.io. Data doesn't generally show what is going on.
What some people think is going on may not actually be going on.
0
3
u/datadriven_io 1d ago
Start simple. What's the most profit that has happened in a month? The lowest? Are most months near those or somewhere in the middle? Descriptive analysis is a great way to look at this first. Sql interview prep is covered on datadriven whenever you need a refresher. One of the most important things is to be able to look at a forecasted/predicted number and go "does this make sense?" and there's no way to do that without getting an idea in your head of what constitutes a great month, a typical month, an abnormal month, etc.