DATA-DRIVEN TAXI FARE ANALYSIS USING MICROSOFT POWER BI: DESIGN, IMPLEMENTATION AND BUSINESS INSIGHTS
This paper presents a Taxi Fare Analysis Dashboard developed using Microsoft Power BI. The proposed system utilizes data cleaning, transformation, modeling, and visualization techniques to analyze taxi booking data and generate actionable business insights. The dashboard provides detailed analysis of booking trends, revenue generation, vehicle performance, cancellation patterns, payment methods, and customer ratings. Power Query and Data Analysis Expressions (DAX) are used to preprocess and analyze data efficiently. Interactive visualizations such as KPI cards, charts, graphs, and slicers enable users to explore business performance dynamically.
The developed system demonstrates how Business Intelligence technologies can support data-driven decision-making in transportation services. The results indicate that Power BI provides an effective platform for analyzing taxi operations and identifying opportunities for business improvement.
Patra, D. P. (2026). Data-Driven Taxi Fare Analysis Using Microsoft Power BI: Design, Implementation And Business Insights. International Journal of Science, Strategic Management and Technology, 02(6). https://doi.org/10.55041/ijsmt.v2i6.083
Patra, D. "Data-Driven Taxi Fare Analysis Using Microsoft Power BI: Design, Implementation And Business Insights." International Journal of Science, Strategic Management and Technology, vol. 02, no. 6, 2026, pp. . doi:https://doi.org/10.55041/ijsmt.v2i6.083.
Patra, D. "Data-Driven Taxi Fare Analysis Using Microsoft Power BI: Design, Implementation And Business Insights." International Journal of Science, Strategic Management and Technology 02, no. 6 (2026). https://doi.org/https://doi.org/10.55041/ijsmt.v2i6.083.
[2] Microsoft Corporation, Power Query Documentation, Microsoft Learn.
[3] Microsoft Corporation, Data Analysis Expressions (DAX) Documentation, Microsoft Learn.
[4] Alberto Ferrari and Marco Russo, The Definitive Guide to DAX, Microsoft Press, 2019.
[5] Marco Russo and Alberto Ferrari, Analysing Data with Power BI and Power Pivot for Excel, Microsoft Press, 2017.
[6] Reza Rad, Power BI from Rookie to Rock Star, RADACAD Publications, 2020.
[7] Ralph Kimball and Margy Ross, The Data Warehouse Toolkit, Wiley Publications, 2013.
[8] Thomas H. Davenport and Jeanne G. Harris, Competing on Analytics, Harvard Business Review Press, 2007.
[9] Provost, F. and Fawcett, T., Data Science for Business, O'Reilly Media, 2013.
[10] Sharda, R., Delen, D., and Turban, E., Business Intelligence, Analytics, and Data Science, Pearson Education, 2020.