Data Analysis in Microsoft Fabric
?What is Microsoft Fabric
Microsoft Fabric is an unified cloud platform for scalable data analysis for big data, especially when data is stream. OneLake is the place for data storage in Microsoft Fabric which consists of two main category, DataLake and Data Warehouse. Data Warehouse is a true place for storing structure data types such as SQL data and DataLake for scalability and flexibility.
Microsoft Fabric and data professionals
Many data professionals can benefit Microsoft Fabrics’ advantages such as data engineers, data analysts, data scientists, and so on. For example, data engineers can use it’s power for extracting, loading, transforming data (ETL Process), and data management. Microsoft fabric’s ability to create data pipelines that orchestrate data ingestion and transformation tasks. Data analysts can use it’s abilities for data analysis, data modeling, report developments and so many other tasks. Data scientists can make advantages for prediction, pattern recognition and so many other works related to their purpose.
Work Enhancement using Microsoft Fabric
If you are familiar with SQL databases, work with SSMS and Power BI before, you can upskill data analysis and reports abilities using Microsoft Fabric. As MS Fabric is an unified platform with a high ability for working with different data sources, ingesting and transforming data from different sources via data flow and data flow Gen2. Then land the cleaned data to another destination. Where as, report consumers and report developers can work with Power BI in MS Fabric more efficiently.
Security and Data Governance
It’s an important factor to work in a secure platform which is powered with data governance. Data governance help us use data without any restrictions, but in an effective way. For instance, two users want to use a database or a report. In our database, we have a column named Region. By defining filters, Grant and Deny, user1 can only access to information of one country such as Iran and user2 can only access to information of country Japan. In this case, both of them can use database without any limitations and fulfil their demands.
