Incorta Customer User Group

Watch Incorta's User Group with Melinda Albert from ASP, Marc Paige from GC Services, and Joe Miller from Incorta.

Agenda: 

9:00am - Welcome 

9:05am - Latest Incorta Community Updates, Presented by: Joe Miller, Sr. Director, Community & Customer Enablement, Incorta

9:20am - Data Hackathon, Presented by Melinda Albert, IT Leader of Data Analytics, Advanced Sterilization Products (ASP)

Session Description: Learn how ASP hosted a global, company-wide data hackathon with Incorta to promote data and analytics skills within their organization. Teams had 24 hours to focus on a single data set to address practical business questions and develop a single dashboard together to present to their leadership team during a final report out. Throughout the event, participants worked together to learn and apply Incorta skills to create visually compelling stories with their data. 

9:40am - Automating Call Center Reporting with Incorta, Presented by Marc Paige, Assistant VP IT Software, GC Services

Session Description: Call centers used local experts who gleaned data from whatever sources they had to populate and distribute spreadsheets to management via email. Issues include no consistency, no common source, data not timely nor uniformly gathered, and locally stored obsolete spreadsheets, leading to no real true perspectives. Incorta solves all of these problems.

10:00am - Upcoming New Feature Highlight: Incorta SQL Views

10:20am - New Feature Highlight: Incorta Component SDK

10:40am - Closing: Announcements & Awards

Transcript:

