Why is SQL one of the most powerful tools in the arsenal of an Analyst?

Out of information analysis, comes wisdom. It’s this information analysis that is one of the important reasons that created the need for storage of data. The world of databases was sprouted to address this need of data storage and many languages were born to interact and deal with the data stored in these databases. But... Continue Reading →

Calculation of metrics at database level or reporting level..? which is the best way..?

I just came across a same old situation of deciding where to do the calculation of certain metrics like percentages ? Here is my take on it with a fictitious example - Scenario 1:  Calculating it at database level and preserving it in the database: see Fig.:1(Associate Level Sales) showing a table with sales made by a few sales executives... Continue Reading →

Up ↑

%d bloggers like this: