Lakehouse is a unique architecture that incorporates the best features of a Data Lake repository, which is used to store unstructured and semi-structured data, and data warehouses, which are used to store structured tables used to create reports. That is, you can store all this data in one place and access it via PySpark or SQL language…
Dataflow is a tool that has been around in the Power BI service for a very long time , and is used to import, transform, and load data into a semantic model (ETL). Practically, it is Power Query in a cloud environment. With the advent of Microsoft Fabric, Dataflow Gen2 was introduced , which is much more advanced compared to the previous version and enables faster work with large amounts of data, as well as their parallel processing.
Python has finally become part of Excel, and from now on you can add pieces of Python code to a sheet to define datasets, process and visualize them. If you have a Microsoft 365 subscription and have downloaded update 2409 (Build 17628.20164), you will be able to use Python normally (no longer reserved for testers only). In this short intro you will learn what Python is and how it can enrich your reports.
When you want to display data that contains multiple separated series in a chart, it can often look clumsy. It is possible to tolerate presentation of three or four series, but anything more than that is a nightmare for those who watch the reports and need to draw a certain conclusion. The solution is to display several smaller, separate charts instead of one. This type of data presentation is called small multiples, and here’s how to achieve it in Excel reports.
No, it’s not about „Monty Python’s Flying Circus“, it’s about another „Python“, a programming language that has recently become part of the Power BI Desktop platform and allows creation of user-defined visuals. Do you really need to use Python? Well, really not! But you must admit that it is convenient, if you are familiar with this programming language, to get the opportunity to “raise a hood” and create visuals according to your own standards …