Expected duration: less than 1 week Project Description: We are wanting to implement a Kibana Dashboard powered by Elastic Search with Auth0 authenticated login as part of a feature within a partner portal on our website. The Elastic Search will pull data from a GCP Cloud SQL server and display various metrics like in the example given. The dashboard will contain various filters.
The secure login will be implemented with Auth0 where user accounts will store various meta data that is then fed to Kibana to restrict various filters and data.
專案需求： 將Auth0登入帳號設定為使用Passwordless登入。 各Auth0登入帳號將包含下列參數： 使用者名稱 其部門 聯絡Email 可見學校 ID (array of id numbers) 可見國家 ID (array of country ids) 建立鏈結Auth0的Elastic帳號 建立鏈結GCP Cloud SQL server 的資料統計圖表，而非鏈結原始SQL或記錄檔 (待確)。 資料將由 學生資料、所在地 (學生國籍)、申請課程資料 …等資料表所組成。 並提供統計圖表作下列條件篩選： - 學年 (使用課程日期推算) - 課程學位 - 課程類別 - 所在地 (根據登入帳號參數Country ID，控制其可見的國家。若無設定，則可見所有國家) - 學校 (根據登入帳號參數School ID，控制其可見的學校。若無設定，則可見所有學校) 各項統計指標如上圖範例。 篩選條件將根據登入帳號於Auth0上的參數而控制。
Project Specification:
Set up Auth0 with user accounts that will sign on with passwordless login Auth0 users will contain the following data: Name Department Email School ID (array of id numbers) Country ID (array of country ids) Elastic Search: Create an account such that it is also connected to our Auth0 Create a dashboard that pulls data from a GCP Cloud SQL server, either form a direct SQL or from log files (to discuss) The data will consist of students, location (country of the student), applications, ...etc. This will allow the dashboard to filter by the following: - Academic Year (using start date of course) - Course Level - Course Type - Location (this will restricted by Auth0 user Country ID. If no value given then users sees all countries) - University (this will restricted by Auth0 user School ID. If no value given then users sees all schools) Various metrics as demoed above. Filters should have various restrictions applied based on the user meta from Auth0
We currently have a working version of this www.ukeas.partners built using PHP, but the Auth0 and Kibana dashboard was set up by someone else and so we are lacking the full understanding of how the pieces come together. We are looking for someone to act as a tutor, describing how to build such an infrastructure step by step so that we can be in a position to feel comfortable with future modifications.
