Creating and Using Databases with Power Pivot & ChatGPT
- Analytics & Tech
- Innovation & Business Improvement
This programme is conducted on-campus.
3 days
Weeknights (7pm - 10:30pm)
Saturday (9am - 6pm)
Who Should Attend
- Business Managers
- Business Owners
- Data Center Executives
- E-Commerce Executives
- Finance Executives
- Marketing Executives
- Professionals
PREREQUISITES
- Participants with at least a diploma qualification and should have basic computer literacy.
- Software Requirement Specification
- Microsoft Windows 10 or 11 (MacOS not supported)
Microsoft Office
2.1 Windows Version ONLY- Microsoft 365 (previously known as Office365) SAAS versions
- Microsoft Office 2019 or newer versions (Home & Student, Home & Business, Standard, Professional and Professional Plus)
- Microsoft Office 2016 and older versions not supported
2.2 Mac versions NOT supported
- Hardware Requirements: 4GB RAM and above, 1GB hard disk space (For Power BI Desktop installation)
Overview
Learning Objectives
- 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 uncover hidden data insights, with the help of ChatGPT
- 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
Assessment
As part of the requirement for SkillsFuture Singapore, there will be an assessment conducted at the end of the course. The mode of assessment, which is up to the trainer’s direction, may be an online test and assignment.
Participants are required to attain a minimum of 75% attendance and pass the associated assessment in order to receive a digital Certificate of Completion issued by Singapore Management University.
Calculate Programme Fee
Fee Table
| COMPANY-SPONSORED | |||
|
PARTICIPANT PROFILE |
SELF-SPONSORED |
SME |
NON-SME |
|
Singapore Citizen < 40 years old Permanent Resident LTVP+
|
$523.20 (After SSG Funding 70%) |
$203.20 (After SSG Funding 70% |
$523.20 (After SSG Funding 70%) |
|
Singapore Citizen ≥ 40 years old |
$203.20 (After SSG Funding 70% |
$203.20 (After SSG Funding 70% |
$203.20 (After SSG Funding 70% |
|
International Participant |
$1,744 (No Funding) |
$1,744 (No Funding) |
$1,744 (No Funding) |
All prices include 9% GST
Please note that the programme fees are subject to change without prior notice.
Post Secondary Education Account (PSEA)
PSEA can be utilised for subsidised programmes eligible for SkillsFuture Credit support. Click here to find out more.
Self Sponsored
SkillsFuture Credit
Singapore Citizens aged 25 and above may use their SkillsFuture Credits to pay for the course fees. The credits may be used on top of existing course fee funding.
This is only applicable to self-sponsored participants. Application to utilise SkillsFuture Credits can be submitted when making payment for the course via the SMU Academy TMS Portal, and can only be made within 60 days of course start date.
Please click here for more information on the SkillsFuture Credit. For help in submitting an SFC claim, you may wish to refer to our step-by-step guide on claiming SkillsFuture Credits (Individual).Workfare Skills Support Scheme
From 1 July 2023, the Workfare Skills Support (WSS) scheme has been enhanced. Please click here for more details.
Company Sponsored
Enhanced Training Support for SMEs (ETSS)
- Organisation must be registered or incorporated in Singapore
- Employment size of not more than 200 or with annual sales turnover of not more than $100 million
- Trainees must be hired in accordance with the Employment Act and fully sponsored by their employers for the course
- Trainees must be Singapore Citizens or Singapore Permanent Residents
- Trainees must not be a full-time national serviceman
- Trainees will be able to enjoy ETSS funding only if the company's SME's status has been approved. To verify your SME's status, please click here.
Please click here for more information on ETSS.
Absentee Payroll
Companies who sponsor their employees for the course may apply for Absentee Payroll here. For more information, please refer to:
AP Guide (Non-SME Companies)
Declaration Guide (SME Companies)
Intake Information
Next Intake: 26, 27 & 28 Sep 2024 [Registration Closed]
You might also be interested in
