Tanya is an expert in Office 365, SharePoint Online and associated products such as Power BI. As an expert in CSP (Cloud Solutions Provider), she is knowledgeable about licencing and the state of the market as well as product functionality.
Power BI Data Prep with Dataflows
Collecting data for Business Intelligence (BI) reporting can be a massive task, often 60-80% of an analytics project is attributed to just bringing together the data from multiple sources in various formats. The preview of Dataflows in adds to the data preparation capabilities of Power Query in Power BI Desktop.
- Create data preparation logic through Dataflows that can be reused across multiple Power BI reports and dashboards.
- Create sophisticated data transformation pipelines using a new recalculation engine to automatically track dependencies and recompute data as new data is ingested. This allows analysts to build on each other's previous work.
- Store data in the customer’s Azure Data Lake Storage Gen2 instance, fueling collaboration across roles. Business analysts can seamlessly operate on data stored in Azure Data Lake Storage, taking advantage of its scale, performance, and security. Meanwhile, data engineers and data scientists can extend insights with advanced analytics and AI from complementary Azure Data Services like Azure Machine Learning, Azure Databricks, and Azure SQL Data Warehouse.
- Organizations have the ability to leverage a standardized and extensible collection of data schemas (entities, attributes and relationships) through the Microsoft Common Data Model.
See the following link for the Microsoft Blog:
I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our teamLee Crowhurst, Technical Director