WEBVTT

1
00:00:00.000 --> 00:00:08.914
So I'm going to transfer now to the CHH Tagetik platform. I'm logging in into CCH Tagetik platform as user CCH Tagetik, you can see that 

2
00:00:08.915 --> 00:00:18.429
in the right top corner. I've opened up a report and I'm showing this report to show that visualizations

3
00:00:18.430 --> 00:00:27.945
cannot only be done by using analytics client like Qlik Sense but also in the standard report engine a lot of visualizations can be added.

4
00:00:27.946 --> 00:00:36.860
For instance we are looking here at the Performance Review Package and if I open up the income statement so the first sheet, you see the typical

5
00:00:36.861 --> 00:00:46.976
income statement on the left hand side, while on the right hand side of this report you see some visualizations that have been added to this report for analysis purposes.

6
00:00:46.977 --> 00:00:55.291
Another example of visualizations can be found in the KPIs sheet where you see combinations of data, visualizations, 

7
00:00:55.292 --> 00:01:04.006
finance data and, for instance, FTE information on the right hand side. So these visualizations are somewhat interactive, 

8
00:01:04.007 --> 00:01:13.722
for instance, if I take a look at the operating expenses in the bottom left corner and if I want to zoom in on variable operating expenses and fixed operating expenses I can

9
00:01:13.723 --> 00:01:23.137
turn off MP expenses by clicking into legenda. So when I close these reports I return to my HTML5 Tagetik homepage.

10
00:01:23.138 --> 00:01:32.153
So from this screen I can access my reports like the report we just had opened, the financial reporting back, I can

11
00:01:32.154 --> 00:01:39.368
access my processes to contribute, for instance, to a planning process or a closing & consolidation process.

12
00:01:39.369 --> 00:01:50.573
I can access my analytics for instance if I take a look at KPI analytics. If I click on this tile a dashboard will open and actually this is the dashboard created in Qlik Sense.

13
00:01:53.548 --> 00:02:01.812
So we are still in CCH Tagetik front-end and, as you can see in the top we are looking currently at the Qlik Sense dashboard

14
00:02:01.813 --> 00:02:09.778
And this dashboard is not static it's interactive. And for instance, we are looking here at Financial metrics across time 

15
00:02:09.779 --> 00:02:17.742
compared to budget. I can make changes to this dashboard very easily by using selections on the left hand side. For instance

16
00:02:19.704 --> 00:02:20.794
I can select another currency

17
00:02:23.352 --> 00:02:25.844
or I can select another entity this is all

18
00:02:27.115 --> 00:02:28.565
rebuilt in the dashboard.

19
00:02:29.652 --> 00:02:37.394
That might as well have a look inside the graph and select the value I only want to see: the first half year of the graph.

20
00:02:37.395 --> 00:02:45.137
So I select June and you see that the other graphs automatically change their numbers. So if I'm okay with this selection

21
00:02:45.138 --> 00:02:52.879
I confirm and here we go. As an end user, in the top tile you can always see all the selections that you have made.

22
00:02:54.560 --> 00:02:59.649
So if I want to return to a 12-month graph I can open up the period selection in the top

23
00:03:00.925 --> 00:03:03.248
select December and deselect June and confirm.

24
00:03:06.975 --> 00:03:16.758
So I'm going to close this dashboard, returning to my HTML5 CCH Tagetik homepage. So instead of opening a single report from CCH Tagetik we can

25
00:03:16.759 --> 00:03:28.042
also access every application built in Qlik Sense using this analytics style. This get me access to all the applications in Quik Sense.

26
00:03:28.074 --> 00:03:34.183
And then a third option to open Qlik Sense is by using a hyperlink from the homepage.

27
00:03:34.184 --> 00:03:39.493
So I'm opening now the KPI dashboard application in Qlik Sense

28
00:03:44.046 --> 00:03:52.086
So what I can see from this application is that this application consists of four reports.

29
00:03:52.087 --> 00:04:01.128
I can open one of the reports and you see here that the dashboard looks exactly the same as when I had it open in the CCH Tagetik front-end.

30
00:04:01.129 --> 00:04:08.168
So also here we can do the same analysis. If I want to zoom in a graph I can do so

31
00:04:09.835 --> 00:04:19.247
to see the details. In Qlik Sense you can also create user stories which are basically analysis that you capture for other users,

32
00:04:19.248 --> 00:04:28.460
so you can show them the results of your analysis. So to capture images you can select an object, for instance

33
00:04:28.461 --> 00:04:37.673
bar charts and use the snapshot option. It took a photo, I can create the description of this photo like:

34
00:04:37.674 --> 00:04:46.886
"Net sales across..." not "...for the full year" and save.

35
00:04:46.887 --> 00:04:56.095
Later on I will be using this photo in a presentation to share with others. So I can go to my next page which shows a different kind of dashboard.

36
00:04:57.332 --> 00:05:04.233
So other type of visualizations. As you can imagine that Qlik Sense has a lot of visualization types

37
00:05:05.700 --> 00:05:08.577
like a map and graphs.

38
00:05:10.103 --> 00:05:16.060
Again these matching graphs are very dynamic so we can make insights, we can make selections. 

39
00:05:16.061 --> 00:05:24.019
We can also make a selection from the map. For instance, if I want zoom in on the US, I click on US in the map.

