{"id":89739,"date":"2023-03-04T11:49:00","date_gmt":"2023-03-04T06:19:00","guid":{"rendered":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/"},"modified":"2024-08-16T00:23:46","modified_gmt":"2024-08-15T18:53:46","slug":"managing-size-of-automation-test-suite-using-sql-and-visualization-tools","status":"publish","type":"post","link":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/","title":{"rendered":"Managing Size of Automation Test Suite Using SQL and Visualization Tools<\/strong>"},"content":{"rendered":"
\"\"<\/figure>\n\n\n\n

Hi, I\u2019m Tapas and working in a supervisor role wherein my duties include tracking and monitoring test deliverables for an ERP. As part of my current role, I need to work with data for various decision-making activities. Therefore, I have decided to take it one step further and learn the concepts and techniques behind Data Science and Business Analytics.<\/p>\n\n\n\n

It became crucial to control the size of the automation suite i.e. the number of tests in our test repository. Approximately 300 tests were getting added to the suite in each release. With this rate, the test suite size became huge over the years. The time required for a run and debug failures was becoming a bottleneck and time-consuming. There was an ask to reduce the test suite to optimize run time and better resource utilization. Automated execution was taking more than 3 days to complete. The debugging was taking almost a week\u2019s time for the team. This has resulted in blocking the capacity of resources in test management activity, which otherwise could have been used for increasing test coverage. <\/p>\n\n\n\n

Automation execution results, pass percentage, and failure rate for each script were extracted as a dump from our in-house test scheduling and orchestration database. This data was broken down into a granular level. Tests were split into various functional categories and sub-categories. Data was collected corresponding to the usage of each category and sub-category by customers. Finally, the tests were organized based on the importance of functional categories and customer usage. Similarly, tests were classified based on the year of creation, the number of failures reported by those tests over the years etc. Finally, the less significant tests were identified and suggested for removal from the main automation suite.<\/p>\n\n\n\n

We used SQL to extract the data. Excel and some in-house BI and visualization tools were used for grouping and segregation. The tools were selected based on the size of the data, compatibility with the requirements and organizational software usage policies. Data collection was the biggest challenge was the source data was residing in multiple repositories. Once the data was collected, it was joined and concatenated to obtain the final dump which was taken for analysis. Look-up tables were created for adding additional information to the data e.g. Adding customer usage by functional categories. This was time-consuming as the detailed analysis was involved. EDA was performed to gather information related to customer usage patterns for different functional categories, tests available under each functional category, and trends of issues reported by tests over a certain time period. The main challenge was to arrive at deciding criteria for the elimination of tests, where EDA played a vital role by providing different insights and statistics based on past execution results.<\/p>\n\n\n\n

Several insights were derived such as 10% of tests were found across the repository which was a kind of repetition which few additional steps. Those were marked duplicated and the additional steps were accommodated in existing scripts. 10% of tests were found to be belonging to very stable areas and never reported an issue over the last 3 years. The number of those tests was reduced by 20% of the tests which belonged to lesser-used functional categories were moved out of the main repository and parked in a separate suite for on-demand execution only. Spending more time in analysis before automating the tests and combining scenarios wherever possible to reduce duplication. The automation was less in the stable areas. There was less focus on low-used functional areas and automation only a few critical end-to-end scenarios in those areas. Once this solution was implemented, it helped in reducing the size of the test repository by 40%. 30% capacity of human resources was freed up on a monthly basis. <\/p>\n\n\n\n

The exercise helped us visit the repository thoroughly and helped in getting a good grip on existing test coverage. Technically, we got a good hands-on opportunity to work on SQL joins, excel and data visualization to draw meaningful results.<\/p>\n","protected":false},"excerpt":{"rendered":"

Hi, I\u2019m Tapas and working in a supervisor role wherein my duties include tracking and monitoring test deliverables for an ERP. As part of my current role, I need to work with data for various decision-making activities. Therefore, I have decided to take it one step further and learn the concepts and techniques behind Data […]<\/p>\n","protected":false},"author":41,"featured_media":89740,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[5],"tags":[],"content_type":[36251],"class_list":["post-89739","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-success-stories","content_type-success-stories"],"acf":[],"yoast_head":"\nManaging Size of Automation Test Suite Using SQL and Visualization Tools<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Managing Size of Automation Test Suite Using SQL and Visualization Tools\" \/>\n<meta property=\"og:description\" content=\"Hi, I\u2019m Tapas and working in a supervisor role wherein my duties include tracking and monitoring test deliverables for an ERP. As part of my current role, I need to work with data for various decision-making activities. Therefore, I have decided to take it one step further and learn the concepts and techniques behind Data […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/\" \/>\n<meta property=\"og:site_name\" content=\"Great Learning Blog: Free Resources what Matters to shape your Career!\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/GreatLearningOfficial\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-04T06:19:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-15T18:53:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1332\" \/>\n\t<meta property=\"og:image:height\" content=\"933\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Great Learning Editorial Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/Great_Learning\" \/>\n<meta name=\"twitter:site\" content=\"@Great_Learning\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Great Learning Editorial Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/\"},\"author\":{\"name\":\"Great Learning Editorial Team\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\"},\"headline\":\"Managing Size of Automation Test Suite Using SQL and Visualization Tools\",\"datePublished\":\"2023-03-04T06:19:00+00:00\",\"dateModified\":\"2024-08-15T18:53:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/\"},\"wordCount\":670,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg\",\"articleSection\":[\"Success Stories\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/\",\"name\":\"Managing Size of Automation Test Suite Using SQL and Visualization Tools\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg\",\"datePublished\":\"2023-03-04T06:19:00+00:00\",\"dateModified\":\"2024-08-15T18:53:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg\",\"width\":1332,\"height\":933},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Success Stories\",\"item\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/success-stories\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Managing Size of Automation Test Suite Using SQL and Visualization Tools\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"name\":\"Great Learning Blog\",\"description\":\"Learn, Upskill & Career Development Guide and Resources\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\"},\"alternateName\":\"Great Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#organization\",\"name\":\"Great Learning\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/GL-Logo.jpg\",\"width\":900,\"height\":900,\"caption\":\"Great Learning\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/GreatLearningOfficial\\\/\",\"https:\\\/\\\/x.com\\\/Great_Learning\",\"https:\\\/\\\/www.instagram.com\\\/greatlearningofficial\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/in.pinterest.com\\\/greatlearning12\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/beaconelearning\\\/\"],\"description\":\"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.\",\"email\":\"info@mygreatlearning.com\",\"legalName\":\"Great Learning Education Services Pvt. Ltd\",\"foundingDate\":\"2013-11-29\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"1001\",\"maxValue\":\"5000\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/#\\\/schema\\\/person\\\/6f993d1be4c584a335951e836f2656ad\",\"name\":\"Great Learning Editorial Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"contentUrl\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/unnamed.webp\",\"caption\":\"Great Learning Editorial Team\"},\"description\":\"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.\",\"sameAs\":[\"https:\\\/\\\/www.mygreatlearning.com\\\/\",\"https:\\\/\\\/in.linkedin.com\\\/school\\\/great-learning\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/Great_Learning\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCObs0kLIrDjX2LLSybqNaEA\"],\"award\":[\"Best EdTech Company of the Year 2024\",\"Education Economictimes Outstanding Education\\\/Edtech Solution Provider of the Year 2024\",\"Leading E-learning Platform 2024\"],\"url\":\"https:\\\/\\\/www.mygreatlearning.com\\\/blog\\\/author\\\/greatlearning\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Managing Size of Automation Test Suite Using SQL and Visualization Tools","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"Managing Size of Automation Test Suite Using SQL and Visualization Tools","og_description":"Hi, I\u2019m Tapas and working in a supervisor role wherein my duties include tracking and monitoring test deliverables for an ERP. As part of my current role, I need to work with data for various decision-making activities. Therefore, I have decided to take it one step further and learn the concepts and techniques behind Data […]","og_url":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/","og_site_name":"Great Learning Blog: Free Resources what Matters to shape your Career!","article_publisher":"https:\/\/www.facebook.com\/GreatLearningOfficial\/","article_published_time":"2023-03-04T06:19:00+00:00","article_modified_time":"2024-08-15T18:53:46+00:00","og_image":[{"width":1332,"height":933,"url":"http:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg","type":"image\/jpeg"}],"author":"Great Learning Editorial Team","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/Great_Learning","twitter_site":"@Great_Learning","twitter_misc":{"Written by":"Great Learning Editorial Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#article","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/"},"author":{"name":"Great Learning Editorial Team","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad"},"headline":"Managing Size of Automation Test Suite Using SQL and Visualization Tools","datePublished":"2023-03-04T06:19:00+00:00","dateModified":"2024-08-15T18:53:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/"},"wordCount":670,"commentCount":0,"publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg","articleSection":["Success Stories"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/","url":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/","name":"Managing Size of Automation Test Suite Using SQL and Visualization Tools","isPartOf":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#primaryimage"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg","datePublished":"2023-03-04T06:19:00+00:00","dateModified":"2024-08-15T18:53:46+00:00","breadcrumb":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#primaryimage","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg","width":1332,"height":933},{"@type":"BreadcrumbList","@id":"https:\/\/www.mygreatlearning.com\/blog\/managing-size-of-automation-test-suite-using-sql-and-visualization-tools\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/www.mygreatlearning.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Success Stories","item":"https:\/\/www.mygreatlearning.com\/blog\/success-stories\/"},{"@type":"ListItem","position":3,"name":"Managing Size of Automation Test Suite Using SQL and Visualization Tools"}]},{"@type":"WebSite","@id":"https:\/\/www.mygreatlearning.com\/blog\/#website","url":"https:\/\/www.mygreatlearning.com\/blog\/","name":"Great Learning Blog","description":"Learn, Upskill & Career Development Guide and Resources","publisher":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization"},"alternateName":"Great Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mygreatlearning.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.mygreatlearning.com\/blog\/#organization","name":"Great Learning","url":"https:\/\/www.mygreatlearning.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/06\/GL-Logo.jpg","width":900,"height":900,"caption":"Great Learning"},"image":{"@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/GreatLearningOfficial\/","https:\/\/x.com\/Great_Learning","https:\/\/www.instagram.com\/greatlearningofficial\/","https:\/\/www.linkedin.com\/school\/great-learning\/","https:\/\/in.pinterest.com\/greatlearning12\/","https:\/\/www.youtube.com\/user\/beaconelearning\/"],"description":"Great Learning is a leading global ed-tech company for professional training and higher education. It offers comprehensive, industry-relevant, hands-on learning programs across various business, technology, and interdisciplinary domains driving the digital economy. These programs are developed and offered in collaboration with the world's foremost academic institutions.","email":"info@mygreatlearning.com","legalName":"Great Learning Education Services Pvt. Ltd","foundingDate":"2013-11-29","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"1001","maxValue":"5000"}},{"@type":"Person","@id":"https:\/\/www.mygreatlearning.com\/blog\/#\/schema\/person\/6f993d1be4c584a335951e836f2656ad","name":"Great Learning Editorial Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","url":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","contentUrl":"https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2022\/02\/unnamed.webp","caption":"Great Learning Editorial Team"},"description":"The Great Learning Editorial Staff includes a dynamic team of subject matter experts, instructors, and education professionals who combine their deep industry knowledge with innovative teaching methods. Their mission is to provide learners with the skills and insights needed to excel in their careers, whether through upskilling, reskilling, or transitioning into new fields.","sameAs":["https:\/\/www.mygreatlearning.com\/","https:\/\/in.linkedin.com\/school\/great-learning\/","https:\/\/x.com\/https:\/\/twitter.com\/Great_Learning","https:\/\/www.youtube.com\/channel\/UCObs0kLIrDjX2LLSybqNaEA"],"award":["Best EdTech Company of the Year 2024","Education Economictimes Outstanding Education\/Edtech Solution Provider of the Year 2024","Leading E-learning Platform 2024"],"url":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg",1332,933,false],"thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-150x150.jpg",150,150,true],"medium":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-300x210.jpg",300,210,true],"medium_large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-768x538.jpg",768,538,true],"large":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-1024x717.jpg",1024,717,true],"1536x1536":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg",1332,933,false],"2048x2048":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20.jpg",1332,933,false],"web-stories-poster-portrait":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-640x853.jpg",640,853,true],"web-stories-publisher-logo":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-96x96.jpg",96,96,true],"web-stories-thumbnail":["https:\/\/www.mygreatlearning.com\/blog\/wp-content\/uploads\/2023\/04\/PGP-AIML-success-story-blog-banner-Sep-2021.pptx-20-150x105.jpg",150,105,true]},"uagb_author_info":{"display_name":"Great Learning Editorial Team","author_link":"https:\/\/www.mygreatlearning.com\/blog\/author\/greatlearning\/"},"uagb_comment_info":0,"uagb_excerpt":"Hi, I\u2019m Tapas and working in a supervisor role wherein my duties include tracking and monitoring test deliverables for an ERP. As part of my current role, I need to work with data for various decision-making activities. Therefore, I have decided to take it one step further and learn the concepts and techniques behind Data…","_links":{"self":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/89739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/comments?post=89739"}],"version-history":[{"count":1,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/89739\/revisions"}],"predecessor-version":[{"id":89741,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/posts\/89739\/revisions\/89741"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media\/89740"}],"wp:attachment":[{"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/media?parent=89739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/categories?post=89739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/tags?post=89739"},{"taxonomy":"content_type","embeddable":true,"href":"https:\/\/www.mygreatlearning.com\/blog\/wp-json\/wp\/v2\/content_type?post=89739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}