We are building a portal to map out a market. We want to use third party products to manage login's, gather and publish data. The primary driver is a cool UX - and self service.
We will build what we have to, but are pursuing a No Stack approach. Please go through the No Stack slides before replying.
[url removed, login to view]
The build will be
design back end database to house and manage the data
Create an Admin panel to access, report on and manage the data. This will be simple Approve/Publish capabilities. We will use the client tools below for normal 'CRUD' capabilities
Connect Typeform - all forms to gather/edit data - share with users and capture data on and offline.
MapBox - GIS publish to the web, slice,dice, drill down. filter
AuthRocket - log in's, user community management, social log in
Zoomcharts - cool charts, map overlays and dashboarding and reporting
Love Zapier - not hung up on it though - would prefer it
Connect these tools to the back end through API calls to the database - as well as pass authentication tokens.
Users will be able to Create, Read,Update,Claim records.
The site will be a WP multisite (mostly set up)data will be exposed through the web portal. Users must be able to slice, drill down, select and filter data to a high degree.
Data volumes will be low - launching with 6K records and growing to 16K clean records.
The database will also be used to house and clean data we are gathering. We have 20K records to clean and will need some basic logic here to help with this - deduping/name look ups and matching users to companies. We add about 1K of records a week to the dirty data. The data structures and processes will be relatively simple, it is not a true transactional system - it is clean/gather and publish process - do the data will look more like an ODS (operational data store) or a 'flat' dataware house than a transactional relational design.
The data will focus on companies primarily, with user records as secondary records and market data as the tertiary layer.
Phase 1 go live will be Company and Personal profile records - market records to come later. We have fourteen forms used to capture data - these will be in Typeform - building the first Seven is part of the brief. The forms are very similar.
We will deploy through a WP multisite - but light WP skills required - and may get them somewhere else if you don't have them.
We will host on Azure and would prefer an SQL design - but not hung up on this.
If you have a market map already built inside a third party tool, like CRM - very open to hearing about this. Will consider a small number of paid licences or open source. If this is built or bought - we need 'ok' back end admin capabilities.
First principle - don't write code if third party tools exist
Second principle - UX is key, 'cool' will beat complexity of API call integration
Third principle - self service is the goal for us, we are a small business and want to be able to enhance/customise/extend what we have without using developers. The tools we have selected are cool, have a great UX and offer us a large degree of autonomy. If you have other tools you think look better - tell us.
If you are a dev shop and want to build everything from scratch - please don't reply
We are using this project to validate the No Stack principles - to prove we can do it and it works and looks great - so need people that are thinking about the future of the dev market and not hung up on the old way of doing things
Desired Skills PHP, API Development, SQL Azure