Cognos Analytics Explorations is one of the best features in the Cognos platform and it’s an underused gem. Explorations lets you interact with and explore your data to uncover hidden relationships, find trends and identify business performance drivers.
We discuss and demo how to use the features and functionality of Cognos Analytics Explorations.
In this on-demand webinar, we take you on a test drive. We
- Introduce the Explorations environment
- Show what drives a sample data set
- Examine predictive strength of fields in data
- Show how to use comparisons to handle what-if scenarios
- Work with the Exploration Assistant to ask questions of your data
Armed with the insights Explorations helps surface, you can be proactive and predictive. With it, you can act more quickly to mitigate risk, drive strategy for innovation and improve your customer experience.
Presenter
Patrick Powers
Trainer and Consultant
Senturus, Inc.
Patrick has 21 years of experience in training, business intelligence and data analytics. He is a Cognos expert whose product experience goes back to version 6. He is also versed in Tableau, Power BI, Actuate, Hyperion and Business Objects. His certifications include multiple programming languages, including Java and C++, and database certification (MS SQL).
Read moreMachine transcript
0:07
Greetings everyone, and welcome to this latest Installation of the Senturus Knowledge Series. Today, we’ll be discussing the topic of using Cognos Analytics Explorations.
0:20
Before we get into the core of the presentation, we invite you to use the GoToWebinar control panel to help make the session interactive.
0:28
And we generally try to respond to questions while the webinar is in progress, but we will cover them either in the Q&A section at the end.
0:42
We encourage you to submit questions via the control panel there. We do mute all the attendees out of consideration for our presenters.
0:51
Question we always get is, can I get a copy of the presentation? And the answer is not qualified. Yes.
0:57
It is available on senturus.com if you go to the Resources tab and then head to the Resources library or you can use the link that was just posted in the GoToWebinar control panel.
1:10
Be sure to bookmark that while you’re there as it has tons of valuable content addressing a wide variety of business analytics topics.
1:17
Our agenda today will cover some quick introductions and then, in our main topic of using Cognos Analytics Explorations: We’ll then do a brief overview, then additional resources, and please stick around at the end for the afore mentioned Q &A. Diving a little deeper into what we’ll be covering today.
1:38
We’re doing an overview of Explorations and then, using Explorations to see data drivers,
1:46
looking at predictive strength, leveraging comparisons, working with the assistant and exporting Explorations to dashboards and reports. By way of introductions, they are so disarmingly attractive that we left our pictures out today so, you could focus on the content. Our main presenter is Patrick Powers.
2:06
He is a trainer and consultant with over 20 years of experience in Business Intelligence and Data Analytics. He is a Tableau Certified Associate and Cognos report expert or Cognos expert, generally, whose product experience goes all the way back to version six.
2:22
My name is Mike Weinhauer, director here at Senturus and also play the role of MC for our knowledge series.
2:30
We always like to get our finger on the pulse of our audience, those of you who’ve been here before know how this works. So I’m going to launch our poll today which is simply how often do you use Explorations? Pretty straightforward, never, occasionally.
2:44
Or, frequently, please choose one of the above.
2:49
I’ll give you just a few seconds to answer. That should be pretty quick.
3:00
All right.
3:01
I’m going to close it out here and share the results.
3:08
So, the, the majority of you haven’t, a full 80%.
3:14
A few of you have done so occasionally.
3:17
That’s interesting, I would have thought that occasionally a number would have been fair and the lever number would be so large. So, good.
3:23
You’re in the right place to learn a little bit more about Explorations and with that, I’m going to hand the floor and the microphone over to Patrick Powers, is yours OK, thank you, Mike. And that poll is actually quite interesting and it’s something that I really want to talk about today.
3:43
You know, one of the goals with these webinars is to try to change how you’re doing things with Cognos.
3:52
Like Mike mentioned, even though it’s March 295th, this year marks 24 years that I’ve been using the Cognos product. The product itself is over 50 years old.
4:05
People don’t often realize that.
4:08
And, for a long, long time, you’ve all been using it the same way.
4:14
I would throw another poll out there, just to be edge, which would be interesting is How many of you just use Cognos essentially as a data dump tool?
4:22
You’re still using it the way it was, underreported, the way it was under version eight.
4:28
You’re still using it, like, It’s nothing but a report product and there’s so much more in there today, especially now. We’re up to 11.1.7.
4:49
Things have been rapidly improving over the last five years in the product.
4:55
Yeah, when you’re talking about a 50 year old product, five years is nothing in the lifespan, but, remember, version 11 came out technically over five years ago.
5:05
Now, granted, it was Christmas, so, really, we’re just crossed that five year point.
5:10
But five years and Explorations is one of those things where they have continued to add features and functionality.
5:20
Our goal with Cognos 11.1 is to really start getting people to self-service. No more writing SQL and reports. No more using it with transactional data sources as data dumps.
5:34
We want to provide a way for people to use it.
5:39
Like the name says, IBM Cognos Analytics and Explorations are the first step to that to actually analyzing data, not just being a passive recipient of data, not just having a scheduled Excel report that’s emailed to you.
6:01
No, Going in there, and really diving deep, finding trends, finding patterns, looking at things that are going on, and starting to understand correlations of data.
6:18
No, correlation is not causation.
6:21
Of course, not.
6:22
But, if we can at least start to uncover our correlations, think about all the things your users are doing right now with Cognos.
6:32
I would wager that the majority of you are giving folks, cognitive, or giving folks Excel report data dumps, You’re running a report, and they’re taking it off into another tool, whether that tool is Excel or Tableau, or something else.
6:49
And they’re going in there to do their analysis.
6:51
And the question that begs is why I’ve got a tool right here?
6:58
I’ve got a tool that I’m already paying for that I’m already using, the gosh golly.
7:05
Look at this.
7:09
So, hey, let’s see what we can do to actually use this for more than that.
7:19
OK.
7:21
No, and Trevor you can actually download the sample from IBM.
7:28
I want to hit the question that just came up, know that there needs to be more examples of the new functions from 11. You’re absolutely right.
7:35
I think that the more webinars we do like this and the more people get to see it in the real-world.
7:43
It helps.
7:45
But, you can get a lot of good samples and a lot of good stuff even directly from the IBM Cognos portal and, the samples have expanded.
7:56
Now, before I get into the official demo, let me let me just show something along those lines for you, Trevor.
8:04
There are a lot more samples out there now than there were in the past.
8:10
There’s, there’s more than just go sales query, go, sales analysis, go data warehouse. There are now samples by business function.
8:19
There are data module samples.
8:22
There’s a lot more in the newer versions of the samples that come up.
8:27
And that is in line with what you’re saying, yeah. And that will go a long way to helping people not use it for data dumps, right.
8:37
So, to that end, let’s go ahead and let’s take a look.
8:43
Let’s take a look and thank you for that, Joe. You’re absolutely right.
8:49
The Accelerator Catalog, we’ve got a lot of videos. We have a YouTube channel gang, shameless plug time, go to our YouTube channel.
8:59
And we show a lot of these things.
9:01
I personally have done a few videos out there on different stuff for not just cargos but other things as well where you can see some of this in action.
9:12
So, yeah, right here.
9:13
The Accelerator catalog, the samples, the how to videos.
9:20
Unfortunately, a lot of organizations, getting to this point, is a cultural shift and a business shift.
9:29
It’s not just about technology, and that that obviously can be frustrating for all of you. Those of you I you know, I know in some ways I’m preaching to the choir.
9:40
And that that can be part of the challenge, too, is getting your organization to understand that getting folks, we all know the dirtiest, the most offensive phrase in the English language.
9:52
That’s the way we’ve always done it.
9:56
Our YouTube channel, Mike, if you wouldn’t mind, throw into our YouTube channel URL, into the chat window for everybody.
10:05
That way, we know everybody can have it.
10:08
So, let’s take a tour. Let’s take a three hour tour.
10:12
Oh, the sea, you’ll start getting rough. The tiny ship will get tossed.
10:17
Down here, I’m at the Welcome. I’m going to start an Exploration.
10:24
And I am going to pick a data source. Now. You know, as a matter of fact, I think I’ll do it this way. It’ll be faster. So, I’m going to be using some call center data.
10:33
And this is data that came from the samples, and I’m going to create an Exploration.
10:43
Thanks, Mike.
10:48
Where do we want to start?
10:50
OK, I can start by either typing in what I’m looking for.
10:57
I could pick one of these.
10:59
These are the fields that it is found that says, hey, this is, these are the fields that I see are the most relevant and most important here.
11:10
You can start with one of these or you can type it in.
11:14
Now the nice thing about explorations is we’re using that IBM Watson and we’re using the built-in functionality of that.
11:24
So, I can type total customers satisfied, Average queue time, and we’re going to see that when we get to the assistant, all right?
11:34
We’re going to see that when we get into the assistant later on.
11:38
For right now, you know what, Hey Dealer’s Choice Jokers Wilde, show me anything.
11:49
So what it’s doing, it’s looking at the statistical relationships between columns in your data.
11:57
All right, so it’s literally looking at my data.
12:01
It’s figuring out the statistical relationship.
12:05
I got to move this over here, my ha!
12:10
Don’t you love when that GoToMeeting control panel just kind of gets in the way?
12:15
Know, Alan, this is all built-in.
12:18
This is, this is stuff that IBM has been building into the product over the last few versions, OK, so there’s nothing you need to do to use this.
12:31
That’s the nice part, this is all right there.
12:36
Sorry, gang Mai.
12:39
Like I said, my control panel gotten my way there, and I ended up click on something I didn’t want to click. So, here we are, It’s gone through.
12:46
It’s looked at my data, and it said, hey, based on the data that I see, this is the most important statistical relevance.
13:03
All of these relationships are connected to total customer satisfaction.
13:12
And, Doug, to your question is, same as Alan know, this is all built-in when I say we’re using, no, this is all the stuff that, that they have integrated the pieces of Watson that they have integrated into Cognos, if you will?
13:24
OK, Patrick, if you’re going to answer the questions in line, maybe you might want to repeat the question just so the rest of the audience is clear on what was being asked.
13:34
Thank you, Mike. You’re absolutely right. Sorry, I forget not everybody can see them. All right. There’s, I brought up Watson and that seems to have confused a few people.
13:43
There’s questions about is needing Watson as a separate tool now, what I’m talking about here, gang, is, I’m talking about the pieces of Watson that IBM as a company has slowly started to integrate into Cognos as a product, OK, So, nothing, You guys don’t need to do anything for this. There’s no additional add ones needed to do what I’m doing today here.
14:11
So, statistically speaking, total customer satisfied has the most correlations to other columns of data.
14:21
These are the other columns of data and the thickness of the line is representing the strength of that relationship.
14:33
All right?
14:34
It’s representing the strength of that relationship and we see that an agent shift is coming in at 58%, agent shift ID, and agent shift ID. So it’s in there twice, and everything else is sitting around a 30 to 40%.
14:53
Now, down the bottom here, there’s a slider.
14:59
And if I adjust this slider, I’m going to take this up to 80%, and I’m going to take this up to on the other end, 60%.
15:16
Now, I don’t have anything. I lose this.
15:20
There is nothing that has a 60 to 80% impact on this.
15:28
So I have to bring this back down. I’m going to bring it back down to 40%.
15:34
OK, these are the top three things.
15:39
These are the top three things that are impacting our total customer satisfaction, the agent and the shift of the agent, and the total number of calls.
15:50
All right, total number of calls.
15:54
Logically, that would make sense.
15:58
And this is what this is about. It’s about logic, right?
16:02
Let’s click on that Total Calls.
16:06
Here’s where this control panel is, once again, in my way, when I click on Total Calls, it produces some sample visualizations for me.
16:19
Here is just a straight card showing me the total number of calls.
16:24
Here, we see Predictive strength, and here, we see one that shows talk time and total calls by abandoned calls.
16:36
Let’s dig deeper.
16:41
Now, I’m in here to deeper.
16:43
I’ve got five abandoned calls in total.
16:47
I see my talk time totals for this.
16:52
And, look at this on the right.
16:55
Look at all this on the right.
16:58
The details, this is where we’re starting to see some real analysis.
17:04
We’re starting to see that real analysis. I do want to address one question. Sorry. I had to move my control panel out of the way, so I’m not seeing all the questions as much.
17:14
But I will say that the reason there were two agent shift IDs. So the question. Why are there two agents Shift IDs? That field is present in multiple tables.
17:24
So if you had revenue, for example, in three different fact tables in the package you were bringing in, you would see revenue three times if it was an impactor to the data.
17:37
OK, so that’s probably the last one I can answer in line gang, because I need the screen real estate.
17:43
Having run at this resolution makes it tough for me.
17:47
I’m used to running at a nice four K resolution.
17:52
So here we see our total calls as a sum.
17:56
Our Total Talk, Time is a sum, and we see that reflected against abandoned calls but it’s this details on the side, OK, It’s the details on the side.
18:10
And what we see in what you probably have already noticed tock time looks weird All right?
18:18
Talk time looks weird because it’s defaulting to an aggregation of some not useful.
18:28
So let’s change that.
18:29
Let’s change the properties of our talk time.
18:34
OK.
18:35
So I can change the summarization to an average.
18:42
OK, Ah.
18:46
Now we’re seeing the average talk time.
18:54
And no, I don’t know off the top of my head. I believe this is in seconds.
18:59
So we see the total number of calls.
19:02
We see how many calls were abandoned, and we see the average talk time on this.
19:09
If I click on this number five, down here, the five is showing me are correlations.
19:19
What does total abandon call’s correlate to?
19:25
It’s allowing me to dive deeper into this.
19:31
I can see the correlation between abandonment and total calls, average cost per call, et cetera.
19:39
This is probably more insight in 15 minutes.
19:46
Then most of you have seen on your data in a long time, right?
19:52
This is more than just looking at it at Excel.
19:57
OK, how do these correlate?
20:01
How are they correlating together? So I’m going to look at this second one.
20:05
The correlation of abandonment percentage and the average cost per call, it’s got 96 percent correlation.
20:15
So when I drill into that, I’m now looking at predictive strain.
20:23
I’m looking at the predictive strength of each field and the correlation. And we’ll get into this deeper in the next demo.
20:31
I just want you all to see what’s starting to come up here.
20:34
The average cost per call with the abandonment percentage.
20:40
What drives that?
20:43
What drives us to abandon Nicol what drives us too?
20:50
Get rid of it.
20:52
And we see a sample visualization down the bottom.
20:55
Now, the nice thing is that we can jump back to any of these.
21:01
So if I go back to Data, Relationships, I go right back to Data Relationships. These are all still open.
21:11
Coming back here.
21:13
And from here, I can start a new query.
21:17
I can ask a question.
21:19
I can edit the original whatever I want.
21:23
So if I go back to the original and I get rid of this, hey, let’s take a look at one of the ones it recommended.
21:35
Let’s take a look at Q time, what impacts Kew time?
21:42
We’re going to see a new diagram with new differences in thicknesses.
21:48
And we are going to see the queue time against total calls 47%, 47%.
22:00
This is the weight of the total calls against the acute side.
22:05
Now, some of these are irrelevant, and you’re probably thinking that, well, is there relevancy to look at first name now, probably not.
22:15
Is there a relevancy to age?
22:17
Maybe we’d have to dig in deeper. Same thing, what supervisor?
22:22
You don’t have to use all of these fields, obviously.
22:26
We don’t have to use all of them.
22:28
This is just giving us the statistical relevancy and giving us a starting point.
22:36
Speaking of that, we can also start from scratch. So we can use this like the dash boarding tool.
22:45
So if I pick a new card, a single new card will do comparisons in a separate demo.
22:53
I can create my own visualization here.
22:56
I can drag fields over.
22:58
So if I go to my source, hey, here it is.
23:03
Here’s my source. So this is my data module in this case.
23:08
I can expand our customer.
23:11
I’m going, it’s going to drag State on over to the canvas.
23:17
And I’ll end up with a map of the US.
23:24
I’m going to expand out from here wireless plan.
23:29
I got monthly fee, which is currently an attribute, and so I’m going to change it to a measure.
23:41
So I’m going to make this a measure.
23:43
And I’m going to make it an average.
23:47
OK, you’re going to make it a measure.
23:53
And I’m going to format it as currency real quick.
23:58
All right.
23:59
Good there, I’m going to pick USD just to get it the way I want it.
24:07
Now, I can drag this to the location color.
24:14
So I couldn’t use this for self-exploration.
24:23
Try that again.
24:28
There we go. Ended up in there twice.
24:31
Get rid of one.
24:34
Perfect.
24:35
So here I can see that my monthly averages ranged from $45 to 49, 87.
24:42
I can zoom in on a particular state if I want to.
24:49
If I wanted to look and say, Wow, why are Wyoming a main? So, hi, what’s going on, but in this case, I’m going to click on California.
24:57
I’m going to right click.
25:00
I’m going to go to Show By.
25:05
Oh look, here’s the hierarchy of this state and it’s recommending these columns.
25:12
So I can change this to city.
25:20
I can drag that over and I can zoom in.
25:23
And I can see if I have any hotspots.
25:27
And I can use this to correlate it, and compare it to my total customer satisfaction.
25:37
Is this, so this is opening up more business questions?
25:40
Is my customer satisfaction impacted by the average monthly fee?
25:50
OK, I have not been looking at the questions for a second.
25:54
So I want to take just quick pause.
26:00
I don’t think there’s anything really there, Patrick that you have to address right now. Except I don’t see anything either.
26:06
There’s just some questions around, did you have to do a lot of, what, what kind of configuration and preparation, nothing.
26:12
It’s kind of important that the idea is that you don’t really have to do a lot of preparation, although the, the insights that you’re going to get.
26:19
You know, like most things are going to correlate to the quality of the data. Exactly.
26:24
Know, now, again, gang, this came from an Excel. Asks, it was turned into a data module.
26:30
But, yes, garbage in, garbage out. Right.
26:34
And, and that, that, I think, is a challenge that a lot of folks face, is that you’re still trying to do business intelligence against transactional data sources, but, boy, Oh, boy, that could be a Webinar in all into its own right. Then, that’s a different discussion.
26:56
And I will, I will address one particular question. There was a question of what version of Cognos am I using? I am in 11.1.7.
27:07
So, this is, this is our environment, hey, this is our Cognos environment and it is on 11.1.7. And the question was, is this a dimensional data mart or relational, relational fine? Let us say this is an XL S I’m not using a package either. The question was: what’s packages amazing? I’m using a data module that was created from a.
27:31
OK, so there was no, there’s no framework manager modeling. There’s nothing here this.
27:37
And that’s the beauty of this.
27:40
If you expand out and you start giving people access to data modules, if you start giving people access to upload their own Excel files.
27:53
Hey.
27:55
They can start using this tool to dig into their data.
28:00
Obviously, you’re not going to give that to everybody, come on, and you know, we know that, you know that, but if we can find those 1 or 2, stewards, those 1 or 2 ambassadors.
28:12
There was a question asking how do you show a wow moment to management?
28:18
I say, find those 1 or 2 people in your organization who are data junkies who are like the rest of us who enjoy doing this and let him go to town.
28:29
They will build you some visualizations, and they will build things that are impressive as heck. I’m going to look at what I did again, in 15 to 20 minutes.
28:40
I’ve been able to show you guys something that hopefully, has at least caught your attention, maybe it’s not completely wow.
28:47
But I’ve at least got her paying attention.
28:52
And that’s a start.
28:56
What I showed you earlier, just a minute ago, was the predictive strength card.
29:03
This shows us a measure of how relevant our data points are to each other.
29:09
We can set that straight.
29:15
This will show us our key drivers. So we can see things like, oh, shift ID really isn’t that important.
29:22
It just so happens that, because it’s a key in our data, it’s coming up, and it’s showing, it’s showing, or, you know, not, it’s not as important as I thought it was. It’s only a 10% driver forget about it.
29:37
I’m looking at the things that are 70, 80, 90% drivers.
29:43
Now, these are IBM’s words on this. Cognos analytics uses sophisticated algorithms to deliver, highly interpret, all insights that are based on complex modeling.
29:55
And that means it’s doing a lot of background stuff.
29:58
Going out there, doing K means, doing clustering, doing these things on, in the back end, to get us to what we need. You don’t have to know which statistical test to run.
30:12
Right, I’m not asking you to suddenly become an R expert and understand everything about statistical analysis.
30:21
It’s a big black box.
30:24
And that’s OK.
30:26
Because, think about the user that’s going to be using it. This is going to be Peggy in Finance trying to figure out why last month’s invoices were higher and why the fuel cost, what was impacting fuel costs.
30:40
We don’t expect them to be a statistical expert.
30:44
We expect them to drag and drop and be able to interpret data.
30:49
So, here, this shows us our overall sat.
30:54
This was one from an airport, showing us our overall satisfaction that may is made up of signage, security, additional signage, and art on the walls.
31:09
These are the things that believe it or not, people are paying attention to, and people are looking at end rating and saying, hey.
31:19
How would you rate our airport?
31:24
As silly as it is, art security signage.
31:30
They’re important.
31:31
You’ve ever been to an international airport, you know? That signage is huge, because, gosh, I need to know where the heck I’m going’.
31:39
We see the impact, and we see how things are rated.
31:45
Let’s take a look at that in ours right now.
31:50
So we had a card.
31:53
We had a card that showed the predictive strength.
31:58
OK, so I’m going back to my explorations icon and I’m going to go to the total abandon calls card.
32:07
Again, down the left are things that are not really impacting.
32:14
They’re impacting but they’re so low.
32:18
These are things that have little impact over on the right, our big, giant orange circle.
32:27
Combination of abandonment percentage and cue time, the abandonment percentage and the supervisor.
32:34
Now that’s an interesting one there, right?
32:37
The supervisor are there supervisors who are encouraging abandonment or are there ones that are enforcing stricter queue times and therefore, making our call satisfaction go down because of that?
32:56
And supervisor start date: Are they a newer supervisor who is still very stringent and following the rules? Or are they somebody who’s been here for 20 years and a little more flexible about me?
33:11
Yeah, if you got a five minute call, you got a five minute call versus the new kid on the block whose all calls must be none or less.
33:20
All right, things, we’d want to dig deeper into things, we’d want to go, when I click on that orange circle, my heat map updates.
33:35
All right.
33:37
We’ll pretend its updating quicker than S, There we go, and we see, are barely our biggest square here, at this abandonment percentage, to this queue time.
33:52
And we’ve got some circles down here, this lets us go through different views of this data, we had a heat map.
34:04
Here, we see a bubble.
34:09
We’re going through different views of that data.
34:13
I’m going to go all the way to the very last one.
34:19
And, on this, this is my abandonment percentage, by total abandoned call’s, colored by age and size by abandoned calls.
34:28
This is my color age.
34:32
Who’s willing to sit on the phone, and who isn’t?
34:37
And I can dig deeper into that.
34:41
If I click on one of those, I get into a much deeper look at it. I see my total abandon calls.
34:48
And again, I see additional correlations to this.
34:54
So this is this is starting to get pretty interesting stuff here.
34:57
Does the age impact the total number of calls?
35:04
And we can see, look at this tiny little one up here, this is somebody 57 years of age. They average 6.5 abandoned calls.
35:14
The total is two. It’s unusually high.
35:20
Unusually high, there is something about people who are if anybody in this class is 57 years of age, No, you apparently don’t like to sit on hold.
35:31
You’re more likely to abandon Nicol that’s, that’s what the data’s telling me.
35:39
There’s a high correlation, and we see that over here.
35:43
We see that in our, in our data, age slightly drives it at 12%, 48 is the most frequently occurring category.
35:53
These are the most people to drop.
35:57
You’re at 57 most likely to drop.
36:02
But the overall frequency is at 48.
36:08
All right.
36:09
Somebody, somebody’s got to admit, this is kind of cool so far, right?
36:13
We’re seeing things about data that we haven’t seen before.
36:20
Some really neat stuff going on here.
36:28
Once again, before I go into the next section, I wanted to see if there’s any questions that are appropriate to answer right now.
36:38
I’m going to pick where there’s, there’s a number of questions.
36:42
There’s a number of questions around the dataset, and I want to kind of address them, just kind of in general.
36:50
There’s been some questions about size of data.
36:54
This is a bigger issue.
36:56
This is a bigger issue than just this particular webinar.
37:03
I could do this with a million row dataset.
37:07
I truly could, assuming that my data has been put into a proper dimensional star schema that I’ve got proper indexes on that data, that I’ve got proper face tables, OK, Trying to do this against the transactional with without referential integrity, trying to do it against something that’s got full outer joins. No.
37:35
And that’s regardless of whether I’m using exploration or I’m building reports, right, gang?
37:41
Aye.
37:42
I would have no trouble bringing up a dataset that was well designed, that was coming from a database that had a true star schema.
37:56
OK, I want to stress that the performance of Cognos or any business intelligence tool in general is always going to be driven by the structure and the layout of your data source.
38:11
Simple.
38:14
There was another question about whether this could be done from an Excel file directly or from a data module. I could use it directly as a data source. It’s being done as a data module, however, to handle some of the joins and be able to add in some of the calculated fields and things along those lines.
38:35
So, while an Excel file can be used for all sorts of things in Cognos 11, using it as a data module gives us the ability to join multiple Excel files, to join it to an existing package, et cetera.
38:48
It sounds like I need to do a webinar next on data modules.
38:52
Yeah.
38:54
Or, one on the difference between a star schema and a transactional source in Cognos?
39:00
OK, but, hey, we still got 20 minutes. Let’s finish this one out, right?
39:05
We can also do comparisons.
39:10
This allows us to put two visualizations side-by-side.
39:15
So here in this sample, I am comparing product categories, sales by product categories.
39:22
So I’m looking at product categories of coffee versus bakery, versus other things in my business, coffee, beans, et cetera.
39:35
Well, in our data, one thing we might want to compare is that monthly fee by state is Californian an anomaly? Is Wyoming an anomaly?
39:48
How does it compare two other states?
39:53
So, we can see, is there a difference in that monthly average. So, let’s take a look at that.
40:00
I’m going to go up here to the top, and I’m going to pick a new card. But this time, I’m going to pick a comparison.
40:05
So, essentially, I’m going to get a two column, Dashboard Starting point, OK.
40:14
I’m going to go to Column stat, starting point.
40:18
If I was doing dashboards, I’ve got two side-by-side if I was doing reports and pick templates side-by-side.
40:26
So I’m going to compare the average monthly fee.
40:29
In both of these, I’m going to pick a column.
40:36
Because I want to compare this side-by-side.
40:37
I want to compare this equally, I’m back at my source here.
40:44
I’m going to go to customer, and I’m going to put state to the bars of the drop zone.
40:55
All right, and I’m going to do that for both.
41:00
And I’m going to put State under Local Filters.
41:08
So for my right hand side, I’m going to pick Florida.
41:15
On my left hand side, my drag stayed over to the local filters again.
41:21
I’m going to do California.
41:23
So now this one is including California.
41:27
This one is including Florida from wireless planned.
41:34
I’m going to take that monthly fee, put it into length.
41:44
Mm hmm.
41:45
Do that for both.
41:50
Look at the skill set needed here.
41:53
Look at the skill set.
41:56
Anybody in your organization should be able to do what I’m doing right now, it’s really just a matter of dragging and dropping.
42:04
You have to have a good source.
42:06
You have to have a well put together package, a well put together data module, whatever it is.
42:13
To be able to do things, so now what I’m doing is I’m putting plan description onto the color, so this allows me to compare, side by side, two different states by planned.
42:29
Is there an impact, is there a difference in the average monthly fee?
42:34
And we see, you know what, we’re pretty consistent.
42:40
State by state.
42:43
We’re pretty consistent.
42:44
So if somebody is in market A or in market be, they’re paying the same amount of money.
42:51
None of this, we’re charging more because they’re here charging more because they’re there, but let’s look at one of our, of our ones that we, that we had an issue with.
43:04
OK.
43:05
Let’s take a look at one of the ones we had an issue with, so I’m going to, where am I on here?
43:12
I’m going to drop this off for a second.
43:15
Come on.
43:21
All right, so now I’m looking across the board without a state.
43:26
Still pretty much going on here.
43:32
Filter, I could drag it to filter both.
43:36
So if I wanted to filter by a particular plan, if I wanted to filter both of them equally, I could use that as well.
43:44
I can also sync these I can sync the selections, I can sync the access, et cetera.
43:53
If there are situations where things aren’t 100% the same not a problem, I can change that.
44:02
And down the bottom, I’ve got a nice text table to quickly look at things like, what’s the men? What’s the Mac’s? What’s the average?
44:11
And what we do see actually there is a slight difference in average just a very slight difference.
44:20
Not a lot, just a little bit and that might help us uncover more data points.
44:27
All right, I got two more to go and we got 15 more minutes give or take.
44:33
One of the big ones that I want to show you next is the assistant.
44:38
Maybe I don’t know what’s in my data.
44:43
Maybe I don’t know where to start.
44:49
The embedded Assistant helps me with this, it allows me to get quick insights.
44:55
It allows me to figure out what is impacting my data, and I don’t know, maybe I think, I know.
45:04
So, I’m going to ask you a question.
45:05
Show me my product profit. Show me my average call time.
45:10
Show me my average income, where income is less than five K.
45:15
Yeah.
45:17
Tell me my average hospitals stay time, where length of stay is less than three days, OK?
45:28
So I can use this for filtering, I can literally type in filtering.
45:33
I’ve got two options.
45:36
I’ve got a full panel, which gives me just a bunch more text, it helps me, and it helps to try to navigate what we’re doing or the compact paddle. Hey, I know what I’m doing.
45:51
Let me just ask a question.
45:55
So, it depends on what I’m trying to do, what I’m trying to see.
46:02
Let’s take a look at the assistant.
46:06
Uh, so on the left here.
46:08
I’m going to go to the assistant, and this is going to open the assistant panel.
46:14
At the very bottom, the very bottom, moving mic and my GoToMeeting control panel for a second.
46:21
We see, ask a question, OK, what impacts?
46:32
Q time.
46:32
And notice that it is trying to help me out here, what impacts cuter?
46:41
What it’s going to bring me back.
46:43
These are the fields that have a great influence on call time in the source, call center.
46:51
Nice.
46:54
Also, hey, I found some other sources.
47:00
They have Q time reference.
47:03
If you want to look at another source, you could.
47:10
I’ll try a different question.
47:13
Let’s try a different question.
47:15
So, agent, what’s going on with my age?
47:22
Here, I have fields that are related to an agent.
47:29
All right.
47:32
Sorry, I had dry scroll back up here.
47:34
Are fields related to an agent?
47:37
Total customer satisfaction, the call date, education.
47:43
How does education and an agent play it?
47:48
Well, let’s take a look at that.
47:51
Interesting.
47:54
I can create a dashboard from this.
48:05
Look at that.
48:07
So, it created a dashboard, an entire dashboard.
48:14
From the information about agents, with education being the primary focus.
48:20
So, here, I see my agents by name.
48:24
And I see their education level.
48:29
And over here, I see their start date.
48:33
I see the average queue time.
48:36
So if I were to pick one.
48:41
It changes these as well.
48:43
And I could save this dashboard and I could give it off to somebody else.
48:48
So, hey, let’s take a look at four different agents.
48:53
Here’s their total calls.
48:56
Is that when they started?
48:58
Here’s their satisfaction level.
49:03
Now that, it’s pretty cool.
49:07
All I had to do was ask a simple question.
49:10
Click one button.
49:14
And I got a full dashboard that I could save off and share with somebody else on the Education tab.
49:22
Notice, it created two tabs: one for Agent, one for Education.
49:27
Here’s my customer satisfaction based on my agent’s education level.
49:36
Now they’ve added entitle.
49:39
I might pull that out.
49:44
Here’s the Q time based on education level. Here’s the talk time.
49:51
Trevor, I loved your question earlier about how to show a wow moment to management.
49:57
I’d like to think that this is a long way, too generating that. Wow, Moment, and I hope all of you agree.
50:07
So, the last thing I want to show you.
50:11
Is that we can do this from a dashboard. We can do this from a story.
50:17
We can pin these to use in Dashboards or Stories.
50:21
So, if I wanted to, I can click on my pins.
50:27
Currently, I’ve got a couple of things pinned already.
50:31
For example, my talk, Time and total’s, I’ve already got this pin.
50:37
And I can go, and I can start a new dashboard.
50:42
I’m just going to keep the default one here for the purpose of this.
50:49
Go right to my PID exploration, drag it over.
50:55
I don’t have to re-invent the wheel.
50:58
I can use this and I could use this in a story as well.
51:02
I could use any of the ones that I have pinned earlier for my explorations.
51:08
I can bring these over, and I can build my own custom dashboard to give to my users, and this would allow me to add in Filters. This would allow me to add in other sources.
51:19
This would allow me to do other things, as well.
51:26
OK, both there was one question earlier that I want to address, before I wrap my portion of it up here. There was a question that says, hey, could you show us the source?
51:44
Close these, man.
51:49
Doo.
51:55
Go here to Team content.
51:58
Here’s the source file.
52:00
There was also a question, can a zip file be uploaded?
52:03
Yes, here is call center.zip.
52:07
OK, so, I could use call center.zip.
52:13
And do it right from there.
52:15
So, this is that source, it isn’t a zip file.
52:19
I don’t know specifically where this came from any further than that.
52:24
This is part of the samples.
52:27
It was taken in as a data module.
52:31
So, here it is as a data module.
52:34
If I were to open it up.
52:40
I can see everything that’s going on here, including the Hidden Fields, Abor ID, things along those lines, OK?
52:52
All right, at 253, for me.
52:56
That is what I have for you.
53:00
Patrick doesn’t leave us a ton of time, but we do have a lot of great questions, um, many of which have an answer but many of which are still out there. So I’ll try to get through these quickly, stick around.
53:11
I think what you can glean from this is that there’s that explanations are very powerful.
53:19
It’s very powerful functionality that leverage the embedded Watson technologies to allow you to look at your data without a whole lot of preparation, run statistical analyzes against it, gain insights, produce visualizations, and then ideally get some Aha moments that you can, that you can leverage.
53:38
And those can be leveraged by any of your anybody in your organization without a whole lot of data prep, configuration in Cognos or, even necessarily, you know, they don’t have to be white coat type of data scientists. So, if you’re interested in learning more about this, Patrick has a slide up right now, We are offering a Cognitive Analytics Explorations class taught by Mister Powers.
54:01
It’s on March 10th and you can get to it via that link.
54:05
In terms of upcoming events, if you want to go to the next slide, we have a Getting Started with just enough data Governance.
54:12
That’s going to be, at our usual time, it’s our Thursday 11, 11 0 AM, Pacific, time, two PM, Eastern on January 28th.
54:20
You can head over to, again, the Senturus website, two events, and find that and sign up for it.
54:27
Real quickly about Senturus, we are the authority and business intelligence concentrating our expertise solely on business intelligence for the depth of knowledge across the entire BI stack.
54:38
On the next slide, we are known for providing clarity from the chaos of complex business requirements, disparate and ever increasing data sources, and constantly moving targets and regulatory environments.
54:50
We’ve made a name for ourselves based on our strengths at Bridging the Gap between IT and business users, and deliver solutions that give you access to reliable analysis, ready data across your organizations, enabling you to quickly, and easily get answers to the point of impact in the form of the decisions made, and the actions taken.
55:07
As you can see here, we have a full spectrum of BI services. Our consultants are leading experts in the field of analytics with years of pragmatic, real-world expertise, and experience advancing the state-of-the-art.
55:17
We’re so confident in our team and the Senturus a methodology that we back our projects with a 100% money back guarantee that is unique in the industry.
55:26
And we’ve been doing this for a while, we’ve been jet upwards of two decades at this point.
55:31
Focus exclusively on business intelligence.
55:34
You’ll probably recognize a lot of those clients up there delivering projects across the Fortune 500 down to the mid-market across virtually every line of business functional area, including finance, sales and marketing, manufacturing, operations, HR and IT.
55:49
Over 3000 successful projects, our team is both large enough to meet all of your business analytics needs. It’s small enough to provide individual attention.
55:58
We do invite you to expand your knowledge, and head over to www.senturus.com/resources.
56:07
Well, there’s hundreds of free resources, including this webinar and others on all things, business analytics and business intelligence.
56:15
Of course, we’d be remiss if we didn’t bring up our comprehensive BI training in the three major analytics vendors Cognos as well as Power BI and Tableau.
56:25
We are ideal for corporations and organizations that are running multiple of those platforms or moving from one to the other featuring tailor group sessions, 1 to 1 or 1 to few mentoring, instructor led online courses, and self-paced e-learning.
56:42
We can configure that in any way to meet your organizations training needs.
56:47
And then, the last slide here, additional resources, we have hundreds of free resources on our website and have been committed to sharing our BI expertise as we have today, or over a decade.
56:58
So, we’ve got about three minutes here, I don’t know, Patrick, if you had a chance to kind of look through some of the remaining questions or new ones that might have popped up there.
57:07
I have first off, I’d like to thank Trevor who gave us the great compliment that we are providing the best experts to the best webinars, so, thank you very much for that.
57:18
In general, I see that a lot of the questions are around the dataset.
57:23
No.
57:24
I, without picking a particular specific question. You do need to have a good, solid dataset, and there was a question asking if you can always create a dataset out of a complex package that is an excellent way to do this, take your larger datasets, and slice them up. Like this was a data mart, and slice them up into smaller data modules, so that your business users can do it.
57:50
So yeah, you don’t need to use that 10000 table data source for these things.
57:56
You can make smaller data modules. There was also a question about if framework bands are still going to be around.
58:02
I don’t want to answer that because I’m not IBM. And I don’t think it’s appropriate for us to answer it.
58:09
From what we know.
58:11
Yes, it’s still going to be around.
58:14
But at the same time, I would encourage you to start looking at and leveraging data modules. Not just as a replacement for Framework Manager. But as a tool for your power users.
58:26
For the tool, for those folks who do want to be able to do more, And especially your Excel users, OK? Because they’re already typically really sharp, really smart, so why not? Allow them to do some lightweight data module? Why not bring them into the fold and get them as you’re as your cheerleaders?
58:46
It doesn’t hurt!
58:48
So as far as the future of Framework Manager, I’m not going to comment but I will say yes, you should be looking at data modules and there was another question about data module’s capabilities that is constantly improving.
59:05
If you compare early versions of data modules to the 11.1 data modules, it’s night and day.
59:12
I personally have taken our Framework Manager class and tried to replicate it in data modules and I’m getting about 80 to 85% right now.
59:23
That’s a long way from where it was three years ago when I could barely get 40 or 50%.
59:30
OK, Otherwise, I think that’s about all I can answer right now. There is a question on licensing which Mike, you might be better able to handle. Is a standard user analytics license allowed for explorations? Yeah. I saw that and I think IBM really streamline that.
59:50
And if you’re an Analytics user, you should have those capabilities, right?
59:54
You should have the full capabilities of the platform so don’t quote me on that. You’d want to, you know, ask your IBM rap or whoever handles that in your organization. But I’m pretty sure that’s the way it’s set up.
1:00:06
And 1 last 1. I want to hit Alan. You asked if we can show the data lineage do you know what?
1:00:12
Off the top of my head, I’m actually not sure if I can show the data lineage or not.
1:00:18
But you know what? I’ve got Nan here. I actually have an exploration.
1:00:23
Let’s just open it real quick. If anybody needs to leave, fine people, feel free to leave.
1:00:29
Let me see if I go to my source.
1:00:36
I can go to properties, but I don’t. I know what you mean by the data lineage. I’m not seeing that option to show the full data lineage, and it looks like I would still have to do that in reporting or in a data module itself.
1:00:51
I don’t have that, that standard lineage feature that you’re looking for here on this source.
1:00:59
Do you happen to know Patrick? I said there were a few questions about using T M one or planning analytics. Do you know if that’s supported for exploration? I don’t know. Honestly, I don’t have that with.
1:01:11
But I do know dimensional packages, relational package’s not a problem.
1:01:18
And also there was a question that it works only with data modules. No.
1:01:22
It works with any anything so I could add another source.
1:01:27
So I could add a standard no! Go sales query.
1:01:33
Just real quick, here.
1:01:35
No, I can add a standard go sales query data source in here and do analysis on this just as well.
1:01:42
So, a standard package standard thing going on.
1:01:45
I still don’t have that lineage, though, even with a package that you are looking for, unfortunately, but if you want in planning, I don’t know.
1:01:56
It looks like explorations requires a Cognos Analytics Explorer license so it’s not available for your viewer or cognitive analytics users. So, it may require something, in addition to sort of your, your, your standard user.
1:02:10
Thanks, Carson, for chiming in on that.
1:02:13
So with that, and again, it is the top of the hour, if we can jump to the last slide. Actually, I want to thank my esteemed colleague Patrick for an excellent presentation there.
1:02:23
And thank all of you for taking time out of your busy days, too.
1:02:27
Join us on this Knowledge Series event.
1:02:30
Hope you’re all staying well and safe and healthy and we look forward to seeing you on the next installment of the knowledge is.
1:02:37
If we can help you with anything BI related, feel free to reach out to us via our website. If you actually still use a phone.
1:02:44
There’s AAA number there, or you can always e-mail us at [email protected].
1:02:48
Thank you very much. And we’ll see you next time.
1:02:51
And the OK, grandpa will all dial the phone today, OK? Thanks, Mike.
1:02:59
Thanks, Patrick.
