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.
If writing SQL queries is in your job description I am certain that you, in great extent, inside SELECT command, use a GROUP BY clause that allows you to group row values by a given column and then apply an aggregation function, e.g. SUM, COUNT, AVERAGE, MIN, MAX… I have good news for you: we can achieve almost the same thing within an Excel report by using the GROUPBY function…
Microsoft Fabric represents an end-to-end analytical solution that combines Power BI, as a reporting platform, Data Factory, as a data integration service, as well as Microsoft Synapse Data Engineering, Data Warehousing, Data Science and Real Time Analytics. It is designed as a software as a service solution, and the data is stored within the OneLake repository, which enables the storage of structured and unstructured data…
Power BI is, for the most part, used for business reporting purposes, and the ultimate goal is to publish company data in the cloud, along with related reports, and then create reporting dashboards that provide the information necessary to support decision making. A free Power BI subscription can also be used for this, but I still recommend that you use (purchase) a Power BI Professional license. Why? More about this in the text that follows …