It is not through magic, software or systems that data becomes useful. It has value only when using the data with common sense as a guiding principal. As a data specialist, I consider it common sense that to use information from various systems effectively, it should be migrated to or made available in a data warehouse. The reasons are intricate but are related to performance of online systems, varying architectures and access rights.
The data warehouse is only built when many different sources of data are brought together. This is the ETL part. Doing this correctly, efficiently and with skill can only be done by a data management specialist. This is the DBA part. Put them together and you get ETL DBA.com.
Business Intelligence is derived from the data warehouse only when the right questions are asked of it. These questions can be answered with front end tools like summary and detail reports or more recently dashboards. Business Objects, SQL Reporting Services, Even MS Excel can expose this information. But regardless of this UI choice, it is the availability of the data and the right questions that drive BI.
ETL DBA provides skills in moving data into any data warehouse platform. We specialize in the ETL, regardless of the toolsets chosen for that last-mile. If you would like to discuss data warehousing that can be done quickly, affordable and most importantly with common sense, please contact us for a consultation.
Webmaster
"Data Warehousing is not a tool or a technology, but a practice rather. A logical workflow that can be replicated and applied to all data in your organization. One that can be repeated, refined and improved continuously."
"From the data warehouse, information becomes available. The questions users ask of this data has the ability to turn data into business intelligence. It may be detail, summary or analytical in nature, and the tools presenting it will vary. But the intelligence comes from the practical use of the information."
Dano Smith
Principal Consultant
Data Warehouse Consulting LLC.