Microsoft Fabric: Optimize Performance by Partitioning Delta Tables
In OneLake, we are able to partition data so that performance enhancements could be made through data skipping. Consider a situation where large amounts of sales data are being stored. You could partition sales data by year. The partitions are stored in subfolders named “year=2021”, “year=2022”, etc. If you only want to report on sales […]
Microsoft Fabric: Optimizing Database Table Architecture
Very simply, we are able to optimize lakehouse data table architecture. In the case where Spark is used, Parquet files are immutable and as such, we end up storing a lot of small files. The Optimize function allows us to reduce the number of files written as it just collates them into larger files. Within […]
Microsoft Fabric: OneLake Data Upload/ Table Transition/ Query & Report Building
To take raw data files in a csv file and transition it to a table format: In OneLake, access Files > data > ellipses > upload > upload files. Here, you will be able to upload a csv file or an excel file. From the data file, select the ellipses > Load to Tables > […]
BI Dashboard & ETL
In my role, I leveraged MSPBots as a third-party integration and business intelligence tool to revolutionize the creation of dynamic, custom client dashboards tailored to each client’s specific metrics and requirements. Utilizing MSPBots, I configured the user interface with custom CSS, ensuring a visually appealing and intuitive experience. To seamlessly integrate these dashboards into the […]