Pro Power BI Desktop

This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now 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 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 will help you to push your BI delivery to the next level. You'll learn to create great-looking visualizations and let your audience have fun by interacting with the elegant and visually arresting output that you can now deliver. You can 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, on tablets, on smartphones, as well as share results via the cloud. Finally, this book helps you save time by preparing the underlying data correctly without needing an IT department to prepare it for you. Power BI Desktop will let your analyses speak for themselves.

• Simple techniques to make data into insight.
• Polished interactive dashboards to deliver attention-grabbing information.
• Visually arresting output on multiple devices grab the reader's attention.

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

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 to Microsoft Access to MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe using SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Integration Services.

Business Intelligence has been Adam's principal focus for the last ten years. He has applied his skills for a range of clients, including J.P. Morgan, The Organisation for Economic Co-operation and Development (OECD), Tesco, Centrica, Harrods, Vodafone, Crédit Agricole, Cartier, Alfred Dunhill, The RAC, Willis Insurance, Signet, and EMC Conchango.

Contenu
Introduction.- 1. Introduction to Power BI Desktop.- 2. Discovering and Loading Data with Power BI Desktop.- 3. Transforming Datasets.- 4. Data Cleansing.- 5. Data Mashup.- 6. Creating a Data Model.- 7. Extending the Data Model with Calculated Columns.- 8. Adding Measures to the Data Model.- 9. Analyzing Data Over Time.- 10. Text-Based Visualizations.- 11. Charts in Power BI Desktop.- 12. Other Types of Visuals.- 13. Filtering Data.- 14. Using Slicers.- 15. Enhancing Dashboards.- 16. PowerBi.com.