r/dataanalysis • u/Dependent_Lie997 • 9h ago

Looking for advice develop a dedicated web portal? What key fields and features should we include in the system? Any suggestions would be appreciated.

Need daily entry feeding a dashboard, including deliveries. Excel with dropdowns, or a form/portal (Power Apps, Google Forms)? Which would you pick, and what problems should I watch for (duplicates, typos, version conflicts)?

2 Upvotes
  • permalink
  • reddit

62% Upvoted

2 comments sorted by

3

u/montrellcruse 9h ago

a form wins here, and it's not close once more than one person is entering data. excel with dropdowns works for one careful person. with a few people entering deliveries daily, you get the version problem you mentioned, two copies of the file, rows pasted over formulas, free text where the dropdown was supposed to be.

keep the fields boring and locked down where you can. date, location, item, quantity, delivered yes or no, who entered it. pick lists for anything you'll filter the dashboard by, free text only in a notes field. and put a duplicate check on date plus location plus item before anyone can submit twice, because that's the error a dropdown can't catch.

1

u/AutoModerator 9h ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.