Tags |
|
|
Links |
|
|
Other Added - Data Warehousing - Tom's Ten Data Tips
Most people spend long hours each week in their office, making it very important to have the right style of furniture. While comfort is important, you really need to be more focused on the office furniture being ergonomically correct then on the color or material of it.You will feel much better at the end of the work day, and have more energy to complete your tasks with an ergonomically correct office chair. It will help improve your posture, resulting in less pain in your back and neck areas. It will also reduce the risk of office injuries and claims.If you use a computer in your office on a regular basis, not having the right posture can lead to carpal tunnel in your wrists. This is the result of moving them in a particular repetitive motion throughout the day. Along with an ergonomically correct keyboard, you can prevent such injuries from happening.Many manufacturers of ergonomically correct office furniture offer a wide selection of office furniture products to choose from. This allows you to still get a great looking office but one that is designed for your body as well. It is a good idea to purchase ergono
5. What is Different About Warehousing Web Data?
Kimball & Merz (2000): "Although this clickstream data in many cases is raw and unvarnished, it has the potential of providing unprecedented detail about every gesture made by every huma
A supply chain, logistics network, or supply network is a coordinated system of organizations, people, activities, information and resources involved in moving a product or service in physical or virtual manner from supplier to customer. Its management deals with the process of planning, implementing, and controlling its operations with the purpose of satisfying customer requirements as efficiently as possible.Supply chain management spans all movement and storage of raw materials, work-in-process inventory, and finished goods from point-of-origin to point-of-consumption. It integrates supply and demand management within and across companies.If a supply chain management system is properly implemented, strategic and competitive areas can be used to their full advantage. Fulfillment is enabled through efficient communication, ensuring that orders are placed with the appropriate amount of time available to be filled. The supply chain management system also allows a company to constantly see what is on stock and making sure that the right quantities are ordered to replace stock.Logistics is enhanced, keeping the co
How large the Data Warehouse market will grow nobody knows yet. But for sure it is still growing fast, and currently is estimated at 4,5 billion dollar per year (IDC).
1. Why Do Data Warehouse Projects Run Into Scope Creep?
To quote Bill Inmon (guru and author of several great books on Data Warehousing) "Traditional projects start with requirements and end with data. Data Warehousing projects start with data and end with requirements." As soon as the project gets under way, users will find new applications, and with it will come new requests for data. Interestingly, these projects often are justified by moving Q&R work away from the 'data people'. What we've seen is that the first thing that happens as soon as the project delivers is that more requests for special queries are submitted to these same 'data people'. This may appear to undermine the initial business case but actually signals the onset of value creation from the DWH project.
2. Star Schema Versus Entity Relation Model?
There has been enormous debate in the community about the merits of different data models. At the risk of over simplifying: ER models tend to have better performance (processing time) for the end user, and are often perceived as "easier" to understand by end users. Drawbacks are that ER models require more disk space, and, because of the intrinsic redundancy in the data, have consistency problems from a maintenance perspective. Having said this, the practice seems to be that often some combination of the two is unavoidable in the practical setting, despite preferences (ER or Star) of the chief architects. Overall, Star models seem to have gained the most ground.
3. The Importance of a Data Warehouse Business Case
Much has been written about the business case for a Data Warehouse. What goes in to a good business case? IT savings are ubiquitous in DWH business cases. The important point is to not limit this to 'pure' savings, but to connect to primary business processes as much as possible. As an example, faster turnaround cycles for list selections are fine (when quantified in hourly rates), but it is even better if the revenue from more customer acquisitions that follow from these selections can be tied in. Not only will the relation to revenue growth rather than savings make for a more balanced business case, more important is the intrinsic business buy-in that results from a direct connection to the company bottom line. These days, changes in legislation (in particular Sarbanes-Oxley) play a major role in justifying business cases. This may be either through a higher company valuation for its transparent information gathering, or, less sleepless night for the CEO, which is of course priceless...
4. Why Do Data Warehouse Projects 'Never' Go Wrong?
Actually, Data Warehouse projects do sometimes fail. But, they fail so rarely, that it is actually very hard to believe... Especially after having talked to so many disgruntled end-users. And there are many ways a Data Warehouse project can go wrong. Delivering on time, data administration issues, and unavoidable data quality issues in feeding systems. Corporate politics (see Tip 7) are probably the best explanation for this phenomenon of near 100% success rates on DWH projects. In my experience, the reason why a failure or 'semi-failure' can go unnoticed is either because senior management is not aware, or, let's say "unmotivated" to talk about misspending of company funds. As a result, not enough is learned. Maybe we as consultants have a stake in this as well, as this assures the industry plenty of ongoing business... J
5. What is Different About Warehousing Web Data?
Kimball & Merz (2000): "Although this clickstream data in many cases is raw and unvarnished, it has the potential of providing unprecedented detail about every gesture made by every human
As another new calendar or fiscal year begins, it is wise to take a good hard look ahead at where your business is heading in light of the business environment of the new year. It is also wise to develop new goals for the upcoming year in this new business environment. The way to take this proactive and positive step in your business is to use strategic thinking and planning.Looking at the start of a new year, we can acknowledge some uncertainty in the business environment and perhaps in our personal lives. Therefore, it is the perfect time to engage in strategic thinking and planning to benefit from the opportunities that are always present, especially during uncertainty.So what are the benefits of using strategic thinking and planning for a new year? Here are seven (7) benefits, according to your strategic thinking business coach.Benefit # 1: An opportunity to take a fresh look t the business environment and how to strengthen your business to take advantage of the changed business environment.Benefit #2: An opportunity to take a fresh look at your business vision and mission. And to make any need
2. Star Schema Versus Entity Relation Model?
There has been enormous debate in the community about the merits of different data models. At the risk of over simplifying: ER models tend to have better performance (processing time) for the end user, and are often perceived as "easier" to understand by end users. Drawbacks are that ER models require more disk space, and, because of the intrinsic redundancy in the data, have consistency problems from a maintenance perspective. Having said this, the practice seems to be that often some combination of the two is unavoidable in the practical setting, despite preferences (ER or Star) of the chief architects. Overall, Star models seem to have gained the most ground.
3. The Importance of a Data Warehouse Business Case
Much has been written about the business case for a Data Warehouse. What goes in to a good business case? IT savings are ubiquitous in DWH business cases. The important point is to not limit this to 'pure' savings, but to connect to primary business processes as much as possible. As an example, faster turnaround cycles for list selections are fine (when quantified in hourly rates), but it is even better if the revenue from more customer acquisitions that follow from these selections can be tied in. Not only will the relation to revenue growth rather than savings make for a more balanced business case, more important is the intrinsic business buy-in that results from a direct connection to the company bottom line. These days, changes in legislation (in particular Sarbanes-Oxley) play a major role in justifying business cases. This may be either through a higher company valuation for its transparent information gathering, or, less sleepless night for the CEO, which is of course priceless...
4. Why Do Data Warehouse Projects 'Never' Go Wrong?
Actually, Data Warehouse projects do sometimes fail. But, they fail so rarely, that it is actually very hard to believe... Especially after having talked to so many disgruntled end-users. And there are many ways a Data Warehouse project can go wrong. Delivering on time, data administration issues, and unavoidable data quality issues in feeding systems. Corporate politics (see Tip 7) are probably the best explanation for this phenomenon of near 100% success rates on DWH projects. In my experience, the reason why a failure or 'semi-failure' can go unnoticed is either because senior management is not aware, or, let's say "unmotivated" to talk about misspending of company funds. As a result, not enough is learned. Maybe we as consultants have a stake in this as well, as this assures the industry plenty of ongoing business... J
5. What is Different About Warehousing Web Data?
Kimball & Merz (2000): "Although this clickstream data in many cases is raw and unvarnished, it has the potential of providing unprecedented detail about every gesture made by every huma
Growing up we where all told in order to make it in life that you must go out there and work hard for everything you want in life. The harder you work the more you will succeed. Is this really that true though anymore? Now a day people seem to work harder then ever before, and still come up empty handed.So is working harder really getting us to where we want to be at in life? More then likely the only place its getting you is laying on our bed with a bad back or a huge headache. The new age is upon us, and now people are looking for ways to work smarter and not harder.There are a number of different ways one can go out and take full control of his or her finical freedom simply by working smarter, and throwing the rule book out the window. The first step to any success story is you need to go out and take a chance. One of the biggest reasons why people dont take these life-changing chances are because they cannot handle change, and they are happy with going to work and making peanuts.When really all it takes it a little change to make a big difference. Some things you can look into for example are investments, rea
3. The Importance of a Data Warehouse Business Case
Much has been written about the business case for a Data Warehouse. What goes in to a good business case? IT savings are ubiquitous in DWH business cases. The important point is to not limit this to 'pure' savings, but to connect to primary business processes as much as possible. As an example, faster turnaround cycles for list selections are fine (when quantified in hourly rates), but it is even better if the revenue from more customer acquisitions that follow from these selections can be tied in. Not only will the relation to revenue growth rather than savings make for a more balanced business case, more important is the intrinsic business buy-in that results from a direct connection to the company bottom line. These days, changes in legislation (in particular Sarbanes-Oxley) play a major role in justifying business cases. This may be either through a higher company valuation for its transparent information gathering, or, less sleepless night for the CEO, which is of course priceless...
4. Why Do Data Warehouse Projects 'Never' Go Wrong?
Actually, Data Warehouse projects do sometimes fail. But, they fail so rarely, that it is actually very hard to believe... Especially after having talked to so many disgruntled end-users. And there are many ways a Data Warehouse project can go wrong. Delivering on time, data administration issues, and unavoidable data quality issues in feeding systems. Corporate politics (see Tip 7) are probably the best explanation for this phenomenon of near 100% success rates on DWH projects. In my experience, the reason why a failure or 'semi-failure' can go unnoticed is either because senior management is not aware, or, let's say "unmotivated" to talk about misspending of company funds. As a result, not enough is learned. Maybe we as consultants have a stake in this as well, as this assures the industry plenty of ongoing business... J
5. What is Different About Warehousing Web Data?
Kimball & Merz (2000): "Although this clickstream data in many cases is raw and unvarnished, it has the potential of providing unprecedented detail about every gesture made by every huma
WORKING FROM HOME SUCCESSFULLY SOUNDS GREAT, BUT WHERE DO I START - AND HOW?Initially it is important to realize the pitfalls of working from home on the internet. Here are those that are the most common:SCAMS There are thousands of dishonest people on the internet who are eager to scam you out of your hard earned money without another thought. BEWARELACK OF MOTIVATION This is a common problem because most people are used to dealing with a boss who has expectations of what he wants of you. This of course and the fear of being fired is sufficient motivation for you. However working from home for yourself on the internet is a whole different kettle of fish. It is essential that you find your own motivation and choosing the right business for you is vital from this perspective.PROCRASTINATION It is easy to fall into this trap because you are used to others making the decisions for you and now you are your own boss and must take over this role. These obstacles are real and should be considered when thinking of choosing a home based internet business. Due to these factors it is vital that you choos
4. Why Do Data Warehouse Projects 'Never' Go Wrong?
Actually, Data Warehouse projects do sometimes fail. But, they fail so rarely, that it is actually very hard to believe... Especially after having talked to so many disgruntled end-users. And there are many ways a Data Warehouse project can go wrong. Delivering on time, data administration issues, and unavoidable data quality issues in feeding systems. Corporate politics (see Tip 7) are probably the best explanation for this phenomenon of near 100% success rates on DWH projects. In my experience, the reason why a failure or 'semi-failure' can go unnoticed is either because senior management is not aware, or, let's say "unmotivated" to talk about misspending of company funds. As a result, not enough is learned. Maybe we as consultants have a stake in this as well, as this assures the industry plenty of ongoing business... J
5. What is Different About Warehousing Web Data?
Kimball & Merz (2000): "Although this clickstream data in many cases is raw and unvarnished, it has the potential of providing unprecedented detail about every gesture made by every huma
Scales are mostly used to measure the weight of an object. Scales has come up with new equipment and machines relating to the improvement of technologies. The equipments and machines are weighing scales which are used every part of the county. These equipments are used in large numbers and its helps to improve the economy of the county. It solves the old problems with the help of the improvement o the technology and explains the financial stability of the company. The periodic innovation of the machines and equipment will avail you the company to produce their manufacturing more effective.The weigh scale is tool or equipment or a machine used to measure the weight of the object. The weighing machine will be helpful in determining the weight of the object in any sector. Nowadays, technologies has been improved a lot in taking the weight of the any particular equipment and the industrialist think compared to the man power, machine power is more efficient. To measure the weight of an object from simple to standard, the weighing scale is used. Weighing scales can be used to measure the force. This equipments and machines are speci
5. What is Different About Warehousing Web Data?
Kimball & Merz (2000): "Although this clickstream data in many cases is raw and unvarnished, it has the potential of providing unprecedented detail about every gesture made by every human being using the Web medium". The subatomic nature of clickstream data poses unique challenges. There are fewer built in feedback mechanisms to ensure data quality, compared to other data streams. The relation between user mouse clicks and server log records is not as tight as in "traditional" transaction processing due to technical issues like proxy servers and caching. Because of these differences, IT people need to adapt to the web process flow, rather than having the process adapt to IT needs as is common for most other DWH interfaces.
6. Which Data Should Be loaded In The Data Warehouse?
The data that enter the DWH ultimately determine its place in the organization. A "let's load all data, to be safe"-attitude is a sure fire way to derail your DWH project. Choices as to what should and should not be included need to be made early on, to keep the project manageable. After proven success of the delivered, deployed, and profitably exploited DWH, there always will be funding somewhere to include previously ignored interfaces. Given the anticipated lifecycle of the DWH, it makes perfect sense to consciously exclude certain sources. The choice as to what data to include needs to be driven by business considerations, and in particular reference to the company bottom line. If it can't be shown how data will be put to use profitably, they stay out! See also tip #3.
7. Data Warehousing & Company Politics
Data Warehouses have an impact on the company bottom line. Hence, they are likely candidates for turf battles, and are also at risk of becoming "small change" in budget allocation negotiations. None of these considerations benefit corporate long term goals. Managing a DWH project is hard enough as it is, and budget issues shouldn't make it any harder than it already is. Because DWH investments are in the present and revenues lie in the future, it is even more important to secure funding through a sound business case and buy-in from the appropriate (high) management level. See also Tip #3. Access to data means power, and talking about power is one of the greatest management taboos, still around. Sensitive as they are, even budgets are more readily discussed...
8. Data Warehouse Projects Traps
Some commonly recurring 'roadblocks' on the path to timely delivery of a Data Warehouse project:
- ETL processes have eaten up so much time (and still need "babysitters"), that little if any time is left to develop applications needed to exploit the DWH
- Some data are needed, but turn out not to be unavailable, or not in a timely fashion
- Maintenance required for tuning, indexing, and backup and recovery is severely underestimated
- Different ways of calculating the same phenomenon lead to different results, and nobody is able to conclusively explain the difference(s)
- The data that is loaded (and recombined) turn out to contain previously unknown inconsistencies in the source systems, the 'classic' data quality issues that trip DWH projects
- Metadata were lacking, and developers spend inordinate amounts of time finding out what a field really 'means'
9. DWH Hardware and Software Go Hand in Hand
In Data Warehousing, it is not about hardware, and not about software: it is about the perfect integrati
HTTP = HTML link (for blogs, profiles,phorums):
<a href="http://www.otheradded.com/article/2572/otheradded-Data-Warehousing--Toms-Ten-Data-Tips.html">Data Warehousing - Tom's Ten Data Tips</a>
BB link (for phorums):
[url=http://www.otheradded.com/article/2572/otheradded-Data-Warehousing--Toms-Ten-Data-Tips.html]Data Warehousing - Tom's Ten Data Tips[/url]
Related Articles:
Learning The Process Of Order Fulfillment
What Every Business Wants-More Sales-Less Taxes & Better Cash Flow
Super Size Your eBay Sales Using Buyer Psychology
Bookmark it:
|