Pro Power Bi Desktop

2. Auflage 2017
ISBN: 978-1-4842-3209-5
Verlag: APRESS

Buch, Englisch, 761 Seiten, Book, Format (B × H): 179 mm x 254 mm, Gewicht: 14728 g

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 LearnDeliver attention-grabbing information, turning data into insightMash up data from multiple sources into a cleansed and coherent data modelCreate dashboards that help in monitoring key performance indicators of your businessBuild interdependent charts, maps, and tables to deliver visually stunning informationShare business intelligence in the cloud without involving ITDeliver visually stunning and interactive charts, maps, and tablesFind new insights as you chop and tweak your data as never beforeAdapt delivery to mobile devices such as phones and tabletsWho This Book Is ForEveryone from CEOs and Business Intelligence developers to power users and IT managers

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Aspin, Adam

Fachgebiete

• Mathematik | Informatik EDV | Informatik Angewandte Informatik Wirtschaftsinformatik
• Mathematik | Informatik EDV | Informatik Business Application Unternehmenssoftware
• Wirtschaftswissenschaften Betriebswirtschaft Wirtschaftsinformatik, SAP, IT-Management

Inhaltsverzeichnis

Introduction1. Introduction to Power BI Desktop2. Discovering and Loading File- Based Data with Power BI Desktop3. Loading Data from Databases and Data Warehouses4. Direct Query and Connect Live 5. Loading Data from the Web and the Cloud6. Dealing with Datasets7. Data Transformation8. Data Mashup9. Structuring, Managing and Parameterizing Queries10. Creating a Data Model11. Extending the Data Model with Calculated Columns12. Adding Measures to the Data Model13. Analyzing Data over Time14. Table Visuals15. Matrix and Card Visuals16. Charts in Power BI Desktop17. Formatting Charts in Power BI Desktop18. Other Types of Visuals19. Maps in Power BI Desktop20. Filtering Data21. Using Slicers22. Enhancing Dashboards23. PowerBI.com24. Appendix A: Sample Data

Über Autor(innen)

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.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 Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SharePoint, and Power BI.Business Intelligence has been Adam's principal focus for the last 15 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 SQL Server Data Integration Recipes (Apress), High Impact Data Visualization with Power View, Power Map, and Power BI (Apress), and Business Intelligence with SQL Server Reporting Services (Apress).