Overview

Full Product Details

Author:   Adam Aspin
Publisher:   APress
Imprint:   APress
Edition:   3rd ed.
Weight:   1.738kg
ISBN:  

9781484257623

ISBN 10:   1484257626
Pages:   898
Publication Date:   12 June 2020
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

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 Connect Live.- 5. Loading Data from the Web and the Cloud.- 6. Loading Data from Other Data Sources.- 7. Structuring Imported Data.- 8. Data Transformation and Cleansing.- 9. Restructuring Data.- 10. Complex Data Loads.- 11. Organizing, Managing, and Parameterizing Queries.- 12. The M Language.- 13. Creating a Data Model.- 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. Third-Party Visuals.- 20. Maps in Power BI Desktop.- 21. Filtering Data.- 22. Using Slicers.- 23. Enhancing Dashboards.- 24. Advanced Dashboarding Techniques.- 25. Appendix A: Sample Data.

Reviews

Author Information

Adam Aspin is an independent business intelligence (BI) consultant based in the UK. He has worked with SQL Server for more than 25 years. During this time, he has developed several dozen reporting and analytical systems using Microsoft analytics. 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 Access to Oracle and MySQL, with occasional sorties into the world of DB2. He is, however, most at home in the Microsoft universe using SQL Server, SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, and Power BI, both on-premises and in Azure. Business Intelligence has been Adam's principal focus for the last 25 years. He has applied his skills for a range of clients in industry sectors such as finance, utilities, telecommunications, insurance, manufacturing, and banking. Adam is a frequent contributor to SQLServerCentral.com and Simple-Talk. He has written numerous articles for various French IT publications. A fluent French speaker, Adam has worked in France and Switzerland for many years. He speaks regularly at events such as SQLBits, SQL Saturdays, and local SQL Server user groups. Adam is the author of the following Apress books: SQL Server Data Integration Recipes; High Impact Data Visualization with Power View, Power Map, and Power BI; Business Intelligence with SQL Server Reporting Services; and Data Mashup with Microsoft Excel (Apress).

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions