During this webinar, Igor Lukanin, Head of Product at Cube, discussed the integration of Cube Cloud with the Microsoft ecosystem. Here are five key takeaways:
The Universal Semantic Layer Concept of Cube: Cube offers a solution to data modeling chaos by serving as a universal semantic layer. It combines data modeling, access control, query acceleration, and API integration, providing a centralized platform. The location where the semantic layer is run and the connectivity options can significantly impact its performance.
Integration of Cube with Microsoft Azure's Data Analytics Tools: The multi-layer support that Cube offers for the range of Microsoft Azure's data analytics tools, including Synapse data warehouse, Power BI, Azure Blob Storage, and Azure Active Directory among others, stands out. Igor stated that Cube allows seamless integration with the Microsoft ecosystem, enabling users to maximize their usage.
Ease of Using Power BI: Igor elaborated on the compatibility between Cube and Power BI, highlighting the simplicity and speed of building visualizations using Power BI with a developed data model in Cube. The use of the PBIT file and SQL API provided by Cube enables immediate data visualization in Power BI.
Cube Cloud Demo: Igor's demonstration of Cube Cloud provided a detailed walkthrough of connecting Cube Cloud to Microsoft Fabric, building and querying a data model, and visualizing data in Power BI. Further, Igor demonstrated how pre-aggregations can speed up data retrieval. His demo highlighted the potential of Cube as an analytic tool that delivers noticeable results in record time.
Syncing Cube Cloud with Power BI: Loading data into Power BI using Cube Cloud was one of the most valuable sections of the webinar. Igor showed how views in Cube Cloud can be used to expose the data to manage the data visibility in the data model effectively.
For data engineers facing the complexity of data modeling, Cube’s integration with the Microsoft Ecosystem, particularly Azure’s data analytics tools and Power BI, provides an efficient solution.