Oct 01 2014

Introduction to SAS Macros


A quick example: Let’s look at the following SAS program: Above SAS code is written to extract policy level details for 09-Sep-14 and let us say that the user needs to run this code on a daily basis after changing the date (at both the places) to current date. Thankfully, SAS – like any other …

Continue reading »

Sep 30 2014

An exciting update from us – hopefully a learning aid for you!

One of the most common queries, we receive through several forums is: Which is the best training for me? OR What is the right training to start / transition into an analytics role? OR I am confused between Trainings A & B, which one should I consider? You can have a glimpse of some of …

Continue reading »

Sep 29 2014

The case of lost customer centricity in your analysis!


Today’s article is different (but very important!). It will not tell you about techniques to perform cutting edge analytics! On the contrary, it is to emphasize the fact that at the end of the day, you are creating products / services for a customer out there. And until and unless your analysis / strategy / recommendation does …

Continue reading »

Sep 25 2014

Tutorial on Web scrapping, text mining and predictive modeling (a.k.a. Solution to AV Author identification challenge)


While working late in office, something very strange happened to me. I got a message from Google that I should leave office in next 5 minutes in case I wish to catch the movie, which I booked two days back. I was surprised because I never set up any kind of reminder or alarm on …

Continue reading »

Sep 23 2014

Data Munging in Python (using Pandas) – Baby steps in Python

Orange Shoes

Time flies by! I see Jenika (my daughter) running around in the entire house and my office now. She still slips and trips – but is now independent to explore the world and figure out new stuff on her own. I hope I would have been able to inspire similar confidence with use of Python …

Continue reading »

Sep 22 2014

How to automate your Excel models and reporting using dynamic Range?

Emp Code

About some time back, we hired a smart analyst in our team (let’s call him Sam). Sam’s role required him to create and maintain various financial & business models in Excel. He seemed to be on top of his game! Within 2 months of his joining, he had created 2 new models, both of them …

Continue reading »

Sep 17 2014

Commonly asked puzzles in analytics interviews


The earlier you land up to the industry which interests you, the better it is for your carrer. I landed up into analytics industry by chance. When I joined my first firm, I was aware what analytics means, but did not really know how big is the opportunity to grow in this industry. Now, I …

Continue reading »

Sep 16 2014

How do I become a data scientist (or business analyst)?


Last week, I shared a framework to help you answer the question, “Should I become a data scientist (or business analyst)?“. For the people, who clear the cut-offs, the next obvious question is “How do I become a data scientist?” In this article, I’ll share what I would have done, if I was starting my …

Continue reading »

Sep 15 2014

Forum mining challenge – Get the right questions!

forum discussions

Analytics community is relatively small but very vocal on the web world. We subscribe to various Linkedin groups, Facebook groups and other websites to be aware of all that is going on in the industry. For instance, Stack overflow has more than 8 million questions asked till date. (Source: http://data.stackexchange.com/) . The problem statement we …

Continue reading »

Sep 12 2014

How to implement Incremental Load in QlikView?

Incremental Load, QlikView, QVD, Optimize Qlikview

In my previous article, we discussed “How to use QVDs to make your QlikView application more efficient?”. In this article, we will go one step ahead to make our application more efficient while dealing with large transactional data. As discussed in my previous article I was working on a QlikView application, where I had to show the …

Continue reading »

Sep 10 2014

Test your level of expertise with SAS/R/Python


Currently R, SAS and Python are the three languages ruling the analytics industry. Expertise in at least one of the three language is a must to build a competitive profile. But mastering only one language might not make you a hot selling property. Even if you are not an expert in each of the three …

Continue reading »

Sep 09 2014

Should I become a data scientist (or a business analyst)?


One of the common queries I come across repeatedly across several forums is “Should I become a data scientist (or an analyst)?” The query takes various forms and factors, but here is a common real life anecdote: “I have been doing Sales for multiple BFSI giants for last 3 years, but I have stopped enjoying my …

Continue reading »

Sep 04 2014

Framework to build a niche dictionary for text mining

Having the right dictionary is at the heart of any text mining analysis. Dictionary for text mining can be compared to maps while travelling in a new city. The more precise and accurate maps you use, the faster you reach to the destination. On the other hand, a wrong or incomplete map can end up …

Continue reading »

Sep 02 2014

Mining YouTube using Python & performing social media analysis (on ALS ice bucket challenge)

google ALS searches

If you are someone like me, you would have been swamped by the constant feed of people pouring ice buckets over them – but you still watch that next video in the feed, just to see how the person reacted to the icy shock! Yes! you are right – I am talking about the ALS …

Continue reading »

Aug 27 2014

Understanding and analyzing the hidden structures of unstructured dataset


The key to using unstructured data set is to identify the hidden structures in the data set. This enables us to convert it to a structured and more usable format.In previous article (previous article on text mining ) we discussed the framework to use unstructured data set in predictive or descriptive modelling. In this article we …

Continue reading »

Older posts «