- 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
What software does an Analyst need to know?
Posted on 8/3/16 at 1:19 am
Posted on 8/3/16 at 1:19 am
Excel sure, Access probably
wtf is all this other garbage?
R
Perl
Matlab
SAS
Python
Tableau
Hadoop
SQL
SAP HCM
EPIC
SAP LSO
CCAR
SSIS
SSRS
order in which I should give a frick about looking into for "knowledge"
wtf is all this other garbage?
R
Perl
Matlab
SAS
Python
Tableau
Hadoop
SQL
SAP HCM
EPIC
SAP LSO
CCAR
SSIS
SSRS
order in which I should give a frick about looking into for "knowledge"
12
Posted on 8/3/16 at 3:00 am to Kujo
Excel definitely, but you don't really need to know that much, you just have to be expert at what you do know. VLOOKUP, MID, and other functions that let you convert between data types. Make sure you know the keyboard shortcuts too so you can drop and fill a range like a champion.
SQL probably. And you'll want to know whatever language is used at your particular site. That language might be Perl, SAS, Python, whatever but that changes from project to project.
SQL probably. And you'll want to know whatever language is used at your particular site. That language might be Perl, SAS, Python, whatever but that changes from project to project.
Posted on 8/3/16 at 7:29 am to Kujo
what kind of "analyst"?
most of those are tools one may use while performing analysis... just sayin
most of those are tools one may use while performing analysis... just sayin
This post was edited on 8/3/16 at 7:30 am
Posted on 8/3/16 at 7:37 am to Kujo
(no message)
This post was edited on 3/28/17 at 5:54 am
Posted on 8/3/16 at 8:19 am to bigblake
It's an older architecture but if anyone out there knows Ruby and does independent consulting work, please email me: tigeralum2008@gmail.com
Posted on 8/3/16 at 8:24 am to Tigeralum2008
(no message)
This post was edited on 3/28/17 at 5:54 am
Posted on 8/3/16 at 8:43 am to Kujo
quote:
Kujo
quote:
SQL
quote:
SSRS
SQL is basically a way for you to run queries on db's to produce reports that can be interpreted to derive useful information.
SSRS is SQL Server Reporting Service, which is a more enhanced method for expressing the data from your Queries.
Mastering these two programs and skills is an extremely valuable tool if you ask me. Before I left to go to the CM side of the PM world a year or so ago from the Software Dev side where I was, our boss and her minion 2nd in command-type focused us on knowing enough to be dangerous when it came to running SQL queries. I've got to admit it was a great decision for our PM Unit and each of us individually as well.
Brushing up those skills and becoming more useful at running our own queries in SQL made our group the "go-to," once word got out. For folks to run their reports for their monthly metrics, specialized reports from the head honchos at the drop of a dime, etc...You can make a lot of people look really good if you're surrounded by some relatively non-tech-savvy folks...or just folks who are busy doing their normal 9-5 producing widgets who need someone to knock out the metrics for them and may owe you a favor down the road (recommendation, reference, storing a dead body in their truck, etc).
Not sure about the other stuff to be honest. But SQL and SSRS are-in my view-fairly valuable if you're in a business or agency or position where there's large amounts of data that could be harvested and used to report trends, output/throughput production, etc.
This post was edited on 8/3/16 at 8:51 am
Posted on 8/3/16 at 8:58 am to Kujo
I am an analyst. Know Excel and SQL like the back of your hand. Focus on those two.
For Excel, its more than just excel, be sure to learn at least the basics of VBA so you can do macros.
If you are smart you can teach yourself Excel, VBA and SQL. SQL isn't that hard. SQL is all about repetition when it comes to learning it. You learn by doing.
Excel, find something that interests you and use that to learn how to use Excel and VBA. For me it was sports betting. I taught myself Excel and VBA by creating spreadsheets for betting on college basketball.
SQL and Excel are the main 2.
It wouldn't hurt to at least have a basic understanding of Python, but I have never used it at work.
Learning SAS can be a big asset, but its an expensive program to have and an expensive program to take classes for. It's a chicken and egg situation. Do you take expensive classes to learn SAS for a potential job where you might use it? Or wait until you get a job that would use SAS and then try to learn how to use it then? Personally I have never learned SAS, but want to, but its expensive to take classes for. I don't use it at my job, but I know its a possibility in my field when I decide to move on.
For Excel, its more than just excel, be sure to learn at least the basics of VBA so you can do macros.
If you are smart you can teach yourself Excel, VBA and SQL. SQL isn't that hard. SQL is all about repetition when it comes to learning it. You learn by doing.
Excel, find something that interests you and use that to learn how to use Excel and VBA. For me it was sports betting. I taught myself Excel and VBA by creating spreadsheets for betting on college basketball.
SQL and Excel are the main 2.
It wouldn't hurt to at least have a basic understanding of Python, but I have never used it at work.
Learning SAS can be a big asset, but its an expensive program to have and an expensive program to take classes for. It's a chicken and egg situation. Do you take expensive classes to learn SAS for a potential job where you might use it? Or wait until you get a job that would use SAS and then try to learn how to use it then? Personally I have never learned SAS, but want to, but its expensive to take classes for. I don't use it at my job, but I know its a possibility in my field when I decide to move on.
Posted on 8/3/16 at 9:02 am to gmrkr5
quote:probably an analyst/therapist.
what kind of "analyst"?
This post was edited on 8/3/16 at 9:03 am
Posted on 8/3/16 at 9:06 am to Kujo
quote:
What software does an Analyst need to know?
How much schooling do you have?
Posted on 8/3/16 at 9:59 am to Kujo
Those are various databases/erp systems, integration tools, and business intelligence/reporting tools.
What kind of work do you want to do?
Do you want to support a specific type of ERP software?
Do you want to make sure internal/external systems integrate correctly and data is flowing accurately and on time?
Do you want to build complex dashboards, reports, or do data modeling/forecasting?
Do you want to find ways to make ingrained business processes more efficient through technology?
The term "analyst" is used all over and could apply to so many areas of a company and levels of technical ability. You really need to tell us what you want to do before we direct you to what kind of knowledge to go after.
What kind of work do you want to do?
Do you want to support a specific type of ERP software?
Do you want to make sure internal/external systems integrate correctly and data is flowing accurately and on time?
Do you want to build complex dashboards, reports, or do data modeling/forecasting?
Do you want to find ways to make ingrained business processes more efficient through technology?
The term "analyst" is used all over and could apply to so many areas of a company and levels of technical ability. You really need to tell us what you want to do before we direct you to what kind of knowledge to go after.
This post was edited on 8/3/16 at 10:12 am
Posted on 8/3/16 at 10:09 am to goldennugget
(no message)
This post was edited on 3/28/17 at 5:54 am
Posted on 8/3/16 at 10:22 am to Kujo
If you're working at a start up and directly with stakeholders who need more than requirements specification documents or use cases I'd recommend using Balsamiq. You need to learn how to use wireframing applications to create mockups of how your proposed system will look/work. Wireframes focus on content, user interaction and but not on internal processing. Balsamiq is a useful tool for creating wireframes quickly in brainstorming sessions and for getting immediate feedback from stakeholders. Business analysts and designers use this category of tools for creating mockups which once signed off, can be converted into actual designs.
Posted on 8/3/16 at 11:43 am to Kujo
Hadoop and SQL are advantageous to use when manipulating large data sets. I use both daily.
Decision trees: Tree-shaped structures that represent sets of decisions. These decisions generate rules for the classification of a dataset. Specific decision tree methods include Classification and Regression Trees (CART) and Chi Square Automatic Interaction Detection (CHAID) . CART and CHAID are decision tree techniques used for classification of a dataset. They provide a set of rules that you can apply to a new (unclassified) dataset to predict which records will have a given outcome. CART segments a dataset by creating 2-way splits while CHAID segments using chi square tests to create multi-way splits. CART typically requires less data preparation than CHAID.
Sequential patterns: Data is mined to anticipate behavior patterns and trends. For example, an outdoor equipment retailer could predict the likelihood of a backpack being purchased based on a consumer's purchase of sleeping bags and hiking shoes.
This is vital within the ecommerce realm when working with UX design teams.
Decision trees: Tree-shaped structures that represent sets of decisions. These decisions generate rules for the classification of a dataset. Specific decision tree methods include Classification and Regression Trees (CART) and Chi Square Automatic Interaction Detection (CHAID) . CART and CHAID are decision tree techniques used for classification of a dataset. They provide a set of rules that you can apply to a new (unclassified) dataset to predict which records will have a given outcome. CART segments a dataset by creating 2-way splits while CHAID segments using chi square tests to create multi-way splits. CART typically requires less data preparation than CHAID.
Sequential patterns: Data is mined to anticipate behavior patterns and trends. For example, an outdoor equipment retailer could predict the likelihood of a backpack being purchased based on a consumer's purchase of sleeping bags and hiking shoes.
This is vital within the ecommerce realm when working with UX design teams.
Posted on 8/3/16 at 1:06 pm to bigblake
quote:
I don't do independent consulting work but I know Ruby. You're probably the first person I've heard refer to it as "older architecture" .
Is your question regarding a web based application that's coded in Ruby (what made Ruby famous) or something independent of the web?
sorry...It's a web based application. We lost our only guy who knew Ruby. Looking for a contact in case things go bad or need changes.
Posted on 8/3/16 at 1:10 pm to Kujo
Some of those are scripts/frameworks and some overlap with Excel and Access (SQL is another database format, for example).
Good luck.
Good luck.
Posted on 8/3/16 at 11:18 pm to Ace Midnight
Thanks, looks like they want me to do "toad", tableau, and ArcGIS.... getting a pass on the others for now.
I know excel(intermediate, pivot tables and data manipulation all day)....and have messed around with Access....but they want me to mess with crap that doesn't seem better.
Ex: We have this data stream that send tens of thousands of duplicate records.....they are writing some script to fix it.....and I say "it doesn't have a remove duplicates feature?" In excel there's a button specifically for the issue but to do that simple purge you have to write a program?
There's no function button? "Insert function" all these programs seem antiquated, or unnecessarily complicated.
I know excel(intermediate, pivot tables and data manipulation all day)....and have messed around with Access....but they want me to mess with crap that doesn't seem better.
Ex: We have this data stream that send tens of thousands of duplicate records.....they are writing some script to fix it.....and I say "it doesn't have a remove duplicates feature?" In excel there's a button specifically for the issue but to do that simple purge you have to write a program?
There's no function button? "Insert function" all these programs seem antiquated, or unnecessarily complicated.
Posted on 8/4/16 at 12:26 am to Kujo
SQL, Excel, BI Tools (SSIS, SSRS). SELECT Top N so you don't bring down the servers and piss off the real developers.
Posted on 8/4/16 at 4:57 pm to Kujo
quote:
I know excel(intermediate, pivot tables and data manipulation all day)....and have messed around with Access....but they want me to mess with crap that doesn't seem better.
Ex: We have this data stream that send tens of thousands of duplicate records.....they are writing some script to fix it.....and I say "it doesn't have a remove duplicates feature?" In excel there's a button specifically for the issue but to do that simple purge you have to write a program?
There's no function button? "Insert function" all these programs seem antiquated, or unnecessarily complicated.
Excel craps out trying to manipulate any decently sized data set. Removing duplicate records from a file with 500k rows (small by most business standards) via Excel is incredibly inefficient. These guys obviously know more than you. Trust them and learn from them.
Page 1 of 2
Popular
Back to top
Follow TigerDroppings for LSU Football News