Data modeling in Power Apps
About this guide
Scenario
Bellows College is an educational organization with multiple campuses and programs. Many of Bellow Colleges instructors and administrators need to attend events, and purchase items. Historically tracking these expenses has been a challenge.
Campus administration would like to modernize their expense reporting system by providing employees with a digital way to report expenses.
Throughout this series, you will build applications and perform automation to enable the Bellows College employees to manage expenses.
Finally, you will import sample data into Microsoft Dataverse.
High-Level Lab Steps
To prepare your environments you will:
- Create Expenses table
- Add some sample data
Things to consider before you begin:
- Naming conventions - enter names carefully.
Tasks and Job Skills
Exercise 1: Create new table
Objective: In this exercise, you will see how to create a new custom table for Expenses.
Task 1: Create Expenses table and columns
Exercise 2: Enter data
Objective: In this exercise, you will see how to manually enter some sample data into your new table.
Task 1: Modify the columns displayed
Task 2: Add a sample record
Career Connections
The guides in this series provide foundational Power Platform knowledge, empowering roles such as Business Analyst, Citizen Developer, and Entry-Level Consultant to enhance their job performance by leveraging the platform's capabilities.
As of 2025, average U.S. salaries range from $44,000 to $80,000 for entry-level Business Analysts and $52,000 to $101,000 with five years of experience, while Citizen Developers earn around $129,348 annually. Entry-Level Consultants make approximately $65,224, with experienced consultants at top firms earning significantly higher, starting at $112,000 for undergraduates and $192,000 for MBAs. Please note that these figures are approximate, derived from online sources, and can vary based on factors such as location, industry, qualifications, and company size.
