0% found this document useful (0 votes)
61 views10 pages

ISP250 Proposal: Data Warehouse Insights

The document is a coursework cover page for an individual assignment. It includes fields for the student's name, matriculation number, course details, and a student declaration. The declaration states that the work is original and acknowledges that plagiarized work may be checked using detection software. The student must sign to confirm they understand and agree to the declaration. The cover page also includes space for markers' comments and indicates a late submission may be deducted marks.

Uploaded by

Joan 夏
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
61 views10 pages

ISP250 Proposal: Data Warehouse Insights

The document is a coursework cover page for an individual assignment. It includes fields for the student's name, matriculation number, course details, and a student declaration. The declaration states that the work is original and acknowledges that plagiarized work may be checked using detection software. The student must sign to confirm they understand and agree to the declaration. The cover page also includes space for markers' comments and indicates a late submission may be deducted marks.

Uploaded by

Joan 夏
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

COURSEWORK COVER PAGE (INDIVIDUAL)

TO BE COMPLETED BY STUDENT

FULL NAME MATRICULATION NO.

1) GAN JIA PEI 1) I22022258

COURSE CODE AND


CSC2204E INFORMATION MANAGEMENT
COURSE NAME

LECTURER’S NAME Ts. MOHD FAKHRI MAT SAAD

SECTION / GROUP  6S TERM JUNE 2022

 INDIVIDUAL
COURSEWORK ASSIGNMENT DUE
26TH JUNE 2022
DETAILS  GROUP DATE
ASSIGNMENT

NOTE: PLEASE SIGN THE STUDENTS’ DECLARATION ON THE NEXT


PAGE
Students’ declaration:

I understand what is meant by plagiarism. I declare that this is my own work except where due
references are made.
I hereby certify that no part of this assignment or product has been copied from any other
student’s work or from any other source except where due acknowledgement is made in the
assignment.
I am aware that this work may be reproduced and submitted to plagiarism detection software
programs (Safe Assign) for the purpose of detecting possible plagiarism (which may retain a
copy on its database for future plagiarism checking).
I hold a copy of this assignment which I can produce if the original is lost or damaged.

Name Signature

1) GAN JIA PEI 1)

Note:
Lecturer has, and may exercise, the right not to mark this coursework if the above declaration
has not been signed. If the above declaration is found to be false, appropriate action will be
taken which could lead to ZERO mark being awarded for this coursework.

OFFICE USE ONLY

Marker’s comments

Late submission Extension Granted Deduction Final Marks

YES NO YES NO
Table of Contents

No Content Pages
1 Introduction 4
2 Question 1: Why did Generouz need an 5
enterprise-wide data warehouse? How did
integrated data drive the business value?

3 Question 2: With integrated data available in an 6


enterprise data warehouse, suggest and elaborate
ONE (1) new system / application, which
Generouz could potentially developed and
introduced?

4 Question 3: In your view, besides the 7-8


effectiveness of enterprise-wide data warehouse
technology, what other success factors that may
contribute to the overall achievement of the
implementation?

5 Conclusion 9
6 References and Appendices 10
Introduction

A data warehouse is a data management system. Data warehouses often support business
intelligence (BI) activities, especially in analytics. We can use the data warehouse for query and
analysis because it contains a lot of historical data. A data warehouse integrates data and
information collected from various sources into a comprehensive database. For example, a data
warehouse might combine customer information from an organization's point-of-sale system, its
mailing lists, websites, and comment cards. In business intelligence and data warehousing,
analysts and teams can query data to check its validity or accuracy. Business Intelligence helps
businesses ask and answer questions about their data. So, we use it to have the right data and
solid quantitative information in those answers.
Question 1

Generouz needed an enterprise-level data warehouse to help them solve the duplication and
redundancy of information caused by the lack of a unified data processing environment for
different business units. The complexity of handling data and the associated costs come into
focus, especially when dealing with mergers and acquisitions.

Generouz enhances business value by providing effective strategies through integrated data to
understand the true needs of customers. The analytical power of BI facilitates the development of
personalized marketing campaigns based on relevant customer data. Personalized campaigns in
turn can improve marketing efficiency and customer satisfaction.

