Adam Aspin is an independent Business Intelligence consultant based in the United Kingdom. He has worked with SQL Server for over 25 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft Data Platform.

A graduate of Oxford University, Adam began his career in publishing before moving into IT. Databases soon became a passion, and his experience in this arena ranges from dBase to Oracle, and Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe when using SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, Azure Data Factory, Azure Synapse and, of course, Power BI.

Business Intelligence has been Adam's principal focus for 20 years. He has applied his skills for a range of clients in a range of industry sectors. He is the author of SQL Server Data Integration Recipes; Pro Power BI Desktop (now in its third edition); Business Intelligence with SQL Server Reporting Services; High Impact Data Visualization; Data Mashup using Microsoft Excel using Power Query and M, and Pro Power BI Theme Creation-all with Apress.

A fluent French speaker, Adam has worked in France and Switzerland for many years.

Teaches you to cleanse, prepare, and transform external data

Shows how to connect to an extensive variety of data sources

Introduces the M language to develop advanced data transformations

1. Discovering and Loading Data with Power BI Desktop.- 2. Discovering and Loading File-Based Data with Power BI Desktop.- 3. Loading Data From Databases and Data Warehouses.- 4. DirectQuery and Live Connect.- 5. Loading Data from the Web and Cloud.- 6. Loading Data from Other Data Sources.- 7. Power Query.- 8. Structuring Data.- 9. Shaping Data.- 10. Data Cleansing.- 11. Data Transformation.- 12. Complex Data Structures.- 13. Organizing, Managing, and Parameterizing Queries.- 14. The M Language.- 15. Appendix A: Sample Data.