Journal of Advances in Developmental Research

E-ISSN: 0976-4844   •   Impact Factor: 9.71

A Widely Indexed Open Access Peer Reviewed Multidisciplinary Bi-monthly Scholarly International Journal

Call for Paper Volume 16 Issue 1 January-June 2025 Submit your research before last 3 days of June to publish your research paper in the issue of January-June.
Submit Research Paper Join as a Reviewer

Plagiarism is checked by the leading plagiarism checker TurnItIn

Call for Paper

Volume 16 Issue 1
2025

Submit your research paper

Indexing Partners
Academia Advanced Sciences Index Bielefeld Academic Search Engine CiteSeer DRJI Google Scholar Independent Search Engine & Directory Network ISI (International Scientific Indexing) Issuu Mendeley Research Networks
RefSeek ResearcherId - Thomson Reuters ResearchGate Scirus Scribd Semantic Scholar UTeM - Universiti Teknikal Malaysia Melaka Wiki for Call for Papers WorldCat Zenodo

Advanced-Data Modeling Techniques for Multi-Site Work Order Visualization in Power BI

Author(s) Srikanth Reddy Katta
Country United States
Abstract Multi-site work order displays are important and necessary when the organization has developed its operations across several sites. Power BI is one of the valuable applications for data modeling and reporting; however, working with the work order datasets across different sites is challenging. This paper aims to understand how advanced data modeling can be applied to improve multi-site work orders in Power BI. It includes key modeling techniques like star schema design, data normalization, and Power Query on the ETL process (Extract, Transform, and Load). Also, the paper covers the employment of measures to enable dynamic calculations by incorporating DAX (Data Analysis Express Expression). In this context, potential anti-patterns of low performance include complex joins, row-by-row processing, missing indexes, and repetitive execution are discussed. This paper also prescribes the best practices for Row-Level Security (RLS) to achieve secure, role-based access to work order info. Finally, the ways to utilize data streams outside the manufacturing site, like IoT devices and ERP systems, show how overall operation can be assessed. The following research combines examples extracted from real-life cases and practices to illustrate how an organization can derive value from work order data for better decision-making and business enhancement. Using all these techniques presented above under Power BI, an organization can advance its reporting capacity in facility and asset management and consequently improve its competitiveness in the market.
Keywords Power BI, Data Modeling, Work Order Management, DAX, ETL, Star Schema, Business Intelligence.
Field Engineering
Published In Volume 16, Issue 1, January-June 2025
Published On 2025-03-28
Cite This Advanced-Data Modeling Techniques for Multi-Site Work Order Visualization in Power BI - Srikanth Reddy Katta - IJAIDR Volume 16, Issue 1, January-June 2025. DOI 10.5281/zenodo.15104211
DOI https://doi.org/10.5281/zenodo.15104211
Short DOI https://doi.org/g897z4
View / Download PDF File

Share this



CrossRef

CrossRef DOI is assigned to each research paper published in our journal.

IJAIDR DOI prefix is
10.71097/IJAIDR

Downloads
Research Paper Format Copyright Permission Form and Undertaking Form Cover Page Vol 15 Isu 2Cover Page Vol 15 Isu 1Cover Page Vol 14 Isu 2

All research papers published on this website are licensed under Creative Commons Attribution-ShareAlike 4.0 International License, and all rights belong to their respective authors/researchers.

CC-BY-SA Open Access

About IJAIDR
Fees & Payment
Current Issue
Publication Archive 		Submit Research Paper
Track Submission Status
Publication Guidelines
Publication Ethics
Peer Review & Plagiarism 		Join as a Reviewer
Editors & Reviewers
Reviewer Referral Program
Get Reviewer Membership Certi. 		Website/Journal Policies
Usage Policy
Content Policies
Privacy Policy
Contact Us Message on WhatsApp +91-9687-182-185 editor@ijaidr.com