{"id":8432,"date":"2016-11-22T09:34:45","date_gmt":"2016-11-22T09:34:45","guid":{"rendered":"http:\/\/www.devopsonline.co.uk\/?p=8432"},"modified":"2016-11-22T09:35:44","modified_gmt":"2016-11-22T09:35:44","slug":"the-use-of-a-great-bi-strategy","status":"publish","type":"post","link":"https:\/\/devopsnews.online\/the-use-of-a-great-bi-strategy\/","title":{"rendered":"The use of a great BI strategy"},"content":{"rendered":"
Zafar Ali, Director, IDB Solutions LTD, discusses how you can boost your success through the creation of a good BI testing strategy.<\/em>\u00a0<\/span><\/p>\n Enterprises use various BI tools like Cognos, Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau, SQL Server Reporting Services (SSRS) etc., to analyse swathes of data and convert raw data into a more presentable format like dashboard or key performance indicators (KPIs), in order to make well-informed decisions, but you need to make sure your testing strategy is good.<\/p>\n The success of any BI project depends on the trust of the data shown in the BI dashboard\/reports, performance of the BI system, data integrity, data security, ease of use of the application and the graphical representation of data.<\/p>\n Testing of a large scale BI system faces challenges in the form of data quality assurance (DQA), metrics\/aggregation rule test and data grain etc. The success of any BI system depends on the traceability of the BI functionality to the business requirement (BR), issue\/anomalies fix log and how well the test cases are developed.<\/p>\n BI testing plays a pivotal role in the success of large-scale BI rollouts in enterprises.<\/p>\n BI testing ranges from: data validation, formatting, security, and performance to graphical user interface (GUI). Emphasis on a thorough BI is pivotal for improving the quality of data, user interface and meeting business requirements.<\/p>\n The purpose of BI\/DWH\/ETL testing is to get credible data for your end-users. Making sure a comprehensive testing strategy is adopted can increase the credibility of BI.<\/p>\n A comprehensive test strategy is a stepping-stone for the effective test cycle of BI application. Your test strategy should cover any stage of data flow in order to make sure that the data input to data output is effectively tested.<\/p>\n To ensure testing readiness, the following key areas of your testing strategy should be focused on:<\/p>\n ETL testing is quite different from conventional testing. There are many challenges we faced while performing data warehouse testing. Here is the list of few ETL testing challenges:<\/p>\n Data is important for businesses to make critical business decisions. ETL testing plays a crucial part in validating and ensuring that the business information is exact, consistent and reliable.<\/p>\n When a new report or dashboard is developed for consumption by other users, it is important to perform a few checks to validate the data and design of the included reports.<\/p>\n Verify that the new report or dashboard conforms to the report requirement \/ design specifications. Some of the items to check are:<\/p>\n BI stress testing is similar to the testing of any other web\/desktop application. The objective is to simulate concurrent users accessing reports with different prompts and to understand the bottlenecks in the system.<\/p>\n A typical BI user will login to the system and navigate to reports (or dashboards) and apply prompts and drills down to other reports. After the report is rendered, the BI user reviews the data for a certain amount of time, called \u2018think time\u2019. Conducting a stress test requires the simulation of the above BI users behaviour, concurrently, for different user loads. So it is important to have a list of different user logins for the stress test. When executing the reports, each user can pick a different set of prompt values for the same report.<\/p>\n BI applications also have authentication and authorization security requirements, often integrated with SSO (single sign on) or lightweight directory access protocol (LDAP) or other mechanism like oracle weblogic. The objective of security testing is to validate that the BI user\u2019s access to the BI reports, subject areas and dashboards, is limited according to their access levels. Access to the reports is generally controlled by an application role or a LDAP-based security feature in the BI tool.<\/p>\n Single sign on is often used as the authentication mechanism for BI applications in large enterprises – objective of this testing is to ensure that users are able to access BI applications using their single sign on access (or windows authentication).<\/p>\n BI tools, such as OBIEE and business objects, empower the business users by providing the capability for them to create their own reports without the help of a developer. These tools generate the database queries automatically for the reports, based on the measures and dimensions. For OBIEE the model is defined in the RPD, while business objects store the model in the form of a universe. Business users can select any combination of dimension and then measure the attributes available in the subject area in order to come up with their own ad-hoc report.<\/p>\n <\/p>\nWhat is BI testing?<\/h2>\n
Developing a good testing strategy<\/h2>\n
\n
The different testing categories<\/h2>\n
DWH\/ETL testing:<\/h3>\n
\n
Functional testing:<\/h3>\n
\n
Regression testing:<\/h3>\n
Security testing:<\/h3>\n
Report\/BI testing:<\/h3>\n