Dynamic Hourly Project Planner (Gantt chart)
Using Gantt charts for project management is not a new concept. Still, with the advent of advanced Excel features, creating a dynamic hourly Gantt chart has become more accessible than
Tag: BI Dashboard
Daily Sales Report – Data Extraction from multiple PDF files
In this article, we have created a Daily Sales Report (DSR) in Microsoft Power BI. We have extracted and consolidated the data from multiple PDF files using Power Query. After
Static and Dynamic Row-Level Security in Power BI
Row-level security in Power BI uses role filters to restrict which data rows users can access. This tutorial introduces static and dynamic approaches, including the USERPRINCIPALNAME DAX function for the
Quality Analysis Dashboard in Power BI
The Quality Analysis Dashboard in Power BI uses sample data to present Total Task, Sample, Defect, Fatal Error and Quality Score. Its main page summarises results with charts and cards;
Comparative Analysis Dashboard in Power BI
The Comparative Analysis Dashboard in Power BI compares current-year sales with previous-year sales and budget. It shows year-over-year growth, budget variance, category and product analysis, and monthly trends. The example