Power BI & Analytics
Turn data into decisions. Interactive dashboards, KPI scorecards, drill-through reporting, and DAX measures built around business questions.
Microsoft Power BI · Data Visualisation & Analysis
Clear insights.
Connected
business processes.
I turn data into clear dashboards, meaningful visualisations, and connected business workflows using Power BI, Power Apps, Power Automate, and Microsoft 365.
Power BIDAX & SQLPower AppsPower AutomateMicrosoft 365
Based in Ahmedabad, Gujarat, India
Mohit Pandey
Power BI & Power Platform Developer
CurrentlyKankaria Properties Pvt. Ltd. · Nov 2025–PresentClient deliveryNokia Corporation · P&G Group
30+Reports &
dashboards
dashboards
15+Power Apps
Canvas Apps
Canvas Apps
15Power Automate
workflows
workflows
3+Years of professional
experience
experience
Experience network
Companies and clients I have worked with.
A professional network built through delivery, reporting, and analytics engagements.
What I build
Business intelligence · Apps · Automation
Power Apps Development
Bring processes into one place. Canvas Apps for structured data entry and process digitization, connected to SharePoint and Microsoft 365.
Workflow Automation
Make everyday work flow. Power Automate solutions for approvals, notifications, and connected business workflows.
Data Modelling & Integration
Build a reliable foundation. SQL, Power Query (M), ETL, and star schema models for consistent, secure, and maintainable reporting.
From the first business requirement to a dependable reporting solution.
Selected workBusiness questions.
Business questions.
Practical solutions.
Explore 11 case studies across five domains, from reporting challenges to business outcomes.
Report previews use illustrative sample data. Open a case study to explore the report and its business context.
Nice to meet you
A developer who understands the business behind the data.
I’m Mohit Pandey, a Power BI & Power Platform Developer with 3+ years of hands-on experience in reporting, data modelling, application development, and workflow automation.
My work brings together DAX, SQL, Power Query, data modelling, Canvas Apps, and Power Automate. I have delivered across Healthcare, FMCG, Finance, Production & Inventory, and Networking & Marketing.
Power Platform DeveloperKankaria Properties Pvt. Ltd. · Nov 2025–Present
Understand
Requirements, stakeholder needs, and business KPIs.
Build
Data models, dashboards, apps, and workflows.
Validate
Data quality, business logic, and report accuracy.
Deliver
Secure access, scheduled refresh, and useful insights.
My journeyFrom business reporting
From business reporting
to connected solutions.
From reporting and analytics to connected Power Platform solutions.
Nov 2025–Present
Power Platform Developer
Kankaria Properties Pvt. Ltd.
Precast Ultracore · Precast concrete manufacturing
- Develop interactive Power BI dashboards for Production, Sales, Revenue, Purchase, Inventory, and Variance reporting.
- Build Star Schema models and optimize DAX; use Power Query (M), Dataflows, SQL, and ETL for data preparation and integration.
- Develop Canvas Apps with SharePoint and Microsoft 365, and automate approvals, notifications, and workflows with Power Automate.
- Manage Power BI Service, RLS, On-Premises Data Gateway, workspaces, scheduled refresh, and report deployment.
Jul 2025–Oct 2025
Executive BI Analyst
Itdose Infosystems
- Developed healthcare dashboards for Appointment Scheduling, Revenue, Bed Occupancy, and Inventory.
- Optimized DAX, Power Query, and data models; transformed data from SQLyog sources.
- Configured RLS, gateway, workspaces, and scheduled refresh for secure report delivery.
Apr 2025–Jun 2025
Freelance Power BI Developer
Remote
- Developed Sales and Finance dashboards with DAX and Power Query for KPI reporting.
- Designed Star Schema models and reusable DAX measures.
- Integrated Excel, SQL Server, and SharePoint through ETL processes for automated reporting.
Oct 2024–Mar 2025
Power Platform Developer
Ashkom Media India
- Developed Production, Finance, and Inventory dashboards for P&G, integrating SQL Server, Excel, APIs, and cloud sources.
- Built Power Apps for data collection and Power Automate approval and business workflows.
- Delivered KPIs, scorecards, data models, and stakeholder reporting as end-to-end BI solutions.
Nov 2022–Jul 2024
Power BI Developer
Gnap Services
- Designed interactive dashboards to standardize reporting and automate manual spreadsheets.
- Built and optimized DAX measures, calculated columns, and data models.
- Published reports and datasets to Power BI Service; managed workspaces, refresh, and distribution, and reduced model and visual complexity.
Industry expertise
Built around business decisions.
Reporting experience across five industry and business domains.
01 / DOMAIN
Healthcare
Appointments→Capacity→Inventory
Patient flow & resource visibility
Appointment scheduling, hospital revenue, bed occupancy, and medical inventory reporting.
Appointment analyticsBed occupancyPatient flowStock consumption
02 / DOMAIN
FMCG
Production→Quality→Sales
Quality & commercial performance
Reporting across production quality, sales, finance, and inventory, including delivery for P&G.
Quality controlDefect analysisSales KPIsInventory visibility
03 / DOMAIN
Finance
Revenue→Costs→Variance
Revenue, cost & collections
Financial reporting that brings revenue, supplier spend, cost variance, and receivables into focus.
Revenue analysisCost varianceReceivablesSupplier spend
04 / DOMAIN
Production & Inventory
Raw material→WIP→Finished stock
Shop-floor to stock visibility
Production and inventory analytics for WIP, scrap, material consumption, and planned-versus-actual review.
Work in progressScrap analysisMaterial consumptionProduction variance
05 / DOMAIN
Networking & Marketing
Sites & visits→Execution→Review
Field activity & business reach
Operational and business reporting for site visits, field execution, sales, and marketing review.
Site visit trackingField activityMarketing reportingBusiness KPIs
Capture.
Automate.
Analyze.
Canvas Apps capture structured inputs. Power Automate moves work forward. Power BI makes performance visible.
Explore the toolkitSkills & certifications
The skills behind the solutions.
📊 Business Intelligence
🗄️ Data & Databases
⚙️ Power Platform
🔐 Administration & Security
Business & Stakeholder Skills
Industry & Business Domains
Professional learning & certifications
LinkedIn Learning
Power BI Essential Training
LinkedIn Learning
Power BI: Data Modelling with DAX
LinkedIn Learning
Power BI: Dashboards for Beginners
LinkedIn Learning
MySQL Development
IBM SkillsBuild
Project Management Fundamentals
Technical toolkitFrom source data
From source data
to everyday business tools.
Power BI, Power Apps, and Power Automate — connected through data modelling, integration, and governance.
0130+ reports & dashboards
Power BI & DAX
SEMANTIC MODEL → BUSINESS INSIGHT
SalesInventoryFinance
Star schemaDAX measures
KPI scorecardsDrill-throughTime intelligence
From reusable DAX measures and semantic models to interactive reports, KPI scorecards, and drill-through analysis.
02Reliable reporting foundations
SQL, Power Query & ETL
DATA PREPARATION & INTEGRATION
01ExtractSQL · Excel · APIs
02TransformPower Query · ETL
03ModelFacts · Dimensions
Dataflows → Validated data → Scheduled refresh
Transform source data into consistent analytical models using SQL, Power Query (M), Dataflows, and dimensional modelling.
0315+ Canvas Apps
Power Apps Canvas Apps
CANVAS APP · PROCESS PATTERN
Business request
Request details
Department & owner
Submit for review ↗
Structured inputsSharePoint listsMicrosoft 365
Digitize data collection and business processes with Canvas Apps integrated with SharePoint and Microsoft 365.
0415 workflows
Power Automate & Governance
POWER AUTOMATE · APPROVAL PATTERN
Request submitted↓Review & approval
APPROVEDUpdate recordRETURNEDNotify requester
Automate approvals and notifications, with Power BI access controls, gateway management, and scheduled refresh supporting report delivery.
DELIVERY PRACTICES
Requirement gathering · KPI design · Data validation · Stakeholder reporting · Security & access management
Education
Bachelor of Technology
Computer Science and Engineering
IEC College of Engineering & Technology, Greater Noida
Aug 2019–Jul 2023 · CGPA: 6.8/10
The full picture
Power BI & Power Platform Developer · 3+ Years
30+ reports and dashboards, 15+ Canvas Apps, and 15 Power Automate workflows. View the full picture of my experience, technical skills, qualifications, and project delivery.
Get in touchLet’s connect data,
Let’s connect data,
people, and processes.
Let’s talk about Power BI, business apps, and automation — or the next opportunity to build something useful.
mohit.pandey.iec@gmail.com ↗