Data Lake – Differences from Data Warehouses

Comparative Differences! As I mentioned before, data lakes take in all data in its raw form. As a result, this can make it a bit more time intensive and resource consuming in perform analytics on the data in the lake, but it also increases in versatility and flexibility. Because a data warehouse essentially profiles business…

A Data Lake? They’re Getting Bigger!!!

Data Warehouse Down, Data Lake Up Next! As soon as I thought we were done, I hear of data lakes. Oh woe is data… I thought everything was good, I had wrapped up my series on data warehouses and I was slowly working on topics more foundational and basic to my knowledge so far. I…

D’WuhBeeAye – Bringin’ in the Hadoop!

Are we Hadooping now? How about now? How Hadoop Can Help In Healthcare! Meant to help solve problems dealing with lots of data, a combination of complex and structured data with simple data sets of simple numbers. Unfortunately, tables and databases don’t really have a mechanic that can help with this complex variety of data, nor…

D’WuhBeeAye – Warehouse Models in Healthcare

Different Models in Healthcare (data warehouse ones at that! hehe) So, we’ve taken a few weeks looking into data warehouse and what it consists of, let’s finish out with the different kinds of data warehouse models that there are! One of the first concepts to understand that these models differ primarily with how data is…

D’WuhBeeAye – Data Warehouses in Healthcare!

How Data Warehouses Can Benefit Healthcare! So we’ve learned about data warehouses and business intelligence, here’s how it can connect with healthcare! Healthcare has been rapidly evolving ever since HITECH was pushed into the open. But with meaningful use driving healthcare and the transition into the utilization of more and more technology, data warehousing was…

D’WuhBeeAye – Analytic Tools

Analytic Tools for Data Warehousing! Now that you got the data warehouse schema set up! Now for the to(ols)ys! There are many kinds of analytic tools that you can use in your organization with your data warehouse, so instead of listing them out, I’m just going to discuss the overview on certain tools on why…

D’WuhBeeAye – Dimensional Databasing!

The Dimensional Data Model! Starting from the ground up! So let’s take some time to analyze one of the most common methods in data warehousing, using the dimensional data model as its foundation! In most relational databases, the primary concept is to relate a row of information and values to a column of metrics, a…

D’WuhBeeAye – Architecture Design

Part 2 – Architecture Design! Not the building kind! The ones for a data warehouse! Reading through my books, there is already a huge emphasis on designs and how each data warehouse should be configured and maintained for different situations, organizations, and purposes. In a sense, each one is dependent on the specific needs of…

D’WuhBeeAye – Introduction to DW-BI

My First Look Into DW-BI Data Warehousing and Business Intelligence (DW-BI) I really do suppose it’s time for me to talk about this topic now, I’ve had these tabs pulled up on Chrome for close to a month now and I kept telling myself, “I’ll write about it today… no today… nah tomorrow” And now…