apps on pivotal to extract, transform, combine data -> to ms sql db -> powerbi to visualize