Data Shaping and Modeling

Project Brief.

Once your key data points have been determined and identified, the next step is shaping, transforming, and modeling the data into consumable content.  We follow the same methodology as the collection process – simple and to the point.  You data will be re-shaped if necessary, transformations and augmentations will occur if they add value, and finally the data will be modeled into meaningful relationships for ease of reporting.

Self-Service Level:

This offering is catered to provide smaller solutions for the “Power” users or department needs.  The tools involved include Power BI as well as Excel Power Pivot and Power Query.   The data can be modeled in either Power Pivot or Power BI.

Enterprise level: 

This offering is a broader solution entailing SQL Server Analysis Services Tabular Models using custom DAX code with scheduled tasks that run via SQL Server Agent.