BI DESIGN AND DEVELOPMENT

[Audio] Good morning everyone! Today I will be talking to you about Business Intelligence design and development. In this presentation we will cover topics such as BI design BI user interface standards privacy security access standards design methods prototyping lifecycle application development tasks and BI application testing. I look forward to discussing with you the processes and techniques that go into creating a successful BI design. Let's get started!.

[Audio] This slide covers BI Design and Development. We will cover BI Design BI User Interface Privacy Security and Access Standards Design Methods Prototyping Lifecycle Application Development Tasks and BI Application Testing. We will examine best practices and provide strategies to better understand and apply these concepts for your projects..

[Audio] BI Design and Development encompasses the designing of the visual layout and the user experience of a Business Intelligence application. It involves following guidelines for user interaction which ensure the privacy and security of all data. This is a complex task that involves knowledge of the data process in the BI application and the full cycle of data access integration transformation and analysis..

[Audio] Good morning everybody. UI Standards and their importance in designing user-friendly websites is a very important factor especially in the context of Business intelligence or BI development which helps companies use their data to make decisions. Using UI standards will make the workflow consistent across all applications and platforms allowing users to quickly accomplish their tasks. This consistency is especially crucial for BI developers to consider as they often face challenges that make it difficult to deliver a consistent result. With the implementation of UI standards users of the BI application can focus on their intended use and get the best out of it. Thank you..

[Audio] The Web and Business Intelligence (B-I---) Development Challenges come with a variety of areas that affect user interface consumer interactions application functions and delivery platforms. For the Web we have to consider different Web browsers such as Chrome Firefox and Internet Explorer as well as different types of interactions with web browsers different-sized monitors tablets smartphones print P-D-F and more. For BI there are different styles of outputs such as reports dashboards and pivot tables as well as many different types of analysis that can be performed such as sales figures future customer behavior and profitability. All of these also have to be considered for delivery across web tablets phones and more..

[Audio] We are going to discuss the development of Business Intelligence or BI designs. The World Wide Web Consortium was created to establish a number of user interface standards such as HTML DHTML CSS X-M-L ajax PNG SVG. These standards provide users with a consistent experience regardless of the platform function or customer interaction. This helps in the growth of BI as it allows developers to concentrate on content rather than platform-specific functionality. We will explore this topic further..

[Audio] Business Intelligence (B-I---) is a powerful tool that enables data to be analysed to gain insight into customer and market trends. However the BI space is often met with challenges stemming from a lack of industry standards making it difficult to distinguish between different vendors' products and approaches. This means that while the same BI style may be offered by different providers their execution and implementation of analytical functions and charts can vary significantly. Therefore it is important to carefully consider the nuances between vendors and to ensure that the chosen BI solution meets all individual requirements..

[Audio] It is essential to establish a set of user interface standards in order to collaborate successfully with other teams and customers. These standards should cover layout usability and design providing a consistent experience. This can include dashboard and scorecard specific standards such as the number of panels sizing orientation and workflow. For pivot tables likewise there needs to be guidelines for the use of dimensions and measures as well as the look and feel of the UI. Establishing these UI standards helps to ensure successful BI projects and facilitates collaboration..

[Audio] Understanding the common layout and delivery platform standards is a critical part of BI Design and Development. Define the layout text color and filters parameters and slicers to ensure consistency throughout your application's entirety. This includes how they are displayed how they are related and how to handle any differences in viewing size when using a Web browser. When choosing a chart type for each type of analysis select the chart types which best supports it to create a professional-looking BI application for all mediums from Web browser to tablet notebook smartphone print and PDF..

[Audio] It is essential for BI designers and developers to devise standards for data security privacy and accessibility. This involves recognising and abiding by data regulations and codes of behaviour for customers prospects suppliers employees among others. In the current Big Data and Internet of Things environments it is indispensable to put together a BI team that creates and implements standards both in the business and IT realms. This will make certain the correct protection and privacy of data..

