Data Analysis & Modeling for BA/SA is a hands-on course in turning business requirements into data models, from conceptual and logical ERDs and normalisation to third normal form through to star schemas for reporting and data quality checks. It suits business analysts, system analysts and product owners who hand work to developers, and you leave with an ERD and a data dictionary ready to use.
The most common problem in system projects is not badly written code but misunderstanding the data from the start. Requirement documents written as plain text, which do not say where each piece of data is stored, what it relates to or which business rules govern it, leave the development team to interpret things for themselves. The result is a system whose database structure has to change midway, which is the most expensive kind of change in the development lifecycle.
This course is designed specifically for BAs and SAs, not DBAs. Learners practise turning user interviews and business documents into a conceptual model, a logical model and a data dictionary that can be handed to developers straight away. They learn as much normalisation as they need to make design decisions, how to design models for reporting (dimensional modelling) and how to check data quality before a project starts. Both days are one continuous workshop on the NovaRetail case study, so learners see real work from start to finish. (2 days, 6 hours per day, 12 hours in total, Beginner to Intermediate level.)
Course Details
A 2-day course, 6 hours per day (12 hours in total, 09:00-16:00), run as one continuous workshop on the NovaRetail case study at Beginner to Intermediate level, with no SQL needed. It uses only free tools: dbdiagram.io, draw.io, DBeaver Community Edition and PostgreSQL 17 on Docker. The course builds on Business Requirement Essentials for BA/SA (BASA-00) and focuses on data design from the BA/SA side rather than DBA work. Learners take home templates for a data dictionary, business rules catalogue and data requirement document, worksheets with answers, and the ERD and star schema they build in class.
Section 1: The BA/SA Role in Data Design
Section 2: The Three Levels of Data Models
Section 3: Lab: Extracting Data Structures from Requirements
Section 4: Lab: Drawing Correct, Readable ERDs
Section 5: Lab: Choosing Keys and Managing Business Rules
Section 6: Day 1 Workshop: NovaRetail Logical ERD
Section 7: Lab: The Normalisation BAs and SAs Actually Need
Section 8: Building a Professional Data Dictionary
Section 9: Lab: Data History and Models for Reporting
Section 10: Lab: Assessing Data Quality from the Analysis Stage
Section 11: Reviewing the Model with Stakeholders
Section 12: Day 2 Master Workshop: Refining the Model and a NovaRetail Star Schema
No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770
Built for Business analysts and system analysts who write requirements that involve data · Product owners and project managers who review and approve a project's data design · Developers and testers who want to understand where database structures come from and communicate better with analysts Background you should have: An understanding of your organisation's business processes and some experience of requirement gathering · Basic use of Excel or Google Sheets Not sure the fit is right? Talk to our team on LINE @itgenius or call 02-570-8449.
THB 7,900 (currently THB 7,110 on promotion). The course runs 12 hours. The price excludes 7% VAT (for payment in a company's name). Pay by bank transfer to the company account, confirm it on our payment page, and we can issue the receipt or tax invoice in your company's name.
Yes. Everyone who completes the course receives a Certificate of Completion from IT Genius Institute. Each certificate carries its own number, and anyone holding that number can verify it online on our certificate page, so you can add it to your portfolio or pass it to HR as evidence of training.
You can attend onsite at IT Genius Institute or arrange to join online, and we also run it as a private in-house session for your team. Ask about dates and venues on LINE @itgenius or call 02-570-8449.
Yes. You may retake the same course free of charge in a later round, under the institute's conditions. Tell our team which course and round you attended, and we will check it and offer you the rounds that still have seats. Ask us on LINE @itgenius or call 02-570-8449.
Enrol online with the registration form on this page. You can register several attendees at once and enter your tax ID and billing address for the tax invoice. Or request a company quotation straight from the quote button. For anything else call 02-570-8449 or reach us on LINE @itgenius.
Many system projects do not fail because of technology. They fail because the team and the client understood the requirements differently. Clients often describe their problem mixed with a solution they have already decided on, and requirement documents are…
Many business analysts and system analysts have to wait for the development team or a DBA to pull data every time they need to check a problem case. The cycle is slow, and the data that comes back often does not answer the real question. Yet writing SQL well…
System analysis and design work burns more time on writing documents and drawing diagrams than on the design thinking itself. Getting the use cases complete, finishing the process flows, making the ER diagram match what was actually agreed, then writing the…
