Path / sequence analysis

DanielRA81

New Member
Joined
Feb 10, 2013
Messages
5
Hi all,

I have a set of data that provides information about which slides from a presentation (similar to web site pages) that has been shown at what position within each session. An example of the data structure is shown below:



SessionKeySlide RankSlide Name
001c162c-e85e-40ae-8da8-9e9cb06d35d71Frontpage
001c162c-e85e-40ae-8da8-9e9cb06d35d72VTE: A Serious and Significant Threat
001c162c-e85e-40ae-8da8-9e9cb06d35d73VTE claims many lives each year
001c162c-e85e-40ae-8da8-9e9cb06d35d74What do you use for VTE prevention
001c162c-e85e-40ae-8da8-9e9cb06d35d75Placebo 10 mg: One Tablet, Once Daily
001c162c-e85e-40ae-8da8-9e9cb06d35d76MoA
001c162c-e85e-40ae-8da8-9e9cb06d35d77Placebo 10 mg: One Tablet, Once Daily
006c9163-f874-4ba5-8fa4-5a31d3711b7c1Frontpage
006c9163-f874-4ba5-8fa4-5a31d3711b7c2Other safety outcomes at 2 weeks
006c9163-f874-4ba5-8fa4-5a31d3711b7c3Dependable Safety - RECORD1-3 POOLED
006c9163-f874-4ba5-8fa4-5a31d3711b7c4Simple Dosing and Administration
006c9163-f874-4ba5-8fa4-5a31d3711b7c5THR/TKR Benefit Calculator
006c9163-f874-4ba5-8fa4-5a31d3711b7c6How do you think about the e-detailing on the iPad
006c9163-f874-4ba5-8fa4-5a31d3711b7c7Other safety outcomes at 2 weeks

<tbody style="background-color: transparent; border: 0px; border-collapse: collapse; border-spacing: 0px; list-style: none; margin: 0px; outline: 0px; padding: 0px;">
</tbody>

My question is whether it is possible within Excel/Power Pivot to make the needed calculations in order to visualize the data in the same manner as for example Google Analytics flow:


It doesn't have to be a chart, it can also be a table or hierachy of some sort - eg. like this example:

Regardless of the visualization type, the business need is to be able to see in which order the slides have been shown and how many times. E.g. Slide1 has been shown 200 times, from that 50 times slide 3, 20 times slide 4 and130 times slide 2 have been shown after slide 1… and so on:
Slides 1 (200)
Slide 3 (50)
Slide 4 (20)
Slide 2 (130)
Slide 5 (70)
Slide 6 (50)
Slide 4 (20)
Any thoughts and inputs are very welcome.

Cheers
Daniel
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top