Microsoft Power BI Cookbook

Creating Business Intelligence Solutions of Analytical Data Models, Reports, and Dashboards

Author: Brett Powell

Publisher: Packt Publishing Ltd

ISBN: 1788293789

Category: Computers

Page: 802

View: 8026

DOWNLOAD NOW »

Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications Proven development techniques and guidance for implementing custom solutions with DAX and M languages Who This Book Is For This book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful. What You Will Learn Cleanse, stage, and integrate your data sources with Power BI Abstract 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 dynamic, dashboard-ready calculations Take advantage of the analytics and predictive capabilities of Power BI Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution In Detail Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of 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. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects. Style and approach This book consists of practical recipes on Power BI that target novices as well as intermediate Power BI users. It goes deep into the technical issues, covers additional protocols, and many more real-live examples.
Release

Mastering Microsoft Power BI

Expert techniques for effective data analytics and business intelligence

Author: Brett Powell

Publisher: Packt Publishing Ltd

ISBN: 1788292286

Category: Computers

Page: 638

View: 4837

DOWNLOAD NOW »

Design, create and manage robust Power BI solutions to gain meaningful business insights Key Features Master all the dashboarding and reporting features of Microsoft Power BI Combine data from multiple sources, create stunning visualizations and publish your reports across multiple platforms A comprehensive guide with real-world use cases and examples demonstrating how you can get the best out of Microsoft Power BI Book Description This book is intended for business intelligence professionals responsible for the design and development of Power BI content as well as managers, architects and administrators who oversee Power BI projects and deployments. The chapters flow from the planning of a Power BI project through the development and distribution of content to the administration of Power BI for an organization. BI developers will learn how to create sustainable and impactful Power BI datasets, reports, and dashboards. This includes connecting to data sources, shaping and enhancing source data, and developing an analytical data model. Additionally, top report and dashboard design practices are described using features such as Bookmarks and the Power KPI visual. BI managers will learn how Power BI’s tools work together such as with the On-premises data gateway and how content can be staged and securely distributed via Apps. Additionally, both the Power BI Report Server and Power BI Premium are reviewed. By the end of this book, you will be confident in creating effective charts, tables, reports or dashboards for any kind of data using the tools and techniques in Microsoft PowerBI. What you will learn Build efficient data retrieval and transformation processes with the Power Query M Language Design scalable, user-friendly DirectQuery and Import Data Models Develop visually rich, immersive, and interactive reports and dashboards Maintain version control and stage deployments across development, test, and production environments Manage and monitor the Power BI Service and the On-premises data gateway Develop a fully on-premise solution with the Power BI Report Server Scale up a Power BI solution via Power BI Premium capacity and migration to Azure Analysis Services or SQL Server Analysis Services Who this book is for Business Intelligence professionals and existing Power BI users looking to master Power BI for all their data visualization and dashboarding needs will find this book to be useful. While understanding of the basic BI concepts is required, some exposure to Microsoft Power BI will be helpful.
Release

SQL Server 2016 Reporting Services Cookbook

Author: Dinesh Priyankara,Robert C. Cain

Publisher: Packt Publishing Ltd

ISBN: 1786467992

Category: Computers

Page: 596

View: 490

DOWNLOAD NOW »

Create interactive cross-platform reports and dashboards using SQL Server 2016 Reporting Services About This Book Get up to speed with the newly-introduced enhancements and the more advanced query and reporting features Easily access your important data by creating visually appealing dashboards in the Power BI practical recipe Create cross-browser and cross-platform reports using SQL Server 2016 Reporting Services Who This Book Is For This book is for software professionals who develop and implement reporting solutions using Microsoft SQL Server. It is especially relevant for professionals who are software engineers, software architects, DW/BI engineers, and DW/BI architects who perform simple to complex report authoring implementations. This book is also suitable for those who develop software solutions that integrate reporting solutions and are keen to learn about Microsoft SQL Server 2016's features and capabilities. What You Will Learn Key capabilities, architecture, and components of Reporting Services New features that have been added to Reporting Services Design the architecture for reporting solutions Design the architecture for BI solutions Implement reporting solutions using Reporting Services Improve the performance, availability, and scalability of the reporting solution Enhance reporting solutions with custom programming and improved security In Detail Microsoft SQL Server 2016 Reporting Services comes with many new features. It offers different types of reporting such as Production, Ad-hoc, Dashboard, Mash-up, and Analytical. SQL Server 2016 also has a surfeit of new features including Mobile Reporting, and Power BI integration. This book contains recipes that explore the new and advanced features added to SQL Server 2016. The first few chapters cover recipes on configuring components and how to explore these new features. You'll learn to build your own reporting solution with data tools and report builder, along with learning techniques to create visually appealing reports. This book also has recipes for enhanced mobile reporting solutions, accessing these solutions effectively, and delivering interactive business intelligence solutions. Towards the end of the book, you'll get to grips with running reporting services in SharePoint integrated mode and be able to administer, monitor, and secure your reporting solution. This book covers about the new offerings of Microsoft SQL Server 2016 Reporting Services in comprehensive detail and uses examples of real-world problem-solving business scenarios. Style and approach This comprehensive cookbook follows a problem-solution approach to help you overcome any obstacle when creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services. Each recipe focuses on a specific task and is written in a clear, solution-focused style.
Release

Pro DAX with Power BI

Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular

Author: Philip Seamark,Tom Martens

Publisher: Apress

ISBN: 9781484248966

Category: Computers

Page: 280

View: 2693

DOWNLOAD NOW »