Consistent and complete data enables Generouz to effectively use best practice analytics for
customer growth and retention. At the same time, product profitability, cost control and
productivity can also be improved. Generouz can adjust tactics and come up with better
strategies. Generouz sales have also grown. Because of the accurate data, they can proactively
contact customers before possible weather disasters such as floods or hurricanes to provide key
policyholder information and explain the claims process. These and other analytical insights now
drive Generouz to provide precise customer service.

Performance returns from aggregated information are also seen in financial operations. It enables
Generouz to operate a smooth, analytical center of excellence with planning, capital
management, risk assessment and other decision support capabilities to provide timely, accurate
and efficient accounting, reporting and analytical services. Without a unified business-centric
view, reporting is slow, labor-intensive, and inaccurate. It also helps Generouz with what-if
analysis. Data analytics teams can identify previously unknown potential discrepancies in the
data environment. 

On the other hands, an enterprise-wide data warehouse makes it easy for agents and employees
to view policy information at a glance. It helps to save business and technical teams a lot of time
and [Link] can be generated in 5 to 40 seconds instead of days or weeks, with some
units seeing a 10 to 20 percent increase in productivity.
Question 2

Bitrix24 was probably introduced by Generous. In my opinion, I think Bitrix24 is the best
insurance management software. Bitrix24 is a popular CRM in the insurance industry. Selling
insurance is hard in the internet age, and comparing prices is easy. It helps us with emails,
nurturing and drip marketing, phone calls, scheduling, prospecting, lead qualification, quotes,
invoicing, help desk and product catalogs, and more. We can look at current sales and make
forecasts for the near future. Additionally, Bitrix24 enables us to understand the sales funnel, see
which marketing channels bring in the most leads, and identify weak points in the sales process.
We can use Bitrix24 to manage individual sales as well as our entire company as Bitrix24 comes
with over 35 online tools that go beyond simple account management. Even better, thanks to the
free mobile app, we can take our CRM with us wherever we go. Finally, we can improve
efficiency and company profits.
Question 3

A company also need people or employees to contribute to the overall achievement of


implementation. For projects to be successful, companies need competent people. Without
people, a project can go off the rails at any time. For this, the project staff and all stakeholders of
the project must share their enthusiasm and commitment with the team. Teams should have a
similar vision for the project and aim for success. If there are defects in the team, the project
manager is in serious trouble. Inappropriate leadership and out-of-sync teams can lead to project
failure. Project managers should assign the right work to the right team members and make sure
they work well with each other.
Additionally, employees should have the skills to use the technology. Even the best technology
needs people to support the technology. If there are no people who know how to operate, then
the top technology will not be able to make the most of it. Hence, the company needs to have
perfect training in terms of personnel. Even new employees can quickly learn and master the
operation.

In addition, the company needs to have a comprehensive plan. Having a detailed plan is
beneficial to the success of the project from the very beginning. The team and stakeholders of the
project should know where the project is going from the start. This initial step in the project
allows for the creation of a realistic time frame. It provides accurate timing for generating cost
estimates and also helps to clearly document milestones and deliverables, which will make
project progress much easier. Plans detail resource requirements and act as a warning system. If
anything goes wrong, the warning system will give you a clear idea of what to expect.

Companies also need proper risk management. As we all know, the project did not go exactly as
planned. Some projects fail and others fail due to risks that arise during the project. As project
managers, we need to ensure that all stakeholders are fully aware of the risk log and where they
can find it. Even if something happens, the team can solve the problem in an efficient way with
the plan already in place. This gives the team confidence when facing project risks and helps the
client feel safe with the progress of the project.
Last but not least, open communication channels are very important to the success of the project.
When the team fully understands the importance of all aspects of the project, they will be able to
complete the work according to a specific schedule. Plus, employees learn when to say no. A
person should not make promises that they cannot keep. As project managers, we should be
honest about what can be delivered and when. Open communication allows employees to be
more engaged and understand that what they are doing is critical to the success of the business.
Conclusion

