hello po pahelp nmn po if kayo po ang boss ko anu po b ang gsto nyo malaman sa data na to?gagawan ko po ng data analysis thank you po

11 months ago 39 Replies
GN
Gge Nrdla
1 year ago

hello po pahelp nmn po if kayo po ang boss ko anu po b ang gsto nyo malaman sa data na to?gagawan ko po ng data analysis thank you po

3 Likes

Replies

Gge Nrdla 1 year ago

hindi po sir practise for power bi po

0 Likes
Gge Nrdla (1 year ago)

wala pa po kc aqng idea if anu ang ilalagay q sa visualisation

Larry Encomienda 1 year ago

Project ba to sa company nyo?

0 Likes
Dncc Mits 1 year ago

If i am your boss, gusto ko malaman ang pinaka mabentang at Hindi na produkto, anong buwan ang ubos inventory at mabagal.

1 Like
Gge Nrdla (1 year ago)

Dncc Mits ok po send ko po sayo once ive done thank you po

Gge Nrdla (11 months ago)

Dncc Mits hello po 1st pic isend you po yan po yung month na mabenta and the 2nd pic product na mabenta po

Gge Nrdla (11 months ago)

Gge Nrdla (11 months ago)

Darwin Tacubanza (11 months ago)

Gge Nrdla for time series representation, better to use line graph to show trend

Gge Nrdla (11 months ago)

yes sir i was trying to use a line graph. do you have any idea sir how to change or filter the date into month?

Gge Nrdla (11 months ago)

Darwin Tacubanza thank you po sir sa suggestion addition knowledge q po itong mga mali q ☺️

Darwin Tacubanza (11 months ago)

Gge Nrdla sa power BI may column diyan for month, year, day

Gge Nrdla (11 months ago)

Darwin Tacubanza thank you sir hanapin ko po

Jomar Avergonzado 1 year ago

natry mo na ba i-feed sa chatgpt yang dataset mo? try mo then ask chatgpt to act as a stakeholder ganon ganon

2 Likes
Carlo de Guzman (1 year ago)

hello po, paano po siya iproprompt?

Gge Nrdla (1 year ago)

Jomar Avergonzado d ko pa po ntry sa chatgpt

Jomar Avergonzado (1 year ago)

Carlo de Guzman di ko pa talaga sya natatry pero i think pwede to (if di masyadong malaki dataset)

copy the dataset then paste mo lang tapos iprompt mo lang ...

"act as a stakeholder then ask me to give analysis for certain metrics/insights that can be drawn from the dataset"

Carlo de Guzman (1 year ago)

Pano sya i copy paste na dataset? Select all lang tas copy then paste?

Gge Nrdla (1 year ago)

Carlo de Guzman maliit lng ang sample data ko wala pa kc aqng idea if anu ang need na ipakita sa visual presentation

Jomar Avergonzado (1 year ago)

Carlo de Guzman yes,ganyan lang

Jomar Avergonzado (1 year ago)

Gge Nrdla try mo sir, tas update mo kami if gumana

Carlo de Guzman (1 year ago)

Ahh ganon pala thank you!

Gge Nrdla (1 year ago)

Jomar Avergonzado thank you po sir

Darwin Tacubanza 1 year ago

Though sa powerBi makapagsuggest ng possible reports based on data, you can also check chatgpt or other tools to find recommendation

1 Like
Regine Fontanilla 1 year ago

Sales po ba to? For me, total sales. Total sales per month. Total or average units sold but I'm not sure of it's relevant. Total sales per item. Total units sold per item.

0 Likes
Gge Nrdla (11 months ago)

Regine Fontanilla sorry po di ko na po na edit yung database ko for monthly sales but i will send to you the average sales per unit po thank you po

Gge Nrdla (11 months ago)

Darwin Tacubanza 1 year ago

Possible scenarios:

For descriptive

  • daily total sales trend
  • total sales per region
  • top representatives
  • top items sold and number of units
  • average monthly sales
  • average sales per item
  • average sales per region
  • when and where are the peak sales?
  • items with low sales
  • regions with low sales

Diagnostic:

  • possible reason for downtrend of sales per region
  • downtrend per item
  • possible downtrend of sales per representative

Predictive:

  • forecast of sales for next months
  • forecast of items to be sold
  • forecast on possible additional representative

Sa prescriptive: for further discussion nalang haha

Additional

  • KPI on sales per item, per country, per representative
10 Likes
Gge Nrdla (1 year ago)

Darwin Tacubanza thank you po sir forward ko po sayo ang nagawa ko once it done thank you po🥰

Darwin Tacubanza (1 year ago)

Gge Nrdla you can start with descriptive first 🙂 kayang kaya yan po more power! 🙌🙌🙌

Gge Nrdla (1 year ago)

Darwin Tacubanza yes po sir with the help of other like you i can do it.thank you po

Aljon Torno (11 months ago)

Darwin Tacubanza pede po ba to pagsamasamahin sa buong dashboard???

Gge Nrdla (11 months ago)

Aljon Torno yes po pwd po sir yun ginawa ko po nase sa sinabi nya isa lng po ang d ki mgawa is yung monthly sales kys gagawa muna aq ng seperate data tpos add q na lng po try q if pwd

Gge Nrdla (11 months ago)

Aljon Torno

Gge Nrdla (11 months ago)

madami pa nmn pong space

Darwin Tacubanza (11 months ago)

Gge Nrdla congrats on your progress

Darwin Tacubanza (11 months ago)

Aljon Torno hindi po in reality, depende sa prioritization ng management niyan, if they just want to know what's happening, kahit sa descriptive yan na yung pinaka mabilis. matagal po gawin yung mga susunod na suggestions

Aljon Torno (11 months ago)

Salamat po ng marami po...

Aljon Torno (11 months ago)

Meron kayo alam resources po kung san pede aralin ung mga yan...like descriptive , predictive , and prescriptive..