One of the great leaders in Data Warehousing is a man by the name of Ralph Kimball. He has written many books and articles about the topic of Data Warehousing. A book he wrote called “The Data Warehouse Toolkit” is a classic for those looking to make a name for themselves in the Business Intelligence/Data Warehousing field.
A particle section he wrote that is extremely helpful to those wanted to get an idea of what is important for a Data Warehouse Professional is the “Data Warehouse Manager Responsibilities”
1. Understand your users by business area, job responsibilities, and computer tolerance.
2. Find out the decisions the end users want to make with the help of the data warehouse.
3. Identify the “best” end users who make effective decisions using the data warehouse.
4. Find potential new end users, and make them aware of the data warehouse.
5. Choose the most effective, actionable subset of the data to present in the data warehouse, drawn from the vast universe of possible data in your organization.
6. Make the end user screens and applications MUCH simpler and more template driven, explicitly matching the screens to the cognitive processing profiles of your end users.
7. Make sure your data is accurate and can be trusted, labeling it consistently across the enterprise.
8. Continuously monitor the accuracy of the data and the content of the delivered reports.
9. Keep the end user’s trust.
10. Continuously search for new data sources, and continuously adapt the data warehouse to changing data profiles and reporting requirements.
11. Take a portion of the credit for end user decisions made using the data warehouse, and use these successes to justify your staffing, software, and hardware expenditures.
12. Keep the end users, end user executives, and your boss happy
“If you do a good job with all these responsibilities, you will be a great data warehouse manager! Conversely, go down through the list and imagine what happens if you omit any single item. Ultimately, your data warehouse would have serious problems.” – Ralph Kimball, The Data Warehouse Toolkit
Joshua is working to become a Data Scientist with focus on Analytics, Big Data, Machine Learning, and Statistics. His passion for Data and Information are second to none. He is a certified IBM Cognos Expert with more than 10 years experience in Business Intelligence & Data Warehousing, Analtyics, IT Management, Software Engineering and Supply Chain Performance Management with Fortune 500 companies. He has specializations in Analytics, Mobile Reporting, Performance Management, and Business Analysis.
- 2,133 feed subscribers
- Data Enthusiast (@DataEnthusiast) on Our Leaders Deserve Better: Why We As Analysts Are Failing Them
- @DataDave on Tableau 8: A List of 35+ New Features
- @DataEnthusiast on Tableau 8: A List of 35+ New Features
- @GradientGmbH on A Map of Business Analytics Capabilities
- @freakoPLo on A Map of Business Analytics Capabilities
Tags2008 Analysis Analytics Article Big Data Book Business Intelligence Charts Cognos Dashboards Data Data Warehouse Design Dimensional Flow Elements Fusion Tables Google Humor IBM Install Learning Logical Market Microsoft Model Modeling Operational Predictive Programming Python Ralph Kimball Reporting Science Server SQL SSIS Statistics TED Tools Tutorial Unstructured Video Visualization Warehousing Windows