Description
2. Discovering and Loading File-Based Data with Power BI Desktop3. Discovering and Loading File-Based Data with Power BI Desktop
4. DirectQuery and Connect Live5. Loading Data from the Web and the Cloud6. Loading Data from Other Data Sources7. Structuring Imported Data
8. Data Transformation and Cleansing
9. Restructuring Data
10. Complex Data Loads
11. Organizing, Managing, and Parameterizing Queries
12. The M Language13. Creating a Data Model14. 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
Author: Adam Aspin
Publisher: Apress
Published: 07/08/2020
Pages: 898
Binding Type: Paperback
Weight: 3.49lbs
Size: 10.00h x 7.00w x 1.84d
ISBN13: 9781484257623
ISBN10: 1484257626
BISAC Categories:
- Computers | Programming | Microsoft
- Computers | Database Administration & Management
About the Author
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).