Creating Power BI or Tableau reports from data in multiple source systems can require a Cirque du Soleil of convoluted data manipulation. The ETL work to go from raw data to dimensionally modelled data that provides accessible, insightful analysis can take months. Modeling data directly in Tableau or Power BI also delays analysis and silos the cleansed data within one BI platform. And don’t even get us started on using Excel for combining data!
In this on-demand webinar, learn how you can get deep, timely business analytics from multiple data sources in minutes. Find out how you can eliminate ETL and rigid star schemas and align business metrics across all your visualization tools.
We introduce Incorta and demo its agile, near-real time operational analytics platform. Using popular CRM, ERP and project management systems as examples. we show how Incorta quickly and easily connects mutli-source data for analysis and sharing in a drillable Power BI or Tableau report.
Senior Sales Engineer
Michael has been designing, delivering and selling analytics solutions for over 28 years. Before joining Incorta, he was at Senturus and instrumental in the development of the Senturus Analytics Connector, which lets Tableau and Power BI use Cognos as a data source. During his career, he has gained a wealth of hands-on, practical BI and big data experience in solutions architect and sales roles at Oracle, IBM and SAP.Read more
Welcome to today’s Senturus webinar on KPIs from multiple sources in minutes.
Thanks for joining us today. A quick housekeeping before we get started. In your GoToWebinar control panel, which is off to the right on your screen right now, you’ll see that there’s a question panel available there.
You can type questions into that panel during the webinar. We will do a Q&A session at the end of today’s presentation. You can type questions anytime you like into that question.
One of the first questions we usually get is whether you can obtain a copy of today’s presentation. Of course, you can go to Senturus.com/resources, and you’ll be able to download the deck of today’s presentation.
And beyond that, the agenda for today, we’ll do some quick introductions, talk about challenges to accessing timely insights, do an overview of Incorta’s unified platform for data analytics. We’ll do a quick demo.
And then we’ll do a bit of an overview of Senturus and some additional resources, and as I said, we’ll wrap up with Q&A session.
For today’s presentation, we are lucky to have Mr Michael Weinhauer here. As many of you know, Mike is a Senturus alum, now he’s a senior Sales engineer, at a Incorta. Mike has immense depth and breadth of experience across the analytics space. Like many of us here, he’s been doing this for more than a decade or two.
So it’s great to have Mike here today.
I’m Steve Reed Pittman, director of Enterprise Architecture and Engineering here at Senturus. And with that, I’m going to turn it over to Mike.
Excellent. Well, thanks, Dave. Thanks for having me back here. It’s good to be back.
We like to get a sense for the pulse of our audience, if you will, or the topology of R of the clients and attendees. So, we got two poles here today. What are your core systems of record, your ERP, or CRM, or whatever?
He’s an Oracle, any flavor of that, EBS fusion, etc, etc. Even I wouldn’t bucket JD Edwards. Are people soft in there?
Net Suite, SAP, Salesforce or some other system.
Obviously, it’s a single choice.
Give you guys a few more seconds to get this answer, to get about two thirds of you with your votes in.
Because it’s just coming off the election a few weeks ago, you should be good at voting.
All right, 72%, I’m going to close it out, share back.
So you should be seeing the poll results, they’re so good. A little more than half are on Oracle or some permutation of Oracle NetSuite customers, interesting, 15% SAP Hana Core other.
By the way, if you want to comment on what the other might be, our polling is sort of limited in terms of the number of options we can provide.
You can go ahead and put that in there, questions, window, or chat.
We have one other poll here. So I’m going to click over the next slide.
What are the biggest challenges in your existing analytics environment? And this is a multiple choice.
So is it, is it time to insights? Meaning you have is it backlogs in IT and long ETL pipelines, you know? These are kind of leading questions. I have never met a customer. I was like, no, that’s not a problem.
So I expect a lot of people to everyone, pretty much, to check that one.
Is it debit building, they’re responding to changes.
So the median column, what’s the next business question on the business changes, or you have mergers, acquisitions, maybe.
Those are always things that create a whole bunch of chaos and how quickly and how comprehensively are you able to respond to those changes as an organization and really leverage data?
Is it the inability to draw from high level KPIs to granular details?
In other words, a lot of cases end up with summary level detail, but can you get down? What does it take for you to get down and do?
Well, yeah, why is that red light blinking red?
And, or is it like a self-service, you know, self-service is the holy grail analytics.
And organizations have achieved a greater or lesser extent of success there, You know, owing to the fact that it’s combination of technology, and people and processes, and it’s not easy to, It’s not easy to change all those and move all those levers, or, again, is it something else?
I’ll close this, and share it back, again, about three quarters of all sharing your insights. Thank you for doing that. And I’m only 43% said, It’s time to insight, so It’s made a liar out of me.
About a third have difficulty responding to changes, again, same percentage, closing in on half inability to get from high level to granular details.
The base chunk, their lack of self-service, and then 43% other.
Another one that I’m curious about what the other is, It’d be a lot of different things.
But anyway, that’s always fascinating to see what people are encountering, and again, sort of what the lay of the land is, if you will.
So, with that, I want to dive into our topic today, which is getting key insights and KPIs from multiple sources in minutes.
You know, minutes might be a bit of a stretch, but you can get to it pretty quickly or with in quarter. One quarter specialize in is real-time analytics on raw business data.
So, I’ll start off my caveat in real time because I know somebody’s always going to say, oh, real-time, you know, like streaming data, or you know, vibration and temperature sensors off of equipment and stuff like that.
We’re not talking about that real time, We mean more in the operational sense. However, we do have customers that are refreshing that data as frequently as every 5 to 10 minutes. So, that’s what we mean by real-time there.
And the key is raw business data here. And I’ll get into that in just a second here as we get you access to all the data.
So, the challenges that we see people come to us for, are, you know, again, kind of tying back to those polls are that, you know, why, you need to make data driven decisions.
Now, while the question you’re asking And the decision to make is still relevant.
The landscape keeps changing in business and, having those, those long, complex data pipelines makes it really hard to answer those questions quickly.
And not having all that dark data, right? You end up sacrificing a lot at the altar of performance.
And you’re looking at summary level detail, and it’s difficult to drill down very far, you know, much further than a level, or two, and you really need to go 670.
And, you know, the all burden of analytics on IT, people aren’t spending, no, they’re not looking to expand their IT organizations, especially now.
The economy being on all shakier flooding, they’re trying to do more with less.
And, you want to create, you know, self-service.
So, not only to empower business users, and allow them to answer their own questions or answer the next question, but to reduce that backlog, and, again, do more with less with lean IT staff.
So, if that sounds familiar to you, you know the quote, unquote, modern data architecture, that so many of us, have built our careers on in our, are used to, is really kind of an anathema to those three things that I just mentioned on the prior slide.
Right. And so this probably looks very familiar to pretty much everybody on the line here.
You’ve got your Systems of record.
You use some type of a of an ETL tool along the way here to land that data, perhaps into a data lake, maybe not, but or an operational data store, or something like that. And then more ETL happens where it lands and perhaps a data warehouse, or some facsimile of that.
Where in about 75% of that data is being sacrificed, rights being left behind is being aggregated and whatnot.
Then it’s further aggregated. and again, sort of obfuscated, I’ll say, as it’s landed in things like data marts.
And then I would argue even further as we started pushing it out to the end users. So every one of these arrows is code.
It’s time, it’s money, and it’s, in agility.
And then I’ll go further.
What we’re going to touch upon today is not only sort of how Encarta addresses this, but how we give you flexibility in this without leading to even more metadata that you’re getting up creating and in Tableau or Power Query, or Power BI or Click metadata. And you can do it all kind of in one place. And you’re all saying it off the same sheet of music.
So this is not really kind of like this is sub optimal, for the aforementioned challenges of being agile and answer questions while they’re relevant, things like that. So, again, the, you know, the typical flow is you have a question, call IT. Get on there, rather length, lengthy list. I can pull the data in.
Then, every new question, you’ve got to kind of go back to this whole process.
So, Incorta came about because there are a bunch of guys actually from Oracle that were in their applications area that we’re like, Well, what if I had a question? And, I can already see it and load it myself and have insights within minutes.
And so they created Incorta which the real difference is here is that what we do is we pull data directly in from those sources without any ETL we make, we call it digital twin, of that data. So it’s really easy light touch on that sort set source system. We pull it in, we put it very rapidly, so we can pull in billions of records across multiple systems, parallel loading, things like that.
And then you get direct line of sight back into all of that data.
You’re not having to trim it down because you can’t pull in that much data, or it’s going to be too big desk, we just pull it right in, Then we expose it via, either directly or through business friendly Business views, which are exactly what you might think they are. Right, kind of standard dimensions and measures that, that you’re, that, facilitate self-service and whatever tool it is, whether it’s Incorta or you are using our own internal analyzer tool or via external tools like Tableau and Power BI which are pretty much ubiquitous.
I would guarantee in almost any organization above a certain size, you end up having, you definitely have Excel, like way too much of it.
You probably have Tableau, and you probably also have Power BI.
Additionally, you oftentimes, people use Incorta as a data hub because we free the data from, say, Oracle Cloud, right, or the, the complexities and myriad, sort of, Byzantine structures and op and all that good stuff from sap.
And, pull that in and enable us to push that up to something like Azure Synapse analytics or push it out to a black line or an anti plan. Or something to use for planning purposes.
With, drill back to, the Rock record level sub ledger detailed data, to really facilitate speeding those types of processes, right, closing the books, budgeting, planning and forecasting, and whatnot.
So it’s really a fundamentally different approach to collapsing and eliminating those pipelines and really creating agility in a world where, you know, you want to do more with less and need to answer questions quickly.
So, the benefits are, we give you unrivaled data access, you run those analytics directly on the application data, That’s 100% identical to the source.
You have complete control over the governance and access and the lineage That’s verifiable all the way down to the individual record level details.
Right. So your lineage instead of being, you know, when you’re looking at lineage and a lot of other tools, you have to go, oh yeah, this is Tableau, that came from this extract.
Which came from, you know, Bob’s, SQL server owners, desk, or the system. And it’s combined with this. And by the time you trace it, right, it’s like, kind of going back to the ancient Egyptians.
Here, it’s one line. Hey, it’s like, Oh, this field comes from this field, in my ERP system, or this field in Salesforce, and you can see that easy line of sight.
And we provide this really fast time to insights where you can deliver latest data in minutes, quickly join other sources, and provide sub second queries. And that’s really weird, Incorta court is different.
So I’ll ask you to suspend your disbelief in a moment for a moment and understand how this really shakes up that landscape and that traditional way of thinking. So how do we accomplish that Incorta?
Well, we have a technology called Direct Data Mapping.
And really, the platform has several technologies that really facilitate all of this. First of all, that parallel data loading that I talked about, both full and incremental, by the way. So we pull and make that digital twin.
Then we do an incremental load every 5, 10, 15 minutes, whatever your business requires. And we’re able to do that really quickly. Don’t have to do a bunch of ETL or any ETL on it and a lot of cases. So that we’re able to do that very quickly without bogging those systems down and give you those insights.
And the direct data mapping is really this enriched metadata map and smart query routing.
So the most expensive part, and I’ll show you this in the demonstration, the most expensive and complicated and difficult part for any database is the joint.
That’s the plan.
Because of the optimizer and even the most modern, no databases with them, with the latest technology and the most horsepower, they tell you, today, I don’t go beyond really 3 or 4 joins if you’re doing, you know, with a volume of data.
And so what Incorta doesn’t, direct data mapping is every point of data that we ingest is aware of how it relates to every other point of data.
And we pre plan the join paths between those data points. So we don’t have to plan the query at runtime.
And that’s really what’s fundamentally different.
So we are able, to query billions of rows, and do hundreds of joins across thousands of tables across multiple sources.
So think about that for a second. That’s really the difference, and it really works. Well, it’s pretty amazing. And we load this.
We loaded into memory, and you’re able to hit it with a Incorta or with any of these other tools, which I’m going to show you, in just a little bit here. So, I’m going to show you how we’re able to do that, and kind of get walk you through how the platform does that.
Then, this is just showing you the business schema. This is a snapshot of what a quarter looks like. I’m going to walk you through this in a little bit, but we gave you this ability to create those simplified views, because obviously you, SEP folks out there or even Oracle.
You know, it’s, you wouldn’t want to present to anybody with an ERP type schema, or those, a lot of a lot of cases, those names.
And you have other logic that you want to have in here, like, calculations, are aging, buckets, currency, conversions, things of that nature.
So, you can put those into what we call a Business View that is much more friendly for your business analysts, and allows you to maintain data governance controls, and, and, you know, sort of control who has access to that data while enabling self-service, all within the same platform. And then, importantly, we provide a set of data apps.
And there’s a reason we started asked about Oracle sap, Salesforce NetSuite Workday because we have pre-built content across a wide array of No business processes in order to cash, procure to pay, AP slash L All that stuff built for a lot of the core systems like Oracle, EBS, Fusion, JD, sap, Salesforce, NetSuite, etc., etc.
And this is along it ever growing list of applications. So, the just of that is that we can, we have the connections, we have the knowledge of the schemas, and what data to pull and how to pull that from those systems.
Then those friendly business views on top of that and content dashboards and whatnot, that are pre-built, they get you know, a good chunk of the way there to spinning this up and seeing value out of the system really, really quickly.
Like me, when I first heard about it before, And I was like, yeah, right?
So, what I’m going to do now is I’m going to, show you the application and show you how we actually accomplish some of this stuff. So, the scenario I want to share with you today is what we call an is called a Customer 360 Analysis.
And I love this scenario because almost any organization has customers, clients, wherever you want to call them, and they always want to have, ideally, a better view of them, a more comprehensive view of them.
In some businesses, it’s more critical than others.
But what’s also universalist that that information invariably lives in a whole bunch of different systems.
You’ve got your ERP system that has, they buy, for example, you have your CRM systems. What were they? What would they might, what might they buy? Sorry, I can form sentences here too much, caffeine.
And then ticketing systems, for example, that are, like, well, what are the problems they’re having?
Where, what kind of support are they, are they requiring? Or are they, are they just not using the product? We don’t see opportunities, we don’t see support. Maybe their customer that we’re at risk.
And then, in order to get that view, sort of say, Oh, am I going to lose this customer?
Kind of cross, sell up, sell, no, you, What opportunities do I have, and are they, how do they relate to how, well, how happy the customers?
It takes forever to get that data together around your customer retention churn, because your plan and spreadsheets, you run it through ETL very complicated, very difficult, if you can do it at all.
And that data, a lot of times, is in the, In the data warehouse, especially, not at the level that you need, or the currency you need to really get a full picture of your customer. Right? And that’s especially true for more smaller transaction customers like, imagine Starbucks. You’re going to provide a cup of coffee.
They have like a few minutes to cellular that scope, Which makes a big difference in their profit margins, right?
So, you got the right product there, at the right time, given the right offer, all that sort of stuff, so Customer 360 Analysis is something that, you know, like is pretty relatable to everybody.
So, the demo I want to show you today is really a demo where we actually do combine it in quarter, ERP data, service ticketing data, and CRM data, Oracle ERP, jira, and Salesforce, in this example. But it could be anything.
And what we do is we’re pulling the data.
We integrate it.
We provide that reporting off of that.
Then also provide the ability then to drill back into those systems with context.
And report off of that either within Incorta or with a lot of the tools like Power BI and Tableau. At your organizations.
Know, and love using, again, that same sheet of Music: Right.
That same business view, that’s going to turn, turn up the same numbers across departments and across your organization, because you’re all using the same query engine, The same business logic that you put into that, and it leads to better decisions on more current information.
All right. So, I’m going to jump over here to my demonstration. Just going to log back into my system here.
Really doesn’t take very long.
All right. So, this is the Incorta application. Everything is browser based.
Everything you do from system administration to data acquisition, schema management, those friendly business views, and content creation, is done through the browser, So that means you can embed it in Salesforce or vice versa. You can drill back and forth.
There’s a bunch of stuff you can do here.
For purposes of Customer 360 demonstration, when I’m first going to show you, and I apologize. It’s a bit of a Christmas tree. I didn’t pick colors on this thing.
It’s a 360 customer retention dashboard.
And what it’s doing is it is showing information across three different systems that ERP system, the CRM system, and the ticketing system.
Of course, it’s taking its sweet time here because of, because I’m on a webinar, it’s always slower on these things.
Generally, these dashboards do pop up in seconds.
But what I want to show you here is, what I’ve got here is revenue.
From my ERP system, I have the query sold from my ear pieces as well, forecast revenue from Salesforce, and issues from my ticketing system.
So note taking note of the numbers here, then I’ve got a bunch of other visualizations that show my top accounts by revenue. So that’s ERP based revenue by state, you know, geo based, same information.
This is all Salesforce data showing my win rates and whatnot and these are all my high priority tickets for my top five accounts or for top five in terms of total tickets.
And then Importantly, what I’ve done here is this individual, Customer Transaction Level Information.
The reason I show this is because what we’re talking about here is this would be really tricky for a lot of systems to pull off.
To be able to show this information together and then be able to say, Click on, you know, Staples and have it instantaneously, drill down on all of those systems. And show me that, Hey, I’ve got 55 million in revenue here.
55.04, I have no, roughly one thousand items, or, you know, 800 some odd items that I assault.
I don’t have any forecast revenue. Because the deals are all lost. Youngest 76 issues. Here’s how they sort of break down from my high priority issues.
But then, I have, you know, for 4652 actual transaction lines, and that’s filtered that down automatically, across with data from all of those systems.
Now, you might look at this dashboard initially and say, OK, big deal, right? I can do this in Power BI or, Tableau, or whatever.
But, the reality is that, doing this in Incorta, I’m just going to drill into one of these insights here, and this is R, our Insite Builder, and I will show you what the query looks like.
And this is actually going from our accounts table to the transactions down to this Transaction Lines, all table, which has billions of records, right? It’s very big.
And so what I’m going to do is sort of show you how we’re able to do this without a bunch of ETL and get to this dashboard pretty quickly, both in Incorta and outside of the Incorta using some common tools.
So kind of stepping back from this, the first step is acquisition of the data, and we do that, like a lot of tools through connectors, and we have hundreds of connectors.
We have a native connectors that are in Incorta. built-in support it.
They also have a partnership with, with C data, who has hundreds of connectors, so we can connect to virtually anything.
If you’re getting data out of your system now, whether it’s from flat files, native database connectivity, on prem in the cloud applications, like I said, you know, Oracle, NetSuite has various ways of connecting to it. We support all of those Salesforce, you know, its latest sort of two conductivity, that has a bunch of new functionality.
Data lakes, file systems, things like Google Sheets, and then, you know, rest APIs and whatever. And then, even all the way down to basic kind of ODBC and JDBC.
And what we do is you simply use whatever that that particular means of conductivity is.
And using a JDBC driver, you’re pointing to the host for that, system, giving it a username and password, or passing it, o-auth, credentials, whatever it is.
That provides you with the connectivity to that system.
You could also have local data files.
So in a lot of cases, you might have flat file data that’s coming over and pull it over from FTP, SMTP, uploading the files, whatever it is. We can pull that data in as well.
And then, we have data destinations that are sort of like that black line or the, you know, the planning systems or whatever, when we’re serving as a data hub or Azure Synapse, things like that.
So, once you’ve created those connections, then we go and create a schema.
And this is where we actually go query that system and pull that data all into Incorta.
So, this is an example of a schema that we pull in using our data apps.
And this is just like an standard database schema, right?
But the difference is, is we pulled the data in, and we pull it just like this, right? This is a big hairball, right?
You would never expose something like this, generally, to any sort of front end tool.
Because it just tip over and die, right?
Anybody with any analytics experience will tell you that, even joining a few tables here in this ERP system without doing a bunch of ETL denormalizing this stuff, and reducing those joins.
Well, it would issue a light Jim inquiry that people screaming at you and your tools are tip over.
Much less combining that with Salesforce, with jira Service Desk, or, you know, data science models or anything like that, and attempting to query across those.
So the difference here is that in court, it actually pulls these literally and think about it, like a select star from table A, select star, or, you know, call them A, B, and C from table B, And we’re able to pull in, this is two billion rows.
And you can see if I sort of short this really quickly, my transaction lines, all that 471 million records of data.
So the dashboard that I was showing you before, or I’m pulling in the transaction lines all, that’s actually pulling in that information for those top five and filtering that out of 471 million records in real-time.
And then it’s doing the other queries against Salesforce and Jira, and from a data science thing that I’m a customer churn model, that I’m not showing in this particular demo.
But now, we’re able to pull in that 471 million records very quickly about six gigabytes an hour.
So we’re able to load this thing about 39 minutes, All these tables, all those two billion records.
And it’s only 46 gigabytes on disk.
Because we’re not exploiting that out, and you normalizing it, we’re able to do this with relatively commodity hardware quarter.
We’re cloud first.
We do have an on prem offering, but this is a pretty basic Linux cluster.
I want to say it’s about a 8 to 12 course and like, 32 gigabytes of ram, so nothing crazy.
This isn’t a Teradata, sap hana. Let’s use that kind of giant box. Pretty straightforward commodity, Linux, Box that can pull this off because we’re pulling it straight over.
We’re not doing a bunch of ETL and exploiting it and we’re landing it in highly compressed parquet files as it sits in that system, then we can do, again, incremental loads on that data.
So the Transaction Lines All table, we would want to update that frequently, because think your Starbucks, right? Every 5, 10 minutes, you got a whole bunch more data. You want to pull in? This one changes a lot. The GL Code Accommodations, probably not so much, right? So you would maybe load that daily or not touch it very often.
So you have complete flexibility around this.
But the point is all this data in, Then, what I’ve done is, I’ve done the same thing, Bor, Salesforce.
So I pulled this in. Here’s all the typical Salesforce objects that you’d see. Right, your opportunities, your leads, your accounts.
Again, going into the diagram, we’re pulling that straight in, as it is, including things like the history, so you can do all that sort of zero point in time reporting and whatnot.
And again, we’re sort of joining that up, too, the accounts receivable, which is our ERP system, and we’re joining that out to our jira Service Desk, so we know our customer support issues.
Then the last one is the jira Service desk, and connecting to that system, and pulling in all the information from, that that we want, right?
We have our roles, our issues, and everything around that and what we’re doing is we are, in this case using from a business perspective, we are linking all of these to, our customer accounts table, which is serving as our customer master.
Now, you might use an MDM solution or, in some cases, customers are using Incorta.
I’d actually run fuzzy logic against that to do some of that data cleansing and that data governance, but however you’re doing it, generally, you’re going to have sort of a gold standard right for your customer account. So, in this case, what we’ve done for the customer counts as the ERP system serves as the customer master.
And Salesforce has a custom field that has customer ID, and all we’re doing is we’re joining at account customer ID to my customer accounts master table on customer account ID in the ERP system.
And we’re able to do that, again, because we are pulling the data in at the lowest level of detail.
So it’s a lot simpler to do that.
Then, on the jira Service Desk, I’m doing the same thing, I have an Account key, and I have some Account Key logic that I’m doing in here. I can actually go in here, too.
I’m going to go into that table and show you the joins here.
Alright, so here’s that. Join.
There’s actually some logic in here.
So you’re not sort of limited by be just doing those joins. You can actually do more complex logic on that.
So I’ll go in here and show you this real quick.
So, where I’m customer ID string to customer account ID, I’m doing a string function.
And in this one, I’m actually doing a formula or I’m sub streaming that bucket in those distributed versus retail so that I’m able to then join that out too, that other system, right?
So, that’s just a simple calculation and Incorta that I can create, either at this schema level, and then it gets, sort of built into this table, or, you know, I can do it at any level here.
So, again, so now I’ve got the three systems connected to, I’ve pulled in all the data in those systems, and I’m maybe updating that every few minutes.
And I’ve created relationships across those, so now I’m able to do some, I’m able to do reporting across those in query across all of those, but, you know, giving people, again, that sort of a view of the information would be kind of a nightmare, right? Sending your self-service users screaming.
So what we have again, are these business schemas, which are these friendly business views that allow you to present to your end users a much friendlier view of that data.
Now, what I’ve done here is created a Customer 360 view that combines, that has a bunch of the accounts receivable data.
You give it a friendly name, pulls in some of the, a bunch of the Salesforce opportunity information, again, that jira Service Desk information and a bunch more of the Salesforce opportunity information.
And as well, there is logic in here.
Calculations, same calculation editor, same sort of functionality where I’m creating opportunity status buckets based on the fields in Salesforce, right?
So, now, this is a subset of that data that incorporates all three of those.
And now I’m able to go ahead and say, oh, yeah, you know what, I want to look at, you know, by month, and by country, and I can just go ahead and pull in information here, and say, you know, this is my, you know, my revenue.
Introductory table, and you can see how I’m pulling data from that two billion records system, and I just pulled this in seconds.
And so, it’s very, very quick, very, very easy to do that, because of that direct data mapping, and the way we store it, and the way we load the data into memory.
And from there, what I do is I can create those insights.
And I end up back with my, I combine those into dashboards that have, you know, bar charts and maps and things of that nature.
So that’s kind of how we get from point A to point B So you can see where without having to do all of that ETL.
And pulling in all of the data that not only can I do that very rapidly.
I pulled in two billion records in about 39 minutes.
Obviously, I didn’t do that here.
There’s another webinar that we did with Senturus, some, I want to say about two months ago, where I do an overview and actually do load about 25 million records.
It loads in about a minute, so, you don’t take my word for it.
But, we do, we’ve loaded, we load that data, created those joins, not too complicated, right?
Created a business schema where you pull in the fields you want, maybe throw out a few calculations.
And boom, we’re off to the races creating content that is doing queries across these three systems and giving me insights into that from high level KPIs, all the way down to that record level transactional detail in sub second time, bout.
So, the other half of this, or the other part of this, is the, you know, the desire by organizations who have, other BI tools.
And they want a front end that, instead of using Incorta is, using Power BI and Tableau.
So, here’s a dashboard, Empowered that shows pretty much the exact same information. I’m going to toggle back and forth between these a little bit over.
I’ll give you all a headache, but what I want to quick show you is, I’m going to jump back to this guy. And I’m just, I just want to bring to your attention, started that, that business schema that I showed you. Right? So, I have Customer 360.
There’s that business friendly view that has, you know, 76 columns in it.
And if I wanted to, you know, attached to that again, I’ve got these 76 columns here and have descriptions, and I can go view all the states and, you know, all that kind of good stuff, right?
So, kind of take a mental picture of that.
And now I’m going to toggle over here, and if I show you the fields, here’s my Customer 360, Customer 360 with my 76 fields in it.
So, I’ve expose this business view, the metadata that I have in Power BI is one view, Right? So, so think about that for a second. Instead of having to pull in all these tables and do all the joins, and do it, again, in Power BI, put a bunch of logic in Power BI.
I put all that stuff into a business view.
And what that yields, for me is a dashboard where the numbers are identical two of the numbers in the Incorta dashboard. So, I’ll bring your attention to the revenue.
Across the board here, 222 million, 67,000, forecast an out, 1.05, 541 issues, then 46,960 individual transactions or, you know, this dataset at my top accounts by revenue, Staples, Costco, etc.
Geographical information here, you know, revenue by state.
Washington at $31 million.
You see the lost, the one, the wind percentage, here’s the one that I have open, Here’s my tickets by customer, so I’m actually, you know, pulling information across those three systems.
So again, if I toggle back over to my original dashboard here, Sorry, I don’t know.
A much better way to do that.
You will notice that it’s loading very slowly.
You’ll notice that numbers are identical, two.
Numbers that are in that power.
Right, and so, your 2.2, 60, 7000, and 1.05 at 41, top five customers are the same, same opportunities are the same, and I have, at the bottom, 46,960 records, right?
So, the only difference really between these two is that I have the 46,960 in this dashboard, and I started to go and, you know, click on one, it filters down.
What I do here is I’ve actually done drill through.
So I click on this or I click on Costco, right? And you can see where it does the same thing.
It’s going to go in an update, all the metrics. And those are going to tie out to in My Incorta dashboard.
So, if I drill into Office Depot here, you see 28.84 or 28.8 for Florida, all that good stuff.
Then what I do is, I instead, Here’s I drill through, and that’s because Power BI is not going to, let me bring back more than one million records at a time.
So if I want to look at that detailed data, I’m actually going to go then drill through, and I get a filtered list of all of the transactions, right.
And that number ties out, by the way, to the revenue number, and I can look at all the individual tickets, and I can even then create links back.
Or I can even drill back into Incorta passing through maybe Office Depot, hide, whatever. I didn’t set that up in here.
But the point is, I’m able to, you know, really interact with that data and I’m doing the same thing here in Power BI and it tracks and ties and does the same thing all with a single business view off of those three systems.
And if I want to add another column to that, Great. Go for it. Push it out, and I’m able to use it.
That’s the last thing I’m going to show you, is, I think I covered everything off there, is, you know, you can do same thing in Tableau.
So, again, no, going back to any one of my individual visualizations.
Here’s my business view, right?
It’s my Customer 360, is that really highlighted for me here?
But you can see, these are my 76 fields that are the same ones.
And they’re used to populate these various metrics, and the 222 million, 67,105, 541 issues, 31 million in Washington, you get the idea, right. So I’m not going to run you through all of that here, but I can create those same visualizations.
So the organizations, you know, the departments, lines of business, whatever, partners, vendors, they can use that tool of choice that they want to use.
Because we’re just a Postgres database to, to that system.
So, if I wanted to actually go and create a new one, my credentials saved in here. I’ll see how quickly this goes this.
I’ve got a little off road here because you have a little bit of time, but to know that to do all this and create new content, I just open up a new Power BI instance and on here, sites are co-operating with me.
And I’m going to go get data.
And I have the credentials and everything already stored in here, and that’s how Power BI works.
I’m not going to do that because I don’t have this handy.
All I need to do is, if I want to create content, I’m going to say New, and I have to just flip a switch and Incorta, right? You have to, By default, you can’t, But each to the flip a switch, it says, Allow connection to other visualization tools.
Then, what Incorta does. It says, Oh, hey, you want to use Power BI?
Here’s your connection string information.
And, yeah, there’s not a demo instance, so it doesn’t have the actual connect string up there.
But it would say, you know, like, here’s my demo.encoded.cloud, whatever port 5436, you put that in the post gress data.
Fields, write the UI.
Wanted to direct Query. And it’ll say, hey, here’s all the here’s all the business schemas that are available to you.
It’ll show these to the extent that you have permissions on it. Right.
So if you’ve said, well, you know, only my marketing people can see Customer 360, then, know that, sync it up with your Active Directory or l-dap, or your through SAML, or whatever that is.
Then they’re able to easily see that in and in Power BI or Tableau or whatever, whatever that tool is.
So I’m not actually going to put that in yours, I don’t have the connection string handy.
But you get the idea, you just pull up again, and then you’re off to the races.
So, that was all I had to show you from a demonstration perspective.
So, to summarize, you know, we get that you’ve sort of maybe seen demonstrations of other BI tools.
And, but there are some really key differences that I really tried to highlight and, you know, hammer home, is that, yeah, how do you do these various tasks drill down?
We give you that transaction level detail, right?
You saw me pulling all the data, roll it up, drill all the way down to the record level detail to switch screens out the dump it out to Excel, or a different tool all in one place.
Everyone else pretty much limited to subsets. And, you know, I was just talking about rendering reports sub second from collecting, And they’re a little slower, usually over these web meetings.
It tends to be very, very quick across, and that’s Billions of Records.
Thousands of tables, several systems, right? And here it takes minutes, hours, days, or simply isn’t even possible.
For somebody who’s complex reports hollow stick to add no new business data. I didn’t do that here.
But, you know, to add a new source, you can imagine, I create a connector, Pull the data in two billion records in 40 minutes, smaller systems. You’d be super quick.
Otherwise, you could take weeks to rebuild the connections remodel.
It figure out, OK, how does it ripple downstream to everything else?
Then how do I know my accurate rip my results are accurate, because you don’t have to reshape the data. You’re I know it’s accurate. I can go ahead and see it if a number is off. I guess what’s comprising that number?
And, and fix it. I guess it’s actually brightest source system, right?
Somebody put it in the wrong place, then here, you know, versus, you’ve going to go back and comb through, sort of inscrutable and complex ETL at whatever stage in that process. So that, by definition, usually means error, exclude data, summarized data. You don’t know where that’s.
So, again, the sort of timelines to actually get things done here.
The traditional BI, EDW, I think this is sort of generous too is you do analysts stuff up your 618 months Corridor.
You’re talking days.
First, we’ll spend some more time doing QA and all that sort of stuff, but it’s really quick, because you’re, you’re not spending all your time doing all this other stuff.
So, the proof is in the pudding right.
So we’ve got some great logos here.
Starbuck’s went from 12 months to started analyzing a lot of their merchandising stuff and providing, you know, say offers on stuff that might expire for perishable goods to be able to add in in 60 days.
And they’re, you know, implement this project, Equinix will not possible to 44 days shutter flight three months. At 30 days. Broadcom not possible to 11 days.
They actually acquired Symantec Antivirus company and they integrated their systems with Broad comes through a quarter 11 minutes.
So, they were able to actually get a view across ERP systems across a newly acquired company.
They think about that as something that takes companies years, if they even bother doing it.
So, it’s really cool in terms of how you’re able to do that and get visibility.
So, if this sounded interesting to you, we, here’s a couple of other resources that are here.
And, by the way, you can pull this step down, as Steve mentioned, you can go and try it yourself. There’s a link here.
You can spin up a cloud instance, You pull in your own data of our data apps, and you can go join the Incorta community if you have questions, or want to contribute, or whatever, want to just learn about Incorta.
And in the learning, you can learn about using our free courses there, literally free e-learning courses. And there’s free, instructor led courses for both business users.
The business user one takes a few hours and self paced.
The you can get certified in Incorta ticket. This five day course. It’s a few hours a day.
Also, self paced Or there’s an instructor led one.
And there’s a full Admin course where you install an inquiry. You learn the whole shooting match. That’s instructor led, all free.
And if you want to go learn more, about a Incorta data apps, whatever, maybe sign up for our, we have a Data App Week coming up, which is, again, remember our blueprints for major systems like Oracle, NetSuite, etcetera, etcetera.
Some of the customers that I highlighted there will be actually speaking at that, showing the real business benefits that they get from are companies like Facebook, Comcast, and others.
So, definitely go there and check that out.
So, hopefully, that was handy. And, with that, I’m going to hand it back over to Steve for a little talk about how Senturus can help you and other things.
All right, Thank you, Mike, also, just a quick reminder for everybody that we are going to be doing Q&A here shortly. So, if you do have questions, go ahead and type them into the question panel. While I’m doing my thing here. We’ve got a few questions already that really add any additional questions you may have. And, as Mike said, remember, you can download the deck from our website, And you’ll also find some additional technical details, is a little bonus, and that deck that we weren’t able to cover in today’s webinars.
I think a little deeper into Incorta deck.
Few quick things about Senturus, number-one ways we can help you. Of course, we can help you when it comes to in Incorta, we can help you with the phased implementation strategy. We can help you migrate data sources over.
We can help you with integrating and Incorta into your existing analytics environment, regardless of the tools you use today.
Which, of course, for us, means often connecting to Power BI, Tableau or Cognos and we can help you out with dashboard and report development.
That, as I mentioned earlier, you can find additional resources on our website, not only the deck from today, but an enormous amount of knowledge sharing expertise for a couple of decades now, And you can find a whole bunch of it out there on our website.
So definitely check out the Senturus website or demos tech tips, and a bunch of other valuable information. A couple of upcoming events. one is the Incorta Data App Week, which Mike just mention. That’s coming up December sixth through ninth. You can register at the Incorta website.
And as Mike said, the data week, they’ll be focusing on some customer spotlights of how some of the biggest organizations out there are using Incorta to improve their time to fast analytics. We’ve also got another some terrific webinar coming up in December, using query folding to improve our performance will be Thursday, December 15th hosted by our own Pat Powers. And they’ll probably be here in the background. Also on that one, I hope to see you there.
Senturus, in general, just a quick bit about us. We concentrate on BI modernizations. and migrations across the entire stack. We’ve got a long, strong history of success. Many of you have worked with us for many years.
We’ve been in the industry for over 20 years, over 1300 clients and 3000 plus projects in here for a long time, we’ve got a dedicated team were large enough to meet all your business analytics needs were small enough to provide you personally.
So do reach out to us with any needs you have in your analytics environment.
We’re also hiring. So if you’re interested in joining the Senturus as team, we are looking for talented and experienced professionals. We’re currently looking to hire a consultant and a management consultant. So, if you’re interested in joining the team here at Senturus, reach out to us either by e-mail or on our website, to get more details, or to send us your resume.
With that, we’re going to go ahead and jump into the Q&A session, so I’m going to turn it over to you, Mike. I might type in here and there. It looks like we’ve got a few questions.
Yeah, I’ve actually been reading through those June. Thanks for, Jen. Thanks for being on. It’s good to see your name.
So your question was, why do you have access to raw data, ERP other ways to users, isn’t more trouble, and it’s worth giving access to the least to at least refine or clean data.
So, you know, you’re right in the sense that I think it depends on the users and what their use case is.
So remember what we’re talking about here in a lot of these things is our operational use cases.
So Imagine you’re in the finance department, and you’re trying to close the books and or you’re doing budgeting and forecasting and that.
you’re basing those numbers off of the data in your ERP system And you’re like, well, OK, why is this number not tie it out?
Or you know Why is this? You know? Why is this number like this?
Then you end up going and pulling up all that data and looking at the record level data, it’d be like, oh, OK, well, you know, we need to know what that stuff is. So, yeah.
Use it where you’re going to want to just show the aggregated or refined data and you can certainly do a lot about it in Incorta, right.
And a lot of cases it’s maybe just filtering out nulls or doing some fuzzy logic and creating buckets and things like that.
So it’s entirely up to you, what you expose, how you expose it.
If you do logic on it, you can certainly do refining and things like that within a Incorta.
But there’s a lot of cases you know if you’re doing uh, they’ve got a bill of materials, MRP run or something like that and it’s you know, so you’ve got some anomalies.
You want to go look at what is what fed that algorithm and figure out what was, you know, what was wrong in that assumption, or what went well went haywire. So there is a need to get down into that transactional level data. So we’re not sort of suggesting that you throw out all the raw data to every end user. It’s definitely going to depend on that.
But, know, when you pull it in, there’s operational aspects, where you’re going to want to really look at all that data.
And then, in a lot of cases, even if it’s for just analytics purposes, you end up having to troubleshoot a lot of that data, making sure. Is it refined? Is it cleaned, isn’t accurate?
Does it, does it tie out?
And then chasing that down through a bunch of ETL, this is really tough if you can do it at all, right? You know.
I did operational reporting with Sales Ops and Marketing Ops for about a year and a half width Senturus, a set of client and digging through all the Python code and SSIS has got SSIS code, Bachelor of Hadoop, back to Salesforce was a nearly impossible task.
So, you know, again, that lineage is sort of a sort of a nightmare.
And then, let’s see. So hopefully that answers your question in that.
Hey, Mike, I have a kind of a horizontally related question here. Well. It’s not exactly tangential that sounds or arguably, the GM anyway nerdiness there, folks.
So my question is, in terms of limiting detail access. So I can envision a situation where you might have a set of users who you want to only see aggregate data? But then, there’s some subset of users who you want to be able to drill through to the detail. and how like, in Incorta, would you handle that by doing like, separate business views for those types of users?
Or can you control kind of, like drill down permissions within a simple business view, just like, how just broadly, how would that be?
Yeah, that’s a great point, so you, could architected a bunch of different ways, but we do, know, so we have security at every level. You can do row level security in Incorta, using, you know, like session variables, IE, who’s logged in right now.
And it maps to a security table, and determines what they can see, or what level of detail, they can see, whether they can see the base schemas.
That raw data that I, showed you, whether they can pull that data in, and see that data, Whether they have access to the business views, or what business views they have access to.
So you might have, you know, greater level of summary, and some of those, and then, column level security, so, again, same sort of thing.
If they can see personal PI, type stuff, HIPAA information, things like that.
And we also have, you can use those, those roles and that security to do obfuscation of data.
So if you’re showing, like, Social security numbers, and you star out the first, you know, the First five, right, just show the last four, things like that.
So it’s all role based security, you know, when we integrate, again, with things like Okta and all that stuff, so what’s nice, again, is because of that that digital twin, a lot of the security that you might have mapped against that operational system, a transactional system.
If you’ve done that, you can pull that over and leverage it, write it in court, and without having to create a new set of structures that map to another data source, because the shape is the same.
Does that help?
That does, Thank you. That was awesome. Thanks, Mike. I’ve got a couple more questions of my own here, but I can ask you off, because we’ve got some questions for you over there, horizontal or vertical.
So, another question here is, What types of connections can power BI use to directly, to connect directly to it?
Incorta data, the current setup using Synapse, which is then accessed by Power BI?
Yeah, so, again, and that’s an interesting use case because we do a Incorta caveat data hub where we, again, free up the data from maybe Oracle Cloud, which is, it makes it really hard to get at the data. And you’re stuck with Oracle’s tools, and maybe you’re a Microsoft shop and you end up using Incorta, but then, they’re using things like Synapse.
So, we actually use our business views and what we call materialized views to shape that data into more of a star schema and push that.
And the Synapse which does that hit by Power BI?
So, that’s kind of a more Azure Stack type of approach.
The connections I used are more. It’s a Postgres connection, and we call it SQL on it.
And it’s it really just makes it Incorta business views and schemas.
Again, permission control Look like a Postgres database to those tools.
And so that’s really the type of connection that we support there for that and really any other tool. So, it doesn’t matter what you’re using.
Then, there’s another question, Do business views work similarly to Cognos framework manager models where joins between query subjects?
You use Cognos terminology Query subjects, for those of you who may not be Cognos conversant are, are basically queries, right?
So they usually, it’s a table might be a view or a combination of tables, they call a query subject.
So, where the joins between those query subjects are implicit and, therefore, do not need to be notified by user while building reports, And the answer is 100%. That’s exactly what it’s done for.
So the joins are handled at the schema level.
And the business view allows you to combine information, not only and view that in a very friendly way, where the joins are handled back at the schema level, not only within a system, but across systems.
And that’s the power, and because we’re able to have the direct data mapping, we can do those joins, dozens, hundreds, of joins, across hundreds of thousands of tables across multiple systems. With some, you know, with response.
Time in seconds, milliseconds.
We’re at the top of the hour, so I don’t want to keep everybody here, I think this is a great stopping point. Thank you, as always, for joining us here, and it’s good to be back hear your voice and Incorta. Yeah, great to hear your voice out there.
Yeah, For everyone who’s attending, thank you, for joining us today.
You can always reach out to us, of course, on the web, by e-mail, or by phone, if you’d like, talking to people. Also, you may have noticed in the chat window, Scott Felton posted access to his calendar the account. If you’d like to get some time on Scott’s calendar, talk more about Incorta. Feel free to do that. He’s always happy to hear from you.
And with that, thank you, everybody, for attending today’s webinar. We hope to see you again at a future Senturus webinar.