Know the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI, Microsoft’s leading self-service business Intelligence application, and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks. Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. Explanation is given to how, through combining building blocks of DAX (such as measures, table filtering, and data lineage), Power BI can yield impressive analytical power. Throughout Pro Dax with Power BI these building blocks are used to create and compose solutions for advanced DAX problems so you can independently build solutions to your own complex problems, and gain valuable insight from your data. What You'll Learn Understand the intricate workings of DAX to solve advanced problems Deconstruct problems into manageable parts in order to create your own recipes Apply predefined solutions for addressing problems, and link back step-by-step to the mechanics of DAX, to know the foundation of this powerful query language Get fully on board with DAX, a new and evolving language, by learning best practices Who This Book Is For Anyone who wants to use Power BI to build advanced and complex models. Some experience writing DAX is helpful, but not essential if you have experience with other data query languages such as MDX or SQL.
Release

Building Dynamics CRM 2015 Dashboards with Power BI

Author: Steve Ivie

Publisher: Packt Publishing Ltd

ISBN: 1785280171

Category: Computers

Page: 184

View: 3259

DOWNLOAD NOW »

Build interactive and analytical sales productivity dashboards for Dynamics CRM 2015 with Power BI About This Book Create Dynamics CRM reports using Power BI for Office 365 and Power BI Designer Discover best practices to build and deploy these dashboards to Power BI sites and Dynamics CRM 2015 Learn how to extend dashboard to mobile iPad and Surface Power BI apps Who This Book Is For This book is intended for all Dynamics CRM 2015 users—administrators, managers, business analysts, or report writers who are new to creating dashboards using Power BI and Dynamics CRM. It would be helpful to have a basic knowledge of the Dynamics CRM 2015 platform, but no prior experience is required. What You Will Learn Organize and consolidate Dynamics CRM 2015 datasets Add summaries and visualizations using charts and maps Enhance data clarity with filters, slicers, timelines Improve analysis by joining other data sources Deploy and present the dashboard to Power BI for Office 365 site Use the advanced Q/A functionality with Power BI to query data in the dashboard graphs and charts Connect the dashboards to Dynamics CRM 2015 Extend functionality with Power BI mobile apps In Detail Dynamics CRM 2015 holds a wealth of information about customers and the sales pipeline, but sometimes leaves users with basic end-user reporting and dashboard options. Power BI is a great new tool for analyzing and presenting data, giving us the ability to dig deeper into the information. With the increased requests for real-time sales analytics, Power BI when connected to Dynamics CRM offers a self-service approach to build, shape, and present data through an easy-to-use interface. The set of features within Power BI will give all users a tool to generate real-time sales productivity reports and dashboards to enhance their sales performance. This book will provide you with the skills you need to learn how to build and present Dynamics CRM 2015 sales dashboards using Power BI. It follows a step-by-step process to build an interactive dashboard by organizing and consolidating datasets, improving the look and feel of graphs, charts, and maps, and enhancing data clarity with filters and slicers. By sequentially working through the steps in each chapter, you will learn how to use the Power BI Q/A functionality to query data in the dashboard, extend the dashboards to the mobile apps for the iPad and Surface, and leverage the pre-built workbook template provided by Microsoft for Dynamic CRM 2015 sales, service, and marketing dashboards. Style and approach A step-by-step approach to building a Power BI driven Dynamics CRM dashboard explained in an easy-to-follow style. Each topic is explained sequentially in the process of creating a dashboard, and detailed explanations of the basic and advanced features of Power BI and Dynamics CRM that appeal to the needs of readers with a wide range of experiences are also included.
Release

Tableau 10 Bootcamp

Intensive training for data visualization and dashboarding

Author: Joshua N. Milligan,Donabel Santos

Publisher: Packt Publishing Ltd

ISBN: 1787282929

Category: Computers

Page: 384

View: 7124

DOWNLOAD NOW »

Sharpen your data visualization skills with Tableau 10 Bootcamp. About This Book Make informed decisions using powerful visualizations in Tableau Learn effective data storytelling to transform how your business uses ideas Use this extensive bootcamp that makes you an efficient Tableau user in a short span of time Who This Book Is For This book caters to business, data, and analytics professionals who want to build rich interactive visualizations using Tableau Desktop. Familiarity with previous versions of Tableau will be helpful, but not necessary. What You Will Learn Complete practical Tableau tasks with each chapter Build different types of charts in Tableau with ease Extend data using calculated fields and parameters Prepare and refine data for analysis Create engaging and interactive dashboards Present data effectively using story points In Detail Tableau is a leading visual analytics software that can uncover insights for better and smarter decision-making. Tableau has an uncanny ability to beautify your data, compared to other BI tools, which makes it an ideal choice for performing fast and easy visual analysis. A military camp style fast-paced learning book that builds your understanding of Tableau 10 in no time. This day based learning guide contains the best elements from two of our published books, Learning Tableau 10 - Second Edition and Tableau 10 Business Intelligence Cookbook, and delivers practical, learning modules in manageable chunks. Each chunk is delivered in a "day", and each "day" is a productive day. Each day builds your competency in Tableau. You will increase your competence in integrating analytics and forecasting to enhance data analysis during the course of this Bootcamp. Each chapter presents core concepts and key takeaways about a topic in Tableau and provides a series of hands-on exercises. In addition to these exercises, at the end of the chapter, you will find self-check quizzes and extra drills to challenge you, to take what you learned to the next level. To summarize, this book will equip you with step-by-step instructions through rigorous tasks, practical callouts, and various real-world examples and assignments to reinforce your understanding of Tableau 10. Style and approach A fast paced book filled with highly-effective real-world examples to help you build new things and help you in solving problems in newer and unseen ways.
Release