Browse categories
Explore
Fiverr Pro
English
$
USD
I will build automated excel mis reports using power query, power pivot and dax
MIS and BI Reporting Specialist
MIS & BI Reporting Specialist | 13+ years
in retail, logistics & food delivery ops.
I build automated, refresh-ready solutions:
- Excel: Power Query, Power Pivot & DAX
- SQL: MySQL & SQL Server
- Red...
About this Gig
Do you need automated monthly or weekly MIS
reports that refresh with one click
without any manual work?
I will build a fully automated MIS report in
Excel connecting your data sources through
Power Query, linking them via relationships
in Power Pivot, and delivering accurate
reports through DAX-powered Pivot Tables.
What you get:
- Data cleaning via Power Query
- Power Pivot model with table relationships
- DAX measures (MTD, MOM%, YTD, achievement%)
- Pivot tables connected to the model
- One-click refresh across all sources
Ideal for:
Sales reports · KPI scorecards · Attendance
· Inventory · Delivery cost · Store-wise
performance reports
I work with:
Excel, CSV, ERP/POS exports, multiple sheets
Basic: up to 50,000 rows
Standard: up to 5,00,000 rows
Premium: up to 10,00,000 rows
For 10L+ rows, message before ordering
This gig is for MIS reporting only
For custom tools like ordering sheets or
incentive calculators -please contact me before placing an order.
Why me?
13+ years MIS experience retail &
logistics operations, 40+ locations.
Share your files I'll handle the rest.
Platform:
Excel
•
Power BI
Development technology:
Power Query
•
DAX
•
Other
Expertise:
Formulas
•
Functions
•
Power Query
•
Cleaning
•
Modeling
My Portfolio
Other Data Processing Services I Offer
FAQ
Q:What is the difference between Power Pivot and a normal Pivot Table?
A:Normal pivot tables work on a single flat table only. Power Pivot allows connecting multiple tables with relationships and writing advanced DAX formulas — giving much more accurate and flexible reporting.
Q:What Excel version is required?
A:Power Pivot works on Excel 2016 and above, and Microsoft 365. I will confirm compatibility before starting your project.
Q:Can you work with ERP or POS exported data?
A:Yes — as long as you can export your data as Excel or CSV format, I can work with it directly.
Q:What if my data changes every month?
A:That is exactly what this solution is built for. Once the model is set up, just replace the raw data and click refresh — the entire report updates automatically.
Q:My dataset has more than 10 lakh rows. Can you still help?
A:Yes — please message me before ordering. I will review your requirement and send a custom quote with milestone-based delivery.
Q:Can you fix my existing broken Power Pivot model?
A:Yes — if your existing model is broken, slow, or incomplete, I can audit and fix it. Please describe your issue before ordering.
Q:Is this gig for custom Excel tools or business solutions?
A:This gig is specifically for MIS reporting — monthly, weekly, or daily reports using Power Query, Power Pivot and DAX. For custom business tools like ordering sheets or incentive calculators, please check my other gig.
