Data Warehousing – A Simple, Practical Approach

Data warehousing and business intelligence circles are filled with experts. These experts have created elaborate models to describe how to format tables into schemas, etc.  Business intelligence gurus have outlined elaborate ways of creating reports, cubes, graphs, and the list goes on, and on, and on.  Don’t you wish there was a simpler way; a no-nonsense, practical approach.  Well, I hope to offer you one.

I will offer several simple principles to lead you through a practical approach to data warehousing and business intelligence.  This simple model consists of three parts:

  • Liberate the data
    — Acquiring and preparing the data, such terms as ETL (extract-transform-load), Schema, etc.
    — Guiding Principle: Data is an Asset, Optimize your Assets
  • Democratize the data
    — Reporting of all kinds, this part is where the data is accessed by the end users
    — Guiding Principle: Information is power, if where and when needed, comprehensive, and transparent
  • Underlying Processes
    — How will we keep the data warehouse growing with the organization, communicate with users, and make the data warehouse easy to use
    — Guiding Principle: Be an easy place to do business

Future posts will address important concepts such as “Data is the artifact of a process,” “User created data,” “How users use data,” and “Metadata & data lineage.”  I hope you feel as I do, data warehousing and business intelligence should be practical, easy to understand, and no-nonsense.

So, why listen to me?  Well, I had the privilege to lead the charge and work with a group of very talented folks that merged the data warehouses during the merger of Verizon’s Information Services organization.  We made some mistakes and we did some things right.  Most of all, we did not go purely based on some model.  We took the best of all the available models and got it done. I have taken this approach and applied it in other environments. It works. You chose if this information is helpful.

Until next time!

Dr. Dave

Posted in Data into Dollars | Leave a comment

Personalize the “big picture”

In business, a company will hire people to perform a variety of tasks.  These tasks are necessary to reach the goal of the whole – “the big picture.”  When asked what the individual does, they often focus on the task or job title.  When asked, “What do you do?” the individual will say, “I am a DBA” or “I am a product manager for coupon products.”  The individual does not see themselves delivering the end product; for example, “moving freight from sender to receiver,” “getting the largest possible tax refund for our clients,” or sometimes even “connecting buyers and sellers.”

I can hear it now, “he is a DBA,” or better still, “I am just a DBA.” 

Well, let’s say you work for an advertising company. You work on the database that stores the ads and sends them to Internet search sites.  The search sites don’t read your database in real-time; rather, the ads are extracted by another team and sent to Google, Yahoo, or MSN.  If the database is down, the ads don’t get sent; the buyers and sellers are not connected. Sounds pretty important to me.  You are not just a DBA; you connect buyers and sellers!

Do you have a direct line of sight to how you fit into your “big picture?”   Don’t minimize your value, be proud of it.  Personalize your big picture but start saying, “I connect buyers and sellers by managing the databases used to put ads of advertisers (sellers) online for the consumers (buyers) to find them.”  Take yourself out of the equation, “Without what I do, the buyers would not see the sellers’ ad and thus never get connected.”   Like I said before, sounds pretty important to me!

Do it now; personalize your “big picture.”

Until next time!

Dr. Dave

Posted in Leadership & Management | Leave a comment

“Think outside the box” or “Draw No Boxes”

Several years ago, I attended a “Leadership Development” course. The course began with the instructor telling the class that we need more people to “think outside the box.” Frustrated, I disagreed and said, “I needed fewer people drawing boxes around me and forcing me to think outside of them.” Seems too simple – eh? Before you say, “you have to have boxes,” you need to understand what I mean.

Often, people doubt it is possible to have “no boxes” when you think. It is possible if you consider that everyone in the company has a single job to do. If you are a home builder, you build homes. Whether you are in the accounting department, a framer, or a marketer — you build homes. All I ask is you don’t limit yourself to your domain but consider how to be better if there were no limitations. Limitations of money, people, processes, or expertise may cause an organization to choose a specific option. The point to my comment — don’t just limit your options based on boxes you draw around yourself.

This incident spawned the idea for this blog. It took me several years, but I felt the need to share my thoughts. I hope they make sense and you glean something usable from them.

Until next time!

Dr. Dave

Posted in Leadership & Management | Leave a comment