|Business Management Information|
Business Intelligence & Data Warehousing in a Business Perspective
Business Intelligence has become a very important activity in the business arena irrespective of the domain due to the fact that managers need to analyze comprehensively in order to face the challenges.
Data sourcing, data analysing, extracting the correct information for a given criteria, assessing the risks and finally supporting the decision making process are the main components of BI.
In a business perspective, core stakeholders need to be well aware of all the above stages and be crystal clear on expectations. The person, who is being assigned with the role of Business Analyst (BA) for the BI initiative either from the BI solution providers' side or the company itself, needs to take the full responsibility on assuring that all the above steps are correctly being carried out, in a way that it would ultimately give the business the expected leverage. The management, who will be the users of the BI solution, and the business stakeholders, need to communicate with the BA correctly and elaborately on their expectations and help him throughout the process.
Data sourcing is an initial yet crucial step that would have a direct impact on the system where extracting information from multiple sources of data has to be carried out. The data may be on text documents such as memos, reports, email messages, and it may be on the formats such as photographs, images, sounds, and they can be on more computer oriented sources like databases, formatted tables, web pages and URL lists. The key to data sourcing is to obtain the information in electronic form. Therefore, typically scanners, digital cameras, database queries, web searches, computer file access etc, would play significant roles. In a business perspective, emphasis should be placed on the identification of the correct relevant data sources, the granularity of the data to be extracted, possibility of data being extracted from identified sources and the confirmation that only correct and accurate data is extracted and passed on to the data analysis stage of the BI process. Business oriented stake holders guided by the BA need to put in lot of thought during the analyzing stage as well, which is the second phase. Synthesizing useful knowledge from collections of data should be done in an analytical way using the in-depth business knowledge whilst estimating current trends, integrating and summarizing disparate information, validating models of understanding, and predicting missing information or future trends. This process of data analysis is also called data mining or knowledge discovery. Probability theory, statistical analysis methods, operational research and artificial intelligence are the tools to be used within this stage. It is not expected that business oriented stake holders (including the BA) are experts of all the above theoretical concepts and application methodologies, but they need to be able to guide the relevant resources in order to achieve the ultimate expectations of BI, which they know best.
Identifying relevant criteria, conditions and parameters of report generation is solely based on business requirements, which need to be well communicated by the users and correctly captured by the BA. Ultimately, correct decision support will be facilitated through the BI initiative and it aims to provide warnings on important events, such as takeovers, market changes, and poor staff performance, so that preventative steps could be taken. It seeks to help analyze and make better business decisions, to improve sales or customer satisfaction or staff morale. It presents the information that manager's need, as and when they need it.
In a business sense, BI should go several steps forward bypassing the mere conventional reporting, which should explain "what has happened?" through baseline metrics. The value addition will be higher if it can produce descriptive metrics, which will explain "why has it happened?" and the value added to the business will be much higher if predictive metrics could be provided to explain "what will happen?" Therefore, when providing a BI solution, it is important to think in these additional value adding lines.
In the context of BI, data warehousing (DW) is also a critical resource to be implemented to maximize the effectiveness of the BI process. BI and DW are two terminologies that go in line. It has come to a level where a true BI system is ineffective without a powerful DW, in order to understand the reality behind this statement, it's important to have an insight in to what DW really is.
A data warehouse is one large data store for the business in concern which has integrated, time variant, non volatile collection of data in support of management's decision making process. It will mainly have transactional data which would facilitate effective querying, analyzing and report generation, which in turn would give the management the required level of information for the decision making.
The reasons to have BI together with DW
At this point, it should be made clear why a BI tool is more effective with a powerful DW. To query, analyze and generate worthy reports, the systems should have information available. Importantly, transactional information such as sales data, human resources data etc. are available normally in different applications of the enterprise, which would obviously be physically held in different databases. Therefore, data is not at one particular place, hence making it very difficult to generate intelligent information. The level of reports expected today, are not merely independent for each department, but managers today want to analyze data and relationships across the enterprise so that their BI process is effective. Therefore, having data coming from all the sources to one location in the form of a data warehouse is crucial for the success of the BI initiative. In a business viewpoint, this message should be passed and sold to the managements of enterprises so that they understand the value of the investment. Once invested, its gains could be achieved over several years, in turn marking a high ROI.
Investment costs for a DW in the short term may look quite high, but it's important to re-iterate that the gains are much higher and it will span over many years to come. It also reduces future development cost since with the DW any requested report or view could be easily facilitated. However, it is important to find the right business sponsor for the project. He or she needs to communicate regularly with executives to ensure that they understand the value of what's being built. Business sponsors need to be decisive, take an enterprise-wide perspective and have the authority to enforce their decisions.
Implementation of a DW itself overlaps with some phases of the above explained BI process and it's important to note that in a process standpoint, DW falls in to the first few phases of the entire BI initiative. Gaining highly valuable information out of DW is the latter part of the BI process. This can be done in many ways. DW can be used as the data repository of application servers that run decision support systems, management Information Systems, Expert systems etc., through them, intelligent information could be achieved. But one of the latest strategies is to build cubes out of the DW and allow users to analyze data in multiple dimensions, and also provide with powerful analytical supporting such as drill down information in to granular levels. Cube is a concept that is different to the traditional relational 2-dimensional tabular view, and it has multiple dimensions, allowing a manager to analyze data based on multiple factors, and not just two factors. On the other hand, it allows the user to select whatever the dimension he wish to choose for analyzing purposes and not be limited by one fixed view of data, which is called as slice & dice in DW terminology.
BI for a serious enterprise is not just a phase of a computerization process, but it is one of the major strategies behind the entire organizational drivers. Therefore management should sit down and build up a BI strategy for the company and identify the information they require in each business direction within the enterprise. Given this, BA needs to analyze the organizational data sources in order to build up the most effective DW which would help the strategized BI process.
High level Ideas on Implementation
At the heart of the data warehousing process is the extract, transform, and load (ETL) process. Implementation of this merely is a technical concern but it's a business concern to make sure it is designed in such a way that it ultimately helps to satisfy the business requirements. This process is responsible for connecting to and extracting data from one or more transactional systems (source systems), transforming it according to the business rules defined through the business objectives, and loading it into the all important data model. It is at this point where data quality should be gained. Of the many responsibilities of the data warehouse, the ETL process represents a significant portion of all the moving parts of the warehousing process.
Creation of a powerful DW depends on the correctness of data modeling, which is the responsibility of the database architect of the project, but BA needs to play a pivotal role providing him with correct data sources, data requirements and most importantly business dimensions. Business Dimensional modeling is a special method used for DW projects and this normally should be carried out by the BA and from there onwards technical experts should take up the work. Dimensions are perspectives specific to a business that could be used for analysis purposes. As an example, for a sales database, the dimensions could include Product, Time, Store, etc. Obviously these dimensions differ from one business to another and hence for each DW initiative those dimensions should be correctly identified and that could be very well done by a person who has experience in the DW domain and understands the business as well, making it apparent that DW BA is the person responsible.
Each of the identified dimensions would be turned in to a dimension table at the implementation phase, and the objective of the above explained ETL process is to fill up these dimension tables, which in turn will be taken to the level of the DW after performing some more database activities based on a strong underlying data model. Implementation details are not important for a business stakeholder but being aware of high level process to this level is important so that they are also on the same pitch as that of the developers and can confirm that developers are actually doing what they are supposed to do and would ultimately deliver what they are supposed to deliver.
Security is also vital in this regard, since this entire effort deals with highly sensitive information and identification of access right to specific people to specific information should be correctly identified and captured at the requirements analysis stage.
There are so many advantages of BI system. More presentation of analytics directly to the customer or supply chain partner will be possible. Customer scores, customer campaigns and new product bundles can all be produced from analytic structures resulting in high customer retention and creation of unique products. More collaboration within information can be achieved from effective BI. Rather than middle managers getting great reports and making their own areas look good, information will be conveyed into other functions and rapidly shared to create collaborative decisions increasing the efficiency and accuracy. The return on human capital will be greatly increased.
Managers at all levels will save their time on data analysis, and hence saving money for the enterprise, as the time of managers is equal to money in a financial perspective. Since powerful BI would enable monitoring internal processes of the enterprises more closely and allow making them more efficient, the overall success of the organization would automatically grow. All these would help to derive a high ROI on BI together with a strong DW. It is a common experience to notice very high ROI figures on such implementations, and it is also important to note that there are many non-measurable gains whilst we consider most of the measurable gains for the ROI calculation. However, at a stage where it is intended to take the management buy-in for the BI initiative, it's important to convert all the non measurable gains in to monitory values as much as possible, for example, saving of managers time can be converted in to a monitory value using his compensation.
The author has knowledge in both Business and IT. Started career as a Software Engineer and moved to work in the business analysis area of a premier US based software company.
Business Relationship Germs
In management seminars I often compare debt to an infection. A reasonable amount of debt will not kill a business, but too much debt will. While most businesses carry a substantial amount of debt from time to time, it must be maintained in an acceptable relationship to stockholder's equity.
Performance Appraisal Checklist: Raise Not Just Appraise Performance
It's that time again! Perhaps the most dreaded management practice is the annual performance review. Whenever the subject comes up, out comes the groans from both managers and staff no matter what industry or type of company. Many say appraisals are like having a root canal ? only more painful. It shouldn't be.
The Comfort Zone
The Comfort Zone I have a friend named Gene, a serial entrepreneur who currently runs a software business. Like many people, last year was a tough one for his company. They survived largely by providing add-on services to existing customers - a decent response to difficult circumstances. They even grew revenues a bit. But here's something else that happened: They got comfortable. They decided they could exist on their base of customers, and then they "realized" there would be no new ones.
Relationship Building - 5 Tips and 5 Questions
And is isn't hard - it's more about focusing on people, who they are and what interests them. And that's just where you spend your time. About them - not you, not your business. Create partnerships.
Measuring Creativity, DIY style
Creativity measurement is often required in order to benchmark existing competencies, monitor improvement, increase output and generally provide tangible and useable processes and structures for clients.
Creativity and Innovation Management ? Motivation and Management Layers
Creativity can be defined as problem identification and idea generation whilst innovation can be defined as idea selection, development and commercialisation.
Management to the Vision-Contribution and the Role of Compliance
As a manager our role is to:
Writing and Revising Your Life Story
Change is not simple. Why do we repeat behavior that doesn't work? Those actions that lead to stifling debt, disappointing careers, or stuck relationships? Then do it harder, yet expect a different result? Why is it not obvious that trying to exit an old story by simply writing a "better ending" only recreates the same story, and ensures that we remain in it? That a thousand better endings to an old story don't create a new story? That the past cannot be changed and is a settled matter? That too often, we see ourselves as the victims of the stories that we author and the feelings we create?
Sharing the Reins: 10 Reasons To Sell Your Company To Your Employees
In 1987 I sold my business, South Mountain Company, to my employees (and myself). My sole proprietorship became an employee-owned cooperative corporation. It was a hinge point in the history of the company. Ownership has become available to all employees, enabling people to own and guide their workplace. The responsibility, the power, and the profits all belong to the group of owners.
Rethinking Workplace Security: How the Rules Have Changed
The workplace has traditionally been a dangerous place. Very early in mankind's history perils emanated from the place and type of work they performed. Long before industrialization, men mined precious metals, gems and fuel in the form of peat and coal hidden beneath the earth's surface. Extracting these materials brought with it the risk of cave-ins and being buried alive. Moreover, the quest for the most basic of all life giving substances, water, could also end in sudden death or severe injury as well shafts were dug in the soft earth.
Success at Work : People Skills : Dealing with New Ideas
Re-organizing, re-engineering, re-training, down-sizing, outsourcing, changing-changing-changing. Organizations today think they need to be constantly changing or they will perish. Corporate leaders worship at the alter of new ideas where the motto is, "Any new idea is a good idea".
Four Employee Behaviors That Can Kill Your Business
I found it important to clarify for employees what "deal-breaker" behavior was at my company. These are the things I insisted would not be tolerated and would lead to immediate or ultimate termination, depending on the nature of the infraction of these hard and fast rules. Here are the behaviors I would not tolerate:
Use Noncompete Agreements To Protect Your Business
Q: One of my former employees has launched an online business very similar to mine and is contacting my clients and trying to steal their business from me. Do I have any legal recourse against him? -- Brad J.
Quality Standards with ISO 9001
Standardizing Quality Systems
Project heroes. We've all heard of them. Some of us have even seen them. A project is in jeopardy. This guy (or gal) comes out of nowhere, analyzes the situation, tells you exactly what the problem is, and then goes on to fix it before you can even update your project plan!
The Compliance Officers Killer Application
It used to be that only the largest multi-nationals needed a Compliance Officer. Today most practices, regardless of size, would be wise to charge someone within their organisation with the responsibility of keeping abreast and managing the compliance process.Take as an example European employment law that has been introduced over the last few years that has changed the face of European businesses. Small businesses in particular are finding that a casual and informal approach to employment issues can now result in statutory fines that have no bearing on the financial health of the individual company and could, without as much as a by your leave, directly result in the demise of a company.Small to medium businesses do not often have the luxury of employing a full time Compliance Officer and although larger organisations can afford a dedicated person they are finding that with compliance issues mushrooming the Compliance Officer now has a team, a department and if not already, how long before compliance becomes a division? Regardless of size, the first step in compliance for any organisation requires them to identify the areas of compliance that are applicable to them. Rules and regulations are being introduced monthly on a local, regional, national and international level, covering everything from data protection and freedom of information, anti-money laundering to environmental waste control, race relations to health and safety; with ignorance being no defence there is a requirement on the individual businesses to know their responsibilities, and fines for those that wait to be told. Having identified the areas of compliance the company then needs to understand what they need to do to ensure they comply. It is becoming conceivable that with the shear volume of compliancy issues that companies who can show a good faith effort in complying will, even when they fall short, reduce the risks of fines.Having identified and understood the compliance issues the Compliance Officer needs to define and implement policy and disseminate the information throughout the organisation.It is important for the Compliance Officer that they do not inadvertently become the company's patsy. Senior managers are not averse to ignoring the internal memos they receive advising them of their responsibilities. Compliance Officers need to deliver their messages up and down the corporate food chain and record that their advice and directives have been received and more importantly understood.The Compliance Officer has to avoid becoming the company scapegoat. This won't happen by itself, a sales team that has a long history of success though a relaxed attitude to selling is not going to willingly adopt new, and what they will see as restrictive, practices without a fight. 'I didn't get the memo', 'I didn't understand it', 'I thought it meant something else', 'I thought these were only guidelines' are likely to be stock replies, along with the one or two old timers that didn't think compliance issues applied to them. It used to be a safe bet to blame IT, blame Compliance is rapidly taking its place.One valuable tool in the Compliance Officer's tool box is the online survey and questionnaire.The online survey can deliver a message internally to the individual; it can be informative like a memo and educational by referencing detailed policy. Importantly it can become a valuable self registering record that confirms that the information has been properly disseminated and understood.A single survey question can achieve all these objectives at the same time.Take an example:-Are you aware that section 45 of the Companies (Auditing and Accounting) Act 2003 imposes an obligation on directors of certain companies to prepare statements on their company's compliance with its relevant obligations? (Click here for a summary of Company's Policy on Compliance Reporting Obligations)YesNoFor those Directors that have not read the policy the survey will give an opportunity to view the company's policy online (using an embedded live HTML link). Should Directors answer 'No' the Compliance Officer knows who to target.The survey also records the manager's response and shifts the responsibility away from the Compliance Officer to the individual manager where the responsibility needs rest for a company to meet its compliance obligations.Using an online website such http://www.surveygalaxy.com where multiple surveys can be managed, easily modified, updated and re-issued on a periodic basis across an organisation online surveys can be the Compliance Officer's killer application.Through the regular use of online surveys the Compliance Officer will be in the driving seat, leading and not chasing compliance issues, not only circulating the information on a one to one basis but also monitoring and recording the level of awareness throughout the organisation.The Compliance Officer's role is a difficult one, like a parent keeping a wayward child on the straight and narrow, most employers, let alone their employees, often do not fully understand the true consequence of their, often innocent, minor discretions. Assigning a Compliance Officer is a start but enabling them to fulfil their remit will be the difference between a company being fully compliant and one that risks suffering the consequences for having let compliance take a back seat.
One Crazy Cookie
In order to survive, you have to be happier than if you were in your right mind.
The Power of the Contract in Performance Management
An essential step in managing the performance of salespeople is that of establishing a sound and agreed contract between manager and the salesperson. A contract in this context is simply an agreement between the manager and the salesperson as to how best they are going to work together. It is a chance for each party to outline expectations, hopes and fears and is a superb opportunity for both the manager and salesperson to fully understand each other in terms of personality style, motivators and de-motivators. It is also an opportunity for the manager to ensure that the salesperson fully understands their role and their responsibilities as well as their sales and activity targets.
The Dog That Didnt Bark
A few weeks ago, after consultations with others in an association I represent, I made a partnership pitch to another organization with similar interests. If the idea comes to fruition, it will radically change our organization.
Is Your Company in Need of Family Therapy?
How Companies Are Like Families
|home | site map|