HowToBuildApps
From Semantifi Wiki
1. What is your App name and what does it do?
- Come up with a catchy name, write a brief description on what the app can search on.
- Write about the domain/vertical under which this App belongs e.g. Finance, Government, Retail?
- Define the vocabulary of the App using standard terminology that is neutral and easy to understand from consumer point of view.
2. Do you have a list of search queries?
- What are the measures and dimensions?
- Is there a time dimension? Find out if your measures varying on yearly, quarterly, monthly, weekly, or daily basis.
- Come up with a list of queries that App can answer.
3. Identify data sets
What is the format of your native datasets? (CSV, MS Excel etc.,)
4. Is your dataset ready?
- Clean up the data to make it look consistent
- Transform the date if required
- Create lookup tables
- Understand the relationship and constraints on tables
- Run direct queries to verify dataset is complete
5. Index your tables
Identify primary keys and unique ids on tables and add indexes.
6. Publishing from Console
- Register as a publisher on semantifi.com at
http://www.semantifi.com/publishApps.jsp
- Create a new App
- Create logical assets from SWI tool
7. Discover meta data of all the source tables
- Identify fact table(s)
- Identify simple lookups
- Classify the columns into id columns, measures, dimensions
8. Validate the joins
- Go to Admin console and define joins
9. Create concepts (optional)
- Define concepts
- Flag population concepts and time-series/distribution concepts
10. Mapping
- Do mapping between the concepts and table columns
- Complete mappings on instances and column members
11. Define asset grain
12. Set the default metrics
13. Publish the dataset
14. Test from Advanced Search
15. Attach knowledge model, verify concepts and instances are showing up in auto-suggest of search
16. Test from free form search bar
17. Write a Wiki help page
