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.
What You Will Learn
- Produce designer output to astound your bosses and peers.
- Share business intelligence in the cloud
- Deliver visually stunning charts, maps, and tables.
- Make them interactive too!
- Find new insights as you chop and tweak your data as never before.
- Adapt delivery to mobile devices such as phones and tablets.
Audience
Pro Power BI Desktop is written for any user who is comfortable in Microsoft Office. Everyone from CEOs and Business Intelligence developers through to power users and IT managers can use this book to outshine the competition by producing 21st Century business intelligence visualizations and reporting on a variety of devices from a variety of data sources. All of this is possible through leveraging your existing skill set with the same, common Microsoft tools you already use in your daily work.
Cuprins
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. Power Bi.com.
Despre autor
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 d Base to Oracle to Microsoft Access to My SQL, 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.