- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: What are some hard skills younwish you had learned for your career?
Posted on 3/11/18 at 11:49 am to TheCaterpillar
Posted on 3/11/18 at 11:49 am to TheCaterpillar
I’ve been going back and forth between deciding if I should stick with Excel, which I’m very familiar with, or to learn to use Access, and SQL.
My current set up has a “front end” sheet the user uses, and a “backend” that serves as a data base.
While Access may be better, I guess I failed to see how it could be that much better than Excel to justify the learning curve.
(Data sets are basically a list of analytical results of a sample).
Breaking out that kind of data through different granularities can easily be done with pivot tables.
Unless the big difference is that Access is much faster at sorting large quantities of data compared to Excel.
My current set up has a “front end” sheet the user uses, and a “backend” that serves as a data base.
While Access may be better, I guess I failed to see how it could be that much better than Excel to justify the learning curve.
(Data sets are basically a list of analytical results of a sample).
Breaking out that kind of data through different granularities can easily be done with pivot tables.
Unless the big difference is that Access is much faster at sorting large quantities of data compared to Excel.
2
Posted on 3/11/18 at 11:56 am to athenslife101
While at Chrysler, had a chance to take College classes for free.
I should of taken AC,Plumbing, and auto repair classes. Being able to fix these dealios saves you tens of thousands over the years.
I should of taken AC,Plumbing, and auto repair classes. Being able to fix these dealios saves you tens of thousands over the years.
Posted on 3/11/18 at 12:20 pm to Volvagia
It must suck for you gen x old dogs to have to try and learn new computer tricks. That's why employers love millenials
Too bad we couldn't stay on ms dos and the punch cards y'all are familiar with
Too bad we couldn't stay on ms dos and the punch cards y'all are familiar with
Posted on 3/11/18 at 12:23 pm to Volvagia
Yep, making tools at work using computer systems that the company provides is what separates the worker bees from the engineers.
I created a test system that was adapted by our vendor and is standard now.
I made tools to do whatever little functions using macros.
The best guys get 5x More done than any 5 normal people.
One time I wrote more accounting requirements in 2 weeks than the entire team of 5 or 6 had done in 6 weeks.
We are not all the same.
I was promoted to highest grade in USA in my federal agency.
I was on 4 teams at once.
Tool making gives and gives.
Interesting thing about being dba, systems programmer, business analyst and tool making ace all at once is you are busy all the time.
I created a test system that was adapted by our vendor and is standard now.
I made tools to do whatever little functions using macros.
The best guys get 5x More done than any 5 normal people.
One time I wrote more accounting requirements in 2 weeks than the entire team of 5 or 6 had done in 6 weeks.
We are not all the same.
I was promoted to highest grade in USA in my federal agency.
I was on 4 teams at once.
Tool making gives and gives.
Interesting thing about being dba, systems programmer, business analyst and tool making ace all at once is you are busy all the time.
This post was edited on 3/11/18 at 12:30 pm
Posted on 3/11/18 at 12:30 pm to Volvagia
It’s about size of data for me. I deal with 100 million rows or more. Excel can only handle a little over 1 million.
Excel is still a tool I use constantly, but SQL helps me pull what I need from our data warehouse. I’ll also connect Excel to that warehouse with SQL scripts and that way I can refresh and it populated my Excel tables and reports with new indoetmation.
Excel is still a tool I use constantly, but SQL helps me pull what I need from our data warehouse. I’ll also connect Excel to that warehouse with SQL scripts and that way I can refresh and it populated my Excel tables and reports with new indoetmation.
Posted on 3/11/18 at 12:31 pm to el Gaucho
quote:
Too bad we couldn't stay on ms dos and the punch cards y'all are familiar with
I know. I’m delaying upgrading to 10 for as long as possible because it removes the last vestiges of 3.1 and XP
Posted on 3/11/18 at 12:34 pm to athenslife101
Programming
Posted on 3/11/18 at 1:30 pm to athenslife101
R is an open source analytics and integrity program. It’s strength is histograms and data viz.
SAS is primarily a financial statistics tool. Its downside is that it’s expensive and a lot of companies are going to alternative solutions, but it’s still used quite a bit by large organizations.
SAS is primarily a financial statistics tool. Its downside is that it’s expensive and a lot of companies are going to alternative solutions, but it’s still used quite a bit by large organizations.
Posted on 3/11/18 at 3:28 pm to Eli Goldfinger
Kinda two ends of the spectrum there. R is a true programming language. Sas is basically a query writing tool for folks who don't really know SQL. Drag and drop.
I'm an ETL architect, we have people that use both. Also, if you know SQL you should be able to write T-sql PL/SQL, whatever. I'll write code for both and also vertica in a single day.
I'm an ETL architect, we have people that use both. Also, if you know SQL you should be able to write T-sql PL/SQL, whatever. I'll write code for both and also vertica in a single day.
Posted on 3/11/18 at 3:41 pm to athenslife101
Electrical.
Plenty of work.
Decent money.
Plenty of work.
Decent money.
Posted on 3/11/18 at 3:41 pm to athenslife101
Foreign language. Probably Spanish.
Posted on 3/11/18 at 3:55 pm to athenslife101
ABAP code language
Also would be nice if I could speak German and Spanish.
Also would be nice if I could speak German and Spanish.
This post was edited on 3/11/18 at 3:56 pm
Posted on 3/11/18 at 3:59 pm to dirtsandwich
The skills needed change so much after the first ~7 years professionally. Kickass Excel and PowerPoint skills are very valuable at the early stage but those skills will quickly lose relevance for me.
My ability to instruct my directs on how to use them more effectively will be the extent of how I use those skills the rest of my career.
My ability to instruct my directs on how to use them more effectively will be the extent of how I use those skills the rest of my career.
Posted on 3/11/18 at 4:19 pm to athenslife101
quote:
some hard skills
Posted on 3/11/18 at 4:28 pm to athenslife101
quote:Not really. They're just really efficient in Excel.
I feel like.vba and sql will can be the next step in learning to do professional level investment valuations and modeling and shite
Posted on 3/11/18 at 5:10 pm to Louie T
Tableau Baw!
Page 3 of 3
Popular
Back to top
Follow TigerDroppings for LSU Football News