• Samples2
  • Studio

  • Home
  • Partner Bio
  • Live Data Models
  • Case Study
  • Other Vidoes











Additional DAX / PowerQuery Training Available





Old vs New Cost Profiles



'Calendarize' a Basic Table





A PowerBI approach to restructuring an 'Event Duration' data set is described in a way that enables 'Calendarized' reporting. Said otherwise - static tables get atomized then reassembled with dynamic DAX measures. A live model with hot slicers is provided.


Video - YouTube



Cost Models - SLA Maintenance



SLA Maintenance





A PowerBI approach to abstracting actionable insight from multiple 'Transaction' tables using recently introduced DAX table functions. A live model with hot slicers is provided.


Video - youtube



Data Science



Logistic Regression - Clearly Explained





A step-by-step approach to constructing a simple 'Logistic Regression' is first developed in Excel and then compared to results from an enterprise-grade statistical package.


Video - Youtube

Advanced Join - MultiCriteria / Range LookUp



Use Case - Ip Address Range LookUp





Solutioning a complex multi-criteria / range lookup 'Join' using PowerBI is compared & contrasted to results using a PowerPivot DAX Query and SumProduct with Excel.


video - Youtube

TimeSeries Analytics



Triple Exponential Smoothing - Customized Cycle Parameters




Video - Youtube

IP Address Management



IP /Decimal Conversion using PowerQuery




Video - Youtube