Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
powerbiexpert22
Impactful Individual
Impactful Individual

report estimation

what is generic estimates (in days) for a single person to deliver Power BI report based on complexity criteria (low,medium,high) . i know it all depends on requirements however just wanted to know generic estimate perspective

 

Complexity LevelEstimate in Days
Low?
Medium?
High?
2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@powerbiexpert22 , It also depends on whether the transformation of data was needed or not usually these estimates are also true above 20 reports

 

 

Complexity Level Estimate in Days per report
Low 1-3
Medium 4-8
High 7-10

 

There are many other factors like sources, data cleanup etc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Ritaf1983
Super User
Super User

Hi @powerbiexpert22 

I'm approaching a decade in the field, and even today I can't accurately estimate the time it takes to prepare a report. It depends on many factors: the quality of the data, the level of drill-downs, the complexity of the calculated logic, and how much of it comes 'pre-cooked' from the database versus what you need to calculate within the tool.

In addition to all of this, as a data visualization expert, I have a commitment to get as close as possible to 'data pixel perfection' despite the tool's limitations. For me, the design phase usually takes longer than building the model and writing the DAX calculations.

The quickest report I've created took 2.5 workdays, and the more complex ones took up to 3 weeks. Therefore, during expectation-setting discussions with clients, if I'm required to provide an estimate, I always say it’s very rough, and the only thing I can commit to is raising flags if the pace is slower than expected.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @powerbiexpert22 

I'm approaching a decade in the field, and even today I can't accurately estimate the time it takes to prepare a report. It depends on many factors: the quality of the data, the level of drill-downs, the complexity of the calculated logic, and how much of it comes 'pre-cooked' from the database versus what you need to calculate within the tool.

In addition to all of this, as a data visualization expert, I have a commitment to get as close as possible to 'data pixel perfection' despite the tool's limitations. For me, the design phase usually takes longer than building the model and writing the DAX calculations.

The quickest report I've created took 2.5 workdays, and the more complex ones took up to 3 weeks. Therefore, during expectation-setting discussions with clients, if I'm required to provide an estimate, I always say it’s very rough, and the only thing I can commit to is raising flags if the pace is slower than expected.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
amitchandak
Super User
Super User

@powerbiexpert22 , It also depends on whether the transformation of data was needed or not usually these estimates are also true above 20 reports

 

 

Complexity Level Estimate in Days per report
Low 1-3
Medium 4-8
High 7-10

 

There are many other factors like sources, data cleanup etc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.