Preview

Best Practices for Msbi

Good Essays
Open Document
Open Document
1064 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Best Practices for Msbi
Best Practices for MSBI
· Extracting data from source systems, transforming it, and then loading it into a data warehouse
· Structuring the data in the warehouse as either third normal form tables or in a star/snowflake schema that is not normalized
· Moving the data into data marts, where it is often managed by a multidimensional engine
· Reporting in its broadest sense, which takes place from data in the warehouse and/or the data marts: reporting can take the form of everything from printed output and Microsoft Office Excel® spreadsheets through rapid multidimensional analysis to data mining.
SQL Server 2008 provides all the tools necessary to perform these tasks [MMD07].
· SQL Server Integration Services (SSIS) allows the creation and maintenance of ETL routines.
· If you use SQL Server as a data source, the Change Data Capture feature simplifies the extraction process enormously.
· The SQL Server database engine holds and manages the tables that make up your data warehouse.
· SQL Server Analysis Services (SSAS) manages an enhanced multidimensional form of the data, optimized for fast reporting and ease of understanding.
· SQL Server Reporting Services (SSRS) has a wide range of reporting abilities, including excellent integration with Excel and Microsoft Office Word. PerformancePoint Server™ makes it easy to visualize multidimensional data.
Moreover, Microsoft Office SharePoint Server® (MOSS) 2007 and Microsoft Office 2007 provide an integrated, easy-to-use, end-user environment, enabling you to distribute analysis and reports derived from your data warehouse data throughout your organization. SharePoint can be used to build BI portal and dashboard solutions. For example, you can build a score card application on top of SharePoint that enables employees to get a custom display of the metrics and Key Performance Indicators (KPIs) depending on their job role.
Design from the
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    MIS 535 Course Project Proposal Srilakshmi
    • 641 Words
    • 3 Pages

    MIS 535 Course Project Proposal Srilakshmi

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    MIS 563 COURSE PROJECT
    • 2795 Words
    • 12 Pages

    MIS 563 COURSE PROJECT

    "Introduction to the Report Center." - SharePoint Server. N.p., n.d. Web. 13 Feb. 2014. http://office.microsoft.com/en-us/sharepoint-server-help/introduction-to-the-report-center-HA010174199.aspx…

    • 2795 Words
    • 12 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Rlht2 Task 3
    • 1508 Words
    • 7 Pages

    Rlht2 Task 3

    Datanal, Inc., was established by five IT entrepreneur colleagues in 2002. It enjoys a reputation for outstanding performance and presently employs some 350 IT specialists, most with proven skill in analyzing, organizing, and managing large, diversified streams of data and databases in logical, systematic form, transparently and effectively bridging present artificial separations. By enabling customers to assimilate a consistently large influx of new data while simultaneously drawing from previously unrealized complementary database…

    • 1508 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Better Essays

    Unit 217 Organise and Report Data
    • 2343 Words
    • 10 Pages

    Unit 217 Organise and Report Data

    It is usually presented in the form of a report in tables, charts, statistics, and graphs or on spread sheets etc. This data may be used to arrive at important decisions within the organisation or with external organisations. So the data report has to be produced in such a way that it meets the aims and objectives of the requirement.…

    • 2343 Words
    • 10 Pages
    Better Essays
    Read More
  • Best Essays

    Kudler Dimensional Model Hands-on-Project
    • 1512 Words
    • 7 Pages

    Kudler Dimensional Model Hands-on-Project

    To extract the data, each source’s distinct set of characteristics will need to be managed and integrated into the ETL system. The content of the logical data mapping document has been proven to be the critical element required to plan ETL process. The primary purpose of this document is to provide the ETL developer with a clear-cut blueprint of exactly what the expectations are from the ETL process.…

    • 1512 Words
    • 7 Pages
    Best Essays
    Read More
  • Good Essays

    Huffman Trucking Data Warehouse Report
    • 891 Words
    • 3 Pages

    Huffman Trucking Data Warehouse Report

    The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a…

    • 891 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Bis Midterm Sheet
    • 1467 Words
    • 6 Pages

    Bis Midterm Sheet

    A data warehouse is to extract and clean data from operational systems and other sources to store and catalog that data for processing by BI tools. Data warehouses can include external data purchased from outside sources. Meta data is kept in the data warehouse. Physically, a data warehouse consists of a few fast computers with very large storage devices.…

    • 1467 Words
    • 6 Pages
    Good Essays
    Read More
  • Powerful Essays

    Bi Software Package Recommendation
    • 1214 Words
    • 5 Pages

    Bi Software Package Recommendation

    The purpose of this report is to present the findings of an analysis which was conducted on SAS (statistical analysis software) in order to make a buying recommendation to the organization for the best BI (Business Intelligence) software package. Business intelligence can be a tremendously valuable tool for organizations such as ours when it is used properly. The ability to look at the results from the analysis of actual business data and make decisions is critical for our success. This will give our managers the ability to make decisions based on fact instead of educated guesses and theories. SAS’s BI software will provide our organization with the ability to surmount today's challenges and make the most of tomorrow's opportunities by aiding us in achieving our short-term and long-term goals and in gaining maximum returns from our information assets.…

    • 1214 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Assignment 3: Business Intelligence And Data Warehouse Paper
    • 628 Words
    • 3 Pages

    Assignment 3: Business Intelligence And Data Warehouse Paper

    Database is designed to make transactional systems that run efficiently. Characteristically, this is type of database that is an online transaction processing database. An electronic strength record system is a big example of a submission that runs on an OLTP database. An OLTP database is typically controlled to a single application. The significant fact is that a transactional database does not lend itself to analytics. To effectively achievement analytics, you require a data warehouse. A data warehouse is a database of a diverse kind of an online analytical processing database (In Yang, In Everson & in Yin, 2004). A data warehouse survives as a layer on top of another OLTP databases. The data warehouse obtains the data from all these databases and builds a layer optimized for and dedicated to analytics. A database designed is used to handle transactions designed analytics. It is not structured to do analytics well. A data warehouse is structured to make analytics fast and easy.…

    • 628 Words
    • 3 Pages
    Good Essays
    Read More
  • Better Essays

    The Wild Frontier (3)
    • 1024 Words
    • 4 Pages

    The Wild Frontier (3)

    Our decision to implement Windows SharePoint Services will help meet many of the criteria for providing support for the additional remote offices and help prevent duplication of work. SharePoint will possibly be a powerful tool to make decision making easier. Familiar tools that are powerful that are reporting and analysis features which are easy to use. Interfaces that are familiar that enables users be comfortable working with data. It will possibly improve the company’s effectiveness. Adding interactive dashboards and scorecards that help users define and measure accomplishments, could be a benefit as well. Using key metrics can be matched to specific strategies, plus shared, discussed and maintained. The benefits of a complete reporting and an analysis solution includes also a full set of features that will be…

    • 1024 Words
    • 4 Pages
    Better Essays
    Read More
  • Powerful Essays

    The Voip Adoption
    • 1699 Words
    • 7 Pages

    The Voip Adoption

    development that occurs? In order for real time data warehousing to work many elements are required. These include the mainframe reservation system, satellite feeds from airplanes, central customer database and all other data sources such as their website, customer service applications, frequent flyer programs and reservation systems. Each of these works together and for every change that is made it is sent back to the data warehouse and displayed or is available to all customers within minutes (Brown, DeHayes, Hoffer, Martin, and Perkins, 2003).…

    • 1699 Words
    • 7 Pages
    Powerful Essays
    Read More
  • Good Essays

    Database Usage in the Workplace
    • 592 Words
    • 3 Pages

    Database Usage in the Workplace

    Another advantage of the database approach is flexibility in terms of data usage. The data is kept in…

    • 592 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    dfdfdfdfdfdfdfdfdf
    • 352 Words
    • 2 Pages

    dfdfdfdfdfdfdfdfdf

    14) Sometimes, large organisations break out ________ from their data warehouses so they can be used for a specific functional area of the organisation like marketing or…

    • 352 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Information System
    • 323 Words
    • 2 Pages

    Information System

    MIS, produces reports summarized from transaction data, usually in one function area, Reports on total sales for each customer.…

    • 323 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Management Information System
    • 266 Words
    • 2 Pages

    Management Information System

    -enables managers and analyst to interactively examine and manipulate large amounts of detailed and consolidated data from many perspectives.…

    • 266 Words
    • 2 Pages
    Satisfactory Essays
    Read More

Related Topics