[Audio] In order to ensure that security and privacy standards are maintained as BI design and development advances access rights should be both secure and easy for business consumers to access the necessary data. To reach this goal BI teams should create security standards to identify which data needs to be secured and what the application implementation should look like. In addition BI security standards should be also dictated by the enterprise security framework. Moreover collaboration between BI teams and the business is essential in order to set up access standards based on factors like business group title role and location. With these privacy and security standards in place businesses and consumers will have quick and secure access to data..

[Audio] To design a BI application creativity and knowledge of the data and its possible usages must be combined. To ensure the design meets the set goals the BI content specifications UI standards and user needs and preferences need to be carefully studied. This allows the designer to create an attractive and easy-to-use design that allows users to engage with the data in meaningful ways. The end product of the design should make data exploration easier and give users the opportunity to make informed decisions based on the gathered insights..

[Audio] BI designers need to concentrate on employing the most suitable methods for establishing specifications. Storyboarding gives a visual of either the challenge or solution through static sketches or frames. Similarly use cases are documents which determine the goals of the user and the system and define interactions which assist those goals. Additional techniques involve data modeling process modeling and wireframing. Ultimately our aim is to communicate our design in the most efficient and productive manner..

[Audio] In order to create a working prototype for any of the visual design methods there needs to be a target schema with sample data a BI tool a prototyping environment and a team with experience in developing with a BI tool. We will be discussing these elements further when it comes to BI design and development..

[Audio] Sketches are an integral part of the design and development of BI. As illustrated in Figure 14.2 they can be done quickly and inexpensively with a whiteboard or paper. However this does not facilitate collaboration or easy sharing. Hence many applications are available nowadays to enable these tasks. These applications also come with pre-made shapes which make sketching faster and neater..

[Audio] Sketches are an advantageous way to start the architecture of BI applications. Being flexible and collaborative they allow for ideation without focusing on details. Utilizing sketches provides a visual demonstration of the application's structure that cannot be described by words thus they are an ideal tool to communicate and negotiate the design with stakeholders in a collective conceptual space. After the basic design is implemented other visual techniques can be used to gain more insight. Sketches offer limitless potential for design..

Wireframes. htt ://su rt.m coola 80m Product Sales Analysis r Chart oduct Dimension x Column I Column 2 Column 3 Column 4 Dimension y Column 6 Column 7 Column 8 Measures Measure I Measure 2 Measure 3 City b bbb bbbb b bbb bbbb bbbb bbbb Line Chart Sold Date 201s Qx201x Ox 201 x 201s Qx201x Qx201x Sales S xxxxx.xxx S XXXXXXXX $ xxxxxxxx $ xxxx-xxxx S XXXX-XXXX $ xxxxxxxx.

[Audio] A wireframe is a basic visual representation of a product's design typically created in a greyscale palette to maintain focus on the core structure instead of any specific colors or layouts. This allows it to act as a blueprint of the user experience and ensures the design meets all technical requirements. Upon completion it should provide clarity on page structure and the elements that will be included in the final design..

[Audio] Wireframing is an invaluable tool in the designing of a BI application allowing for the creation of a layout sketch that outlines each data content group the placement of visualizations such as charts and tables and other applicable elements. Through this approach a low-fidelity design can be rapidly produced laying the groundwork for the next step. Subsequently let us consider how humans have changed their environment over the course of their evolution..

[Audio] Storyboarding is an invaluable tool in the design and development of BI applications. It involves creating sketches of the various analytical processes used by business people allowing for a more precise understanding of the relationships between them. This helps form a layout that satisfies the needs of the user. Storyboards also allow for a thorough visualization of the visualizations and workflows without the need for a prototype. By applying this technique to design and development one can produce a more user-friendly and efficient BI application..

Product Sales Analysis Column Chart Pie Chart Filter Filter Line Chart Drill-down stomer Bar Chart Drill-down City bbbb bbbb bbbb bbbb bbbb bbbb City b bbb b bbb b bbb Qx201x Sales Sale S S sxxxxxxx $ sxxxxxvx S sxxxxxss.

[Audio] Mock-ups are an important part of Business Intelligence Design and Development. They are medium to high-fidelity representations of a BI application's layout just like architectural drawings. Mock-ups are static visualizations which show the colors icons buttons text and charts the user will work with when the application is completed. Mock-ups are usually not used in most BI projects as the BI tools can create a prototype much more quickly and which can then be used to template. However in cases where creating and producing a multimedia item is expensive mock-ups can prove to be very advantageous as they help save time and money..

[Audio] A hybrid methodology is the way to go when developing BI applications. Rather than have a traditional waterfall approach the BI project manager should use a combination of the traditional waterfall approach to design the BI framework along with an agile approach to develop the underlying components. This hybrid approach enables teams to build BI applications incrementally and iteratively through a process of prototyping. This way business people can have an active role in providing feedback throughout the entire process which helps to avoid the implementation surprises that can cause problems in BI projects..

Calendar Year 2008 2009 2010 ProductCateeory Bikes Clothing Components (blank) Level Of Education Bachelors Graduate Degree High School Partial College Partial High School Road Bikes ooaa $25 $30 $10 $9 $8 $7 $6 $5 $3 $2 $1 $0 Sales *2006 41 42 s 2007 42 43 2008 Grand Total Bikes - Touring Bikes Bikes - Road Bikes Bikes - Mountain Bikes Mountain Bikes Touring Bikes $0 $5 $10 $15 Millions $20 1 4 1 4 2006 Bikes OMountain Bikes $1,562,457 $314,949 $440 199 $329 530 $477 779 989 638 $626 185 $780,916 $ 08 2007 2008 Grand Total Bikes Total Partial Hig School 5% Partial College High School 16% Sales by Education Level • Bachelors • Graduate Degree Bache • High School 34% • Partial College • Partial High School IGraduate Degree 19% ORoad Bikes arourine Bikes $1476 749 $1 73 813 $1 067 304 $850 020 952 029 $787 346 $843,055 $1028 987 $1,292,642 7 $459 5 $6,530, $1 396 $ 327 799 $9,359 103 $1,413 569 6 $958,086 $2,427,366 $6,530,344 $1 791 698 $2 014 012 $1 396 $1 327 799 $9 359 103 $1 13 530 $2 569 678 $9,162,325.

[Audio] Good morning everyone. Software prototyping is a technique to build parts of an application to explore various aspects such as how well it meets requirements its functionality performance et cetera For BI prototypes the two primary goals are to involve intended users in the process to receive feedback and enable developers to work incrementally. Three key success factors are dedicating time and effort working incrementally and timing the process. To have a successful project the BI team needs to make sure that the business people have allocated time for prototyping and that they will be actively involved in providing feedback. Developers have to be aware that they are working on an incremental prototype to ensure that they gain a comprehensive understanding of the application as a whole. Finally they have to make sure that the process is time-boxed to guarantee that tasks are completed on time. Thank you..

[Audio] Identifying and determining the component to be developed is crucial when defining the prototype scope. Participation of developers reviewers and managers must be determined as well. Additionally objectives deliverables sign-off criteria and the timeline have to be set and accepted. If a rapid prototyping or agile solution is chosen this step could be concluded during a single meeting..

[Audio] We will focus on creating a BI application prototype for this slide. We will construct components of the BI application using the chosen BI tool to deploy the application. To guarantee we have everything necessary we should ensure there is a development environment and at least some sample data from the BI schema is accessible. With that we can start developing the BI application prototype..

[Audio] Good morning everyone. Today we will be learning about the design and development of BI which stands for business intelligence. The development of BI applications requires a careful series of steps to ensure a successful outcome. This includes conducting unit tests letting users test prototypes gathering user feedback revising as necessary and prototype sign-off. Firstly developers run the prototype and examine test results to ensure that any changes needed are made prior to passing it on to business people. Then users are allowed to test the prototype. The goal is to get input from the business people and make sure any feedback is incorporated into the final product. If major flaws are found revisions must be made and the prototype must be tested again. Finally a sign-off indicates that the prototype and the overall BI application have been properly assessed. Thank you..

