For organizations that are committed to delivering fast response times and even faster times to root cause analysis and resolution, the speed at which they can access their customer data is critical to meeting customer expectations and service level agreements (SLAs). However, when data is stored in multiple business applications, databases, and siloed source systems, it becomes extremely difficult to acquire, analyze and quickly take action to ensure the highest quality and standards of customer experience.
Unifying data from multiple sources into a common data environment makes it possible for organizations to quickly access the insights they need from a single, trusted, and accurate source without the need to visit and pull reports from different systems and stitch them together to generate actionable insights.
In this webinar, you will learn how the solutions by stc team successfully combined millions of records from data sources across the organization to enable their agents to investigate, resolve, take action and respond to customer issues with speed and agility.
Watch on demand to learn:
- How solutions by stc leveraged Incorta to reduce customer resolution times churn, while simultaneously improving customer satisfaction.
- Why increased speed and easier access to data helped solutions by stc reduce troubleshooting time by 300%.
- How Incorta’s unified data and analytics platform helped increase their revenue and market share, increase ARPU, improved SLAs, cost optimization, and enhanced customer experiences.
Ahmed Tarek: Okay, good afternoon everyone, this is Todd from in quarter i'm leaving the proceeds for the Emir region, today, we will talk about one of our customer success stories, and my beloved one will talk about how encode to help.
Ahmed Tarek: Our customers to be in 300% reduction in the troubleshooting time and first of all I would like to introduce the company and introduce the panelists that I that I have from the customer side.
Ahmed Tarek: So, first of all.
Ahmed Tarek: Mr Obama when Mr bhalla is it enablement and the integration solutions manager that solutions by us to see and Mr matt Campbell senior software engineer at solutions wise to see as well it's my pleasure to have you, Mr Abdullah, Mr in the webinar and before going deeply about.
Ahmed Tarek: Like to introduce solutions by us to see solution was to see it's a well known company in Saudi Arabia, actually, they are leaders in the digital champion part from the digital transformation, they are offering.
Ahmed Tarek: vitas of services for the ICT solutions such as telecommunication it financial technology digital media and advanced digital solutions, and I think we are the leader in the region and Saudi Arabia regarding this transformation part.
Ahmed Tarek: And this kind of thing it's great for us to have them today to talk about the use case, so I will start with Mr rob.
Ahmed Tarek: in the way of what were the business challenges that we have inside us to see before having a.
Abdullah Al-Ghubain: Salaam aleikum.
Abdullah Al-Ghubain: Challenges electronics more judah and dinner.
Abdullah Al-Ghubain: solution by stc it's any combined between internal operations things and whatever we need to send to the customer so.
Abdullah Al-Ghubain: We have multiple parties, and we have, we need to report, a lot of things due to multiple applications available.
Abdullah Al-Ghubain: And we have a difficulty to manage all those data in one source and how to manipulate with it, how to design, how to get to benefit from it so honestly we we try multiple solutions to combine those multiple systems together and get the benefits.
Abdullah Al-Ghubain: To have a one visibility and one place to see the report.
Abdullah Al-Ghubain: Which is, we cannot succeed with those implementation.
Abdullah Al-Ghubain: and handle.
Abdullah Al-Ghubain: We fund and then quarter we.
Abdullah Al-Ghubain: We try and it was magnificent, to be honest.
Abdullah Al-Ghubain: How easy to implement how easy to onboard multiple systems in one place, and you will find all the data, all this keener everything in one place.
Abdullah Al-Ghubain: Any challenges was really any someone on me to troubleshoot you need to go to X report why report existence and he will spend.
Abdullah Al-Ghubain: A lot of time to troubleshoot one incident, or he wants to inquire one things and also sometimes the customer asked about the status and where are they standing for.
Abdullah Al-Ghubain: Data validation for X product or circuit or bandwidth or anything.
Abdullah Al-Ghubain: So yeti.
Abdullah Al-Ghubain: making things easy.
Abdullah Al-Ghubain: And available in one place.
Abdullah Al-Ghubain: at any time.
Abdullah Al-Ghubain: Without in quarter, we did not see any succeed to do this, so any.
Abdullah Al-Ghubain: let's say that if someone want to bring a data or that inflammation for one month, for example, he need to go to X system.
Abdullah Al-Ghubain: And why system and combine it and negotiate and then he provided and upload this manually and any bi tool to have a visual we could utilize the dashboard, then we will take a screenshot and we'll send it to the customer so it's a longer process.
Abdullah Al-Ghubain: So.
Abdullah Al-Ghubain: Currently, and I think in the next slide or two.
Abdullah Al-Ghubain: we'll have more feasible for the numbers, so those challenges with us before then content now tonight is easy and say.
Ahmed Tarek: Okay, so.
Ahmed Tarek: The question for Mr Ahmed camel as well from the technical side what were the technical limitations in the traditional a push for before in code that you are facing.
Ahmed Kamel: So many.
Ahmed Kamel: Our technical.
Ahmed Kamel: To the technicality, we have some challenges regarding generating thousands probably say, for example, we have many, many systems, our core systems.
Ahmed Kamel: which will lead to, for example, developer dashboard or some customers asking for a status for some services or for some language revitalization which we need to merge two or three systems in order to get the customers requirements.
Ahmed Kamel: So here was the big challenge, how we can combine the data from the different systems together and after that combine all the data to show it to the customer, or to provide to the customer is this is one of our.
Ahmed Kamel: biggest challenges that we face before in code and another challenge is related to how we can environmental variables to need to the technical uriah.
Ahmed Kamel: Some queries low level queries in each system in each dissimilar to source in order to extract the required data to and then, combined with the old joined because.
Ahmed Kamel: Those are the main the main challenges before incorporate even to visualize the data, it will take too long time to the returns on if the customer requests or if the operations team request some data or some way what we may need.
Ahmed Kamel: 334 days in order to prepare it because you need to write queries for each system extract the data, combined with the sort of.
Ahmed Kamel: visualize it in a view to in order to provide to the customer, or to the operations team So those are the main challenges before before in quarter one more relative to the performance.
Ahmed Kamel: One of our biggest challenges is the the.
Ahmed Kamel: Performance for extracting data, as you know, we.
Ahmed Kamel: We are monitoring, a lot of customer nodes.
Ahmed Kamel: The monitoring systems, for example, collect some data every five minutes for for the workloads and we have.
Ahmed Kamel: Billions of records, so how we can extract the data for a specific circuit in specific time to provide to the customer, so the performance or one of the our biggest challenges, so all of the challenges we faced.
Ahmed Kamel: Before I was like like me before in quarter at the hundred laughter in quarter all of those challenges.
Ahmed Kamel: me we overcome all the challenges and we are able to to merge all the data and the one place, and we have a great performance in order to extract the data from our customers and we're going to go slow Inshallah we'll.
Ahmed Kamel: talk in detail how we can how we achieve this user.
Ahmed Tarek: Right Thank you Mr Mr hunt for that information, so I think we'll spend almost five.
Ahmed Tarek: or 10 minutes talking about.
Ahmed Tarek: Import architecture to help our audience to understand architectural behind in quarter so as the as you hear about in kota so in Cortez unified data analytics platform.
Ahmed Tarek: That accelerate the operational reporting in a time resolution manner and deliver that the insights in an easy way and the fast way to drive more business performance.
Ahmed Tarek: And this is our core actually approach in coordinated approach that leveraging the full data accessibility for over the data will not have a limitation, while accessing the data.
Ahmed Tarek: or reshaping the data into a different format, we are just doing the direct access to the source systems.
Ahmed Tarek: And this helps us or help our customers to have a trusted accuracy about the numbers that are generating from.
Ahmed Tarek: The reports and we'll talk about examples from solutions by stc about that later.
Ahmed Tarek: And also, you can achieve the security part or you can achieve apply the security rules over the beta or over the users that login to the system.
Ahmed Tarek: And as Mr Mohammed mentioned the time or the performance sport in general and the time to deliver the insights, this is the key about.
Ahmed Tarek: In kota approach and this something as Mr Abdullah mentioned as well it's not achievable and it will be a hard way to do the whole journey and what the traditional approach.
Ahmed Tarek: So in court as a unified data analytics platform can Haz can has can connect to different source systems and upbringing billions.
Ahmed Tarek: and hundreds of millions of records, with a big number of joins into the encode the engine to be compressed and use our own in memory optimized engine to do the required aggregations.
Ahmed Tarek: And to do the required calculations, besides that we have the ability to do the visualization as well inside in quarter visualization or inside in quarter component.
Ahmed Tarek: And the ability, because we are not a lovely technology or open technology for third party tools.
Ahmed Tarek: To use or to consume the data that you prepared inside in quarter for the visualization as well, like our big blue so beside that.
Ahmed Tarek: We can talk about details about the component, that we have inside.
Ahmed Tarek: encoder and behind the scenes, so the data flow inside in code that can happen through the architecture that you can see, the first part is regarding the data acquisition.
Ahmed Tarek: which we have the connectors to connect to the different system that you have the schema detection detect to the structure of the people's if you have joins or foreign key is defined.
Ahmed Tarek: In your source systems in code that can detect it automatically as well, using our diet, with a mapping technology our pitted technology to extract.
Ahmed Tarek: And the load the data into our storage without the need to the ship to ship, the data into another format.
Ahmed Tarek: And encode the is storing the data into a park a format open a standard format.
Ahmed Tarek: In the storage over the desk it will be compressed so your data source size will be always inside in quarter less than the original size, because of the compression way.
Ahmed Tarek: And beside that we have admitted data and the Meta data it contains all the details that governance how.
Ahmed Tarek: The local service is loading subtract and load and enrich that data as well inside the product, and also to control how the analytics or service that we have moving the data from the porky into the in memory engine.
Ahmed Tarek: So after loading the old data and doing the required relations or the required blending between the different data sources.
Ahmed Tarek: Over the party files, then you have the ability to use the component for the data analytics, which includes the business views that's our semantic layer that you can bring or build a one view or upset attractive you to bring different columns from different data sources in one view.
Ahmed Tarek: And, as well as you can naming or labeling these columns was business name that the business can understand if you would like to add a formula or a specific logic.
Ahmed Tarek: For this business users, you can do that, so you can achieve the self service analytics part with your business users as well, and with applying the security rules.
Ahmed Tarek: Over the data itself so different users can see different data based on the authorities, all the security rules that you are applying to these data sources.
Ahmed Tarek: And we have our in memory analytics engine our smart in memory engine so based on the needs or based on the queries that you are building.
Ahmed Tarek: On top of in quarter visualization the memory, the memory engine will be consumed for that, based on the usage itself for living with column for the analytics.
Ahmed Tarek: And we have are providing as a technology smart the query routing way, so you don't need to think about how I should optimize my query to get a better performance, you are just drag and drop the required matters or dimensions.
Ahmed Tarek: to generate a specific inside and the engine can understand directly how each data point inside the system are linked together and do the required the aggregation inside the memory engine itself.
Ahmed Tarek: And, as I mentioned before, we have our own data visualization part and we have open access using the sequel interface for the third party tools to connect to encode.
Ahmed Tarek: The last optional part that we have inside the product is a spark as far as far off in court itself.
Ahmed Tarek: and actually is responsible for accelerate or excel the part for the data enrichment itself so if you would like to build a very custom transformation.
Ahmed Tarek: Or you would like to build the data science use cases or machine learning use cases, you can use our zipline notebook embedded.
Ahmed Tarek: Through spark inside the product as well to write Python sequel postgres sequel or scholar over the data that's loaded into the party.
Ahmed Tarek: And this new drafting tables will be saved physically on the parkway and it can be used later for the analytics for linking them together with any other.
Ahmed Tarek: tables that are already loaded into in court and for sure when we are talking about enterprises like socials by stc.
Ahmed Tarek: The components that you can see here can be scaled horizontally across the infrastructure that you have, if you would like to achieve the high availability part if you would like, at that moment of time to increase the specs of the machines or by adding a new machine and.
Ahmed Tarek: actually do the load across the different components across the different.
Ahmed Tarek: machine that we have across different nodes that you have so you can do this horizontal scaling inside in court, the through the encoder components.
Ahmed Tarek: And the through the admin access that we have it's an interface that enables you to build the clusters and manage the resources for your hardware within quarter in an easy way, instead of writing scripts or something like that.
101
00:17:05.040 --> 00:17:13.410
Ahmed Tarek: So that's a quick brief about or the detail the brief about encodes the architecture itself and how the components works in trial inside equals.
102
00:17:14.340 --> 00:17:30.150
Ahmed Tarek: So if I go back to Mr attainment regarding how encode the based on that architecture that our audience see so how important that help with you from the implementation side to get data from different data sources.
103
00:17:32.190 --> 00:17:41.550
Ahmed Kamel: With regard to how in court ahead of us that, as we mentioned here, we have almost about 8 million data sources.
104
00:17:42.660 --> 00:17:51.510
Ahmed Kamel: We need to combine these different users so using the engine, we are able to import the old data.
105
00:17:51.570 --> 00:17:52.200
Ahmed Kamel: From the.
106
00:17:52.260 --> 00:18:02.550
Ahmed Kamel: data sources, and we are able to, for example, determine the refresh rate for the data and, for example, we have some critical data sources which we needed.
107
00:18:03.480 --> 00:18:17.820
Ahmed Kamel: We needed to read real time or near real point so, for example, we have artificially about five to 10 minutes, and we have some data sources, which is refresh daily, for example.
108
00:18:19.200 --> 00:18:28.050
Ahmed Kamel: We are able to using the the import we are able to use encode the engine to import all the data from multiple sources was our.
109
00:18:28.770 --> 00:18:40.140
Ahmed Kamel: Design refresh rate and the most important thing that we are able to showing the different data sources stickers, and this is was one of our many challenges, for example.
110
00:18:40.770 --> 00:18:50.490
Ahmed Kamel: We have three or four systems ready to the operation team, we are able to join the data from the different sources and in quarter.
111
00:18:51.210 --> 00:18:55.860
Ahmed Kamel: Show in quarter will need to overcome to generate some reports, or do we need to.
112
00:18:56.430 --> 00:19:05.280
Ahmed Kamel: generate some as a customer set 60 view we are able to get the data from the different sources, at the same time, and this is one of our.
113
00:19:06.060 --> 00:19:16.200
Ahmed Kamel: Our main challenges here, for example, if we have a customer have some new data from the monitoring systems we have another data from the support systems, and you have a lot of data from the original systems.
114
00:19:17.130 --> 00:19:28.650
Ahmed Kamel: When the customer calls to check some issues, the agent was able to find all the data from the differences in from the different systems or from different data sources in the same place.
115
00:19:28.950 --> 00:19:33.840
Ahmed Kamel: He was able to see how many cases, for example, how many cases open for the customer and last month.
116
00:19:34.110 --> 00:19:45.300
Ahmed Kamel: He will he was able to see what is that what about the the bandwidth or the authorization for the service provider to the customer, because he able to see the availability, that the history everything he can see in one view.
117
00:19:46.290 --> 00:19:58.560
Ahmed Kamel: Using it records the engine to showing all the data sources that goes on and and the most important thing all the data is already included in the memory so once you need.
118
00:19:59.580 --> 00:20:06.090
Ahmed Kamel: To get the data for a specific service in certain period, you can get it instantly using.
119
00:20:07.230 --> 00:20:11.670
Ahmed Kamel: The analyzer from from unquote analytics Apps, so this is one of our.
120
00:20:13.380 --> 00:20:18.210
Ahmed Kamel: One of our many challenges we are able to join all the data, together, we are able to.
121
00:20:19.290 --> 00:20:25.200
Ahmed Kamel: have a big performance or any dramatically faster resolution time for.
122
00:20:26.250 --> 00:20:36.030
Ahmed Kamel: To get the data and the selected burn and show it to the operations team and the customers in one view showing all the data from all the systems.
123
00:20:37.320 --> 00:20:39.120
Ahmed Kamel: Together, to help the team.
124
00:20:41.010 --> 00:21:01.290
Ahmed Kamel: Have a faster resolution time he can see all the details to the customer and he can see everything in one view so this was one of our biggest challenges we are able to achieve another thing regarding to the new requirement for example if the key of the customer relations team require.
125
00:21:02.310 --> 00:21:15.330
Ahmed Kamel: A new data on new reporting, so we are able to do it in a very faster way before we almost we take four or five days to generate on the one report.
126
00:21:15.840 --> 00:21:21.930
Ahmed Kamel: Now wasn't ours, we can generate the data for the to the cost, using the input analytics as we already, as you mentioned.
127
00:21:22.710 --> 00:21:35.550
Ahmed Kamel: We have the data in memory ready for you to use drag and drop analyzer to generate the data to generate the insights to generate the the charts or raw data tables whatever you need.
128
00:21:36.450 --> 00:21:47.400
Ahmed Kamel: To provide to the customer So those are the main the main use case for us, and this is how in quarter engine helps us help us to.
129
00:21:49.080 --> 00:21:50.520
Ahmed Kamel: overcome our challenges.
130
00:21:51.390 --> 00:22:02.460
Ahmed Tarek: So I have a question here regarding the modeling and the blending for for the latest forces, you need to write a script or doing something to generate or to link the data together.
131
00:22:03.810 --> 00:22:06.720
Ahmed Kamel: No actually using quarter.
132
00:22:08.010 --> 00:22:21.420
Ahmed Kamel: load of service, for example, if you have a data source, you can just connect to it after reconnect you have to you will find all the tables or the operations for the religions and clean the tables.
133
00:22:22.020 --> 00:22:26.910
Ahmed Kamel: already generated for you, for example, if you ever like a source, have, for example, 100 table.
134
00:22:27.450 --> 00:22:35.400
Ahmed Kamel: For example, 500 relations for an unemployment to keep it when the tables once you connect to it and CT the will generate the model.
135
00:22:35.790 --> 00:22:51.840
Ahmed Kamel: For you, or you just few clicks you will be able to connect to the schema you will be able to import the the the diagram for the database over the data source was the table, he was all the joins ready for you to use, so this is one of the amazing features from my country.
136
00:22:53.370 --> 00:23:04.470
Ahmed Tarek: that's a great I think this slide is talking about if you can give us a brief about that so far the the output from in quarter side for solutions by us to see.
137
00:23:07.080 --> 00:23:17.250
Ahmed Kamel: who's now, as mentioned in spite we have more than 600 dashboard and have more than 140 years of using the system.
138
00:23:18.660 --> 00:23:24.330
Ahmed Kamel: Most of our departments now are using depend on in quarter, in order to get.
Ahmed Kamel: The required attributes or the required to keep your eyes on data we.
140
00:23:30.900 --> 00:23:33.660
Ahmed Kamel: began its beginning spreading the common.
141
00:23:36.750 --> 00:23:40.260
Ahmed Kamel: As mentioned here that the average volume the queries.
142
00:23:41.310 --> 00:23:47.490
Ahmed Kamel: Most of our teams now quarter, in order to generate the required required reports and dashboards.
143
00:23:48.630 --> 00:23:54.660
Ahmed Tarek: Okay, so for for the critical thing to gardening back curious report with accuracy or data available.
144
00:23:55.200 --> 00:24:03.930
Ahmed Tarek: In addition, and after shooting reports with the business sometimes i've been this come back and the traditional way and saying this numbers are correct.
145
00:24:04.320 --> 00:24:20.160
Ahmed Tarek: And you need to investigate so while start using import the and the belt reports and sharing them with the business and he did you face the same issues with the business from the data validation of the data accuracy, you get issues from them regarding that.
146
00:24:21.480 --> 00:24:26.490
Ahmed Kamel: Extra you know goes before in Costa, we were manually connected, the data sources to get.
147
00:24:27.540 --> 00:24:46.440
Ahmed Kamel: To get to the request information have to get the required fields and dashboard and while you are connecting manually for sure you will you will have some human mistakes afternoon quarter the joining or the linking between the data source is automatically by the system or by the inch.
148
00:24:48.000 --> 00:25:02.460
Ahmed Kamel: This is how incorporated us decrease dramatically decrease the issues of it to the accuracy for users, using the engine to generate the required insights for the for the costumes and for the teams.
149
00:25:03.210 --> 00:25:04.290
Ahmed Tarek: Okay that's great.
150
00:25:05.310 --> 00:25:15.450
Ahmed Tarek: Also, I think one of the challenges that you mentioned on Assad Allah mentioned as well, that you have different customers and you need to share a customized report for each customer or something like that.
151
00:25:16.530 --> 00:25:24.930
Ahmed Tarek: Regarding the security controls, because I think the data somehow for each customer, so the customer need to see the data or the report for its data only.
152
00:25:25.500 --> 00:25:33.510
Ahmed Tarek: So how encoded to help you in applying the security that you need over the reports that you are scheduling to be shared with the customer.
153
00:25:34.260 --> 00:25:37.620
Ahmed Kamel: Yes, as you mentioned one of our challenges.
154
00:25:37.680 --> 00:25:43.200
Ahmed Kamel: is to send, for example, weekly or monthly reports to own the customers.
155
00:25:43.620 --> 00:25:44.820
Ahmed Kamel: So I.
156
00:25:45.330 --> 00:25:49.260
Ahmed Kamel: internationally in the manual way you have to generate it, one by one and sentence.
157
00:25:49.620 --> 00:25:50.910
Ahmed Kamel: But during quarter.
158
00:25:51.180 --> 00:26:08.700
Ahmed Kamel: We have only one dashboard for all the customers, using the security benefits from in quarterly or able to automatically send the reports, only one remote and we are able to send it to the old customers and each customer will only receive the details.
159
00:26:09.840 --> 00:26:11.010
Ahmed Kamel: So this is.
160
00:26:12.030 --> 00:26:18.540
Ahmed Kamel: hell, but also a lot actually we are able to automatically scheduled reports to be sent in.
161
00:26:19.380 --> 00:26:26.790
Ahmed Kamel: A required for me to have some represent weekly we have some represent multi to all in the customers and we are able to.
162
00:26:27.000 --> 00:26:39.750
Ahmed Kamel: differentiate between the data each customer will see on the data which is related to him and he will be able to see the status of the service vaporisation the the operational case, everything will be able to see only.
163
00:26:42.180 --> 00:26:42.870
Ahmed Kamel: Using, of course.
164
00:26:44.130 --> 00:26:52.440
Ahmed Tarek: that's great that's the question from my side regarding the implementation by itself, I think, with this big achievement that you get.
165
00:26:52.860 --> 00:27:02.940
Ahmed Tarek: Through encode the from the number of dashboards or something like that roughly that the time that you spend two for the encoder to implement implementation to be in production.
166
00:27:05.490 --> 00:27:06.630
Ahmed Kamel: you're with us.
167
00:27:08.910 --> 00:27:17.970
Ahmed Kamel: it's almost it's Nice and within these we are able to even even if you remember the B2C takes about one week, I think.
168
00:27:18.330 --> 00:27:22.170
Ahmed Kamel: within one week we are able to to join different data sources engineering.
169
00:27:22.470 --> 00:27:30.360
Ahmed Kamel: I want to combine data from different data sources and show it to the to the teams, so this is something really, really.
170
00:27:31.470 --> 00:27:36.840
Ahmed Kamel: impressed me very challenging from unquote to be able to connect with different.
171
00:27:37.230 --> 00:27:46.950
Ahmed Kamel: You don't need to doing modeling your you don't need to make a sale or whatever you are just to connect to the data sources in both the tables all the tables will be.
172
00:27:47.280 --> 00:28:04.170
Ahmed Kamel: available in quarter with the showings already available in the data sources already reported to the testing and you are that the thing you need to do is to join the different data sources together load the data, after that, just to go implementing the reports and dashboards.
173
00:28:04.470 --> 00:28:10.020
Ahmed Kamel: So I think it was in week within being as or the Boc we converted, I think, within one week.
174
00:28:11.580 --> 00:28:29.100
Ahmed Tarek: It was one of my favorite pieces, by the way it was actually a great success for me as well, and for in quarter to have solution is by us to see one of our customers Thank you Mr rabbit for this beneficiary information so for Mr bhalla from the business outcomes.
Ahmed Kamel: At the end, after implementing importer.
Ahmed Tarek: From stc solutions by stc side, so what were the business outcomes.
Abdullah Al-Ghubain: Business outcome is what we care about is time to mark any method can, and then I know if someone asked about something he needs is immediately, so we don't spend times to.
Abdullah Al-Ghubain: OK, I will go to exist, and why system drink reports try to analyze it to then figure out Okay, I need to have at least a beauty reports and hey, we need to do our cosmetic things under to take time.
Abdullah Al-Ghubain: Any connecting multiple sources, making the data available on the spot.
Abdullah Al-Ghubain: Honestly it's helped a lot.
Abdullah Al-Ghubain: In both sides any normal reports, which is looking at reports that say and ad hoc reports so.
Abdullah Al-Ghubain: it's a lot of us what we kept it to time to market.
Abdullah Al-Ghubain: The tenant for investment, so any reduce the time to market for any report.
Abdullah Al-Ghubain: From honestly from days to let's say, and I will give the maximum which is.
Abdullah Al-Ghubain: let's say it's a happy and happy scenario it's ours, but the maximum any with a complex report, I told be available one two hours and it's combined and ready to be shared with us about simple asked about and also.
Abdullah Al-Ghubain: Making those later available in one place as as the guys mentioned in yakima done both achmad as a B or C was honestly we give a complex scenario.
Abdullah Al-Ghubain: It was challenging to see the beauty of the quarter and it surprised us honestly and.
Abdullah Al-Ghubain: Making the data available with a short time, and all those data available it's reducing the operational costs for us, which is.
Abdullah Al-Ghubain: Staying in one report on one dashboard and have full visibility for the calendar status and it's like any honestly it's nice to life.
Abdullah Al-Ghubain: So he doesn't need to go one me to either to the exact system to see what is the current status that will be available that it could be any if something happened to data bottle in this report.
Ahmed Tarek: So.
Abdullah Al-Ghubain: Can you buy one by opening this report, he will have a 360 view for the customer kind of situation and he can answer anyone customer internal user.
Abdullah Al-Ghubain: Having a view or checklist, for example, sometimes, he will see the status or quality.
Ahmed Tarek: check.
Abdullah Al-Ghubain: He will see it.
Abdullah Al-Ghubain: Also, the other beauty is alive dashboard its life.
Abdullah Al-Ghubain: If you're implementing other resources or other.
Abdullah Al-Ghubain: Project it's not like me, you need a frequency to pull the data and sometimes you need.
Abdullah Al-Ghubain: A creative guy huge.
Abdullah Al-Ghubain: scripts to to have the last life any data available new site.
Abdullah Al-Ghubain: As I mentioned in the slide any before when we building the scripts everything can we put a huge investment and getting the live data we reach to 20 minutes any now within quarter without anything can just drag and drop connect with the new that source, for example.
Abdullah Al-Ghubain: Getting getting maximum within five minutes latency so it's any creating a huge impact and it's a good impact on me.
Abdullah Al-Ghubain: An hour to me.
Ahmed Tarek: yeah that's.
Ahmed Tarek: Great, so I think this is your code, Mr Abdullah regarding in kota so for this slide may I can ask you about why was included chosen again as other available options.
Abdullah Al-Ghubain: Honestly, when we was looking for.
Abdullah Al-Ghubain: solution for our pain.
Abdullah Al-Ghubain: We any specially with figured out in quarter we input and big obstacles honestly for unquote any as any at that time.
Abdullah Al-Ghubain: Saying i'm quarter with the sharks.
Abdullah Al-Ghubain: without naming any companies.
Abdullah Al-Ghubain: let's say we need to see it results in and the challenging was with you on the other, guys is make it available with one week with all available that that we need.
Abdullah Al-Ghubain: To be viewed, and I want report.
Abdullah Al-Ghubain: I did, to get succeed, and we did other internal PLC is also playing around with the system we figured out it's really it's easy and.
Abdullah Al-Ghubain: Not like another systems, you need to develop an 8am mountain and you need to develop a queries and you need to bring the data and you need to experts and different systems here honestly any with.
Abdullah Al-Ghubain: Any guys knowing it, and some basics and sql they can connect to any database take them into data and important and the data will be of it.
Abdullah Al-Ghubain: it's easy to use.
Abdullah Al-Ghubain: Any with me and let's say million and billion difficult still the performances any grit there is no any impact on the performance.
Abdullah Al-Ghubain: A few increase the number of records to the fullness.
Abdullah Al-Ghubain: Satisfying very satisfying for us so honestly it surprised us in the beginning, and any maybe until now we have surprised.
Abdullah Al-Ghubain: me from day to day, if any, complex scenario it's came honestly we haven't caught for please use it as I had mentioned in for splitting between.
Abdullah Al-Ghubain: users and any it's good to a non hidden company.
Ahmed Tarek: that's a great job well it's our pleasure as, as I mentioned to have solutions by us to see one of our successes stories.
Ahmed Tarek: And if I if I would like to wrap up what you underestimate said regarding in kota I think in Cortez the fastest way to do your operational reporting.
Ahmed Tarek: Over multiple sources, how you can blend the source systems together in one place to be your single point of truth.
Ahmed Tarek: Without the need to do a lot of development for needed the time to market is critical, I think, for all the business.
Ahmed Tarek: So in kota is mainly solving the business issues and helping the ID as well as the business to achieve their kpis or they're driven.
Ahmed Tarek: kpis to be life and to be available all the time, I think that availability also it's one of the most important thing for all.
Ahmed Tarek: The organizations to have the data available, so you can create whatever that you need from the business side or from the it side, I think we have some of questions over the question section I will move for them.
Ahmed Tarek: yeah so my belief.
Ahmed Tarek: system for the okay so.
Ahmed Tarek: A question for us the seat solutions by us to see me want to make sure that you are using the system, so I think and Mr Abdullah showed us how the user system actually.
Ahmed Tarek: Another question how long it would take I think we answered that regarding how long did the project to be generated reports before and after in quarter we mentioned that.
Ahmed Tarek: Regarding the efforts from the ID another question, how do you want to find the safe efforts for the engineers after using encoder.
Ahmed Tarek: I think i've met if you can answer this part regarding the same time for you as an engineer, and your colleagues when we were developing reports in many ways.
Ahmed Kamel: I think you already mentioned that.
Ahmed Kamel: One of our challenges before the quarter, is how to implement the periodic and the operation of TRIPS, we will we need to.
Ahmed Kamel: For example, before in quarter, you have to write low level queries over all the data sources over the different data sources in order to extract the required data, and you have to own the data manually.
Ahmed Kamel: Using the legacy technology to to to provide the required to report on the required reading labels or dashboard dashboard to the internal teams or or the customers afternoon quarter you already have.
Ahmed Kamel: The data already joined and your evening you can create a business use this business, you know you can bring all the data from different sources, which is already joined together in only one, you can you'll have to adhere to to generate that.
Ahmed Kamel: You know, you can provide the business view to to the interviews or he can use it himself and he can prepare the report himself or if you need to.
Ahmed Kamel: revert you can use the define the business here's over defined data sources, which is already available already integrated already joined.
Ahmed Kamel: and using the the analytics drag and drop to just combine the data or just to bring the data from different sources be repetitive, and one inside of one table and provide to the to the to the customers, or to the Internet, as mentioned by the complexity within two.
hours we can prepare.
Ahmed Kamel: You for that to where, for example, we take them.
Ahmed Kamel: To the queries.
Ahmed Kamel: The data joining it to this.
Ahmed Kamel: And we do this exercise, every time every time.
Ahmed Kamel: We have a report.
Ahmed Kamel: You have to write a query get the data join together and provide it up now everything is ready, you just go with one point at the beginning, and you can just using the analyzer drag and drop the data together and provide it, as required.
Ahmed Tarek: Right, I think we covered most of the questions I see in the kitchen in full hour for the migration part.
Ahmed Tarek: I know that you already developed this these reports before in code that even in a manual way, so, while doing the migration from the previous way to.
Ahmed Tarek: In quarter, how long it takes so did you spend a lot of five to do the migration for the number of records that you already built before the quarter.
Ahmed Kamel: No, we didn't take a lot of.
Ahmed Kamel: time we were having almost.
Ahmed Kamel: I think 300 plus report before before and costly and our legacy systems of time quarter we migrated all the sources, we only at the beginning, we prepare the the scheme of the business meals.
Ahmed Kamel: After that will start in start implementing the door I think even think one month, we were able, were able to to implement or to migrate all the important pray.
Ahmed Kamel: For us, so it didn't take much time at all.
Ahmed Tarek: that's great, I think, so I think we are now covered.
Ahmed Tarek: The question that we have in q&a a within the presentation within our conversation as well.
Ahmed Tarek: So, again it's my pleasure to have you, Mr Africa than Mr bhalla and this webinar and we are looking forward to have more success with each other.
Ahmed Tarek: To make more achievement inside solutions by stc within kota so thank you so much, thank you for that in these they can muster up the lead Thank you so much.
Abdullah Al-Ghubain: Thank you.
Ahmed Kamel: Thank you, thank you.
Hosted by:

Abdullah Al-Ghubain
IT Enablement & Integration Solutions Manager


Ahmed Kamel
Senior Software Engineer


Ahmed Tarek
Head of Solution Engineering, EMEA
