---

Tagline: Free interactive data analysis and visualization for the desktop

---

Deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. This new edition has been updated to cover all the latest features, including combo charts, Cartesian charts, trend lines, use of gauges, and more. Also covered are Top-N features, the ability to bin data into groupings and chart the groupings, and new techniques for detecting and handling outlier data points.
You can take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience´s attention. Slice and dice the data with remarkable ease and then add metrics and KPIs to project the insights that create your competitive advantage. Make raw data into clear, accurate, and interactive information with Microsoft´s free self-service business intelligence tool.

Pro Power BI Desktop shows you how to choose from a wide range of built-in and third-party visualization types so that your message is always enhanced. You´ll be able to deliver those results on the PC, tablets, and smartphones, as well as share results via the cloud. This book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you.

What You´ll Learn

Deliver attention-grabbing information, turning data into insight

Mash up data from multiple sources into a cleansed and coherent data model
Create dashboards that help in monitoring key performance indicators of your business
Build interdependent charts, maps, and tables to deliver visually stunning information
Share business intelligence in the cloud without involving IT
Deliver visually stunning and interactive charts, maps, and tables
Find new insights as you chop and tweak your data as never before

Adapt delivery to mobile devices such as phones and tablets
Who This Book Is For
Everyone from CEOs and Business Intelligence developers to power users and IT managers

---

Introduction 1. Introduction to Power BI Desktop 2. Discovering and Loading File- Based Data with Power BI Desktop 3. Loading Data from Databases and Data Warehouses 4. Direct Query and Connect Live 5. Loading Data from the Web and the Cloud 6. Dealing with Datasets 7. Data Transformation 8. Data Mashup 9. Structuring, Managing and Parameterizing Queries 10. Creating a Data Model 11. Extending the Data Model with Calculated Columns 12. Adding Measures to the Data Model 13. Analyzing Data over Time 14. Table Visuals 15. Matrix and Card Visuals 16. Charts in Power BI Desktop 17. Formatting Charts in Power BI Desktop 18. Other Types of Visuals 19. Maps in Power BI Desktop 20. Filtering Data 21. Using Slicers 22. Enhancing Dashboards 23. PowerBI.com 24. Appendix A: Sample Data

---

Adam Aspin is an independent business intelligence consultant based in the United Kingdom. He has worked with SQL Server for more than 20 years. During this time, he has developed several dozen reporting and analytical systems based on the Microsoft BI product suite.

---