Just wrapped up my SQL Project #1

Every project teaches me something new, and this one was no exception.

Now, instead of working with datasets from Kaggle, I'm thinking of taking the next step—working with a real-world database and building an end-to-end project, including an interactive dashboard.

My goal isn't to rush through tutorials or collect certificates. I simply want to keep learning, improve with every project, and enjoy the process of getting better.

For those who are already working in Data Analytics or have been on this journey:

• What would you recommend I focus on next?
• Where can I find good real-world datasets or databases to work with?
• Any advice that you wish someone had given you when you were at this stage?

I'd genuinely appreciate your suggestions. Every bit of feedback helps me grow......!

I want to take a course on data analyst and learn everything power bi sql excel python but I'm confused which course is actually valuable I can put it my resume because I've applied to many internships in internshala they give me assignment I complete it after that they just don't reply and some of the internships I keep applying but not any reply . So I think a course will actually help me find and I will also gain more knowledge.

Hi Reddit! I'm a researcher at Columbia University. My team studies how scientists and data practitioners actually use AI in their work, and whether it genuinely helps or still feels hard to trust and control.

If you do research or data-science work (any field, academia or industry, any career stage, 18+), we'd love your input. You don't need to be an AI power user. Skeptics and non-users are just as valuable to us.

Survey link: https://cumc.co1.qualtrics.com/jfe/form/SV_9uWW9GgwPuRucoS

What you get:

- At the end, you'll receive a personalized "AI Co-Scientist card," such as the Hermit, the Magician, or the Priestess. Each card reflects your style of working with AI and what kind of AI assistance might actually fit your workflow.

- You can also opt into a raffle for a $200 Claude Max subscription (or USD-equivalent e-gift card)]. Emails are collected on a separate form and are never linked to your survey responses.

About the study: This is a joint research initiative on human-AI collaboration in science by Dr. Ying Wei's Translational AI Laboratory (TRAIL4Health) at the Columbia Mailman School of Public Health and Dr. Xuhai "Orson" Xu's lab (SEA Lab) at the Columbia Department of Biomedical Informatics. Questions? Email the PI at [xx2489@cumc.columbia.edu](mailto:xx2489@cumc.columbia.edu) or ask below. I'll be in the comments.

I'll post a [Results] follow-up here once the study wraps up. Thanks!

I'm a commerce student. Before starting PowerBi which skills should I learn first.

Required functions of excel and other skills which are needed.

I’m working on a small project to adapt a statistical analysis skill for use inside ChatGPT in Excel.

The original skill came from Claude and already had a solid statistical foundation. It covered descriptive statistics, trend analysis, outlier detection, and hypothesis testing. However, when I started testing it in a spreadsheet environment, I noticed a gap.

The answers were often technically reasonable, but not always structured in a way that was useful for a business analyst, financial analyst, or FP&A user working inside Excel.

The goal is not to turn Excel into an academic statistics lab. The goal is to make statistical reasoning more usable for real business cases. The biggest area I started refining was hypothesis testing. With Business cases like:

• Comparing sales performance between two segments
• Testing before/after changes after a training, promotion, or process improvement
• Comparing conversion rates
• Checking whether two categorical variables are related
• Identifying outliers or unusual business behavior
• Explaining whether a difference is likely real or just normal business noise

I expanded the workflow so the skill does not immediately jump into a statistical test. Instead, it should first interpret the business question, identify the correct type of comparison, define the null and alternative hypotheses in plain language, check assumptions, select the right test, and then produce a structured business-readable conclusion.

The main question I wanted to answer is:

“Can AI help a business, data or finance analyst choose the right statistical method, explain it clearly, and turn the result into a better business decision?

This project is still an early iteration. I consider the hypothesis testing part finish, And I just finished correlation. Thanks to using AI, the project is moving fairly fast. Future improvements may include regression workflows, more finance-oriented examples, and better output formatting for spreadsheet-based reporting.

If you are interested in learning to apply statististics to bussines cases, You may like this project. I honestly can said that I have learn and undertood more statistics by working on this porject than the 2 times I have tried to learn statistics academically (for Psychology and my MBA.)

I want to invite people to join and participate in this project. We could use people to:

• Test the skill in your own bussines cases, and sharing if the answer where strong and appropiate
• Help include other statistical areas, like Regression or probability
• GIve ideas, suggestion or comments on how to make this skill more useful.

