Data Modeling and DAX in Power BI

Welcome to Week 3 of BUSINFO 703. In this lecture, we’re going to build from the basics

of loading and cleaning data—covered last week—toward more complex data modeling and powerful analytics

in Power BI. The focus areas are case studies, DAX (Data Analysis Expressions),

modeling best practices, and a practical business scenario using real-world datasets

Let’s start by talking about **case studies and the business context**. This week,

you’re introduced to using real public datasets—from the OECD—for topics like air pollution,

cancer rates, and illness-related workplace absences. The big takeaway: in business,

meaningful analysis starts with a question. For example, “How does air pollution affect health outcomes