Conceptual Framework for Business Intelligence

Conceptual Framework for Business Intelligence

The term Business Intelligence (BI) incorporates the concept of deriving useful information from the data in an organization. Designing a BI application involves multiple layers. The goal of this section is to provide a common framework for architects and developers. This framework is conceptual, technology agnostic, and covers the major phases, features, and functionality required to effectively implement a BI solution. The conceptual architecture in below Figure is comprised of five major areas and a set of cross-cutting concerns.

Conceptual system architecture

Data Storage is the end result of Data Source and Data Integration layers.  Data Storage can be termed as Data Warehouse (DW)/Data Mart (DM).  Data Analysis and Data Presentation will leverage the information stored in Data Storage.

Comments

  1. pridesysOctober 31, 2018 at 4:06 PM

    thanks for helpful post. Pridesys Business Intelligence (BI) is offering you easy-to-use analytics and business intelligence tools. With these tools you can explore your data. Create new patterns, rich visual and insights. for more info visit: http://pridesys.com/business-intelligence-and-analytics/

    ReplyDelete
  2. Rohit PrabhakarAugust 3, 2021 at 5:52 PM

    Thanks for sharing such useful content
    Business Analytics

    ReplyDelete
  3. Ariel BickMay 28, 2022 at 1:16 PM

    Along with development of your website, if you look for proper and diverse Web Development Services, you can expect to get the services in content development, as well. In fact, before you settle into a deal with the company.

    Hire Dedicated Flutter Developers

    ReplyDelete

Post a Comment

Popular posts from this blog

SSRS Report Design: Best Practices

Introduction Microsoft® SQL Server™ Reporting Services is a comprehensive reporting tool. In using Reporting Services, you can design and deliver a wide range of reports, from simple tables to online free-form reports with graphical items and interactive links. Reporting Services can render reports for a variety of client-viewing formats, including HTML, PDF, Excel, and image formats. The wide variety of options and choices can be problematic for report authors who must make numerous decisions when choosing how to lay out a report. This paper provides a few guidelines to make these decisions easier and answers common questions.
Read more

SSAS OLAP Design - Best Practices

Introduction This paper outlines the recommended best practices for designing OLAP databases in Microsoft SQL Server 2005 Analysis Services to better meet the functional and performance needs of users. Designing a database for Online Analytical Processing (OLAP) databases is very different from designing a database for Online Transaction Processing (OLTP) and requires a different approach for achieving optimal results. The best practices recommendations are grouped into the following sections: Data Source Design Best Practices Dimension Design Best Practices Cube Design Best Practices Partition Design Best Practices Aggregation Design Best Practices Within each section, these best practices are ordered roughly by priority, where priority is a combination of how important the best practice is and how often you must worry about it. Major topics not covered include best practices for the design of calculations and for server management and operations.  These two topics are s...
Read more

Business Intelligence Basics

BI Concept:  Star Schema: The star schema has a center, represented by a fact table, and the points of the star, represented by the dimension tables. Snowflake Schema: In a snowflake, the dimension tables are normalized. ODS: ODS should be considered only when information retrieval requirements are to be real time and cannot access OLTP systems because of criticality of resources. Dimension Types: Changing Dimension:  Changing dimension is the dimension which has at least one attribute whose value would change over the time. Slowly Changing Dimensions: Attributes of a dimension that would undergo changes over time. For example: Employee work location  • Type I: The existing record is updated with change. • Type II: History is preserved, a new record is added to dimension and old record is marked as inactive.  EndDate or IsLatest is generally used to represent latest record of a business key. • Type III: Type III preserve...
Read more