Build an Onboarding App
We’re using Power Apps and Microsoft SQL Server to build an onboarding application that could be used in any organization!
Introduction to Onboarding App Development: Darren introduces the process of building an onboarding application using Power Apps and Microsoft SQL Server. He mentions publicly available notes, tools like Obsidian for organization, and a brief recap of a previous session.
Database and Requirement Gathering: Darren discusses the need for understanding and gathering detailed requirements from clients, particularly for building an onboarding app. References are made to handling data types, documents, notifications, and the complexities involved in designing the system.
Designing the Database Structure: A large portion of the discussion involves creating a flexible database structure that will handle various data types and documents. Examples are given of one-to-one relationships, utilizing mapping tables, and the importance of using foreign keys.
Focus on Reusability and Expansion: Darren emphasize the need to create systems that can be reused and expanded in the future, such as building a questionnaire engine that can morph into various needs or designing an app that can handle multiple languages. Job security and the joy of programming are highlighted as positive aspects.
Technical Details and Reflection: The conversation concludes with a detailed explanation of various technical aspects of building the app, such as creating date time stamps, considering data types, and addressing potential issues with mismatched types in Power Apps. The conversation suggests a shared excitement for the project and a focus on thinking big and designing applications for a connected age.
When to use OLAP vs. OLTP. Online analytical processing (OLAP) and online transaction processing (OLTP) are two different data processing systems designed for different purposes. OLAP is optimized for complex data analysis and reporting, while OLTP is optimized for transactional processing and real-time updates.
Comments are closed.