40
00:05:24.020 --> 00:05:30.976
I see that each and every visualization in my report is focusing on the data for US.

41
00:05:33.362 --> 00:05:36.294
So if I reject selection I return to my original state.

42
00:05:38.111 --> 00:05:47.201
What I can also do is I can benefit from the hierarchies in Tagetik to do a drill down to see more details.

43
00:05:47.202 --> 00:05:57.092
So in the bottom part of the graph you see the heat map on the left hand side where you see, that say, the net sales of products grouped by customer segmentation

44
00:05:57.093 --> 00:06:06.584
like finance, retail and manufacturing and on the right hand side you see the net sales by products. So on the right hand side I see home software

45
00:06:06.585 --> 00:06:15.075
that's also part of the chart on the left hand side. If I zoom in on home software, I click on it, 

46
00:06:15.076 --> 00:06:22.566
then you see that the graph on the left hand side to, the heat map, is now joining in on the components of home software

47
00:06:22.567 --> 00:06:26.058
If I confirm this selection then also my chart from which I zoomed in shows now the details of the home sofware components.

48
00:06:26.059 --> 00:06:43.549
So with this I've shown you some analysis, purposes with Qlik Sense. Now I want to create the presentation for the other users within Qlik Sense.

49
00:06:43.550 --> 00:06:54.034
I am going to use the photo that I created, the first graph. To do so I go to my stories and I've already started the story

50
00:06:55.366 --> 00:07:04.477
that now I am going to finish. So the story is basically like a PowerPoint presentation where you can add titles and subtiltes

51
00:07:04.478 --> 00:07:13.590
and where you can add photos and comments to share your insights with other. So from the right hand sides I can drag-and-drop

52
00:07:13.591 --> 00:07:22.703
components in my sheets. So for snapshot I open the snapshot library and today we've created the total net sales for the full year

53
00:07:22.704 --> 00:07:31.815
snapshot. I'm going to select that one and drag it into my story. I give it a little bit more space. So how it appeares you find 

54
00:07:31.816 --> 00:07:40.928
the header by inserting text objects and also documents so you can add snapshots to your analysis but you can also add

55
00:07:40.929 --> 00:07:49.841
full dashboards to your story. So in the sheets library you have access to your existing reports. If I select the

56
00:07:49.842 --> 00:07:59.148
KPI dashboard and your sheet is added to my story and actually this is a live sheet. So I'm going to play this

57
00:08:00.772 --> 00:08:05.007
presentation, play the PowerPoint presentation.

58
00:08:06.357 --> 00:08:07.032
Play the story.

59
00:08:08.769 --> 00:08:14.135
I can see the analysis, I can see the comments that are in. If I go to the next slide

60
00:08:17.685 --> 00:08:24.752
my data scanner for the interactive dashboards and also here I can make selections if I want.

61
00:08:29.739 --> 00:08:30.782
This is all interactive.

62
00:08:38.385 --> 00:08:39.423
And all my charts are updated.

63
00:08:55.022 --> 00:09:03.061
So the last topic of the Qlik Sense demonstration is to show a type of "natural language processing", so for that I go into insights. 

64
00:09:03.062 --> 00:09:14.702
Natural language processing is basically asking the system in your own word for some analysis and the system will try to generate the object you asked for. So compared to 

65
00:09:14.703 --> 00:09:23.042
Google where you ask in your own words to Google information and you get the results present. So, for instance, if I want to have a graph

66
00:09:23.043 --> 00:09:34.883
or a visualization that shows the sales by country I can type in, for instance, "sales by nation".

67
00:09:34.884 --> 00:09:44.223
So the system analyzes my question and comes up with new insights by Qlik but it's also

68
00:09:44.224 --> 00:09:54.064
exploring its existing charts that are already in the dashboards to see if this suits your needs but what I need is a new chart and now I only see US.

69
00:09:54.065 --> 00:10:03.904
That is because in the Entity filter I'm filtering on New York. So I remove the filter and now you see all countries appearing in my graph,

70
00:10:03.905 --> 00:10:13.445
and that is exactly what I need. Another option that Qlik Sense gave me is a map with all the countries in there. If this is what I want I can ask this components to an 

71
00:10:13.446 --> 00:10:23.085
existing sheet or added to a new to create sheet and then I can extend my analysis from there. So here you see that this kind

72
00:10:23.086 --> 00:10:30.426
of analytics really help users to get insights by entering the sentence instead of doing your own selections.

73
00:10:30.427 --> 00:10:43.266
Now I go back to the to the PowerPoint presentation. So a little recap of what we have seen. We started the presentation with the CCH Tagetik report

74
00:10:43.267 --> 00:10:53.107
which we have some visualizations. If you want to extend these visualizations with advanced analytics for that we have the Qlik Sense dashboards available

75
00:10:53.108 --> 00:11:01.947
to do that. And the steps we did to the presentation is restarted with HTML5 user interface to open up reports, to open up

76
00:11:01.948 --> 00:11:12.775
Qlik Sense dashboards. We did analysis into dashboards: we've created the user story and we've used natural language processing to let Qlik do the work.

77
00:11:14.071 --> 00:11:18.848
I would like to thank you very much for attending this webinar and I hope to see you again.