Question

I have the following data:

Month on Month data for Loan Officer sales in every county and state.

i.e. I have the transaction price, date, sales person details etc.

But there is a big variation in the average count and dollar value of transactions in every state.

I am trying to represent sales growth. Would I use a SQL index to do this and how would I define this index?

Answer 1

Yes,we can use index to represent growth of sales based number of units sold in each state(may also use Average Count). we cannot find sales based on both average count and dollar value of transactions,the reason is in one state sales is low value is high with this we cannot find Accurate Sales Growth.

Example of using Index:

create index index_name on Table_name(Column1,Column2,...);

-> After using index based on number of units sold of products we can easily find sales growth.