Category Archives: Modeling and Data Sources

Data modeling and various data sources required to enhance existing data

Simple Things To Reduce The Size Of Model

One of our tabular models kept failing due to memory allocation. The model sourced email results and texting results. Over time, it grew to 30 gigabytes and kept growing. The model supported 4 reports and was basically ingesting transactional data. … Continue reading

Posted in Modeling and Data Sources | Tagged , | Comments Off on Simple Things To Reduce The Size Of Model

Organizing Visuals For End-Users

Sometimes we build models with lots of measures in the fact tables. Also, columns that are less likely to be utilized can be quite distracting. See a small fact table below: To make that fact table easier to use, I … Continue reading

Posted in Modeling and Data Sources | Tagged , , , | Comments Off on Organizing Visuals For End-Users

Questions To Ask When Buying External Data

Often we need to enhance internal data by using the services of external vendors. Most organizations already use vendors in some capacity. For analytics, they could be a source of additional data, partner for a specific project, or act as … Continue reading

Posted in Modeling and Data Sources | Tagged , , , , | Comments Off on Questions To Ask When Buying External Data