Analysis and workflow for data

[Navya08]

I want to built a logic behind two sheets can someone help me to go through this?

sheet 1 : Termination Data 

Objective: is to find no of terminations per entity.

sheet 2: transfer data

objective : is to find no of transfer from one entity to another and no of transfers entity wise.

And if any analysis can be done through alteryx on this

[gawa]

hi @Navya08 

Regarding Objective 1&2, you just have to use Summarize tool. Pls refer to the attached WF.

When it comes to analysis, it is difficult to provide the generic solution, it ttally depends on your goal... but ,I say, first thing to do is to make some visualization to get insight.

For example, regarding Transfer data, we can create Heat Map by Interactive Chart tool to know which Entity has the most/least numbers of employees leaving/accepting like. 

[Navya08]

For transfer - i am getting output

old entity new entity and count for new entity

what if i want emp id, name , transfer date and old entity , new entity for all and then new column maybe (formula tool) stating entity changed - yes  or No

[Navya08]

What i did is- i did group by name and emp id as well

and then added formula tool

that

entity changed: iif(old=new),”no”,”yes”)

but the problem is after this if i want to see total  new entity wise count i am not getting total count instead because of name and emp id group by i am getting output like this:

 Empid. Name. Old entity  new entity Entity transfer total

123         Abc.  Sales.          HR.            YES.              1

456.         Dgh.    Sales.      Sales.          No.              1

where total is (new entity -count)

[Akash08]

Is it solved or still you are looking for solution. If you are looking for solution, then please again state the question and output needed below. Might help you out.

[SahilArora3139]

 you can download connector for power bi to visualise data

[Navya08]

Spoiler

---

@Akash08 wrote:

Is it solved or still you are looking for solution. If you are looking for solution, then please again state the question and output needed below. Might help you out.

---

I want to built a logic behind two sheets can someone help me to go through this?

sheet 1 : Termination Data 

Objective: is to find no of terminations per entity.

sheet 2: transfer data

objective : is to find no of transfer from one entity to another and no of transfers entity wise.

And if any analysis can be done through alteryx on this

output required:

1)emp -id.

2) name

3) old entity

4) new entity

5) entity transfer - yes/no

6) entity wise count (new entity)

example

01.  Abc.    Sales.    Marketing.   Yes.   Marktng:2 Sal-1

02.  Cde.     Sales.    Sales.          No

03.   Rst.     Finance.   Marketing.  Yes 

where marketing:2 and sales:1 is the new entity total.

also interactive chart for both if possible to do analysis

[aatalai]

also look at the data investigation pallet that can help provide some inspiration

[Navya08]

I am still looking for a solution