"Hi Amy, I'm fairly new to the field and am curious about how Python fits in. Is that what is commonly used for data manipulation? Is there an advantage to knowing Python over another scripting language such as Ruby?"
AnalyticBridge
Data Intelligence, Business Analytics
eggman2001's Discussions
Is knowing SQL helpful for online marketing analytics?
8 Replies
Started this discussion. Last reply by DataLLigence Dec 6, 2010.
Looking to change careers (seeking advice)
1 Reply
Started this discussion. Last reply by MikeJay Apr 8, 2009.
eggman2001's Page
Latest Activity
eggman2001 replied to Vincent Granville's discussion [Poll] How hard is it to get a data science job? in the group Polls
DataLLigence replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"Regarding SQL, I would say knowing SQL is a huge plus in Analytics. Pulling data for my projects based on the business problem/requirement, processing the data, etc. using SQL is something I do everyday. Once I create the analysis or modeling…"
Ralph Winters replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"All 3 of the programs are good choices. Both R & SAS have modules which integrate SQL calls within the environment."
eggman2001 replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"Thank you for the feedback. I understand much better now. I'm also wondering what some programs are to analyze the data that should be on my radar. I'm starting a masters program in statistics in the spring and am interested in what the…"
Angela Waner replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"I agree with everyone.
Being able to write your own SQL, is valuable because of "downsized" IT departments with limited resources. And since I am writing my own SQL, I will sometimes clean data/generate new variables with the SQL. Maybe I…"
eggman2001 replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"Thank you. That's all very helpful."
Themos Kalafatis replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"I agree with Vincent and Ralph. Although your question is about using SQL during the analysis rather than using SQL to extract your data, here are some situations where i found SQL to be of great help :
1) When looking for outliers and marking them…"
Ralph Winters replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"In theory you are correct. You shouldn't need SQL for anything else other than managing data. However since most shops are SQL centric, you probably should learn it only so that you would be able to extract your own data when the need arised.…"
Vincent Granville replied to eggman2001's discussion Is knowing SQL helpful for online marketing analytics?
"It is a mandatory requirement for almost any kind of analytic job.You can learn SQL by creating your own MySQL database: it's free (open source). At this time, very few people use in-database analytics (such as SQL server data mining)."
eggman2001 posted a discussion
Is knowing SQL helpful for online marketing analytics?
I work in online marketing analytics, and I do most of my data analysis using excel. However, recently I've come across some job postings listing SQL as one of the qualifications. I've used SQL in the past for things like retrieving, inserting, updating and deleting data from a database. However, I've never really used it as part of a data analysis process, and I'm wondering if it could be, or should be. I feel like you would use SQL to manage your data, but then use another tool (such as R or…See More
eggman2001's discussion was featured
Looking to change careers (seeking advice)
I currently work in the online advertising industry, running banner and search engine marketing campaigns for advertisers. However, I recently did some background reading on "data mining" and found it so intriguing that now I'm interested in potentially switching careers. I have always had an aptitude for working with numbers and I'm generally comfortable with learning new technologies.If I'd like to become a data mining expert, what avenues can I explore in order to get there? Are there…See More
MikeJay replied to eggman2001's discussion Looking to change careers (seeking advice)
"Eggman,
You are fortunate in that you live in the best city in the world for graduate studies. Data mining as such requires a bit of analytical/statistical sophistication and a good place to start is too look at a couple of DM texts "Data…"
eggman2001 posted a discussion
Looking to change careers (seeking advice)
I currently work in the online advertising industry, running banner and search engine marketing campaigns for advertisers. However, I recently did some background reading on "data mining" and found it so intriguing that now I'm interested in potentially switching careers. I have always had an aptitude for working with numbers and I'm generally comfortable with learning new technologies.If I'd like to become a data mining expert, what avenues can I explore in order to get there? Are there…See More
Profile Information
- Short Bio:
- I work in online advertising in NYC running search engine marketing and banner campaigns as well as some web analytics. I have no formal background in data mining, but am interested in getting into it.
- Field of Expertise:
- Web Analytics, Other
- Years of Experience in Analytical Role:
- Some web analytics and online advertising technology
- Professional Status:
- Director, Consultant
- Interests:
- Other
- Industry:
- Online Advertising
- How did you find out about AnalyticBridge?
- Wikipedia
Comment Wall
- No comments yet!
Top Content
Follow us
© 2013 AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC
