How to Prepare a Power BI Semantic Model for AI and Copilot
Copilot can make a governed Power BI semantic model easier to explore, but it cannot repair unclear definitions, duplicate fields, weak relationships,…
Read Article
Hi, I’m Sepehr Mehrvar
Data-Driven Industrial Engineer & Analytics Specialist
I combine industrial engineering, data analytics, and machine learning to turn complex information into practical insights, efficient processes, and better decisions.
CORE EXPERTISE
Where Engineering Meets Analytics
I apply analytical thinking, engineering methods, and modern data tools to understand complex problems and develop practical, evidence-based solutions.
Projects at the Intersection of Data and Operations
Selected projects spanning dashboards, simulation models, and predictive methods to examine operational challenges and support clearer decisions.
SIMULATION & OPERATIONS
SmartBankSim: Bank Queue & Staffing Simulation
A discrete-event simulation built with entirely synthetic data to examine how arrival patterns and teller coverage affect customer queues. It compares staffing scenarios using average and 95th-percentile wait times, customer abandonment, and staff utilization to illustrate capacity-planning and service-level trade-offs.
TOOLS & METHODS
Python • SimPy • Pandas • Power BI • Scenario Analysis
PROJECT OUTPUT
A scenario-testing framework showing how different teller coverage levels affect waiting time, customer abandonment, and staff utilization across changing demand periods.
ARTICLES & INSIGHTS
Practical Notes on Data, Operations & AI
I write about data analytics, industrial engineering, simulation, and machine learning, focusing on practical methods, clear examples, and more informed decisions.
Power BI Import vs DirectQuery vs Direct Lake
Power BI Import, DirectQuery, and Direct Lake have different query paths, freshness patterns, and operating requirements. This practical guide explains the trade-offs…
DAX Measures vs Calculated Columns: When to Use Each
Measures answer dynamic questions in the current report context. Calculated columns create stored row-level fields for categorization and model design. Learn how…
OPEN TO OPPORTUNITIES
Let’s Connect
I’m open to opportunities in data analytics, industrial engineering, process improvement, and applied machine learning.
@analyst7_
@Sepehrmehrvar
@analyst7__