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…

CRM (Customer Relationship Management) Intro

New Job! Salesforce CRM Administration. Time to learn… CRM Customer Relationship Management Software, meant to help build and maintain relationships with clients. It’s a super broad term but that shows how applicable it can be, CRM systems can be IT support ticketing systems, project management situations, sales and accounting etc. Typically viewed as SaaS (Software…

Storage devices! Understanding SAN and NAS

NAS vs SAN Storage Devices They both store data for infrastructure, back in the day there were these servers for data storage and then came the devices to store the data meant for servers. Network Attached Storage At the end of the day, it’s an uber file server. It is a remote storage volume that…

Big Data In Healthcare

The Rising Rise of Big Data Big data or large data sets, when pulled together in the right context can provide hidden insights to trends and patterns that can help dictate or guide certain decisions. But how did it happen? Emerging technologies these past few years have really allowed large complex sets of data be…

Gimme Dat(a) ACID Please.

Seriously though? Let me explain. ACID me up. Still confused? Not sure what’s going on? Well let me show you through ACID. Hopefully by now, you realize that I am not actually talking about the drug acid, but the ACID theory in database systems. Another hopeful thought is that you realized that I’ve been capitalizing…