The complete everyday reference guide to Power BI, written by an internationally recognized Power BI expert duo, is back with a new and updated edition.
Packed with revised practical recipes, Microsoft Power BI Cookbook, Second Edition, helps you navigate Power BI tools and advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. With the help of the recipes in this book, you’ll gain advanced design and development insight, practical tips, and guidance on enhancing existing Power BI projects.
The updated recipes will equip you with everything you need to know to implement evergreen frameworks that will stay relevant as Power BI updates. You’ll familiarize yourself with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. By the end of this book, you’ll make the most of Power BI’s functional programming languages of DAX and M and deliver powerful solutions to common business intelligence challenges.
publication date
2021-09-30
what you will learn
Cleanse, stage, and integrate your data sources with Power Query (M)
Remove data complexities and provide users with intuitive, self-service BI capabilities
Build business logic and analysis into your solutions via the DAX programming language and dashboard-ready calculations
Implement aggregation tables to accelerate query performance over large data sources
Create and integrate paginated reports
Understand the differences and implications of DirectQuery, live connections, Import, and Composite model datasets
Integrate other Microsoft data tools into your Power BI solution
key features
Update your knowledge with new recipes for query optimization, aggregation tables, Power BI API, and paginated reports * Work with recipes across diverse Power BI platforms including the Power BI Service and Mobile Applications * Implement custom solutions with M and DAX languages through actionable guidance and proven development techniques
approach
This book consists of practical recipes on Power BI that targets intermediate Power BI users. It goes deep into technical issues, covers additional protocols, and many more real-life examples.
audience
If you’re a BI professional who wants to up their knowledge of Power BI and offer more value to their organization, then this book is for you. Those looking for quick solutions to common Power BI problems will also find this book an extremely useful resource. Please be aware that this is not a beginner’s guide; you’ll need a solid understanding of Power BI and experience working with datasets before you dive in.
short description
Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services.
subtitle
Gain expertise in Power BI with over 90 hands-on recipes, tips, and use cases
keywords
data visualization, business intelligence and anlytics, Power BI books, Microsoft PowerBI, Microsoft business intelligence, Visual analytics, data collection, data modeling
Product ISBN
9781801813044
