Creating an idea management tool

[Adinator]

Hello Community,
I have been given a big project by my boss.
I am supposed to create an idea management tool for improvement suggestions in PowerBI, where you can see when an improvement suggestion was received, when it was processed and when it was completed, so you have an overview. The turnaround time should be displayed. I hope you can help me.

[lbendlin]

Please be more specific.

Do you want to track existing Power BI ideas? There is a forum subsection for that, and you can subscribe to their RSS feed.

Or do you want to create your own idea management tool? Use one of the commercially available ones, or create a simple one with PowerApps. Power BI is the wrong tool for that.

[Adinator]

i want to create my own. i get the data from excel. i want to create a dashboard from it so i can see all the important information. like this sample below

 

[lbendlin]

That's not an idea management tool. It's a report. What actions are you planning to take based on the report and in which system are you planning to take them? What are you managing?

[Adinator]

Exactly one report. I want to see how many suggestions for improvement I have in total, with filter functions I want to see them individually like how many were in quarter 1, quarter 2 etc..
- I want to see how many of the suggestions are in progress, how many are completed.

I want to filter by department, or by responsible person.

[lbendlin]

How does the data end up in Excel? Is a single person entering/maintaining it or is it done by a group of people on a SharePoint?  How many items? Single tab or multiple tabs? Have you checked the links provided by Amit regarding data modeling best practices?

[amitchandak · Accepted solution]

@Adinator , best practice can help
https://learn.microsoft.com/en-us/power-bi/guidance/

https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/

Video from Guyinacube- About tools
https://www.youtube.com/watch?v=G4YND7H2vwM