Monday, June 19, 2023

Microsoft Fabric creates a Warehouse automatically - Microsoft Fabric - III

Discover the power of Microsoft Fabric in automating data warehousing with our latest video, “Microsoft Fabric creates a Warehouse Automatically”. This informative video demonstrates how you can effortlessly create a data warehouse without the need for complex and time-consuming traditional warehousing processes.

Join us as we explore how Microsoft Fabric automatically generates a default data warehouse, showcasing the transformation of Delta tables into accessible tables within the warehouse. Learn step-by-step how to create Delta tables in the lakehouse, enabling their visibility as fully functional tables in the data warehouse.

Furthermore, we explore the flexibility of the data warehouse, demonstrating how you can enhance it by creating custom views and stored procedures.  Additionally, we demonstrate the way of opening the warehouse as the default Power BI dataset for creating reports and dashboard.

Don't miss out on this informative video that provides valuable insights into Microsoft Fabric's data warehousing capabilities. Subscribe to our channel for more in-depth tutorials and stay up to date with the latest advancements in data management and analytics.




Tuesday, May 30, 2023

Sunday, May 14, 2023

Unleashing Power BI in Jupyter Notebook - Embed and Create reports

This video discusses two things:

  • Embedding Power BI report in Jupytor Notebook
  • Creating Power BI report directly in Jupytor Notebook.
Embedding Power BI is not something new, it was announced in May 2021. Creating Power BI report in Jupytor Notebook was announced in last month, April 2023. Both topics are discussed in detail with demonstrations. Following are discussed:
  • Powerbiclient Python package
  • Two Authentication method
  • Install powerbiclient in Jupytor notebook
  • Embed Power BI report in Jupytor Notebook
  • Add custom Notebook filter for filtering reports
  • Loading visual data into Pandas dataframe
  • Create Power BI report in Jupytor Notebook
  • Quick report feature and personalizing visuals
  • Publishing to Power BI service for sharing the dataset and report



Real-time Streaming in Power BI - Push Dataset

This video discusses the way of showing stream data with Power BI visuals, specifically with Push Datasets. Here is the content: 
  • Types of streaming datasets supported by Power BI
  • The way of creating the Push dataset
  • Sending values using a .Net application
  • Creating reports and dashboards visuals using streaming dataset.