Hi
please find out sample excel sheet and analyse the data.
1)sheet 1:
market,time,type,sale fields available. using below sql query.and market field available string and num vales.so its load only string values.
select sheet1.time, sheet1.market , sheet1.garp_activity_type, sum( d.est_daily_net_sales )
sheet1
where sheet1.time >= '01-Jan-2017'
group by sheet1.time, sheet1.market , sheet1.garp_activity_type
having sum( sales ) <> 0
2)shhet2:fields like below .while loading time how to remove where its come UNKNOWN and -1 and fffff values.
| MARKET_GARP_DESC | ,MARKET_HFM_CODE_LEVEL1, | MARKET_HFM_SORT_LEVEL1 |
| Moldova | MARKET_NONE | 4 |
| UNKNOWN | -1 | fffffffffffffffffff |
| Indonesia | MARKET_NONE | 4 |
| Central and Eastern Europe - Overhead | MARKET_NONE | 4 |
| Switzerland | MARKET_NONE | 4 |
| Bosnia + Herzegovina | MARKET_NONE | 4 |
| UNKNOWN | -1 | fffffffffffffffffff |
and implement below sql query.
2)"select distinct d.market, m.*
from sheet2,
sheet1
where sheet1.market = sheet2.MARKET_GARP_CODE
and
sheet1.time >= '01-Jan-2017'"
3)
3)"select distinct sheet1.garp_activity_type, sheet3.*
from sheet3,
sheet1
where sheet1.garp_activity_type = sheet3.BUSINESS_LINE_GARP_CODE
and sheet1.time >= '01-Jan-2017'"
i don' know any requirements write now.i am going to work on this data.so please understand and how implement the data model and
if any idea about kpi with expressions on above data please send to me.
i shared only less fields in attached doc.if need full data for analyzing please drop a massage below email
chaitanya.mspa@gmail.com
thanks
daisy
