Here is Data Analytics challenge

[Jason Voorhees]

I run a branded-clothing store in a mall in New York. One of the sales staff, sp12, just resigned. Do I need to replace them? After I ramped-up the store I've generally tried to keep 7 sales staff. Whenever someone resigns, I use the 1-month notice period to add another person, which is why some months have staffing of 8. Should I continue this pattern? Can you please analyze this data that has sales by salesperson by month, so that you can help me decide what to do?I try to maximize my expected gross margin that I'll earn in the next 6 months, that I calculate as 50% of Sales minus Salary (3/person/month) minus commission (5% of the Sales amount).Show step-by-step logic to back up your recommendation. If you have questions, please use your knowledge of shopping for clothes to make reasonable assumptions and list those assumptions in your response to me. If you think my rules-of-thumb are sub-optimal, please provide better ones

This is the prompt above and data attached you need to build a script to read any future excel/csv formatted with these same columns, analyze it, and provide your recommended answer. With this script (a) I can upload data every month to get your recommendations and (b) other shop-owners can also use it to get recommendations for their shops You can use AI for everything from the code, to the analysis to the data crunching but again it wont be very useful if you just feed it the prompt and upload the file expecting an output

Here is the .csv I''ll reveal the answer later and if you arrive at it you are just as good as competent analysts in big firms. A small hint it might help to visualise the data and break it down further into more metrics to find it.

https://limewire.com/d/qQ8ki#iZY6JwhEE1

 

[Revan]

no tag? nigger fuck u

 

[iabsolvenico]

Interesting, high iq

 

[Jason Voorhees]

@Revan

 

[Revan]

@Revan

good

 

[Jason Voorhees]

@Chadeep @Wuzzdio @chang cypionate @Hess

 

[Jason Voorhees]

@Souleth @Sub5kang @Divineincel @filthycurrycel @Nothing

 

[Sub5kang]

This is the prompt above and data attached you need to build a script to read any future excel/csv formatted with these same columns, analyze it, and provide your recommended answer. With this script (a) I can upload data every month to get your recommendations and (b) other shop-owners can also use it to get recommendations for their shops You can use AI for everything from the code, to the analysis to the data crunching but again it wont be very useful for this

Here is the .csv I''ll reveal the answer later and if you arrive at it you are just as good as competent analysts in big firms. A small hint it might help to visualise the data and break it down further into more metrics to find it.

https://limewire.com/d/qQ8ki#iZY6JwhEE1

What degree at uni did you study if I may ask

 

[chang cypionate]

no tag? nigger fuck u

Mirin new avi.

 

[Revan]

Mirin new avi.

thanks cuh, this one staying for a while

 

[Jason Voorhees]

Why jfl? Is the question too easy for you?

 

[Jason Voorhees]

@imontheloose @RedDragonSlayer67

 

[Jason Voorhees]

Why jfl? Is the question too easy for you?

@chang cypionate

 

[Souleth]

Bump

 

[Jason Voorhees]

Bump

You can use AI bro.

 

[Jason Voorhees]

@optimisticzoomer

 

[Jason Voorhees]

@Joeseminate

 

[filthycurrycel]

ok im reading it rn

 

[Seven]

no tag? nigger fuck u

the fuck is that avi nigga

 

[filthycurrycel]

Yeah no i'm not gonna even attempt solving this. Ran it through AI once and i didn't understand anything.
What are the topics that someone has to study upon to figure this out?

 

[Revan]

the fuck is that avi nigga

es my girlfriend cuh

 

[Jason Voorhees]

Yeah no i'm not gonna even attempt solving this. Ran it through AI once and i didn't understand anything.
What are the topics that someone has to study upon to figure this out?

Buisness analytics, Optimisation and Advanced statistics. Perhaps you can probe the ai for more thorough analysis I think it will keep changing its mind

 

[brotato78]

This is the prompt above and data attached you need to build a script to read any future excel/csv formatted with these same columns, analyze it, and provide your recommended answer. With this script (a) I can upload data every month to get your recommendations and (b) other shop-owners can also use it to get recommendations for their shops You can use AI for everything from the code, to the analysis to the data crunching but again it wont be very useful if you just feed it the prompt and upload the file expecting an output

Here is the .csv I''ll reveal the answer later and if you arrive at it you are just as good as competent analysts in big firms. A small hint it might help to visualise the data and break it down further into more metrics to find it.

https://limewire.com/d/qQ8ki#iZY6JwhEE1

on god no one here knows how to do this

except maybe @imontheloose

 

[Jason Voorhees]

on god no one here knows how to do this

except maybe @imontheloose

Show kids here your Oxford math @imontheloose

 

[Joeseminate]

nobody doing this cuh

 

[polonaecel]

This is the prompt above and data attached you need to build a script to read any future excel/csv formatted with these same columns, analyze it, and provide your recommended answer. With this script (a) I can upload data every month to get your recommendations and (b) other shop-owners can also use it to get recommendations for their shops You can use AI for everything from the code, to the analysis to the data crunching but again it wont be very useful if you just feed it the prompt and upload the file expecting an output

Here is the .csv I''ll reveal the answer later and if you arrive at it you are just as good as competent analysts in big firms. A small hint it might help to visualise the data and break it down further into more metrics to find it.

https://limewire.com/d/qQ8ki#iZY6JwhEE1

The answer is 12