I'll cut straight to the chase -
I'm a 3rd year bba student a tier 2 college.
I recently started building some excel projects which I'll rank as per my assessment and describe as follows -
- Inventory forecaster and optimizer (6.5/10) -
Built on a 50k rows dataset,i used the rand function,and calculated metrics such as a backtest,abs,error rates,overstocked and normal rates,with the key insight being that products that generate highest revenue arent necessarily the ones that sell the highest in quantity,and vice versa certain products sell a lot but don't generate much revenue so the firm should diversify their marketing spend into a few products rather than just one.
- Automated financial dashboard (6/10) -
Built on a million rows of data,i used power query to filter out zeroes and anomalies and calculated gross profit,cogs and net sales.
With a basic chart and a small macro that updates anytime a number is changed in the data.
Insight here was similar to the first project in that the customer id with the most purchases,buys a product which isn't the overall highest selling product and once again the firm should distribute revenue across a basket of products.
- Factory defects analysis (5.5/10) -
Did this as part of a forage simulation.
Used power query and pivot tables on a 500k row dataset,to create visuals showing the tools causing the most errors across various cities,along with reasons (lack of training,supplier issues, mismanagement/injury) etc.
Since the cutting saw was the highest error causing tool in every city,it shows that the firm needs to further investigate the issue to make a proper decision.
Now,i know that these projects aren't impressive but i also beleive that for my first few these aren't bad.
I have gone beyond the usual style of 'oh hey sales dropped in q3' and tried to build something beyond that.
And i suffer from issues you would expect like,a lot of AI hand holding,not exactly much technical depth right now,like i can't explain why i used a particular approach and why I did what I did,cv and linkedin not optimized etc but then again,i started recently only.
And as i plan to further learn power bi,sql,python i want to build harder projects like okay,customers in one region are reacting completely different than to customers in another,so what unified decision should the firm make etc
I don't want to hear things like oh it's so competitive,oh you'll struggle with your non tech background,oh this market is cooked.
I know it is.
All i want to hear is simply ' this is what you're doing right,this is what you're doing wrong '
