DOC PREVIEW
K-State CIS 764 - Business Intelligence

This preview shows page 1-2-3-4-5 out of 16 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 16 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 16 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 16 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 16 pages.
Access to all documents
Download any document
Ad free experience
View full document
Premium Document
Do you want full access? Go Premium and unlock all 16 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 16 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

Business Intelligence byIntroductionBI ArchitectureSlide 4ETL ProcessData warehouse for data storage and relational designThe Micro strategy platformComponentsThe project design processSlide 10Slide 11Slide 12The below snapshot shows attributes built from a customer table. Each of these columns in the customer table architected into Micro Strategy with proper joins and business rules.Given below is a sample report generated with region Category and Sub Category which shows forecast and Revenue based on these. Various front settings and thresholds can be used to change the colors (like the above indicate the green and red based on the forecast expectations).Slide 15ReferencesGreeshma MalgireddyBusiness Intelligence (BI) systems facilitate the analysis of volumes of complex data by providing the ability to view data from multiple perspectives. An optimum business intelligence application :Gives users access to data at various levels of detail.Allows users to request information and have it delivered to them accurately and quickly.The diagram above illustrates the common setup for standardizing data from source systems and transferring that data into Micro Strategy.Source Systems for data collectionSource systems refer to any system or file that captures or holds data of interest. A bank is an example of business with source systems.A source system is usually an online Transaction processing (OLTP) system. These OLTP systems are the databases or mainframes that store real-time processing data.The ETL process consolidates data so that it can be stored in a data warehouse.The Extraction, Transformation and Loading (ETL) process involves the following steps:1.Data is gathered from various source systems.2.The data is transformed and prepared to be loaded into the data warehouse.3.The data is loaded into the data warehouse.A well designed and robust data warehouse is the source of data for the decision support system or business intelligence system.The data warehouse provides the foundation for a robust online analytical processing (OLAP) system.Data here is typically read-only and is rarely inserted, updated or deleted.Metadata 1. Configuration objects 2. Schema objects, include a) Facts b) Attributes c) Hierarchies 3.Application objects Intelligence serverDesktopWeb and web universalProjectThe above snapshots show the actual client (Micro Strategy Desktop). This is a thick client where most of the Micro strategy functionality can be managed for the Desktop. All the schema objects(attributes, facts, hierarchies etc.) must be built from this thick-client.Based on the proper user privileges various users get different access to this interface.The above snapshot shows a thin client (Micro Strategy Web universal) where most users will be seeing this interface. The users login through either micro strategy integrated corporate portals or directly launching the Web universal (Micro strategy deployed in a web server). 7The users in this interface can be given access to built various run time objects like filters (used to filter a part of data), metrics(used for calculated columns like standard deviation, average


View Full Document

K-State CIS 764 - Business Intelligence

Documents in this Course
Load more
Download Business Intelligence
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Business Intelligence and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Business Intelligence 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?