Using Microsoft Power BI in data engineering We have a lot of discussions with clients about a desire to do “better reporting”. They have been using Power BI but feel they now need a data warehouse to create reports that will give them all the info they need. Fundamentally, organizations often have an analytics problem, one for which a data warehouse forms part of the solution, however, the complexities lie in the data. Often organizations…





The way in which we use and interact with data has dramatically changed over the years. Originally, we leveraged static pictures and charts that captured a one-time snapshot of our data. But this is no long sufficient, as static visualizations only provide a historical view at a single point in time. Instead, interactive visualizations and real-time reports are now the demanded norm needed to turn massive volumes of data into immediate, actionable insights. But there…

Ready to create modern reports using SharePoint as a data source? If so, then once again, you’ve come to the right place. For those familiar with SharePoint, you know that SharePoint offers many different data store types, including SharePoint lists, SharePoint libraries, and documents (such as Excel files stored in SharePoint that contain data within them). And where there is data, there is a need to report on it in order for you to uncover…

If you have ever used SharePoint lists before, you know they provide a very simple way for users to store and share list-based items. Simple text and number fields are straightforward, but complex field types in SharePoint (such as lookups, managed metadata, rich text, locations, etc) can present several reporting challenges that SharePoint by itself can’t solve. This is where Microsoft Power BI comes into the picture. Power BI provides specific tools to aid with…

If you’re ready to build modern dashboards in SharePoint Online, Microsoft Teams, and SharePoint Server, then you’ve come to the right place. For more than a decade, SharePoint has been the platform of choice for business intelligence dashboards, originally leveraging features like Power Pivot for SharePoint, SQL Server Reporting Services (SSRS), and PerformancePoint. Fast forward to 2019, and SharePoint can seamlessly bring content together from Power BI, Excel, and many other data sources into rich…