Pro Power BI Desktop

Description

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.;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. 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.