ITECH7406: Business Intelligence and Data Warehousing Research Report

This report provides an overview of business intelligence (BI) and data warehousing, emphasizing their applications across various industries such as transportation, banking, and manufacturing. It explores how BI, encompassing data management and analysis, facilitates decision-making, planning, and prediction. The report examines techniques like predictive analytics, content analytics, and data mining, highlighting their impact on optimizing routes, understanding customer behavior, and forecasting trends. Challenges in data collection and integration are also discussed. The analysis covers information integration, customer analytics, and planning and forecasting techniques, illustrating how BI and data warehousing offer competitive advantages by enabling businesses to understand customers, design products, and adapt to market dynamics. The report concludes that BI and data warehousing are essential for driving businesses to the next level through data-driven insights.

1
Business Intelligence
and Data Warehousing
Student Name

2
Introduction
• Business intelligence is the analysis and use of business
accumulated data for planning and decision making.
• Data warehousing refers to the storage, analysis, and
management of business data for effective business decision
making.
• Business intelligence involves data management and data
analysis that is important for business decision making.
• Business intelligence involves data management and data
analysis that is important for business decision making.
• Data are analyzed for reporting and understanding f the trend
that give more picture of customer behavior.

3
GLOBAL DATA CONNECTIONS
(Ashton, 2018)

4
Transportation Industry
• Business intelligence
• Business intelligence data mining techniques help track the pattern of transportation
system throughout an industry.
• Transport route and traffic is important for optimization of routes and planning for
transport expansion for those areas that have been identified for heavy traffic.
• Content analytics
• Content analytics technique enables the determination of effects of a certain variable in
the transport industry.
• Some of the drivers to transportation are analyzed for effective transport system is
prices, demand, competition, and energy.
• Predictive analytics
• The prediction analytics data analysis involves the analysis of the data set in the
transport industry to predict the future data pattern.
• This also helps in advising road users on the specific areas that will experience heavy
traffic over some time (Feldman & Himmelstein, 2013).

5
Energy Consumption Data
(shrinkthatfootprint.com, 2019)

6
Impact and challenges
• The data analysis and business intelligence enable planning
for heavy transport traffic during the peak seasons requires
high data management techniques that analyze the past
transport data and reporting on the future trend.
• Forecasting is normally used to model the transportation
system that is characterized with effective flow of traffic
hence better transport services (Han, Pei & Micheline, 2011)
• Collection of data especially on the global transportation
system remains a challenge

7
Driving Data

8
Banking Industry
• Information integration and governance
• Information integration and governance technique is data analysis that
plays a role in classifying customers information over a certain banking
phenomenon that is important for target market segmentation.
• Data discovery and exploration
• Data exploration technique is an analysis technique that enables banking
organizations to determine the link between various variable within the
banking transactions.
• Business Intelligence data mining
• Intelligence data mining is another data analysis technique that focuses on
the detection of outliers and anomalies within the company's data sets.
• Customer analytics
• Customer analytics technique is used in the banking industry to track
customer data behaviors leading to the prediction of some phenomenon in
banks (Chaudhuri, Dayal & Narasayya, 2011).

9
Call data analysis
(ABN Software, 2019)

10
Impact and challenges
• Banking transaction data particularly customer demand, prices,
and competition clearly enable the bank to model its service
provision hence competitive advantage against its competitors.
• Planning for customer service and modeling is enhanced through
the use of data business intelligence and data warehousing in the
banking industry (Witten, Eibe & Hall, 2011).
• Data bridges is the challenge that highly affects data collection
leading to high risk of fraud

11
Banking intelligence system
(Inove Prime 2019)

12
Manufacturing Industry
• Planning and forecasting
• Planning and forecasting is another technique that enables the
manufacturers to predict customers taste for the product
before production.
• Data and content management
• When designing product and product portfolio, data on
products that show similarity helps the producer to categorize
these products together for effective management.
• Data warehousing
• Data warehousing technique is used to store, manage and
analyses data such as product characteristics, customer base,
target market, and customers demand-related factors (Patil,
Srikantha & Suryakant, 2011).