Incorta Admin: Good morning, everyone in just a few minutes we'll get started we're just waiting for everyone to join the call.
Incorta Admin: Thank you for joining us today we'll get started in just a moment, while we are getting started just want to take a few minutes to go over some.
Incorta Admin: Quick housekeeping notes.
Incorta Admin: And today's webinar is our youth group is hosted by massive Arar and myself, Melissa billy i'm your technical host Amazon is your master of ceremonies.
Incorta Admin: And before we go into everything we want to just make sure that everyone has their camera enabled we do want to see your faces, however, please keep yourself on mute unless we are in the Q amp a part of the.
Incorta Admin: event and then we'll do live Q amp a or chat q&a we do ask that you use the chat function for any questions that you have, while the presenter is speaking.
Incorta Admin: MAS and can then do those in the moderator Q amp a or bring you have you asked your question live.
Incorta Admin: And we're not doing breakout sessions today our content is back to back sessions, so it will be very easy, and no one needs to go into breakout rooms and with that I am going to turn it over to muslin muslin.
Mazen Arar: Excellent.
Mazen Arar: So thank you, Melissa and welcome everyone, thank you for joining our virtual.
Mazen Arar: Q4 group, we have a very exciting and packed agenda, as you see i'm not going to go through the agenda, you can see, it also, I would like to welcome our speakers today.
Mazen Arar: You will see them throughout this event so i'm not gonna get an overall intellectual right now also at the end, once the presentations are over we'll get back together again for closing discussion Q amp a and announcements.
Mazen Arar: Let me start by introducing our first speaker Joe Miller, he is a senior director of Community and enablement is going to talk to us about in court that Community Joe go ahead, please.
Joe Miller: Thank you, my cousin I just want to confirm that you can see my screen okay see a community and learn slide yep.
Joe Miller: perfect.
Joe Miller: Well, welcome everybody to today's user Group, I want to thank you all for joining here today.
Joe Miller: I do realize that the timing of this is always a challenge when it comes to mid December, because I know we're juggling the closing of the year.
Joe Miller: making sure that we meet those metrics goals okrs quotas, whatever they may be within your business and balancing trying to fit in family time in their over the holiday season and we're.
Joe Miller: happy to have you here despite all that chaos that's going on, through the December period to to listen to some other people who might be working within quarter using encoder in their day to day if you've been to some of these user group meetings before you may have heard me.
Joe Miller: promote some of the Community and learn opportunities that we have and i'd like to do that again today, for those who are joining that are are new to the user.
Joe Miller: So when you become a part of the quarter family you get more than the incorporate a unified data analytics platform I like to think that you get much more than that.
Joe Miller: The first of which is you're joining the Community a Community like what's here today, we would consider these one of our offline but now online communities where people of.
Joe Miller: Like mind and like a feather gather together but community is the place that in between some of these sessions, if you want to continue the interaction.
Joe Miller: With some of your peers that's what we'd like to to push people and encourage people to go to.
Joe Miller: You can find community.at sorry if you can find Community at Community dot encoding calm and as people joined into the session I did see a few familiar names and faces of of members of our communities today.
Joe Miller: If you haven't visited it, there are a few different components that you can interact with it, that may help you in your day to day, the first of which is, we have a Q amp a forum.
Joe Miller: If you're in the flow of working within korda and you have a question that's not quite a.
Joe Miller: Technical how to, nor is it a behavioral issue you're just really kind of looking at how to apply a problem to your your business context.
Joe Miller: that's where I think the Q amp a forums comes in handy because you'll have access to the employees who have worked across multiple customer accounts, who, who have been out there answering questions.
Joe Miller: you'll have partner experts who have been doing implementations as well and.
Joe Miller: Other Members right from like industries who had may have come up against the same problem so ask your question there and see if you get any answers.
Joe Miller: As of recent i've been seeing pretty good response times within the Community in some days that it's as low as eight hours on some responses so feel free to ask them there.
Joe Miller: And and look for some responses, now we know that Q amp a is kind of where It all starts when people have a question, but there are a couple different paths that.
Joe Miller: Those questions can turn into some sort of solution.
Joe Miller: The first of which is, as you evolve your question and you start to find all the answers you may find that there's a certain gap and capability or functionality that you.
Joe Miller: That you're missing from in quarter today and you'd like to see that added in and that's where our ideas forum comes into place, you can come in, submit an idea.
Joe Miller: Have others vote that idea if they also find themselves in a similar position and interact with each other to kind of mature and grow that idea.
Joe Miller: As you start to build on that in other cases, if there is a solution in place through the Q amp a.
Joe Miller: You can actually go and turn that question into knowledge and that's where our best practices and help knowledge base comes from.
Joe Miller: experiences that we've had out in the wild or through our support Center get turned in articles.
Joe Miller: That give us key information around how to work with in quarter from a best practices perspective, a few basic how tos and considerations and finally we have events, most importantly, we'd run the action insights event but i'll talk about that a little bit more in just a second.
Joe Miller: The other thing that you get access to is learned and CT calm it's are open and free platform for anybody whether you're just a prospect, looking at the platform for the first time, or you have been a longtime veteran that just needs to brush up on the latest version, the product.
Joe Miller: This is the place that we encourage people to go, we have for learning paths today with a few more in the pipeline.
Joe Miller: Some of the courses that we have is of course for business users of course around and quarter essentials, which really covers the whole breadth of the product at a very high level.
Joe Miller: Of course around developers, which is really more focused on schema design and, of course, on administration.
Joe Miller: With all those learning paths, we firmly believe that having hands on experience really improves the The ability for our learners to retain information so.
Joe Miller: As you jump into that environment will give you a lab environment to test and play around with and you won't you won't break anything and finally making sure that you get recognition and certification for for doing those activities.
Joe Miller: I know there is a subset of people out there that actually may not be in the December chaos, I know many people who try to wrap their year.
Joe Miller: Maybe on December 20 and leave that last week of the year, when everybody's out seemingly to kind of just get their lives in order upscale reorganize plan.
Joe Miller: And if you have TEAM members that are in that position, I would encourage them if they're looking job skill and quarter to take a look at learn quarter calm over the New Year.
Joe Miller: events that are coming up from Community and learn to keep an eye out for over on the left is our action on insights series, so this is a series focused on 30 minute technical bits usually a conceptual overview then followed by a DEMO.
Joe Miller: Our next one is actually going to be happening next week, presented by yours truly I will be doing a session on row level and column level security.
Joe Miller: In the new year we'll start scheduling these out shortly, but you'll start to see events land for in quarter for data scientists will be rerunning the 2021 favorite session of data data engineering best practices and korda.
Joe Miller: Back in February, then in March will be talking about blueprints and an April, about the mobile application so if there any of those interest you.
Joe Miller: you'll start to see those coming into our Community over the next few weeks over on learned in korea.com I didn't make a mention.
Joe Miller: of some upcoming classes, that people can participate in on the new year if you're interested in the developer and illustration class we do run those live.
Joe Miller: They take four days, but each day is about two and a half hours of instruction.
Joe Miller: And we run those in multiple time zones what i'm showing here is simply a subset were scheduled that to the end of q1 So if you want to plan ahead.
Joe Miller: All of those are on learn and quarter calm one call out that I do have is that learn is going to be adding some new learning paths in the New Year.
Joe Miller: So, in an effort to be more exacting with how we're targeting our learners in their capabilities we wanted to build some courses that strongly aligned with capabilities of the product, so in the turn of the year.
Joe Miller: either in the last days of December or in the early days of January we will be deploying a course that's.
Joe Miller: a replacement for our end user course today and it's really going to be focused on dashboard consumers making sure that.
Joe Miller: Those that are interacting with your platform understand how to click filter personalized interact glean insights from your data.
Joe Miller: or from dashboards and if you're a dashboard developer today, this might be helpful to distribute in the organization so you're not creating multiple copies.
Joe Miller: Of the same dashboard to acquiesce the needs of different teams, where one core report might be able to suffice and then on the flip side of that will be actually building a little bit more of a robust course around the discipline of dashboard development best practices visualization.
Joe Miller: One thing that I do want to mention is that, even though i'm promoting the Community today and i'm asking everyone to go there do know that this is kind of a something that i'm announcing for the first time in front of some of our users, that we are going to relaunch the Community.
Joe Miller: When I stepped into encarta about six months ago now, we had gone around and interviewed a series of customers and really tried to understand where our Community was really succeeding.
Joe Miller: Where it needed to be strengthened, looking at how our products have evolved over time and really what we said is let's take the valuable content that we have now and put it into an even more scalable and robust platform that.
Joe Miller: is going to make it a little bit easier for our users to interact on so we'll be introducing a whole new ui.
Joe Miller: will be breaking out that knowledge base that we have today that's kind of the heart of our Community and re architected that to kind of.
Joe Miller: align with areas of our product what's really interesting about the new Community platform that we are going to be promoting.
Joe Miller: Is that it allows for the citizen Community user to build up knowledge base so as you go into questions you can nominate them to knowledge base and collaborate with other Community peers to build that knowledge.
Joe Miller: will be introducing badges and leaderboards for recognition and contributions to our Community improve search and we'll be introducing a few competitions throughout 2022 as well.
Joe Miller: When to expect it where we're deep underway with developing this Community, as we speak, right now, but targeting of late January launch.
Joe Miller: And I when I say launch I really mean a soft launch and this is the core reason why I bring up this relaunch here today is i'm looking for you, and anyone who's on this call.
Joe Miller: Who has been a part of the Community today because I have seen some familiar faces on here or they're just getting started, and they have experienced with.
Joe Miller: High performing communities in the past i'd like to make an offer to anyone who's participating in this session today to join me for a soft launch before we open it up to the general public.
Joe Miller: We want to give it a week or maybe week and a half of a period where we just roll it out to a subset of users, you can think of it as a beta.
Joe Miller: And just give us our feedback what we care about the most is making a community that is going to be valuable for our Members.
Joe Miller: So it's an open invite to anyone who wants to join this all you need to to enroll in this is just send me a quick note.
Joe Miller: Either do the duration of the session or shortly after the session Joe Miller at encarta calm and just let me know you want to be on that list.
Joe Miller: And in January we'll be in touch about coordinating logins and access to the environment and give us your feedback, so we can improve that so by the time we roll it out to the general public it's in a form that's certainly well received by by our users in our Members.
Joe Miller: And that is it, I really appreciate the time that i've been given here i'm going to hand it back to Madison to introduce Melinda.
Joe Miller: Thank you, everybody.
Mazen Arar: and Muslim is on mute Thank you so much, Joe and any questions for Joe related to Community or learn please feel free to to ask.
Mazen Arar: If not.
Mazen Arar: I guess Melinda, so I would like to do this, you guys Melinda is a great customer of mine from a species, an IT leader of data analytics she's going to talk to us about data hackathon so that they did at HP and I thought was a very successful project they worked on Melinda go ahead, please.
Melinda Albert: I am fantastic thanks so much miles and Hello everyone again, my name is Melinda Albert I am the it leader of data and analytics on ESP.
Melinda Albert: And i'm really excited to tell you about the very first data hackathon competition event that my team hosted back in August of this year.
Melinda Albert: And i'm going to go through and describe everything that we did as part of this event really with intention in case anyone here wants to kind of take this idea and perhaps tailor it to their organization and hostess similar type of event.
Melinda Albert: So let's start off by talking about why we decided to move forward with this event, and we have a variety of different challenges at Asp around data and in court adoption.
Melinda Albert: And i'm assuming some of you on the call can probably relate to a few things here in similar ways.
Melinda Albert: And we really recognize that there was an untapped potential within the organization and the way that they utilize our data.
Melinda Albert: different levels of in quarter adoption, you know, we have some pockets that are super strong they're using the tool in a very structured meaningful way but there's a whole.
Melinda Albert: lot of other groups that aren't using it quite as effectively as they could and there's definitely some perceived barriers, a little bit of apprehension to get hands on with the data.
Melinda Albert: So, in looking at all these problems, of course, we all know, there's there's no one of his there's no magic bullet to solve all of this.
Melinda Albert: But when we were thinking about what we could do to kind of change the tide a little bit.
Melinda Albert: We landed on doing this hackathon event, so our mission here was to begin fostering a data driven culture make everyone more comfortable with using in quarter.
Melinda Albert: And really cultivate this type of environment where they see that it's pretty easy to actually use a quarter in understanding and solving their business problems.
Melinda Albert: An event like this, I think, is really powerful because you bring people together and you're.
Melinda Albert: you're doing this out in the open together rather than having individuals independently kind of learning and korda or working just within their function.
Melinda Albert: To start using data, a little bit more.
Melinda Albert: I think there's something really good to be said about seeing your peers and colleagues getting their hands on and going through the same process with you so that's why we thought this mission, this hackathon would be a really great.
Melinda Albert: Cross functional collaboration and networking opportunity to and you'll see as as I talked through what we did here this event was really targeted for anyone with any sort of experience level just to build their confidence within quota and with data.
Melinda Albert: Our event, it was a two day event we started off by bringing everyone together and the kickoff events.
Melinda Albert: We brought in a guest speaker from our parent company a VP of data and analytics there, and he talked to everyone got them energized and help them understand.
Melinda Albert: Even if you have absolutely no technical background that doesn't matter in today's world you still need to use the power of data in your organization's.
Melinda Albert: We also had a guest speaker come in from within Asp and she talked about her journey in learning and coretta and her process to set up her first dashboards how she learned it to really prove out kind of a small little case study.
Melinda Albert: To show everyone on on that kickoff call that it's it's absolutely possible doable for anyone in the org.
Melinda Albert: We did give a little bit of a incorporate a refresher for everyone, since again my users were super new coming into this and then we went through.
Melinda Albert: mechanics or logistics of the events team data assignments prompts competition roles i'll be talking to you about those items into more details we get through this.
Melinda Albert: After the kickoff event teams had 24 hours to go work and create their dashboards because, again, this was a competition event.
Melinda Albert: And all that work over the 24 hours led up to the day, two of the event, where all the teams came back together and presented their dashboards.
Melinda Albert: To a leadership panel and they they went through it we had some real time scoring happen, both with the leadership panel and by my in quarter team, and then there was a little bit of time for a debrief with leadership and then we pick the top three teams, with the best dashboards.
Melinda Albert: announce the winners and gave out some prizes to.
Melinda Albert: It if we look a little bit just at the participants that I had I had 65 different people working with us during this event, we had representation from around the world, which was was fantastic for us, because we are a global company.
Melinda Albert: seven different functions were represented and you see a significant number of are two participants really did not have much prior training within quota.
Melinda Albert: And there's definitely different levels of how often they use or consume dashboards so you can kind of keep this in mind, is I tell you about what we did.
Melinda Albert: Your your user base and might look a whole lot different perhaps they're much more mature, so you can kind of think about how you might kind of tailor or edit some of the ideas i'm presenting to you, to perhaps do this event in a way that's going to be the most impactful to your org.
Melinda Albert: We talked a little bit about the event preparation, now we did start inviting everyone about a month prior to the actual events, and one thing that we thought.
Melinda Albert: really worked well for us as part of the rsvp process, we included a survey, where we collected data on the participants level.
Melinda Albert: of comfort and use it within quarter and.
Melinda Albert: What they've done for training in the past with us because early even earlier in the year, my team rolled out about seven or eight different training courses.
Melinda Albert: And then some tactical information around you know what department, are they in what region are they in.
Melinda Albert: because all that was really important to us because we did decide that we wanted to formulate the teams ourselves and pre assigned those teams.
Melinda Albert: We aimed for about four to six TEAM members together, I would recommend definitely not to go over those six members, otherwise the groups kind of get too big to work together.
Melinda Albert: Of course we come try to accommodate similar working hours, so if they were within region together we tried to those folks together.
Melinda Albert: And then we really purposely wanted to create a create cross functional teams, so people could learn from each other.
Melinda Albert: And we wanted to belt balance out the different skill levels we didn't want a team that was all novices.
Melinda Albert: So we definitely try to take that into consideration when we reform those teams and then we we did introduce these teams together.
Melinda Albert: But one week prior to the event, and that was purposeful because the 24 hour working period that we provided to them after the kickoff event.
Melinda Albert: It was really up to the teams to decide how they wanted to utilize their time you know we recognize that because.
Melinda Albert: we're global in nature, not everyone would be working immediately after the kickoff Maybe it was the very end of their day and they need to come back together, so it was important that we get the teams introduced and set up some time together even prior to the event to prepare themselves.
Melinda Albert: And for the competition data sets we were really intentional in the way that we curated the data sets for the competition.
Melinda Albert: it's really important to us that we picked data that could be easily understood by anyone in the business, I think this was a key part of our success.
Melinda Albert: We avoided anything that required super specific domain expertise to understand or to interpret the data, and so we took some you know some basic kind of.
Melinda Albert: product sales information some very basic financial information stuff that anyone that's worked in our company would be able to understand.
Melinda Albert: And when we curated these data sets we put them each their own separate business schema.
Melinda Albert: And I point this out because we wanted to ensure that this event was all about building dashboards and digesting understanding data it wasn't it wasn't supposed to be someone hunting down try to find the different pieces of information, so those are some key things to keep in mind.
Melinda Albert: As far as how we divvy these up we assigned about four to five teams to each of these three different data sets because we want to avoid having over the repetitive presentations to our leadership panel, we want to make sure there was a good variety.
Melinda Albert: We did give some prompt ideas in our kickoff about the different types of questions or analyses that could be performed with each of the data sets.
Melinda Albert: But we did leave it pretty open ended for the teams decide where they want to focus their dashboards on that they were creating.
Melinda Albert: And then we did have a variety of different resources and support available and i'm going to tell you a little bit more about that.
Melinda Albert: When I described how we did that day of hosting for that 24 hour period we did have live support available, the entire time.
Melinda Albert: kind of like a help hotline that any of the teams could dial into an access, one of my team Members, I am fortunate enough to have a team that does operate.
Melinda Albert: 24 seven so we were able to you know really accommodate all those different time zones that we had participants in.
Melinda Albert: And we did create workspace in in court, this is another just tactical item that made it a lot more effective for us.
Melinda Albert: We just created a folder inside in quarter for the hackathon each team also got its own sub folder so if someone called it, you know for team number four and said hey i'm really stuck on this one area Can you help me.
Melinda Albert: My team could go right there to the workspace be able to understand all the different work products that they were creating help them troubleshoot and resolve any other problems.
Melinda Albert: All this information, we did put on to a really simple sharepoint website on our Intranet.
Melinda Albert: This was highly used by all the participants had every piece of information they they needed about those data sets all the competition rules.
Melinda Albert: How to reference guides and leads to other pieces of information that could help them.
Melinda Albert: The really big purpose and takeaway here is, we wanted to make sure that participants never felt stuck or stranded at any point.
Melinda Albert: Because again a bunch of new users, we didn't want them scratching their heads and getting really frustrated definitely not the point of the event to have them feeling that way.
Melinda Albert: As far as the competition rules very simple and straightforward, for us, the teams were tasked to build just one single dashboard in accordance with their assigned data sets.
Melinda Albert: They could have as many tabs and insights as they wanted to provide a really thorough analysis.
Melinda Albert: And, but to me when the most important things is that no other materials were to be used as part of the presentation.
Melinda Albert: Everything had to be in that dashboard alone yeah no slides no PowerPoint here for part of this is all about focusing on what can you build inside in quarter.
Melinda Albert: And the teams had five minutes to present these dashboards on that day to when we came back together and they were allowed to focus in any area that they wanted it's a really, really simple for them to understand what they were charged to.
Melinda Albert: In terms of scoring the the real big message here is we structured this in a way to emphasize the lessons we wanted participants to gain from the event.
Melinda Albert: Knowing that we had so many new users, we thought that this weighted score approach would help bring them a little bit more comfort and make them feel like this is a little bit more achievable for them.
Melinda Albert: So we said okay 60% of your score is really going to go towards kind of data analysis just how thoughtful and thorough, where you analyze the problem.
Melinda Albert: How well, did you address the problem statement that you set out for your team to address and then 40% was lean what we call a little bit more technical.
Melinda Albert: And that was more about how well, did you utilize them quarter, did you did your visualizations actually enhance the way that we can understand the way that you address the problem.
Melinda Albert: And we use these uh these rubrics again the participants had access to them prior We talked through this in the kickoff it was there, an Intranet sites and we went through our scoring very easily we just set up a little excel workbook.
Melinda Albert: Each of my executives they had their own little tab as well as each one of my important TEAM members doings boring each had one of their tabs.
Melinda Albert: Real time we're able to put in there one through five rating for each of these different metrics on the rubric and in a single master worksheet on there, we were able to calculate immediately the scores for everyone, allowing us to announce the winners right away.
Melinda Albert: The event did go really well, it was our first one, you know my team we're all a little bit nervous about it because there's been nothing like this done before at Asp.
Melinda Albert: We we did send out a post survey post event survey to all the participants and there's a few things that I want to mention that that we saw here in those.
Melinda Albert: survey results, we were really happy to see that there is about over 55% of the participants reported that they felt very confident or extremely confident in the way that they were able to build their skills.
Melinda Albert: And still you know well that 42% so saying they're only somewhat confident so definitely some development areas still for some users they're.
Melinda Albert: really happy that around 96% said that they would join us again for another event so really positive feedback there.
Melinda Albert: One area where we saw a little bit more mixed results where we kind of took away that we should do some improvement next time with in terms of the the tools and the training that's provided.
Melinda Albert: For them beforehand so definitely recognize with a lot of new users, we probably should have done a little bit more structured training in the.
Melinda Albert: In the week or two leading up to the minute to prepare them but, overall, the participants loved it i've already been asked several times when is it going to be scheduled for next year.
Melinda Albert: Because they want to get more people involved with it bring more their TEAM members long because they had a really good time and.
Melinda Albert: The leadership group that came in judged it, they were super impressed with all the dashboards and how how thorough of analyses that could be developed by these teams in a 24 hour period, so all around the event did go really well.
Melinda Albert: I a few of our lessons learned kind of besides that point on a little bit more structure trading perhaps a week or two leading up to the event.
Melinda Albert: A few things that I want to share with you, and in terms of our data set prompts yeah I mentioned, we saw in the competition rules, the teams are allowed to pick anything that they wanted.
Melinda Albert: To try to answer that actually proved out to be a little bit of a struggle for the teams so.
Melinda Albert: Next time we're going to be narrowing down the available data set for the competition, a little bit more.
Melinda Albert: and be a little bit more intentional, but the specific prompts that we give to the teams, so that way they aren't spending too much time just trying to decide amongst themselves, but to focus on is getting that.
Melinda Albert: For us really wasn't the purpose of the event and the thing that we wanted them to take away, so we will definitely be more specific in terms of the data sets and the prompts next time.
Melinda Albert: Again it kind of a theme here is maybe too much flexibility was offered to the to the participants.
Melinda Albert: Second thing here is the time that they got to work on their own, we did hear some feedback that they felt they didn't know where to start.
Melinda Albert: And they needed a little bit more structured in a recommended detailed agenda for them to to utilize during the working session so we definitely plan on giving some more guidance.
Melinda Albert: We did already speak to some of the teams that were more successful throughout the event see how that how they laid out their time you know they time box themselves to only about.
Melinda Albert: 2030 minutes in the beginning for everyone to emulate different parts, the data set.
Melinda Albert: They picked something to focus on right away, and then got to work on the dashboard and kind of divided up by different tabs or insights that you know one or two people would work on together and have little checkpoints.
Melinda Albert: To come back in to touch base with the other TEAM members about every hour so we'll be providing them some more structure there.
Melinda Albert: And then, lastly, for the final presentations you know, for us, I was limited to only 90 minutes, with our leadership team, and we did have about 1213 teams participating, and so it did go wham Bam.
Melinda Albert: One presentation to the next, using that kind of five minute time limit and I definitely next time i'm going to look for a little bit more time for my leadership group there.
Melinda Albert: Because it would have been much better for us to be able to allow you know, three to five minutes after each presentation for the judging panel to actually ask some questions to the team about their final presentations.
Melinda Albert: Because the way that we structured it the only time the leadership team got to kind of say anything back to the participants with at that very end the debrief and they kind of spoke to everyone kind of holistically.
Melinda Albert: given some general feedback and and praise on on the work that they did.
Melinda Albert: And then, if you do have any sort of event you've done like this, and for us we're going to be able to leverage what we did this past year, but definitely.
Melinda Albert: Teams would benefit from being given some sort of an example of a really effective final presentation to really learn the best way to build their dashboard in envisioning what that final presentation is going to look like.
Melinda Albert: But, overall, we were super happy with event it definitely had a really strong impact.
Melinda Albert: Within the organization and we've gotten a whole lot of new users and I think a part of really building adoption isn't just about having you know one person begin to use it.
Melinda Albert: it's folks that have feel energized about it, you know they left this event feeling really excited about doing data analysis about using in quarter.
Melinda Albert: And then of course kind of has a trickle effect on the organization anyone else that they work with, so it gave them something to talk about with their peers and we've seen an uptick in our adoption and we're thrilled to be able to do this again next year.
Melinda Albert: So i'll stop there, and matson the see if there's any questions.
Mazen Arar: yeah well, thank you Melinda it looks like you really get the chat That said, all lit up like Christmas tree seven look at it and boom everybody was asking questions, and I see one question it's like did you guys have prizes for the winners.
Melinda Albert: We did have prizes to the winner, so we took the top three teams based on that scoring rubric and we gave out gift cards for each of those teams.
Mazen Arar: Okay, that is, that is very cool usually those are the best Presidents, especially now around the holidays right.
Mazen Arar: yeah I mean, let me tell you this, you really got our interest and the minute you did that draft last time I mean or the the review last time.
Mazen Arar: We went back internally and discuss it we love the idea, and as you see from the chat between Matthew and everyone else, everyone is getting creative with what else can we do with it, but, but this is great.
Mazen Arar: To to create awareness within the company, the question is for everyone, I guess.
Mazen Arar: How did you promote it within the executives, how did you get this project approved because because you got fewer resources, working with you on it, plus you got other participants, and so this is quite a few people how did you get the buy in from your.
Melinda Albert: Great question so.
Melinda Albert: So for this and I don't I actually I did not ask, I did not ask if we could do this event I joined, one of our leadership IT staff meetings and.
Melinda Albert: I had a little bit of time with them and said hey I am going to do this event here's the reasons why kind of like I told you in the beginning we've got.
Melinda Albert: A lot of untapped potential my team is going to do this event, I would love your supports and they didn't have to make a decision, which I think there's a release for our executives there.
Melinda Albert: And they said, this is actually really interesting, and this is really cool so luckily I did not have to deal with any sort of.
Melinda Albert: Opposition to do it, I got their support right away once I had our executive support I did work with each of them to.
Melinda Albert: kind of present it within their departments and their key managers and leaders within each of the departments, so it kind of naturally kind of cascaded down there.
Melinda Albert: But we definitely did I felt like I was going on a road show.
Melinda Albert: talking to each of the departments explaining with event would be like asking for them to support their employees to allow them to have.
Melinda Albert: This time away from their regular responsibilities to participate with us and they were so much of a need within our organization.
Melinda Albert: And so I think if the need is out there in your organization to improve adoption of the bi tool improved data analytics which I think is a need, we all, we all have I think you're going to see that progress very organically.
Mazen Arar: I see I see, and this is this is great yeah I think it's well needed.
Mazen Arar: mark here a friend mark page as question he's assuming that you secured the folders by shared access right.
Melinda Albert: Yes, we did manage everything through user group so we put everyone that rsvp into the event into their own.
Melinda Albert: group security role group inside and quarter and then that is how we manage through assigning all those folders and the business schemas with the data set prompts so all the regular in quarter tools and functionality.
Mazen Arar: Excellent excellent any any other questions for Melinda.
Mazen Arar: All right, perfect Thank you guys.
Melinda Albert: Fantastic Thank you.
Mazen Arar: So much melody I appreciate it.
Mazen Arar: So I guess next topic, let me introduce mark page he's an mvp it software development chief application architects from G gc services.
Mazen Arar: is going to be talking to us about automating call Center reports in with in quarter mark go ahead start sharing, please, and you can get to a presentation started.
Mazen Arar: Your unmute mark.
Marc Paige: Sorry, when I share the screen and move the thing owner, so I can find the unmute button less.
Mazen Arar: Possible what happens to me.
Marc Paige: Go ahead but yeah.
Marc Paige: So basically i'm the Vice President of a software development and chief architect at gc but one of my other roles is to I brought in the quarter data platform.
Marc Paige: About three and a half years ago and it's been a very interesting experience to go through, and one of the things that we had to try and do for this was to provide for the concept of.
Marc Paige: yeah every go sorry automating the call Center and providing analytics and direction for operations gc uses in quarter for gathering a bunch of different information but primary for third party collections so with that we had bi.
Marc Paige: Bi means before encarta little artists ours comical it's not real but basically we had data that we're everywhere right we we had people who were using localized information that they had from.
Marc Paige: places that they extracted information, who knows where and there was no real centralized aspect of where that was coming from.
Marc Paige: There was no governance, so there was no protect protection of privacy or any type of.
Marc Paige: Security type of information, it was just whatever anybody could get and then they would put it into spreadsheets and then those spreadsheets would become variance.
Marc Paige: Much like the viruses of today once you had a spreadsheet that was stored off of somebody local drive, they would do their own thing to it and then share that around.
Marc Paige: So we had these variants arise and the security issues, of course, to we had information that was coming from again with no governance, we have no idea who was bringing out.
Marc Paige: Various data from various clients and then spreading it around through email or or going through various networks to be able to get there.
Marc Paige: So, and that led to the next problem, which was essentially the physical distributions oftentimes there were spreadsheets that I were seeing for people that had 30 to 35 meg's per spreadsheet.
Marc Paige: sent on an email distribution group with 150 people.
Marc Paige: So this This obviously became a big issue for us and we needed to get to the point where we were no longer doing that type of thing for for folks that were sharing it across the email and.
Marc Paige: Again, all of these issues that we're going through and, of course, the local a local storage meant that whatever data that was static Lee stored in that spreadsheet or in whatever reporting fall they had became obsolete as soon as they stored it so.
Marc Paige: The the graphic here added by our friends here in accord I keep calm i've got a spreadsheet for that, yes, of course, keep just grin on it doesn't matter don't worry about the man behind the curtain.
Marc Paige: So, after a quarter that's Ai now and repurpose not artificial intelligence it's after.
Marc Paige: We had centralized data I pulled everything into the data platform, including reference data that they had to.
Marc Paige: From these local field offices that were in spreadsheets that were references that they wanted to have and we basically made a promotion of those local references to enterprise level so bringing those into a quarter.
Marc Paige: force the hand of some of those folks that were arguing about correct reference data and by reference i'm talking about code descriptions status code descriptions.
Marc Paige: Access membership type of things things that were basically localized into each individual office and they had their own local bias or interpretation about what's going on there.
Marc Paige: To be able to get there, so we have the need to be able to to do that promotion essentially at the localized data to the enterprise level.
Marc Paige: And then the next aspect was the sharing we knew that we had to be able to get central sharing the the access between and quota and.
Marc Paige: spreadsheets because I knew spreadsheets where it's going away and, of course, access and now i'm going to go into a little more detail on each one of these.
Marc Paige: So, as I mentioned in centralizing data, the call Center sources were from everywhere we had people who are getting things from people saw from websites and.
Marc Paige: From collection activity and all these different areas were a problem so.
Marc Paige: Providing it into in court and the data platform, giving us the ability to bring this all into one huge virtualized data lake into the data platform itself with the appropriate data modeling to bring the joints together.
Marc Paige: which involved a couple of twists of the hand or sleight of hand in creating some new functional columns inside the data.
Marc Paige: Some places would have, for example, an employee ID that was in a string form of the leading zero.
Marc Paige: Other systems without the employee ID as a as a long or as an integer without the leading zero so in order to do the proper joints to bring data together, creating those functional.
Marc Paige: fields that did the appropriate translation and then using those functional fields, to be able to provide that join was where we did that, so there was some interesting activity that happened along that way.
Marc Paige: As I mentioned that the excel references in text references, one of the things that I have to do make sure is that.
Marc Paige: If you're not authorized to see a specific client data you're not allowed to do that, and I know Joe mentioned earlier in his talk about next.
Marc Paige: The next session is going to be about rowan level security role and field level security well that's exactly what i'm using is the row level security using secure runtime security filters.
Marc Paige: and active directory security groups which are pulled from a list of security groups that are defined for each individual client.
Marc Paige: So those folks that are allowed to see those clients are inside that active directory group.
Marc Paige: And then that active directory group is synchronized back into according to security groups, and then the security groups are used with session variables to do the appropriate runtime filters to make sure that they only see the road data they're allowed to see.
Marc Paige: client agent rosters is something that is not well controlled and has to be made up to date, and this is where a lot of local biased excel spreadsheets came into play.
Marc Paige: Because peoplesoft wasn't updated for who was working under which client, but they kept a spreadsheet for that, so I leverage that by bringing in those rosters into my quarter.
Marc Paige: And then, using that again with session variables and joins to be able to get the appropriate type of filtering on the dashboards.
Marc Paige: I needed to have the ability to go down to the hour and I also wanted to be able to show civilian times versus.
Marc Paige: Military times, so I extended the date and time schema that came out of the box, with a quarter to include an hours and minutes of the day.
Marc Paige: And what this allows me to do is to do much more granular time based analytics and dashboards and insights.
Marc Paige: Based off of this information and by by taking timestamp information and using the built in functionality, with a quarter for hour and minute so forth.
Marc Paige: Joining that back to my new our table inside the daytime schema I was able to provide things by the hour so called activity in and for productivity by the hour when inbound calls happen outbound calls happen, etc.
Marc Paige: Special collections, like the New York City zip codes you'd be amazed that there is no centralized source for being able to find all the zip codes that covered New York City.
Marc Paige: Try and Sunday just see if you can find a single source that has that, but you can just pull down in one place.
Marc Paige: it's it's no simple task so we had to have that agreement, this is one of those biases that came in and we had to do a thing that was their competitive data coming in from spreadsheets again that was just another place to bring it in for providing dashboards that are more centralized.
Marc Paige: So I mentioned localize the local the enterprise.
Marc Paige: I have my local experts as I talked about and making sure that we had everybody who understood that they were local and we wanted to eliminate those local biases.
Marc Paige: and bring them into that enterprise level, so we brought everything into the platform and that forced them to have to look at it from an enterprise perspective.
Marc Paige: I talked about sharing the land to borrow from the famous poem they would not go gently so.
Marc Paige: That became one of the aspects that was a realization that there is no big bang here i'm not going to get rid of spreadsheets I have to make sure that I support spreadsheets as well as.
Marc Paige: transitioning them slowly more and more to the point where we get to in court, as the first place that they want to go look.
Marc Paige: I mentioned the row level security that is a powerful tool as an incentive to plug that security hole that I mentioned in the beginning.
Marc Paige: If i've got users who are sharing data across their email, and we really don't have good governance on that.
Marc Paige: By by making them come in through the platform and providing common enterprise level dashboards row level security gives the executives and the operations managers that level of comfort that they know that their data are not being shared across people who shouldn't see it.
Marc Paige: And of course spreadsheets are all supported by a quarter, both in ingestion and as well as.
Marc Paige: Exploiting.
Marc Paige: Though I mentioned the reference tabs inside of the year and then the other aspect of it was the latency day older older data is now updated by spreadsheets.
Marc Paige: databases that are providing the source of data they were getting out of either the collection system.
Marc Paige: or through a data warehouse and that's being updated on the hour instead of 123 days, sometimes weeks, and in some cases actually there the data we get from competitive data is a month old, so this provides them with a better way of understanding the latency.
Marc Paige: Access sso and all that we did sso the old fashioned way before I learned that ssl was now something that can be done and i'm looking to take advantage of that going forward with the newer versions we're on 5.0 Point two.
Marc Paige: But we did it through the arcane l that scripts on on Linux to be able to get there.
Marc Paige: Any groups are defining what I have for my teams, so that makes it easier for my security teams to be able to do administration, instead of using another tool.
Marc Paige: Going into according to define security groups and access we define the Ad groups inside active directory and then use active directory synchronization to bring in the users and the groups in there.
Marc Paige: And then those groups as Melinda had prior answered my question we use those to secure the production folders on our production tenant.
Marc Paige: To make sure that only the right folks are seeing the right dashboards and that's an addition to the real level security that that also comes into play.
Marc Paige: scheduling html dashboards again was another big deal because, again, it was a relying on people emailing each.
Marc Paige: excel spreadsheets out and it was at the whim of the localized experts to be able to get there, providing a scheduled ability to deliver those dashboards.
Marc Paige: was also a benefit, and just as a personal point of pro tip here one of the original things that I had when the early versions you didn't have the tabs what you would end up doing is usually using a drill down to another dashboard to get to detail.
Marc Paige: Using tabs However, after the first experience of trying to load an email with a static html have a detailed grid that had 54,000 rows I think and the email system saying you want me to show you what.
Marc Paige: That became a problem so by using the tabs and putting the detail on a tab and then only scheduling to export summary tab.
Marc Paige: That became a big aspect so thinking about how the static html needs to load in incognito to me was a lesson learned and i'd share that as a just a general tip for anyone who hasn't already encountered that.
Marc Paige: We use data alerts as well, so data alerts are also an important aspect because of my operations used everywhere, asking, I want to only know when this particular condition happens and in court, a does that extremely well.
Marc Paige: Back to row level security again, as you can tell security is a very important topic for us.
Marc Paige: And then the big thing was we were able to reduce the email storage, because now they're linking to a website and getting to their if they bring down a day.
Marc Paige: dashboard or a grid into a spreadsheet on their own machine that's their problem, but the enterprise email storage as reduced because we're not sharing these megabytes of spreadsheets across the entire system.
Marc Paige: So, for those of you who are galaxy quest fans on Ted on so that's our goal is to continue to expand and create more.
Marc Paige: Adoption of in quarter throughout the entire enterprise i've got more departments, who are looking at things, and these are the basic tops that we're going to go through, so you know.
Marc Paige: Expanding more local exports getting them in and I love the idea of the data hackathon i'm going to bring that back to my my managers and and we're gonna we're going to design one I think that's a great idea.
Marc Paige: expand for other corporate departments, as I talked about machine learning is def definitely has a place in third party collections categorization of accounts and collectibility is a very big topic again has been for decades and then, of course, as the default.
Marc Paige: So that's that's where I am any questions that came into play, I probably spoke quickly and I tend to do that, but open to anything that anybody has.
Mazen Arar: So just like what we thought mark, there is, if you could talk to us about the bi and Ai acronyms I knew somebody would comment on that.
Marc Paige: yeah basically as we were talking through my slides initially that was one of the first things that I thought of when I was looking at is like well I had before, and quarter and then I just said in my mind, but that's bi oh wait that's a nice double entendre.
Marc Paige: Business intelligence is is no no before in quarter that's VI and then Ai well now we're being smart we're using our intelligence what's after quarter.
Mazen Arar: yeah no I love it so Matthew this is for you probably the bi before encoded and after in court, we really need to get that started.
Mazen Arar: And we get me we, I guess, we need to get it registered in our name before mark does.
Mazen Arar: All right, anybody has any questions for mark.
Mazen Arar: Okay excellent Thank you everyone, I really, really appreciate it mark, thank you.
Mazen Arar: And I guess.
Mazen Arar: Next, I would like to introduce to you guys and the rog from core that he will be talking about the upcoming new feature include the sequel views and the rog you're on my friend.
Anurag: and
Anurag: And Actually, this is not, I wanted to do, let me go back here, this is ranks right select this.
Mazen Arar: yep we are.
Anurag: and advising them guiding them how they can solve those business use case now in my experience, most of those use cases can be done pretty easily within quarter.
Anurag: And also create all the tables in the back in in court if table does not exist in gotta create that table all you need to do is just run that Oracle sequel give that as input and to run behind the scenes, create all the tables fear sequel you load data and start analyzing that data.
Anurag: And default is five.
Anurag: And first part in that email will be okay, we want to know how to solve this business use case it's a very complex question I want to ask from the data set, but please, please don't give me any solution which is MB based because I already know how to do that, using me.
Anurag: And I can run this query here, and this is running again that's equal yellow snow that business view can be used in any of these crazy and then on the square right.
Anurag: And I hope that very soon, you will get access to this and you will see what it's capable of doing so, this is the agenda.
Anurag: And in business schema let's create a.
Anurag: And just complex questions, maybe like 10 to 20 30% of all the question you want to ask from your data.
Anurag: And last one here is is my favorite this this was what this does is it allows you to use presentation variable in sequel view so I can define the presentation variable in a dashboard.
Anurag: And let's save this.
Anurag: and make it different right and make it smaller than equal to less than equals right.
Anurag: and run that tool that we have it's a script run that script and it will just convert that Oracle sequel into sequel view.
Anurag: and save this.
Anurag: And since you have the ability to use presentation valuable, we can filter that data Center where clause, along with that query, so there are 10 billion records, maybe output of that query will be like few million records and analyze that information.
Anurag: And then got a dashboard when you create two different types of insights, especially when you create the aggregated table and other insights which are based on aggregated data what you're doing is.
Anurag: And then maybe I should have made it mandatory, but I can go again like this.
Anurag: And then streaming.
Anurag: And this, if you look at the query plan here, this is a query plan, right now, this business you that i've created here this flat view.
Anurag: and use that in the where clause and sequel view so what that means is the query that in caught a sequel will send to the to that data set.
Anurag: And what are the use case where you can take advantage of sequel we'll go over that quick DEMO and then, if we have time we'll have you on as.
Anurag: And when I say advanced analytics and encarta you already have all these joins defined.
Anurag: And, and someone confirm and the slideshow that you're looking at in court Hello.
Anurag: Be this is this is this is important here today, the last thing that I added here, give me average sales for each product per day.
Anurag: Because you're already done a very hard work of bringing in data from different sources and encarta and business user or even it VI developer report developer has access to all that data set.
Anurag: Before I give you a quick overview about what sequel viewers, I just want to quickly touch base on in court, a sequel engine, because that is the foundation on top of which we have built a feature.
Anurag: Between these tables and we run a query against all of these tables in in court, all of us know that query is going to perform in sub second a few seconds it's an incredibly powerful one quarter can do with like.
Anurag: But as soon as you do that, you lose the ability to slice and dice that data and that's where I think sequel view can address some of those scenarios.
Anurag: But at times you get stuck and you say Okay, how do I answer this question i'm not able to do that and, and these are some of the scenarios where it's a little bit tricky within quarter to do that either use you create me.
Anurag: But beyond that.
Anurag: But there are 20 to 30% of the use case where we will either tell them no it's not possible to do that, within quarter or go and create and we metabolize view and then on top of that, you build a dashboard you built a dashboard to do that.
Anurag: But there are scenarios, where you already have all these joins Creator, you want to do some more advanced analytics On top of that.
Anurag: But this also gives you ability, because in sequel we can use presentation variable and filter data that means I can also.
Anurag: But you can also just have that query directly in business schema as a sequel view and then build a dashboard On top of that.
Anurag: Common table expression are using with claws if you're familiar with sequel we support that and that provides you that multi step reprocessing and coming to the final result, very important.
Anurag: Complex salting i've seen many times, because a formula that customers use and to solve that particular column they're not able to do that sequel you can solve that problem as well grand total for corner use case very useful here.
Anurag: Data blending modeling bridge table this is another use case where i'm working with one of our customers, where they have more than 200 Mbps they have modeled in in quarter to.
Anurag: Eight tables and eight plus joins just in simple skill can have like 20 plus joins as well, and the query works in like pretty awesome awesome performance right.
Anurag: follow a postgres sequel syntax and historical reason is, we have been supporting everyone for integration, using postgres connector because of that, we recommend that you use postgres sequel syntax when you write sequel.
Anurag: give you a good experience okay so so so so humble sequel views on that problem and before that what a sequel you so let's come to see me now.
Anurag: Group by product, this is your first really so by each product and date, you will get the total sales and top of that, you will run a query.
Anurag: Hello everyone, this is an Iraq Malik i'm the product manager in in quarter, and I am excited to present this new feature that will be coming in the product very soon in courtesy call me.
Anurag: I took more time than I was given, but with that, let me know if you have any question.
Anurag: I want to do that analysis for a particular region, you want to slice and dice this data by different dimensions.
Anurag: I want to do this let's bring in.
Anurag: I want to just do top and analysis here in this, I want to say okay show me the spirit table for top five top six top 10 categories by sales in each country.
Anurag: in court, a sequel engine is going to support that so, for example, all join types any joint I bet you want to use an encoder sequel you'll be able to do that very good let's have query.
Anurag: Is the schema and let's go ahead and create a newbie way to as equals Okay, so that is something I did very quickly, he will see a new entry here, create news.
Anurag: is to ability to answer, not only simple question from the data set, but also very complex question that you want to ask from your data set.
Anurag: It provides a sequel engine on top of encarta engine and it gives you the ability to write any type of sequel when I say anytime.
Anurag: It will filter that data output of sequel view will return a smaller smaller results that it means the performance of the dashboard and sequel view will be much better.
Anurag: it's available in in the latest cloud released today, if you want to follow that using tableau for va you should be able to do that.
Anurag: it's not going to work if you want to put that run that query and put that in a physical thing in MV analyzer table and then run query On top of that, every time to go back and modify that query doesn't.
Anurag: Join between those tables, because those J holiday access by the way, you can always call these tables and let new sequel engine execute the join.
Anurag: last one I don't spend much time on this, but essentially what this does is this is coming in future first really does include a sequel you will not have this.
Anurag: Let me share my screen.
Anurag: let's bring in subcategory.
Anurag: let's get some names right.
Anurag: let's save this folder and say.
Anurag: let's say top 20 and change this document here right, so you will see all these are blanks here, because for this country it's picking up.
Anurag: like this is getting the length of that so let's take this really now.
Anurag: Multi source very useful case because don't have to model that in the back end using schema you can model that using sequel time intelligence, give me any complex time intelligence scenario, you can do that with sequel you.
Anurag: New business schema that's a user group.
Anurag: Now for that there is a pretty simple and straightforward query here.
Anurag: Now if you're familiar with power via your tablo in part three, is a very powerful tax engine using which you can do some really cool advanced analytics and tablo you have led framework which is level of detail framework.
Anurag: Now let me take an example where there are scenarios, where you may have to run multiple queries to come to the final result.
Anurag: Now let's look at columns it has latest entry subcategory revenue and also ranks now let's click on export data and do that inside I was talking to you about let's do the pivot table here and for country and subcategory let's soda and children.
Anurag: Now next step is of course you can ask hundreds of questions from the data side data that using encoder dashboard.
Anurag: Now there are few features, we have already built on top of importer sequel engine first one that we introduced was a sequel table.
Anurag: Now this example I took let's make it more complex, I want to do that analysis for top 20 products, I want to do that analysis for a particular year or 40 particular quarter or months in a year.
Anurag: Now why this is important, I want to do a simple analysis now, which is, let me just quickly show you what I wanted to use in sequel.
Anurag: Now, also, I think.
Anurag: Now, hard work is to bring in all that data and and keep that data refresh it's very difficult to do that, but within quarter, we all long it's pretty easy pretty straightforward and you gotta shines in that area.
Anurag: Now, having done that many times when I receive sometimes I receive emails from some of these users.
Anurag: Now, this is a very simple pivot table is showing me bunch of countries here and the top all the subcategories they are maybe like 20% categories and then showing the revenue.
Anurag: Now, what a sequel view.
Anurag: Now, when you using quarter dashboard one of the limitation is, let me just put some iron talk about this, so that you can appreciate the power of sequel view when I show you the DEMO.
Anurag: Of in my experience i've been fortunate are lucky enough to have attended hundreds of sessions with various in quarter customers listening to their business use case.
Anurag: OK so again, these are some of the use cases that I have been trying with sequel view and based on again my experience working with customers and different scenarios that they were trying to use and and do, and then they were having issues.
Anurag: OK, enough of.
Anurag: Okay, my use case is pretty simple, I just want to show you how to create sequel view so and use that in encoder so one more thing I want to just touch base really quickly, this is a very simple schema.
Anurag: Okay, so pivot table the sequel link is not here, it will come soon we are enabling that in the next release, but it will show up there and we'll be able to see that query as well for this, but if I change this to, for example, aggregated table.
Anurag: Okay, so these are just some bullet points about what sequel years you can of course read any of these, you will have access to the slides, but let me give you my take on what sequel years and.
Anurag: Okay, there you go, I have this very simple pivot table now, I want to slice and dice this data or.
Anurag: plan is to buy have this available in the cloud in quarter cloud by February, if you get early access to this one practice more than happy to share a cloud environment with you, and you can fight there yeah this will be a left feature, to start with, maybe after one or two release.
Anurag: primary objective of any bi tool.
Anurag: record, you will have the ability to send that query to park your files directly data is not loaded in memories let's say you have a table with 10 billion records.
Anurag: Right in each country in each country that is important in each country pick up top 10 category subcategory or top five or top N and then update this pivot table with that.
Anurag: Right so see this is default a spice less than equal to five showing you only have five subcategories now I can change this to any other value.
Anurag: Right, this is the schema name, and this is sales flat I can now use this in sequel directly, so I don't have to worry about defining.
Anurag: See the data by top and categories subcategories because this is showing me all of these categories, but what I want to do is for each country, I just want to show like top five subcategories all I need to do is just go back here bring in ranking prompts.
Anurag: sequel that is that these tools will Center in court will take advantage of other advanced in court, a sequel engine.
Anurag: sequel view can direct that query to park a using spark sequel and get the result back.
Anurag: sequel we overview let's see this in action.
Anurag: So example here is for for folks to understand what I mean by running multiple queries Let me take a simple example and try to explain this to you let the question you want to ask from your data centers give me every sales for each product.
Anurag: So in the front clause i'm using this query Let me run this query here, which is select country subcategory and some of revenue from this.
Anurag: So let me show you the simple sql here, so this is schema name table in view name, so I, but here i'm connecting to the same quarter instance i'm using right.
Anurag: So query here is not like you drag product and do average sales, that will be average sale for each transactions, because each day for each product, you can have hundreds of transactions so that's not dancer but that that's not you that's not how you will define your query.
Anurag: So that's what take existing sequel query and use it in sequel view to analyze data we have other project going on, which is equal automation you can take Oracle sequel.
Anurag: So this cannot be done in a quarter today using even rank function, because I can just request running query or query right, you can show the rank in a column here, but you can't use that rank as a problem filter.
Anurag: So this feature has been there in in quarter for a while now, and which has been called a sequel engine What it does is.
Anurag: So this in a nutshell, what sequel view is.
Anurag: So this is a bottleneck when the reason I say bottleneck is I encounter dashboard I can run one query and show the result, but I have to run multiple queries on my data side to come to the final result, I need to cure a beta.
Anurag: So this is by the way this dashboard is interacting with sequel view and I can click on this and I also see the query that it's generating.
Anurag: So this is one simple example of running multiple queries to get the final result can do that today and in quarter dashboard for that you have to puree data and then run second query on top of curated data.
Anurag: So this is show you in DEMO how you can create a sequel view but sequel view is built on top of this new encarta sequel engine that we have introduced this other feature, we have built on top of that, and future, you will see a lot more features coming on top of.
Anurag: So this is there a sequel view is going to address some of those use cases that you can solve with this feature.
Anurag: So to overcome some of those limitations, we are, we have already introduced in quarter sequel and gentle touch base on that what it is and then talk about what a sequel view.
Anurag: So, having a business view and then running sequel you on top of that will get more value for your money.
Anurag: So.
Anurag: So.
Anurag: Testing this feature using this feature for last five or six months and.
Anurag: That is built on top of encarta sequel engine and also tablo and power via integration now can take advantage of this new sequel engine What that means is when you connect tablo or power VI live are using direct query using power bi.
Anurag: that's how the system this use case here number one use case where you will see sequel we will add a lot of lot of.
Anurag: that's where you get stuck and when I say multiple queries in this case, in that case you the output of first query some time you have to materialize using either in court on laser table or envy and, on top of that, you run another query in encounter dashboard.
Anurag: The kitchen from Berlin Ben is this release coming so.
Anurag: The reason i'm showing you this is the sequel it also helps you in debug and also understand how this this is working so under sequel, you will notice that, in the class, this is the sequel query that you see here on top of that inside.
Anurag: They are advanced feature in any sequel that you will expect or even simple features, we will expect in any sequel engine.
Anurag: they're like probably hundreds of columns those are very simple schema but hundreds and hundreds of columns in this template tables or eight plus tables.
Anurag: Third, one here common table expression CTE where you can use with claws create temp table within sequel multiple timetables and write a final sequel to use all of those timetable to convert the final result.
Anurag: This encarta sequel engine sequel we just one of that feature.
Anurag: This is a very simple example of running multiple queries you come to the final result.
Anurag: This is not under top 20 but this one is under top 20 right so that's what for Denmark researcher any value for this right so slicing and dicing data using this becomes very simple, if you do something like this.
Anurag: This is where, in quarter view is going to shine because I just give you example of running one query and then running other query On top of that, in court, a sequel view is going to handle.
Anurag: This one is important, referred to in quarter functions and sequel most of you know that we.
Anurag: Use cases where you can run multiple queries and then run final query on top of those queries and come to the final result that's where earlier when I talked about CT.
Anurag: Using that you can do some really cool advanced analytics sequel view is also going to provide you that and caught a platform something similar where bring in any kind of advanced analytics you want to do in in court and slice and dice the data to be able to do that to sequel we.
Anurag: value when using quarter platform is advanced analytics analytics because just having access to windows function in sequel.
Anurag: Variable say select product average sales grew by product that the second query and output of that you will show in the dashboard.
Anurag: very powerful in quarter sequel support that as well, support for analytics function all the windows function that you can use to do some advanced analytics we support that now.
Anurag: view that I just defined shows me this now using windows function i'm partitioning by country and for each country, give me rank for the subcategory this is that very.
Anurag: We have depth in depth been working on quarter sequel engine for a while and most of you have been using in court are familiar.
Anurag: What i've done here is i've another business schema and I have just dragged and dropped some column from that scheme I just I showed you.
Anurag: What that means is some other queries which we're going to spark earlier, they will not go to spark sequel engine will handle those queries and you will see tremendous improvement in performance when you use that book.
Anurag: What what power it brings in court, a platform.
Anurag: When I say very soon, maybe looking at one or two months, and this is my favorite feature i've been.
Anurag: When you have to do a little bit of advanced analytics.
Anurag: When you.
Anurag: Which is to QA data which is building you're adding more data and putting a little bit little bit more stress on the loader servers to create those new tables and then answering this question in the dashboard.
Anurag: Which is to solve this particular question to get the correct answer first query that you will run is select product comma date comma some of sales.
Anurag: will give you the ability to do top and kind of analysis running total today, you can do it in court, but if you want to use that again another formula can do that this will allow you to that lead lag move moving average all of these are very useful.
Anurag: With how in quarter work how direct data mapping works and what are the limitations, when you query that data, especially when you create those joins between tables and encarta the joint types are only left auto join, but other join you try to simulate in dashboard.
Anurag: write a complex query and then get the results and those which table need to be joining other tables and do that so in court, a sequel table can be used to model which table today you have access to that.
Anurag: y is equal, and when you click on this, you will get the sequel editor you can type in that query here, you can also executive see the result here preview the results and save it and.
Anurag: yeah yeah so this will be on Prem because so so that these will work with ashwin to figure out what the Jews will be, but you will also.
Anurag: yeah yeah you can use presentation variable in the query, and that makes it very powerful, especially for slicing and dicing data, you can have like different than just invaluable available in the dashboard and sequel view will refer to the presentation variable to filter it.
Anurag: You already have access to that it has been there from last two or three releases it's still a laugh feature hopefully by January or February next year, it will will remove the Left feature from there, it will be available, it will be GA.
Mazen Arar: yeah and I think you're doing finally time still have a couple more minutes so you're good.
Mazen Arar: Any questions for everyone.
Anurag: You are running a query on top of tables which already exist in memory you're not running a query which is simple aggregated query and output of that query you are showing an encoder dashboard and different insights right pretty straightforward.
Anurag: You can create in business schema and you can use that in in quarter dashboard and when you run that in quarter dashboard and run that sequel view and output of that will be used to show data in quarter dashboard very simple pretty straightforward concept.
Mazen Arar: Yes, it has a question before that is this going to be on Prem as well.
Anurag: You don't want to load all of that data in memory just be there in Parker file.
Mazen Arar: Okay, and so this is planned for q1 right of.
Mazen Arar: yeah excellent excellent okay.
Mazen Arar: Thank you, and I think this will make life much easier for for everyone.
Mazen Arar: can't wait for that feature to be out.
Mazen Arar: let's see mark has a question presentation value in a query I think that's what you said right and.
Anurag: You have hundreds of functions and in quarter dashboard that you can use within quarter sequel you will be able to take advantage of that whatever knowledge, you have because you already know those functions you'll be able to use most of those functions and in court as equal as well.
Mazen Arar: All right, thank you so much really appreciate it, and with that said next next topic would be.
Mazen Arar: Chris from encoder Mohammed Prince, he will be presenting a new feature highlight in quarter component SDK Prince go ahead, please.
Mohamed ElPrince: This is Muhammad friends from.
Mohamed ElPrince: Senior product manager botha and since i've started working code, eight years ago and there, there is a single customer, as that is coming again and again, which is new visualizations because.
Mohamed ElPrince: This, this is a very common asking.
Mohamed ElPrince: Even if we if we add more there's there's a lot more to add the realization and.
Mohamed ElPrince: Keep.
Mohamed ElPrince: There are a lot and a lot of.
Mohamed ElPrince: there's too much to add and visualization so what we're working with thought is that we will depend on a dynamic content, instead of hard coded content and we are introducing.
Mohamed ElPrince: A component, as the so on the agenda we have that will introduce the component SDK that component marketplace and once they're in the beta version coming in the police and we'll DEMO the.
Mohamed ElPrince: SDK and the marketplace central us on some things that we, that is there for the markets, so what is the component, as the key.
Mohamed ElPrince: component is the key is that development get for developers.
Mohamed ElPrince: To build and then has the product, and this way it will leverage available skills in the Community to contribute to encode, and this also will allow.
Mohamed ElPrince: You to build more personalized and specific components to your own business and also will allow us to deliver components much, much faster than ever before Okay, what are components components are.
Mohamed ElPrince: That are like I said dynamic content that will introduce in in kota instead of having hard coded.
Mohamed ElPrince: Hard coding these contents visualization is our one of these contents, but there are much more to come.
Mohamed ElPrince: On the examples like energy with aria and.
Mohamed ElPrince: Good and what is marketplace, the marketplace, is where the quote and we're in cortana Community will.
Mohamed ElPrince: Open components for for everyone to consume and the marketplace, you can install new components with with a few clicks and start using them in few minutes.
Mohamed ElPrince: Okay, and this will allow us to deliver the components much easier than before you don't have to.
Mohamed ElPrince: Re install new releases a new bills to get these to pick up the new components that we're delivering so we hope to harness the power of the Community to will these powerful this powerful system.
Mohamed ElPrince: hey what's available now and 2020 2221 22 2200 for the three, and that is the beta version of the component SDK.
Mohamed ElPrince: And this is available for downloading and start practicing your creativity and as an admin user, you can connect.
Mohamed ElPrince: to your development, environment and render while developing your visualization or other components after you developed a component and you can bundle your visual component in.
Mohamed ElPrince: ink file, then, once we finalize the can ask them quotas for team to add them to the marketplace.
Mohamed ElPrince: You can also explore the data available samples right now on the marketplace, which we have already in introduced unseeded and this release.
Mohamed ElPrince: Once you install any of the marketplace components, they will be available for all of us.
Mohamed ElPrince: Now let's go to the them.
Mohamed ElPrince: Let me share the scope.
Mohamed ElPrince: So start with the developer, the component, as the game, you need to install the component, as the game.
Mohamed ElPrince: Very simple.
Mohamed ElPrince: it's built on mpm so to start developing your new components, you need to install.
Mohamed ElPrince: The creating quarter component from mpm.
Mohamed ElPrince: It would take couple of minutes or i've already installed it after you install then that creating quarter component, you can start developing.
Mohamed ElPrince: Your components, so when you create.
Mohamed ElPrince: A component you give it the command new and.
Mohamed ElPrince: title, which is a DEMO chart, for example, then few words for description and author name and it will start creating the folder structure for the.
Mohamed ElPrince: For the component and that.
Mohamed ElPrince: Let me show you a structure for an existing one until.
Mohamed ElPrince: This thing is still so it's a typical.
Mohamed ElPrince: They act project, so you will find under the structure, there is some folders and files that.
Mohamed ElPrince: developer would typically expect.
Mohamed ElPrince: us.
Mohamed ElPrince: The main files that you need to work on as an under the source there's the index dot CSS and the less for less a stylist for for the styles and.
Mohamed ElPrince: The finishing touches, these are the main files, we should start working.
Mohamed ElPrince: let's go back to the terms.
Mohamed ElPrince: And let me show you one of the samples that we.
Mohamed ElPrince: Have.
Mohamed ElPrince: there's the simple KPI this.
Mohamed ElPrince: To start viewing this component, while you're running.
Mohamed ElPrince: you're developing.
Mohamed ElPrince: Right.
Mohamed ElPrince: And once it starts.
Mohamed ElPrince: afternoon side.
Mohamed ElPrince: and go to the developer content component they so now, this will bend as a vendor whatever I right over here in this simple KPI project.
Mohamed ElPrince: And let me, for example.
Mohamed ElPrince: Now, when I stopped.
Mohamed ElPrince: Trying to connect again.
Mohamed ElPrince: To this one.
Mohamed ElPrince: In this example i'm only showing an aggregate value of the data which is a very simple KPI.
Mohamed ElPrince: So this is an hour for the function.
Mohamed ElPrince: And whenever you.
Mohamed ElPrince: To that definition.
Mohamed ElPrince: You can see this tree.
Mohamed ElPrince: I can change that.
Mohamed ElPrince: Never you save.
Mohamed ElPrince: It to a rebound will build on the rebounder and the total automatically update over he's.
Mohamed ElPrince: done.
Mohamed ElPrince: completed that, let me show you.
Mohamed ElPrince: This is one of the requested.
Mohamed ElPrince: visualizations that we had and.
Mohamed ElPrince: We we started the doing it on the charts as the gay it's only a few lines of code that's very, very simple and and.
Mohamed ElPrince: It.
Mazen Arar: I said we lose you.
Mazen Arar: I think we.
Mazen Arar: might have lost Prince everybody else you can hear me right guys i'm on.
Mazen Arar: Okay, thank you so make sure we snuck me.
Incorta Admin: Not it's not that it's not the zoom.
Mazen Arar: Okay, so let me just give him a second he should be joining in a second.
Mazen Arar: Okay, if you did not join in one more minute I guess, we can.
Mohamed ElPrince: Sorry for that I think they are.
Mohamed ElPrince: Excellent look like some raw story.
Mohamed ElPrince: That we should do it again yeah.
Mohamed ElPrince: So I was trying to do, dynamic KPI.
Mohamed ElPrince: Let me show you how it works.
Mohamed ElPrince: It takes to measure primary and a secondary metric and it takes the dimension, and it will split that the primary and secondary measure over the this dimension groups.
Mohamed ElPrince: Of course, this was our development is locally so it's it's still needs to be done, but i'll show you some of the examples that are now ready.
Mohamed ElPrince: And they are seated in the marketplace.
Mohamed ElPrince: Okay, and this.
Mohamed ElPrince: tab dashboard we have the slice of the slicer it acts like a measure.
Mohamed ElPrince: It acts like a measure like a filter for for the dashboard.
Mohamed ElPrince: So whenever you change the slices you see that the to reflect diagram to prompt filters.
Mohamed ElPrince: The months.
Mohamed ElPrince: When.
Mohamed ElPrince: And item price.
Mohamed ElPrince: So it will reflect here you have you can also see the dynamic dual KPI or its latest version on the marketplace.
Mohamed ElPrince: And it will show you the positive and negative values that you have also the this.
Mohamed ElPrince: This visual.
Mohamed ElPrince: component, where it shows the items, let me show you how.
Mohamed ElPrince: This having a group are grouping dimension dimension and measure and there's filter, of course, and future, you can choose between different icons according to your.
Mohamed ElPrince: Presentation with you.
Mohamed ElPrince: This is completely developed by the charts SDK So this was not there are supported by the native in quarter charts before that.
Mohamed ElPrince: there's also here are some more.
Mohamed ElPrince: visualizations that we will, there is the historic historical.
Mohamed ElPrince: variance or NASDAQ market on the boat race by race of chart.
Mohamed ElPrince: There is also the cryptocurrency work with.
Mohamed ElPrince: This has some times for crypto currencies that are.
Mohamed ElPrince: That are rendered from.
Mohamed ElPrince: An external API is without without loading this data to import so these that are life and you'll see them changing life without.
Mohamed ElPrince: losing any data in porter.
Mohamed ElPrince: And there is also.
Mohamed ElPrince: This population has.
Mohamed ElPrince: The bubble chart.
Mohamed ElPrince: Let me show you an example from.
Mohamed ElPrince: This one all these tiles on this trees are configurable from.
Mohamed ElPrince: From the SDK so you can hear define them and the definition, you will find that you can define new trace dimension, and we can give them the minimum count maximum count the settings and their roles either created or it's a measure.
Mohamed ElPrince: You can define a settings for the measure in three for the scale formatting conditional formatting filters.
Mohamed ElPrince: And there are many functions is and we are still adding more functionalities.
Mohamed ElPrince: and
Mohamed ElPrince: The api's to control your charts.
Mohamed ElPrince: there's also.
Mohamed ElPrince: This is the liquid film, this is very.
Mohamed ElPrince: useful and very.
Mohamed ElPrince: it's a very good visualization for the KPI instead of the regular kpis that we had before.
Mohamed ElPrince: This is also another in progress of charts for the contribution of that particular his region, and he was the contribution of regions for the categories and when we change this, you can see, for, for example, the contribution of different.
Mohamed ElPrince: categories in America.
Mohamed ElPrince: or the other way around, you can see, you can see, the contribution of hardware category and indifferent, the contribution of different regions well since have hundreds of different.
Mohamed ElPrince: So let's go back i'm sorry for the.
Mohamed ElPrince: technical difficulties.
Mohamed ElPrince: So what's next.
Mohamed ElPrince: we're we're improving the developer experience by adding more api's and controls improved controls for two tips and lessons.
Mohamed ElPrince: we're also adding providing more native functionality is like using variables in Title names and column labels.
Mohamed ElPrince: custom color palettes and we are adding more seated samples to the marketplace, we are also enhancing the marketplace experience.
Mohamed ElPrince: Changing the ux and the look and feel and how you can use the marketplace.
Mohamed ElPrince: Supporting different marketplace sources, for example, you might need to be to have your own private marketplace or play your own so that you can host these internally for your own company or for as a staging environment for test.
Mohamed ElPrince: we're also introducing.
Mohamed ElPrince: You ui.
Mohamed ElPrince: ui form to submit to the public marketplace for review and approval, instead of sending them to the support team we're also adding flexibility in the query handling.
Mohamed ElPrince: And we're adding more documentation learning content, and that includes video Apps and knowledge base CDs.
Mohamed ElPrince: What else can you do.
Mohamed ElPrince: There are many charts.
Mohamed ElPrince: Start charting libraries, that you can start using them leveraged income and adding them to input or using the component, as the key.
Mohamed ElPrince: There is no limitations for adding them.
Mohamed ElPrince: As long as you have the right resources to build them so.
Mohamed ElPrince: Who will be contributing to the marketplace, as we said the quarter will add to the marketplace partners and customers and the Community will.
Mohamed ElPrince: Add to the new components to the marketplace and we're still adding some more components to this new platform, not just visualization.
Mohamed ElPrince: So for any is there any q&a any questions.
Mohamed ElPrince: Can we exclude these dashboards yes, you can export these dashboards, but when when they are imported in they have to be installed in the other instance so.
Mohamed ElPrince: to migrate them to to other instances, you have these other instance, have to install the same components from the.
Mohamed ElPrince: From the marketplace.
Mohamed ElPrince: Yes, there are plans to to support many other.
Mohamed ElPrince: capabilities of the visualizations and 3D charts and.
Mazen Arar: yeah I think mark is asking their plans for availability right.
Mohamed ElPrince: Yes, I believe, as long as we're we're enhancing the augmented reality.
Mohamed ElPrince: we're enhancing more and more capabilities and i'm not sure about the security and accessing.
Mohamed ElPrince: A are so but we're adding all the capabilities for for the developers and as much as it's secured and cannot.
Mohamed ElPrince: cannot add any ask you to try, yes, who have the functional capability for the developers to add whatever is capable of building yes.
Mazen Arar: Any other questions for for Prince.
Mazen Arar: All right, thank you, Prince, you can share, please.
Mohamed ElPrince: For more information, you can also go to the Community and the petition for more information.
Mohamed ElPrince: Thank you, thanks.
Mazen Arar: Okay, well, thank you so much press, and I really want to thank all of our speakers Melinda mark and the rod prints and Joe.
Mazen Arar: To me, at least, this was really informative and I really liked it any any other questions do we we have for for the speakers, please feel free to ask it now, if not we'll just go ahead and move on.
Mazen Arar: Okay, so Moving on, so we are starting an award program from now on, with each user group event, we will pick a different category to give an award for this quarter.
Mazen Arar: We would like to thank all of our user user group speakers in the past, I want to say last year and this year, because we really have started this just last year only so.
Mazen Arar: We started in 2020 and you guys all know how was so throughout the past two years we've really had great committed speakers, I want to thank all of them.
Mazen Arar: For, for you know being there for us and and taking part of this event and, by the way, speaking of this event I got a lot of positive feedback from customers they love it so having everyone participate is great.
Mazen Arar: So let me see here.
Mazen Arar: And the award goes to now, I take the credit for this, by the way for the animation.
Mazen Arar: Cisco sanjeev was our speaker in Q4 of last year and.
Mazen Arar: Also q2 of this year, along with Stanford University in the shop and she's Thank you guys.
Mazen Arar: amanda from comcast for q3 and, obviously, today we have Melinda and mark, I really want to thank you guys so much, yes, you do get that word and i'll get in touch with everyone on this slide to make sure they will get their award as soon as possible.
Mazen Arar: Let me see if you have something in the.
Mazen Arar: In the chat yes.
Mazen Arar: Joe is clapping for everyone, so if you have any questions anybody wants to add anything at all, please guys, let me know.
Mazen Arar: Okay, so no questions or comments anyone from in quarter team, if you guys have any questions also please feel free to to bring it up, otherwise.
Mazen Arar: Thank you everyone and behalf of in court and the customer success team, we really appreciate your time and expect a follow up from us with a survey, I would hope that we can get we get a response on that as well Thank you everyone and have a great day or evening thanks a lot.