Tagarchief: Testing

Training “Certified Data & Analytics Tester” (CDAT) – Noord Nederland (met Startgarantie)

Certified Data & Analytics Tester (Foundation Level)

De training CDAT op 18 en 19 mei in Drachten heeft Startgarantie!

Ga je een datawarehouse, data-migratie, dashboard of rapportage testen? Bereid je dan voor op deze klus en volg de training Data & Analytics Tester (Foundation Level).

Tijdens deze praktisch opgezette training krijg je inzicht in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen. Na de cursus ben je in staat op een doordachte teststrategie op te zetten voor data warehouse- , business intelligence- en analytics trajecten, deze uit te voeren en er in heldere woorden over te rapporteren.

De inhoud van de training sluit aan op ISTQB en biedt een specifieke toepassing in de Data (Analytics) omgeving. De training leidt op voor het examen van Data Analytics United, dat thuis kan worden afgenomen via Brightest en PearsonVue.

Deze 2-daagse training DAU CDAT (Foundation Level) wordt verzorgd in het Nederlands (met Engelstalige slides en artikelen) en de trainingsdagen lopen van 9.00 tot 17.00 uur (inclusief pauze). Voor een lunch wordt uiteraard gezorgd.

De kosten van de training bedragen € 1195,- (incl. één Brightest examenvoucher).

Zie voor meer details de beschrijving van de training.

