CHAPTER 2Modeling and visualizing data

The previous chapter reviewed the skills necessary to connect to data sources and transform data using Power Query Editor—the process also known as data shaping.

This chapter starts by covering data modeling skills. In Power BI, a data model is a collection of one or more tables connected by relationships. Apart from the M language, which is used for data shaping, Power BI uses DAX, which is its native formula and query language. Power BI possesses rich data modeling capabilities, which include creating relationships as well as enriching a data model with hierarchies, measures, calculated columns, and calculated tables.

Next, we review the data visualization skills: working with different types of charts ...

Get Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.