Jag Sandhu

PROJECT SCOPE
The client had healthcare billing data with around 360 million records, relying on Excel-based reports. They wanted to convert this transactional data into meaningful visual reports to analyze the business, have time-based analytics, KPIs, and make key business decisions.

IMPLEMENTATION
Gathered the business requirements, understood the data flow, and migrated the relevant transactional data from the Prod system using ETL into an Azure SQL Server operational data store (ODS). Designed the dimensional models and implemented the DWH followed by ETL design through SSIS packages from ODS to the target data warehouse. Imported the DWH tables into Power BI Desktop and designed data modeling as per star schema, providing the clean data to start with the Power BI report.

RESULTS
The client was delighted with my work, and the CEO still uses the reports for his leadership meetings and business decisions. I created DAX measures to add aggregations for MTD, QTD, and YTD comparisons across trailing time measures spanning up to ten years of data.

TESTIMONIAL
"Jag has met my vision of migrating 360 million transaction data into robust Power BI reports, which I wanted so badly for the last seven years. Great work!" - CEO

PROJECT SCOPE
This client wanted a Power BI report to trace COVID-related cases throughout their international office locations concerning employee badge entries and visitors who entered the specific building on the same day. Also, there was a need to integrate health verification data where each employee had to certify before entering the building if one had COVID symptoms or not.

IMPLEMENTATION
Gathered all the requirements and understood the data elements related to this project. Used the SSIS ETL process to import Excel-based data into the DEV server for designing queries and then imported data into Power BI Desktop to create a data model and DAX measures. I followed the exact guidelines of how the client wants to see the data and designed visuals to support the requirements.

RESULTS
The client was delighted with the final Power BI report as per their requirements. Business users could see the results by dynamic current date selections and drill through to any specific employee to see all other contacted employees. The users were also able to see which employees filled out health verification forms and see who else was in that building on any given day with the help of visual indicators.

PROJECT SCOPE
The scope was to display 8,000-10,000 PC hardware and software support tickets data each month and develop dynamic Power BI reports that will enable all managers and support engineers to monitor various tickets SLAs for different locations and point out the tickets that missed SLAs and meet the minimum of 85% SLA numbers for all tickets closed for multiple clients.

IMPLEMENTATION
I understood the scope of work and logic defined for each SLA and then started designing database queries to provide dimensional data to support Power BI reports. I used T-SQL language to create stored procedures, used SSIS packages for ETL, and created automated jobs in SQL server to automate the availability of underlying data models for supporting Power BI reports.

RESULTS
I completed the project by delivering Power BI reports that helped all managers and engineers monitor various ticket related SLAs in the form of relevant and practical visual elements. The Power BI reports enabled the entire support team to meet the SLA timings, figure out the time and material costs, and stay positive above the threshold mark of 85% goals. The entire BI solution was fully automated.