
Basit Ali
Power BI Dashboard Expert and Data Analyst
Habilidades

Conheça meus serviços


Portfólio
Experiência profissional
Data Analyst
FlinkFreight Logistics Inc • Período integral
May 2025 - Present • 1 yr 5 mos
Senior Data Analyst at a freight logistics company, responsible for turning operations, sales and ocean freight data into automated reporting for management and the CEO. Key achievements: • Built and delivered 3 automated Power BI dashboards: Operations (3 tabs: business overview, employee performance, customer performance), Sales (2 tabs: department overview, employee analysis) and Ocean Freight Summary • Designed DAX measures for profit margin %, quote conversion, MoM growth, profit per container and target achievement • Cleaned and merged data from multiple Excel and Google Sheets sources using Power Query • Built a weekly Sales KPI tracker that rolls daily rep activity into a weekly summary and an auto-drafted email for management • Developed a Google Apps Script web app that helps dispatchers find and compare carriers • Ran new vs existing carrier analysis and prepared weekly performance assessments for employees and interns • Prepared data-driven policy proposals for management, including sales commission and dispatcher loss limits Tools: Power BI, DAX, Power Query, Excel, Google Sheets, Google Apps Script