Data Shaping and Modeling
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.
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.
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.