Build effective analytical data models, reports, and dashboards using the advanced features of Power BI. Purchase of the print or Kindle book includes a free eBook in the PDF format. 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 Book DescriptionThe 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. 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 Who this book is forIf 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.

Extend your skills with Odoo 12 to build resourceful and open source business applications Key Features Explore Odoo 12 capabilities to develop business applications Program business logic and manipulate data to implement specific business rules in your applications Integrate Python APIs for building customizable and scalable business logic Book DescriptionOdoo is one of the best platforms for open source ERP and CRM. Its latest version, Odoo 12, brings with it new features and updates in Python packages to develop more customizable applications with additional cloud capabilities. The book begins by covering the development essentials for building business applications. You will start your journey by learning how to install and configure Odoo, and then transition from having no specific knowledge of Odoo to being ready for application development. You will develop your first Odoo application and understand topics such as models and views. Odoo 12 Development Essentials will also guide you in using server APIs to add business logic, helping you lay a solid foundation for advanced topics. As you progress through the chapters, you will be equipped to build and customize your applications and explore the new features in Odoo 12, such as cloud integration, to scale your business applications. You will get insights into building business logic and integrating various APIs into your application. By the end of the book, you will be able to build a business application from scratch by using the latest version of Odoo. What you will learn Manage Odoo server instances Create a new Odoo application from scratch using the most frequently used elements Develop new models and use inheritance to extend existing models Use ORM methods in the Odoo server and from external clients Create Kanban views using QWeb effectively Build custom web and website CMS pages Use external APIs to integrate Odoo with external applications Add automated tests and techniques to debug module business logic Who this book is forIf you are a developer familiar with Python and MVC design and want to build business applications using Odoo, this book is for you.