Neem voor meer informatie contact op met Armando Dörsek van Verified of schrijf je meteen in.

    Ja, ik neem graag deel aan de volgende training:

    Neem alstublieft contact met mij op!

    Training “Certified Data & Analytics Tester” (CDAT) – Utrecht Live & Online

    Certified Data & Analytics Tester (Foundation Level)

    Ben je een tester of ontwikkelaar in een Analytics omgeving, of wil je daar juist deel van gaan uitmaken? Neem dan deel aan deze praktisch opgezette training, waarin je inzicht krijgt in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen.

    Na het afronden van Certified Data & Analytics Tester (CDAT) kun je een  teststrategie opzetten voor data warehouse- , business intelligence- en analytics trajecten, deze uitvoeren en er in heldere woorden over rapporteren. Als je het examen haalt (1 uur, 45 vragen, 26 goed) dan ontvang je ook de bijbehorende Credly-badge.

    De inhoud van de training sluit aan op ISTQB en biedt een specifieke toepassing in de Data (Analytics) omgeving.

    Deze tweedaagse training wordt verzorgd in het Nederlands (met Engelstalige slides en artikelen) en de trainingsdagen lopen van 9.00 tot 17.00 uur, inclusief pauze. Voor diegenen die live deelnemen staat uiteraard een lunch klaar.

    De kosten van de training bedragen € 1195,- (incl. examen t.w.v.  € 190,-).

    Zie voor meer details de beschrijving van de training.

    Neem voor meer informatie contact op met Armando Dörsek van Verified of schrijf je meteen in via onderstaand formulier:

      Ja, ik neem graag deel aan de volgende training:

      Neem alstublieft contact met mij op!

       

      Training “Certified Data & Analytics Tester” (CDAT) – English spoken – Berlin (Germany)

      Data & Analytics United – Certified Data & Analytics Tester  (DAU – CDAT)

      As the volume and importance of data grows – we aim to increase the quality of information delivery. One way to achieve this is by having a well designed testing strategy for data centric products.

      “DAU Certified Data & Analytics Tester” is a training that has been designed for test engineers, test coordinators, business analysts, data leads, data warehouse developers and business intelligence consultants.

      Please join us during two days in Berlin and prepare yourself for the DAU exam.

      Training days
      • 12-7-2021 09:00-17:00 CET
      • 13-7-2021 09:00-17:00 CET
      ​Subjects

      After having drawn a common view on the world of Data & Analytics by exploring the concepts of Business Intelligence, Data Warehousing and Data & Analytics, we’ll dive into testing and test processes, focussing on the specifications required when testing data and analytics solutions. ​

      We’ll explore Risk Based Testing and the special skills that are required testers dealing with data and analytics.

      We will tackle the concept of how to test reports and dashboards, completeness, data quality as well as testing business rules and ETL (extract-, transform and load).

      ​We will explore differences between data & analytics testing and conventional testing, the specifics of Test Environments when dealing with Data & Analytics, Test Data, Ethics and Privacy Law (e.g. GDPR).

      Participants learn how to apply Data Profiling in order to create better test cases and to cover the most relevant Data Quality attributes.

      Exam

      This training will prepare candidates for the DAU Certified Data & Analytics exam, for which you will receive an exam voucher (first exam included). You can take the online or paper based exam through Brightest.

      Price

      EUR 1.195 excluding VAT incl. exam Voucher


        Yes, I'd like to enroll in the following course:

        Please contact me!

        Training “Certified Data & Analytics Tester” (CDAT) – English Spoken – Online

        Data & Analytics United – Certified Data & Analytics Tester  (DAU – CDAT)

        As the volume and importance of data grows – we aim to increase the quality of information delivery. One way to achieve this is by having a well designed testing strategy for data centric products.

        “DAU Certified Data & Analytics Tester” is a training that has been designed for test engineers, test coordinators, business analysts, data leads, data warehouse developers and business intelligence consultants.

        Please join us in 4 weekly online sessions of ± 3 hours each and prepare yourself for the DAU exam.

        Training days
        • 26-5-2021 14:00-17:00 CET
        • 2-6-2021 14:00-17:00 CET
        • 16-6-2021 14:00-17:00 CET
        • 23-6-2021 14:00-17:00 CET
        Requirements

        You will need a laptop or tablet which supports a internet browser to join the MS Teams sessions. An invite will be sent shortly before the first training session.

        ​Subjects

        We’ll start to explore the concepts of Business Intelligence, Data Warehousing and Data & Analytics after which we’ll dive into testing and test processes, focussing on the specifications required when testing data and analytics solutions. ​

        We’ll explore Risk-Based Testing and the special skills that are required of the tester when dealing with data and analytics.

        We will tackle the concept of how to test reports and dashboards, completeness, data quality as well as testing business rules and ETL (extract-, transform and load).

        ​We will explore differences between data & analytics testing and conventional testing, the specifics of Test Environments when dealing with Data & Analytics, Test Data and Privacy and Ethics Aspects (GDPR).

        Participants learn how to apply Data Profiling in order to create better test cases and to cover the most relevant Data Quality attributes.

        Exam

        This training will prepare candidates for the DAU Certified Data & Analytics exam. Your first exam is included in the training fee.

        Price

        EUR 1195,- excluding VAT (21%).


          Yes, I'd like to enroll in the following course:

          Please contact me!

          Training “Certified Data & Analytics Tester” – Nederlands gesproken – 25 mei 2021 e.v.

          Uitverkocht
          Deze training is VOL. Graag verwijzen we je naar één van de andere data.

          Tijdens deze praktisch opgezette training krijg je inzicht in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen. Je kunt na afloop een teststrategie opzetten voor data warehouse- , business intelligence- en analytics trajecten, deze uitvoeren en er in heldere bewoording over rapporteren.

          De inhoud van de training sluit aan op ISTQB en biedt een specifieke toepassing in de Data (Analytics) omgeving.

          Deze training CDAT Foundation Level wordt verzorgd in 4 sessies in het Nederlands (met Engelstalige slides en artikelen) op de avonden van:

          • 25 mei 2021
          • 1 juni 2021
          • 8 juni 2021
          • 15  juni 2021

          Zie voor meer details de beschrijving van de training.

          Training “Certified Data & Analytics Tester” (CDAT) in Berlin/Online

          Data & Analytics United – Certified Data & Analytics Tester  (DAU – CDAT)

          As the volume and importance of data grows – we aim to increase the quality of information delivery. One way to achieve this is by having a well designed testing strategy for data centric products.

          “DAU Certified Data & Analytics Tester” is a training that has been designed for test engineers, test coordinators, business analysts, data leads, data warehouse developers and business intelligence consultants.

          Please join us during two days in Berlin (Germany) and get ready to take the DAU-CDAT exam.

          Training days
          • 10 May 2021  09:00-17:00 CET
          • 11 May 2021  09:00-17:00 CET
          ​Subjects

          After having drawn a common view on the world of Data & Analytics by exploring the concepts of Business Intelligence, Data Warehousing and Data & Analytics, we’ll dive into testing and test processes, focussing on the specifications required when testing data and analytics solutions. ​

          We’ll explore Risk Based Testing and the special skills that are required testers dealing with data and analytics.

          We will tackle the concept of how to test reports and dashboards, completeness, data quality as well as testing business rules and ETL (extract-, transform and load).

          ​We will explore differences between data & analytics testing and conventional testing, the specifics of Test Environments when dealing with Data & Analytics, Test Data, Ethics and Privacy Law (e.g. GDPR).

          Participants learn how to apply Data Profiling in order to create better test cases and to cover the most relevant Data Quality attributes.

          Exam

          This training will prepare candidates for the DAU Certified Data & Analytics Tester exam (voucher included).

          Price

          EUR 1.195 excluding VAT incl. Exam Voucher


            Yes, I'd like to enroll in the following course:

            Please contact me!

            Training “Certified Data & Analytics Tester” (CDAT) – English spoken – 3 On Line Sessions

            Data & Analytics United – Certified Data & Analytics Tester  (DAU – CDAT)

            As the volume and importance of data grows – we aim to increase the quality of information delivery. One way to achieve this is by having a well designed testing strategy for data centric products.

            “DAU Certified Data & Analytics Tester” is a training that has been designed for test engineers, test coordinators, business analysts, data leads, data warehouse developers and business intelligence consultants.

            Please join us during 3 online sessions (of 4 hours each) and prepare yourself for the DAU exam.

            Training days
            • 19-4-2021 18:00-22:00 CET
            • 20-4-2021 18:00-22:00 CET
            • 21-4-2021 18:00-22:00 CET
            Subjects

            After having drawn a common view on the world of Data & Analytics by exploring the concepts of Business Intelligence, Data Warehousing and Data & Analytics, we’ll dive into testing and test processes, focussing on the specifications required when testing data and analytics solutions. ​

            We’ll explore Risk Based Testing and the special skills that are required testers dealing with data and analytics.

            We will tackle the concept of how to test reports and dashboards, completeness, data quality as well as testing business rules and ETL (extract-, transform and load).

            ​We will explore differences between data & analytics testing and conventional testing, the specifics of Test Environments when dealing with Data & Analytics, Test Data, Ethics and Privacy Law (e.g. GDPR).

            Participants learn how to apply Data Profiling in order to create better test cases and to cover the most relevant Data Quality attributes.

            Exam

            This training will prepare candidates for the DAU Certified Data & Analytics exam (exam voucher worth € 200,- included).

            Price

            € 1.195 excluding VAT incl. Exam Voucher


              Yes, I'd like to enroll in the following course:

              Please contact me!

              Training “Certified Data & Analytics Tester” (CDAT) – Online – English Spoken

              Data & Analytics United – Certified Data & Analytics Tester  (DAU – CDAT)

              As the volume and importance of data grows – we aim to increase the quality of information delivery. One way to achieve this is by having a well designed testing strategy for data centric products.

              “DAU Certified Data & Analytics Tester” is a training that has been designed for test engineers, test coordinators, business analysts, data leads, data warehouse developers and business intelligence consultants.

              Please join us in 4 weekly online sessions of ± 3 hours each and prepare yourself for the DAU exam.

              Training days
              • 18-2-2021 14:00-17:00 CET
              • 25-2-2021 14:00-17:00 CET
              • 4-3-2021 14:00-17:00 CET
              • 11-3-2021 14:00-17:00 CET
              Requirements

              You will need a laptop or tablet which supports a internet browser to join the MS Teams sessions. An invite will be sent shortly before the first training session.

              ​Subjects

              We’ll start to explore the concepts of Business Intelligence, Data Warehousing and Data & Analytics after which we’ll dive into testing and test processes, focussing on the specifications required when testing data and analytics solutions. ​

              We’ll explore Risk-Based Testing and the special skills that are required of the tester when dealing with data and analytics.

              We will tackle the concept of how to test reports and dashboards, completeness, data quality as well as testing business rules and ETL (extract-, transform and load).

              ​We will explore differences between data & analytics testing and conventional testing, the specifics of Test Environments when dealing with Data & Analytics, Test Data and Privacy and Ethics Aspects (GDPR).

              Participants learn how to apply Data Profiling in order to create better test cases and to cover the most relevant Data Quality attributes.

              Exam

              This training will prepare candidates for the DAU Certified Data & Analytics exam. An exam voucher can be purchased upon enrollment or after the training (EUR 200,-).

              Price

              EUR 995,- excluding VAT (21%).

              Exam voucher sold separately.


                Yes, I'd like to enroll in the following course:

                Please contact me!

                Online Training DaU “Certified Data and Analytics Tester” (CDAT) – English – special introductory price

                Starting 14 October 2020 Rogier Ammerlaan and Armando Dörsek will provide the online training for “Certified Data and Analytics Tester (CDAT)” against a Special Introductory Price* of EUR 685,- excl. VAT (incl. exam). 

                The training consists of four online blocks of 3 hours each, after which you should be able to take the Brightest DaU exam (1st exam included).

                The dates and times are:
                14 October – 14:00-17:00 (CET)
                20 October- 14:00-17:00 (CET)
                4 November- 14:00-17:00 (CET)
                11 November- 14:00-17:00 (CET)

                Note: These times will enable people from the Americas and India  to attend, too.

                If interested, do not hesitate to contact us for more information and/or an application form.

                *) Special Introductory Price applicable for new entries only, on and after 8 October 2020, booked through Verified.nl. This training was held often in a live setting before (at EUR 995,- ex. VAT, exam at EUR 190,-) and this is the first online version of the CDAT training.  

                Data & Analytics Testing Tools Summary (2)

                Testing of Data & Analytics environments is increasingly supported by test tools. At Verified, we wonder what your experience is with one of these tools – and if you propose certain tools that have helped you ?

                Please let us know, by leaving a message under this post, through the Contact FormLinkedIn or Twitter or contact us in any way you prefer. If you like, we can reply with a listing of more than 15 tools that should help testers and analysts  in testing and quality issues. 

                The previous post on Test Tools can be found here.

                Note: We are not sponsored in any way by the tool providers.

                RTTS QuerySurge

                Querysurge is a commercial product made for testing ETL, where comparison of source and target tables is the main object.

                It offers dashboards, query wizards, various prefabricated queries for comparison of data, text search etc.

                A trial version is available: https://www.querysurge.com/compare-trial-options

                Note that for BI Testing, an add on is available. Connectors are available for Cognos, Tableau, SAP Business Objects, Microstrategy and OBIEE.  Features include comparison of reports when upgrading or migrating, querying report meta data.

                ICEDQ

                iCEDQ is a commercial ETL Test Tool, which runs in the cloud, on premise or hybrid.

                It offers a rule engine module, which features:

                • Checksum rules (e.g. row counts)
                • Reconciliation rules (e.g. missing records)
                • Validity rules (SCD Type 2, Format Checks)
                • Script rules (e.g. execute DML/DDL, pre and post actions).

                iCEDQ currently integrates with Jenkins, TFS, Jira, HP ALM and ServiceNow.

                iCEDQ offers trials through their website:

                https://icedq.com/download-icedq-trial

                Bitwise QualiDI

                QualiDI focuses on ETL testing from sources to targets.

                It provides data validation and comparison of data, has a centralized repository of requirements, test cases, test results and has a API trigger based automation of test execution.

                There is Business Rules Engine, enabling non-technical users to write rules instead of queries. It integrates with Bitwise Test Data Management Suite for providing test data.

                QualiDi is a commercial product, a 30 day trial is available

                Source: https://www.bitwiseglobal.com/innovations/qualidi/

                SSIS Tester

                SSIS Tester is offered by bytesoftwo and focuses on testing Microsoft SSIS.

                SSIS Tester is a testing framework built on top of SQL Server Integration Services. It enables you to test packages, tasks and precedence constraints. It supports two types of tests:

                1. unit tests
                2. integration tests.

                SSIS Tester helps you to develop you ETL process in the test driven manner and to identify errors early in the development process. It offers “data taps” and fake source or targe components, enabling developers to work independently. Tests target packages or particular tasks.

                More information on SSIS Tester on MSDN can be found here:

                http://msdn.microsoft.com/en-us/magazine/dn342874.aspx

                SSIS Tester offers a free 21-day trial version:

                http://www.bytesoftwo.com/download.html

                Next 4 Tools

                In a few weeks I will publish the next Blog post, asking for new experiences. Thanks for reading this post!

                Omdat deze tekst gericht is op een internationaal publiek, heb ik ervoor gekozen om de bovenstaande tekst in het Engels op te stellen. Stelt u prijs op een vertaling naar het Nederlands? Neemt u dan aub contact met ons op.

                Data & Analytics Testing Tools Summary (1)

                Introduction

                During the training Certified Data & Analytics Tester (Foundation Level) we provide a list of tools that can be used in testing or monitoring Business Intelligence and Data Warehouse products.

                Below you can find the first 4 tools of this list, with a short description and links to the tool providers.

                We are curious for your experiences when using these tools. What have they brought to your (testing) team? What is a Big Plus of using the tool – and with which features are you less impressed? Is an active user community available, or a help desk that makes a difference? Please let us know, by leaving a message under this post, through the Contact Form, LinkedIn or Twitter.

                Note: We are not being sponsored by one of the products or their integration partners.

                Data Cleaner

                Data Cleaner is software which is used for Data Profiling.

                It can also be used in the process of creating logical and physical test cases as it offers extensive support to analyze and browse through data sets.

                Data Cleaner also offers features to clean, transform and export data sets. Rules can be built and reused.

                Data Cleaner is free, additional (paid) features are available.

                It can be downloaded to your desktop (Windows, Mac) environment from sourceforge or the community website:

                https://datacleaner.org/

                SAS Unit

                SAS Unit is a framework for the unit testing of SAS programs (SAS EG 9.2, 9.3, 9.4).

                Amongst others, SAS Unit offers features to assess test coverage of SAS Macros, running tests in batch mode, performance testing of SAS programs.

                SAS Unit uses assertions to test the values of macro variables, contents of SAS data sets, relations between data sets, the existence of files incl. log files and – messages.

                SAS Unit is open source software and built from SAS macros.

                https://sourceforge.net/projects/sasunit/

                Informatica DVO

                Informatica offers a testing solution called Data Validation Option for PowerCenter (DVO).

                The DataValidator for PowerCenter product was originally developed by a company DVO SOFTWARE. It is now available under the Informatica brand as Informatica PowerCenter Data Validation Option.

                DVO is a custom tool built on top of Informatica PowerCenter. DVO integrates with the Informatica PowerCenter Repository and Integration Services and enables developers and business analysts to create rules to test the data being transformed during the data integration process.

                Informatica mentions the following ETL Testing Use Cases: Production Validation Testing, Source to Target Testing and Application upgrades.

                Amongst others, it features:

                • An easy-to-use GUI interface to test the rules created for data validations for multiple projects.
                • No programming skills needed to create validation tests.
                • A repository with reporting capabilities to provide a complete audit trail of all tests and their results.
                • Reading data definitions from PowerCenter metadata repositories and can easily deal with data definition changes.

                Note that DVO tests data only, not mappings or workflows. Testing mappings is unit testing, which is different from data validation.

                As DVO is a commercial product it may be attractive to Informatica Power Center users. At this moment, no free trial seems available (Feb 9, 2020).

                www.informatica.com

                Datagaps ETL Validator

                Datagaps offers several products, e.g. ETL Validator, BI Validator, Data Flow and Test Data Manager.

                The Datagaps ETL Validator comes pre-packaged with an ETL engine capable of extracting and comparing millions of records from multiple data sources while executing test cases in parallel.

                ETL Validator also has a Visual Test Case Builder with drag-and-drop capabilities and a Query Builder that enables defining tests without manual typing.

                Key features include enterprise collaboration, flat file testing, data profile testing, baselining, data quality testing, and database metadata testing.

                Datagaps offers a free 30-day trial.

                https://www.datagaps.com/etl-testing-tools/etl-validator-download

                Next 4 Tools

                The next page shows another 4 tools.

                Omdat deze tekst gericht is op een internationaal publiek, heb ik ervoor gekozen om de bovenstaande tekst in het Engels op te stellen. Stelt u prijs op een vertaling naar het Nederlands? Neemt u dan aub contact met ons op.

                Training Data & Analytics Tester (CDAT) – Utrecht

                Tijdens deze praktisch opgezette training krijg je inzicht in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen. Je kunt na afloop een teststrategie opzetten voor data warehouse- , business intelligence- en analytics trajecten, deze uitvoeren en er in heldere woorden over rapporteren.

                De inhoud van de training sluit aan op ISTQB en biedt een specifieke toepassing in de Data (Analytics) omgeving.

                Deze 3-daagse training wordt verzorgd in het Nederlands (met Engelstalige slides en – artikelen). De trainingsdagen zijn van 9.00 tot 17.00 uur, inclusief pauze. Voor een lunch wordt uiteraard gezorgd.

                De kosten van de training bedragen € 1495,- (incl. examen á € 200,-).

                Zie voor meer details de beschrijving van de training.

                Neem voor meer informatie contact op met Armando Dörsek van Verified of schrijf je meteen in op de website van trainingspartner Ammerlaan Training en Advies.

                Training Data & Analytics Testing (CDAT) – Zwolle

                Tijdens deze praktisch opgezette training “Certified Data & Analytics Testing” krijg je inzicht in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen. Je kunt na afloop een teststrategie opzetten voor data warehouse- , business intelligence- en analytics trajecten en deze uitvoeren.

                De inhoud van de training is gebaseerd op o.a. ISTQB met een specifieke vertaling voor de Data (Analytics) omgeving.

                Deze 3-daagse training wordt verzorgd in het Nederlands (materialen in het Engels). De trainingsdagen zijn van 9.00 tot 17.00 uur (inclusief pauze). Voor een lunch wordt uiteraard gezorgd.

                De kosten bedragen € 1495,- (incl. examen á € 200,-).

                Zie voor meer details de beschrijving van de training.

                Neem voor meer informatie contact op met Armando Dörsek van Verified of schrijf je direct in via de website van trainingspartner Ammerlaan IT Training & Advies.

                Training Data & Analytics Testing (CDAT-FL) – Utrecht

                Tijdens deze praktisch opgezette training krijg je inzicht in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen. Je kunt na afloop een teststrategie opzetten voor data warehouse- , business intelligence- en analytics trajecten en deze uitvoeren.

                De inhoud van de training is gebaseerd op o.a. ISTQB met een specifieke vertaling voor de Data (Analytics) omgeving.

                Deze 3-daagse training wordt verzorgd in het Nederlands (materialen in het Engels). De trainingsdagen zijn van 9.00 tot 17.00 uur (inclusief pauze). Voor een lunch wordt uiteraard gezorgd.

                Zie voor meer details de beschrijving van de training.

                Neem voor meer informatie contact op met Armando Dörsek van Verified of schrijf je direct in via de website van trainingspartner Ammerlaan IT Training & Advies.

                Training Data & Analytics Testing (CDAT-FL) (Zoetermeer)

                Tijdens deze praktisch opgezette training krijg je inzicht in het gestructureerd testen in complexe Data & Analytics projecten en omgevingen.

                Je kunt na afloop een teststrategie opzetten voor data warehouse- , business intelligence- en analytics trajecten en deze uitvoeren.

                De inhoud van de training is gebaseerd op o.a. ISTQB met een specifieke vertaling voor de Data (Analytics) omgeving.

                Deze 3-daagse training in de regio Den Haag wordt verzorgd in het Nederlands (met Engelstalige slides en artikelen) en de trainingsdagen lopen van 9.00 tot 17.00 uur, inclusief pauze.

                Voor een lunch wordt uiteraard gezorgd.

                Zie voor meer details de beschrijving van de training.

                Schrijf je direct in via de website van ammer.nl of van Maestro Academy.