Creating and Using Databases with Power Pivot & ChatGPT
Training Provider: SINGAPORE MANAGEMENT UNIVERSITY
Course Reference: TGS-2025058332
S$800
Original: S$1,600
Save S$800
About This Course
This module will focus on the structuring and management of databases using Microsoft Excel. The objective of this module is to build capability in the design of a database and a data model.
What You'll Learn
At the end of the 2-day module, participants will be able to:
• Understand data design principles by outlining best practices in data/database design
• Use Data Table Creation by exploring functionality and architecting tables
• Apply simple data mining techniques using filters and Data Analysis Expressions (DAX) to reveal data features
• Employ data formatting techniques focusing on filtering and data type transformations
• Learn about database management exploring collaboration and data governance tasks
• Learn about data model creation by using power pivot to create simple star schema data model
• Understand data design principles by outlining best practices in data/database design
• Use Data Table Creation by exploring functionality and architecting tables
• Apply simple data mining techniques using filters and Data Analysis Expressions (DAX) to reveal data features
• Employ data formatting techniques focusing on filtering and data type transformations
• Learn about database management exploring collaboration and data governance tasks
• Learn about data model creation by using power pivot to create simple star schema data model
Entry Requirements
Participants with at least a diploma qualification
Course Details
Back to All Courses
Note: To apply for this course, visit or contact the training provider directly.
More Courses from SINGAPORE MANAGEMENT UNIVERSITY
In today's digital-first world, the demand for skilled cybersecurity professionals has never been hi...
This certificate programme is designed for non-technical professionals who want to develop data visu...
The (SCTP) Advanced Certificate in Digital Marketing programme provides a comprehensive and immersiv...