3

Data Preparation in Power Query Editor

In the previous chapters, we discussed various layers in Power BI and went through some scenarios. By now, we know Power BI is not only a reporting tool. Power BI is indeed a sophisticated all-round Business Intelligence (BI) technology, with the flexibility to be used as a self-service BI tool that supports many BI aspects such as Extract, Transform, and Load (ETL) processes, data modeling, data analysis, and data visualization. As a powerful BI tool, Power BI is improving every day, which is fantastic. Microsoft’s Power BI development team constantly brings new ideas to this technology to make it even more powerful. Data preparation and ETL activities are the BI areas in which Power BI is great for ...

Get Expert Data Modeling with Power BI - Second Edition 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.