business intelligence

Data Warehouses for Educational Analysis {1}

by Eric C
In a peer reviewed journal entitled “Building a Data Warehouse to Analyze Entrance Exams” written by Dr. Kornelije Rabuzin, explains building a data warehouse dedicated to student data for analysis. Using business intelligence and the combination of databases and data warehouses, it is possible to analyze student data for educational purposes. Such analysis will determine, based on an entrance exam administered to high school students, to see if students are ready for college and what materials do they know or do not know. Having such data and information can give administrators a handful of reports to determine what the best steps are for students going to college after high school. Based on the types of information mentioned in the article, it didn’t seem much can be done to analyze data based on entrance exam scores, high school grades, and regular exam scores. However, it was difficult to extract such information from various databases and it took much programming and two months. The data was loaded and organized into a star schema structure. But after loading everything into the new database warehouse, it was very useful to determine the student selection process and targeting high schools for certain skills in students. read more...

Significance of Data Modeling in Today’s Business {2}

by Michael V
In today’s modern day business, the day to day operations of a company are so complex that it would be impossible to process by normal means. Raw data is no use to any human being until it is processed to a point of becoming “information” that can be readily absorbed by people to gain the intelligence over business affairs that they need. This is where data modeling comes into play. Data modeling is essentially a process in which basic data in the form of unintelligible words and numbers is converted into a picturesque format that allows information to be absorbed with a mere glance. read more...

Improving Business With Cloud Computing {2}

by Chris S
This article focused on several benefits cloud computing can have on a business. A small list that was mentioned include data duplication, outsourcing, technical capability increase, and data handling. Some of the bigger ideas behind cloud computing improving a business are reducing their costs, security, and convenience. All these reasons tied together would create more efficiency for any business. By using cloud computing technology, businesses will be able to enhance and perform all their operations with ease. read more...

{Comments Off on }

by Willen L
In this web page article lists a summary of each company and what they’ve done to win the TDWI Data Warehousing Institute Awards for 2011. If you don’t know what these awards are, it is one of the most prestigious awards that highlight best data warehousing practices. The contestants can apply to different categories of their choosing. Some categories are advanced analytics, BI on Limited Budget, Emerging Technologies and Methods, Enterprise BI, Enterprise Data Management Strategies, Enterprise Data Warehousing, Government and Non-profit, Organizational Structures, Performance Management, and Right-Time BI. Here is a list of winners that won in 2011 categorized by category they competed in. If you are interested in learning more about these companies and what they did to obtain these awards here is the link. http://tdwi.org/pages/best-practices-awards/tdwi-best-practice-awards-2011-winners/tdwi-best-practive-awards-2011-winner-summaries.aspx read more...

What to Expect in Data Warehousing {2}

by Penny P
Data warehouses play a critical role in corporation/institutions. They allow users to quickly retrieve data to be used for data mining or for data analysis tools. The results that they get from these tools are then used to support business decisions that would be made. The authors of the article designed a case study that would help beginners understand the basics of data warehousing. Using the enrollment data from Universities, the main objective was to prepare the data for a mining system that would be used for predicting student enrollment. read more...

Data Warehousing’s Full Potential: Not Reached? {2}

by Davina V
According to the article a new survey of 421 data managers and professionals affiliated with Independent Oracle Users Group (IOUG) members find “that while most companies have well-established data warehouse systems, adoption is still limited within their organization”. Data warehouses serve as the foundation for business intelligence and analytics applications across 66% of the companies in the survey. However in many of these organizations the data within these warehouses remain separated from its mainstream business operations. Only 33% on the respondent’s companies enable its use for their marketing and sales departments. About a third of the responses indicated that the companies made significant investments in 2010 to 2011 but are unsure about investments for 2012. Thirty percent report budget increases exceeding 25 percent, however this was conducted in mid-2011 and respondents were unsure of the budget for data warehousing. Close to 90% of the respondents have reported an increase of volume in their companies’ data warehouses, and expect it to continue growing. But close to 50% are unsure that the warehouses “will be able to scale down to meet future data requirements”. Over all the people who took the survey stated that the information could have been used better. Some of the information implies that some of the data is duplicated and as a whole may be unorganized. A majority of the respondents expect that to change in the future, though. read more...

Internet Business Intelligence {Comments Off on Internet Business Intelligence}

by Marco M
This article describes the very large amounts of data available on the Internet and focuses on products or tools related to the extraction of data.  Data mining is the extraction of data from the Internet for commercial purposes and is type of business intelligence (“BI”).  BI is a powerful marketing tool for any organization, large or small, e-commerce or non-profit.  It provides information that would help achieve an organization’s goals; however, there is a lack of resources when searching for information about it. Some of the “major BI players” and their BI tools are as listed in this article.  For example, “IBM Cognos 8 provides Dashboards for visualization and Scorecarding for teamwork; Information Builders’ WebFOCUS, in addition to BI, also integrates performance management and data analytics in their tools; JasperSoft’s open source BI Suite supports data analysis, integration, and visualization as well as Web interface capability; Microsoft’s BI Tools are based on SharePoint and SQL services and reporting, which are highly integrated with Office 2010; Oracles’ Business Intelligence Enterprise Edition 11g has various tools that make CRM analytics and ERP analytics easily accessible by users; and finally SAP’s Business Objects XI aims to provide user-friendly data and analytics visualization”. All of these products are designed for “enterprise information systems”.  This article also mentions the need for business intelligence in the industrial and academic bio-research areas.  It discusses the lack of published resources available, and the article ends by predicting that business intelligence can be utilized to acquire information on competitors, track users and “mining can assist in profiling users “. read more...

DBS Business Intelligence {Comments Off on DBS Business Intelligence}

by Jintien C
Database Management Systems is like a bridge between database and user. Under advanced DBS information technologies, Business Intelligence is primary for enterprise to manage and analyze its business information systems. It is designed for flat data structure and complex calculation. And redundancy is introduced. Its data storage is transaction summary for historical data. Multiple integrated applications are in the data storage. Business Intelligence’s data access is only queries with average responding time. read more...