In conclusion, the integrated data brings lots of benefits to the company. It was the key of a
company become successful. However, we still need pay attention to the other success factors
that may contribute to the overall achievement of the implementation like I mentioned above.
Implementing the above factors will lead to project success and build good relationships with
clients and stakeholders. These factors also help us avoid the complex issues that project
managers face during project development.
References and Appendices

1. Payal Tikait (2012) What is Business Intelligence and Data Warehousing,


[Link]
warehousing/
2. Tanja ESCHBERGER (2018) 7 important success factors for the introduction of
innovation management, [Link]
for-the-introduction-of-innovation-management

Common questions

Powered by AI

CRM systems like Bitrix24 enhance sales processes by providing tools for managing customer interactions, marketing campaigns, and sales forecasting . The system offers lead management, helps identify efficient marketing channels, and uncovers weak points in the sales process . With these capabilities, CRM systems streamline operations, improve efficiency, and ultimately increase company profitability by optimizing the sales funnel and enhancing customer relationship management .

Successful implementation of data management projects requires competent personnel, shared enthusiasm and commitment among team members, appropriate leadership, and risk management . A comprehensive project plan detailing milestones, deliverables, and resource needs is crucial for clear direction and timely execution . Also essential is open communication within the project team to ensure engagement and problem-solving readiness . These factors help navigate project complexities and promote successful outcomes .

Generouz required an enterprise-wide data warehouse to address the duplication and redundancy of information arising from a lack of a unified data processing environment across different business units . The integrated data warehouse facilitated the development of effective strategies and improved customer understanding through business intelligence . It enabled personalized marketing campaigns, improved marketing efficiency, and customer satisfaction . Additionally, it allowed precise customer service, enhanced financial operations, and increased productivity by supporting decision-making processes with accurate and timely data .

Generouz could develop a comprehensive CRM system like Bitrix24, which would be beneficial in managing customer relationships, email marketing, prospecting, and sales processes . This CRM can help analyze the sales funnel, identify effective marketing channels, and manage sales both individually and company-wide . Such a system would support efficiency and profitability by streamlining operations and improving customer management across all business levels .

The implementation of a data warehouse enables the development of personalized marketing campaigns by providing integrated and accurate customer data . This information allows businesses to tailor marketing strategies to individual customer needs, improving marketing efficiency and customer satisfaction . Additionally, it facilitates effective customer relationship management by allowing the business to anticipate customer needs and provide proactive customer service, strengthening customer loyalty .

Inadequate leadership can lead to misaligned project teams, resulting in inefficiencies and a lack of direction, which may cause project failure . Without proper leadership, teams might struggle with coordination, motivation, and effective task execution . Such issues can derail project timelines, increase costs, and negatively impact the overall success of the project . Effective leadership is essential for aligning team goals, maintaining project focus, and ensuring smooth project delivery .

Without a unified business-centric data view, reporting becomes slow, labor-intensive, and inaccurate, potentially leading to poor decision-making . A data warehouse helps overcome these challenges by providing a centralized and integrated data platform that offers timely, accurate, and efficient data for reporting and decision support . It streamlines processes, enhances data visibility, and reduces redundancy, facilitating better strategic planning and operations .

Comprehensive planning provides a realistic framework for project execution by detailing timeframes, resources, and milestones, thereby facilitating better management and tracking of project progress . It allows for accurate cost estimation and risk assessment, creating a safety net for the project team to respond effectively to unforeseen issues . By offering clear documentation of each project step, comprehensive planning enhances coordination and reduces the likelihood of delays and budget overruns .

Success factors related to employee competencies include having well-trained and skilled individuals who can support and utilize the technology effectively . Proper training ensures that all team members, including new employees, can quickly learn and master required operations, maximizing the benefits of the technology . Competent employees are crucial for maintaining project momentum and ensuring effective technology application during implementation .

Open communication ensures that team members are engaged, understand the project's importance, and can address issues promptly, contributing to successful outcomes . It promotes honesty among project managers about deliverables, which builds trust and confidence within the team and with clients . Such transparency allows for realistic expectations and better management of project risks, ultimately enhancing overall project success .

You might also like