[Audio] Prototyping is an invaluable asset in BI design and development allowing for validation expansion and collection of business data and technical requirements. It also enables a thorough examination of the components built to ensure their effectiveness as well as allows business people to be involved and provide feedback. When crafting a BI application it is wise to document the design with the BI tool's available documentation abilities and to save the prototype with the documentation. A BI app usually consists of three components: assembling data content creating data charts or visualizations for analysis and developing the BI application as a whole..

[Audio] The objective of this task is to retrieve the data to be used for analysis with the BI application. To achieve this we must connect to the required data sources and execute the queries to acquire the data. We must also create the schema that the BI tool will utilize to interact with the data. After the query results have been attained we must evaluate them for accuracy. To make this easier we can use open database connectivity (O-D-B-C-) java database connectivity (J-D-B-C-) or direct database connections when the data sources are relational databases. Nonrelational sources require different measures for collecting the data..

[Audio] I will be discussing the Design and Development of Princess Garvie Camingawan. The 3dA1010Ud concept is important for the development of Princess Garvie Camingawan and I will illustrate how it is incorporated into the process. In addition we will go over the N011V017ddV stqouvznvnslA N011VOW103dS NOUV017ddV sauvuvas and IN31NOO concepts. To begin we will understand the 3dA1010Ud concept and how it contributes to the development of Princess Garvie Camingawan. Afterwards we will explore the other concepts mentioned. By the end of this slide you will have a better comprehension of the Design and Development of Princess Garvie Camingawan..

[Audio] Without greetings without beginning with Today and without thanks: The thirty-third slide of this presentation is about BI Design and Development. It covers the range of options available to BI developers when querying data which includes filling connection information into source-specific application programming interfaces or apis specifying the data sources and filtering the columns and writing custom-coded S-Q-L statements to get desired results. There is also the option of joining tables by primary and foreign keys either by assuming names are related or querying the source database's metadata. In some cases BI developers may need to write a custom-coded S-Q-L statement to join the appropriate tables. Finally the scope of creating and modifying the schema varies depending on who accesses it and what type of business application is used..

[Audio] Revising the schema of a BI tool can create an optimal environment for data analysis. This entails giving user-friendly names to columns eliminating unnecessary columns establishing relationships not present in data sources that are needed for analysis constructing new metrics applying business rules and building aggregations. Generally this is done by means of graphical applications though scripting may also be necessary depending on the type of BI tool..

[Audio] Understanding the design and development of business intelligence (B-I---) projects is critical. Data charts and visualizations are excellent resources for analyzing data and making decisions. Before creating any data chart the BI developer must investigate the analysis that needs to be conducted and the data used for it. Different BI applications may necessitate a range of charts and visualizations for each data set. The BI developer must build and test the charts to guarantee that all business specifications are met. Additionally business people should be allowed to give their feedback on the charts to make sure they meet their expectations. It is essential to take this feedback into consideration during the development process in order for the BI application to function correctly..

[Audio] We are discussing BI Design and Development. We have arrived at the last step of the BI design procedure the establishment of the overarching BI Application. This necessitates positioning the components in the complete BI Application layout introducing navigation abilities executing UI Standards and joining the components to meet business requirement. Afterwards it will move on to the BI Application Testing Lifecycle..

[Audio] BI design and development is an important component of many projects. The slide has highlighted the importance of BI application testing which is a collaborative effort between BI developers and business people whose involvement started with BI prototyping tasks. Unit tests should be conducted by the developers to ensure that the BI application operates as per specifications. Additionally BI application and system tests should also be conducted to ensure a successful implementation. With close collaboration and careful testing BI projects have a higher likelihood of success..