chop2chip
Well-known member
Donald Trump is definitely filling the Westbrook and Kaepernick role lol
But I won’t debate the ten year run. Y’all are pretty well setup.
Some Red State/Blue State Indicia
- Thread starter nsacpi
- Start date
But I won’t debate the ten year run. Y’all are pretty well setup.
sturg33
I
sorry - for clarity... I mean complex as in "multiple steps"... not a advanced complex task
I was following this video and trying it with my own set of data. made a couple mistakes early but after clarifying some prompts... ran everything in seconds
https://www.youtube.com/watch?v=mMkVdlHXcjo
Kap was great until he decided to get bigger and bigger and then go woke.
Power query / VBA does all of those things with ease. I'd advise you look into that as well.
Its nice to know there are other methods outside of Microsoft as well but these 'problems' are very basis (not an insult to you).
sturg33
I
That wasn't my point
My point was to tell you that new technologies will unlock tons of possibilities that will help you
I'm sure there is something python could do that would be relevant to my job - I'm just telling you all of those things are basic and Power Query / VBA does that easily.
sturg33
I
Can you give me an example of a very advanced excel concept?
Nested logical arugments
Sumproducts
'Ifs' statements
Filter function
And these are all leveraged when analyzing data sets.
The real advanced stuff is when you start using BI and creating data models with connections to outside data sources. You have to ensure that your assumptions can be extended to future data set additions and how to handle change management. Your measures need to be written correctly so as to not corrupt your whole data model.
These types of problems will never be solved by just reciting things into ChatGPT.
Yes chatgpt can give you the output. You just need to know what to tell it to write.
When you’re dealing with non basic data sets and need to run logical arguments in multiple attributes you’ll still need to actually know what you’re doing.
In addition - for those that nkow what they are doing writing a formula in excel will always be faster than using ChatGPT. Especially with excels 2022 array functions it becomes a thing of ease to extend down to your full data set
sturg33
I
Considering Microsoft owns excel and a good chunk of ChatGPT, I would imagine it won't be long before there is an excel plugin built right into the software
Excel has analytics suggestions already.
It’s not going to help people that don’t know what they are looking at.
In the time you type or recite something into chatgpt I’ve already written all the analytical functions that are needed for the dataset.
People will learn that things like chatgpt will not change higher level analytics.
sturg33
I
Look I'm not trying to diminish anything you can do... But it is self evident that this technology is going to be disruptive. People and businesses who learn to.embrace it and integrate it will gain a massive advantage over those who decide not to
If i can just tell it to look at the data in the workbook and create a 12 month P&L forecast based on the previous three years in each geographical location... And then it does it for me in 10 seconds... That will bring a lot of functionality to people who don't currently have the skills to do it, or people who it currently takes several hours to do it
This is ultimately a good thing and will unleash countless opportunities with the time and money saved
That stuff is fantastic. I’m not interested in doing those types of things.
But it’s very overblown how revolutionary this is going to be. You will still need excel/data skills to leverage chatgpt. Listen to some data centric podcasts that discuss it. People are getting it all wrong right now on how it will integrate.
This is also forgetting that raw data sets need cleanup before proper analysis can even be done.
sturg33
I
We are in the infant stages of it being brought to market .. and it is already getting perfect scores on the mcat, SATs, the bar exam... It's writing very functional code and it's even cleaning up tech debt for bad code. it already can do pretty much any function in excel
And I haven't even dabbled with chatgpt4 yet which is substantially more impressive than 3.
Meanwhile, the founder of the technology also happens to own Excel.
I think it's going to revolutionize it among many other things
Having access to the full body of information to regurgitate on an exam is different than actually creating original thought needed to prepare business analytics.
We are a long ways away before this type of stuff will replace existing infrastructures.
People extrapolate what AI is able to do with reciting facts to human intuition. It doesn’t work that way. Not yet at least.
chop2chip
Well-known member
I’m an AI skeptic but I’m constantly surprised how quickly this stuff has evolved.
I lean agreeing with thethe in that I think we underestimate how much quality human work requires human intervention. I think AI will get their eventually but it will take a while and I think we will have a very extended hybrid model.
With that said, AI takeover is inevitable. I think the odds are high a robot will perform a surgery on me in my lifetime and if that’s true, then no job is safe from automation. It’s why I think universal basic income is inevitable.
I lean agreeing with thethe in that I think we underestimate how much quality human work requires human intervention. I think AI will get their eventually but it will take a while and I think we will have a very extended hybrid model.
With that said, AI takeover is inevitable. I think the odds are high a robot will perform a surgery on me in my lifetime and if that’s true, then no job is safe from automation. It’s why I think universal basic income is inevitable.