Analyse your company’s data quickly and easily using Microsoft’s latest tools. You will learn to build scalable and robust data models to work from, clean and combine different data sources effectively, and create compelling visualisations and share them with your colleagues.

This excerpt ‘Data Munging with Power Query’ from the book Beginning Power BI by Dan Clark is your hands-on guide to quick, reliable, and valuable data insight.

Topics covered include:

• Discovering and Importing Data
• Transforming, Cleansing, and Filtering Data
• Merging and Shaping Data
• Grouping and Aggregating Data
• Inserting Calculated Columns

This chapter was published with permission from APRESS, a publisher of technical books. Download the excerpt below or purchase the full eBook HERE.