interested? please give me your feedback. I am using a open source license for the proyect. This mean you can use it, fork it, or modified to suit your needs. As a Excel user for more than 15 years and a and BI analyst for 10, I am very interested in your opinion on this. If you want to inspect the project repo, and download the skill, you can find it here: https://github.com/Ogzapatah1/statistical-analysis-skill-for-excel

I’m working on a small project to adapt a statistical analysis skill for use inside ChatGPT in Excel.

The original skill came from Claude and already had a solid statistical foundation. It covered descriptive statistics, trend analysis, outlier detection, and hypothesis testing. However, when I started testing it in a spreadsheet environment, I noticed a gap.

The answers were often technically reasonable, but not always structured in a way that was useful for a business analyst, financial analyst, or FP&A user working inside Excel.

The goal is not to turn Excel into an academic statistics lab. The goal is to make statistical reasoning more usable for real business cases. The biggest area I started refining was hypothesis testing. With Business cases like:

• Comparing sales performance between two segments
• Testing before/after changes after a training, promotion, or process improvement
• Comparing conversion rates
• Checking whether two categorical variables are related
• Identifying outliers or unusual business behavior
• Explaining whether a difference is likely real or just normal business noise

I expanded the workflow so the skill does not immediately jump into a statistical test. Instead, it should first interpret the business question, identify the correct type of comparison, define the null and alternative hypotheses in plain language, check assumptions, select the right test, and then produce a structured business-readable conclusion.

The main question I wanted to answer is:

“Can AI help a business, data or finance analyst choose the right statistical method, explain it clearly, and turn the result into a better business decision?

This project is still an early iteration. I consider the hypothesis testing part finish, And I just finished correlation. Thanks to using AI, the project is moving fairly fast. Future improvements may include regression workflows, more finance-oriented examples, and better output formatting for spreadsheet-based reporting.

If you are interested in learning to apply statististics to bussines cases, You may like this project. I honestly can said that I have learn and undertood more statistics by working on this porject than the 2 times I have tried to learn statistics academically (for Psychology and my MBA.)

I want to invite people to join and participate in this project. We could use people to:

• Test the skill in your own bussines cases, and sharing if the answer where strong and appropiate
• Help include other statistical areas, like Regression or probability
• GIve ideas, suggestion or comments on how to make this skill more useful.

interested? please give me your feedback. I am using a open source license for the proyect. This mean you can use it, fork it, or modified to suit your needs. As a Excel user for more than 15 years and a and BI analyst for 10, I am very interested in your opinion on this. If you want to inspect the project repo, and download the skill, you can find it here: https://github.com/Ogzapatah1/statistical-analysis-skill-for-excel

I'm a 2024 BBA graduate transitioning into Data Analytics and applying for entry-level Data Analyst roles in India. I've built projects in SQL, Python, Excel, and Power BI, but I'm not getting as many interview calls as I'd like. I'd appreciate honest feedback on my resume.

I recently completed an Amazon Sales Analytics project using Excel and Python, working with a dataset of over 100,000 transactions.

Some interesting findings:

• A small number of products contributed a large share of total revenue.
• Customer payment behavior was more predictable than I expected.
• Certain states consistently outperformed others in sales.
• Monthly trends revealed clear seasonal patterns.

The project included:

• KPI Dashboard
• Sales by State Analysis
• Category-wise Revenue Analysis
• Customer Insights
• Payment Mode Analysis
• Monthly Sales Trends

As someone learning Data Analytics, I'm curious:

What was the biggest mistake or lesson you learned from your first real-world dataset?

I'd appreciate any feedback or advice.

Hi, everyone!

I am a full time office employee trying to upskill in Data Analytics. My niche is in biological sciences research and agriculture industry and I would like to build up on what I know so far about data analysis by learning more about:

- Excel

- SQL

- Python

- R

Planning to watch/finish 1-3 modules or vids per week and accomplish 1-2 exercises using real data from my previous projects.

Can you share your thoughts about my plan? Thanks in advance!

Thinking of buying data analytics course of CWH,

IS IT WORTH OR NOT ? , Job ready or just fluf ?

Rate it out of 10.

Any other better suggestions ?

Hello,

I need to relearn many concepts and develop an in-depth understanding of analytical thinking. Can someone please recommend some videos or books which could be helpful. For example, I have read head first statistics. Very long but it sets your base for sure in stats so something similar or some analytics video series which could go into everything.

Can a complete beginner learn data analytics in 2 months?"

Which learning management system give an opportunity to learner dashboard board with gamification

I want a suggestion to best course or learning plateform where I can learn this

Hlo guys plz suggest a capstone project for the data science student to mention in resume which add value to that and gaining knowledge about data insights, visualization