adminHello,
Are you looking for an exciting new project?
We’re hoping to hire an expert bubble.io developer to help us build out our new application. At Tesylate we produce Power BI analytics for our customers leveraging Power BI’s capabilities with our skills with ETL, Datawarehousing etc to build amazing custom reports.
We’ve identified some key pain points for our customers and for us that we want to solve. To do this we want to embed our current Power BI reports inside a web application and built functionality to solve our clients main issues. We’re doing most of this already using various online excel sheets and ETL packages but its prone to error and harder work for us and the customer.
Here is the requirements for the application:
The application will be built on bubble.io using the G Forms Template. All views will need to work on Web and mobile web and on the native applications when this is possible in bubble.
The first set of functions are already in the template but may need work:
USER CONTROL AND FORMS
1. User Login and control – all the standard user login control including password reset, 2 factor authentication and sign up functionality.
2. Organisation Control – all users will be assigned to an organisation and organisation admins will be able to add/ remove and edit users in their organsiation. Only our users i.e. Tesylate internal users will be able to create organisations and assign them to SQL Databases and Power BI Workspaces.
3. User Roles – all users will be assigned a role, this will determine what reports they can view, what forms they can fill out, what responses they can see and what modules they can see.
4. Forms – there will be a form builder inside the application with all the usual form building functionality with one key exception. When the user is building a form he needs to be able to set a field as a lookup to a "DataSet" more about these later. Form Lookups should also be able to look up other form responses.
DATA SETS
Each of our clients has a database on our MS SQL Server in that database there is a number of views which comprise the clients data model. We want the client to be able to see all the available views in a section of the app called "Data Sets" here they will be able to select any of the available views and see a preview of the data. The column headings must match the source view and so must the data formatting. Key Point: when a view is added or edited in the client data the bubble.io application needs to automatically reflect any changes.
MODULES
This is the user facing part of the form builder. Any form that is created will show in that companies list of "Modules" Selecting the module will allow the user to see the fields in the module and add a new form response. They will also be able to edit previous responses.
EXTERNAL FORMS
Any form needs to be able to be made an external form and have a link that can be accessed with no login infomation.
DEFAULT MODULES
When a new company is created some default modules need to be created for that company including:
Targets
– Date
– Date Interval
– Target Value
– Target Type (lookup to targets table)
– Assigned To (lookup to users table)
– Region (lookup to regions table)
Regions
– Region
Target Types
– Target Type
Holidays
– Date
– Name
Daily Snapshots –
– Email
– Report Name – drop down from list of avaialbe reports in that clients workspace
– Page Name – drop down from list of available pages in that report.
REPORTS
This is the most important module where the actual reports are. You will need to use the Microsoft Embedded Analytics API. The documenation is here: https://learn.microsoft.com/en-us/javascript/api/overview/powerbi/embedding-solutions we will be using the "Embed for your Customers" scenerio. The application needs to automatically embed all available reports for that specific customer based on the workspace that the organsisation is assigned to. Please study the API documentation for more details. Each user role can be assigned or denied a report but all reports will be assigned to all user roles by default.
So in summary a customer will be able to login, view their reports, update their targets, holidays, users etc and view their data sets. Then they will be able to create custom modules using the form builder than can be filled out internall or externally and can be linked to existing data in their dataset.
NICE TO HAVES
SQL INTEGRATION
All modules need to automatically generate tables in MS SQL and sync the data to their duplicate table. (NICE TO HAVE ONLY)
Please provide an estimate qty of hours to complete this project from this infomation with your cover letter.
Hourly Range: $25.00-$50.00
Posted On: January 20, 2024 00:50 UTC
Category: Full Stack Development
Skills:Web Application, Microsoft SQL Server, Bubble.io, API, Web Development, Web Design, API Integration
Country: United Kingdom
click to apply
Powered by WPeMatico
