This Power BI MVP book is not like a normal book used to learn Power BI. This book is a selection of articles from 21 Power BI MVPs. Each chapter focuses on a particular subject. Topics covered include: AI, architecture, data modeling, data preparation, DAX, enterprise issues and Integration. The book is organized such that, as a reader, you may pick and choose any chapter in any order.This book is written by 21 Power BI MVPs from all around the world.

Power BI MVP Book: A book of tricks and techniques for working with Power BI

Computers & Technology

Allington, Matt

Rad, Reza

Maharjan, Anil

Bandari, Indira

Bastick, Liam

Puls, Ken

Gil, Jesús

LeBlanc, Thomas

Ellis, Ike

Etaati, Leila

Databases & Big Data

Independently published

Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization. Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing and securing Power BI content so that only intended recipients can see it. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analysis, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models. The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization, ensuring that you do not spend your time maintaining your solution but on using it for its intended purpose and gaining business value from mining and analyzing your organization’s data. What You'll Learn
<ul>
<li>Architect and administer enterprise-level Power BI solutions 
</li>
<li>Choose the right sharing method for your Power BI solution 
</li>
<li>Create and manage environments for development, testing, and production 
</li>
<li>Implement row level security in multiple ways to secure your data 
</li>
<li>Save money by choosing the right licensing plan 
</li>
<li>Select a suitable connection type―Live Connection, DirectQuery, or Scheduled Refresh―for your use case 
</li>
<li>Set up a Power BI gateway to bridge between on-premises data sources and the Power BI cloud service 
</li>
</ul>
Who This Book Is For Data analysts, developers, architects, and managers who want to leverage Power BI for their reporting solution

Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions

Programming

Apress

This book provides detailed guidance around architecting and deploying Power BI reporting solutions, including help and best practices for sharing and security. You’ll find chapters on dataflows, shared datasets, composite model and DirectQuery connections to Power BI datasets, deployment pipelines, XMLA endpoints, and many other important features related to the overall Power BI architecture that are new since the first edition. 
You will gain an understanding of what functionality each of the Power BI components provide (such as Dataflow, Shared Dataset, Datamart, thin reports, and paginated reports), so that you can make an informed decision about what components to use in your solution. You will get to know the pros and cons of each component, and how they all work together within the larger Power BI architecture. 
Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analyses, methods of sharing analyses that don’t cover all the requirements of your business or organization, and inconsistent security models. Detailed examples help you to understand and choose from among the different methods available for sharing and securing Power BI content so that only intended recipients can see it. 
The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization. It will also help ensure that you do not spend your time maintaining your solution, but on using it for its intended purpose: gaining business value from mining and analyzing your organization’s data.\nWhat You Will Learn 
Architect Power BI solutions that are reliable and easy to maintain Create development templates and structures in support of reusability Set up and configure the Power BI gateway as a bridge between on-premises data sources and the Power BI cloud service Select a suitable connection type―Live Connection, DirectQuery, Scheduled Refresh, or Composite Model―for your use case Choose the right sharing method for how you are using Power BI in your organization Create and manage environments for development, testing, and production Secure your data using row-level and object-level security Save money by choosing the right licensing plan\nWho This Book Is For Data analysts and developers who are building reporting solutions around Power BI, as well as architects and managers who are responsible for the big picture of how Power BI meshes with an organization’s other systems, including database and data warehouse systems.

Pro Power BI Architecture: Development, Deployment, Sharing, and Security for Microsoft Power BI Solutions

Take advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools. This book starts with designing a data warehouse with dimensional modeling, and then looks at creating data models based on SSAS multidimensional and Tabular technologies. It will illustrate how to use SSIS for ETL, and MDS and DQS for data governance and data quality. The book is packed with real-world examples that will give you a good understanding of the BI and DW components of SQL Server 2014, Excel 2013, and SharePoint 2013.

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

CreateSpace Independent Publishing Platform

I have been writing and presenting about Row-Level Security in Power BI for many years. Through the comments and feedback I got from my presentations and articles, I felt a need for a place to have everything gathered in one place. The lack of a book that explains everything about the current subject motivated me to end up gathering all my articles in this book. The result is what you are reading.Row-Level Security in Power BI is not about sharing your content. It is, on the other hand, about sharing the same content with a different audience in the way that they see different views of the data. They will have different access to the data. Some of them might see the entire data, and some others might see part of the data that they are authorized to see.Instead of creating multiple reports with the same format, fields, calculations, and visualizations, and only making them different in filtering, the correct way to do it is through row-level security. This will make sure you have the maximum consistency and minimum maintenance for your Power BI project.This is not a book about theories. This is a hands-on book. There are tons of demos and examples with the code samples that you can try. You will learn through this book, what is row-level security. You will learn different types of security and patterns in which you will see the most common challenges for implementing the security and the solution to save them.The book starts with the basics of row-level security, then you will learn about static vs. dynamic row-level security. You will learn patterns such as everyone see their own data, but the manager sees a different view or users and profiles for branch managers. Or the organizational hierarchy, or even the many-to-many relationship challenge of row-level security etc. through this book.This book is not about how to create a report, build a visualization, connect to a dataset, or set up a gateway. If you want to learn those, I do recommend reading my other book: Power BI online book, from Rookie to Rock Star.

Row-Level Security in Power BI: The complete guide of creating different views of the data for the same Power BI report

Over 80 expert recipes to design, create, and deploy SSIS packages <ul>
<li>Full of illustrations, diagrams, and tips with clear step-by-step instructions and real time examples</li> <li>Master all transformations in SSIS and their usages with real-world scenarios</li> <li>Learn to make SSIS packages re-startable and robust; and work with transactions</li> <li>Get hold of data cleansing and fuzzy operations in SSIS</li> </ul>
In Detail SQL Server Integration Services (SSIS) is a leading tool in the data warehouse industry - used for performing extraction, transformation, and load operations. This book is aligned with the most common methodology associated with SSIS known as Extract Transform and Load (ETL); ETL is responsible for the extraction of data from several sources, their cleansing, customization, and loading into a central repository normally called Data Warehouse or Data Mart. Microsoft SQL Server 2012 Integration Services: An Expert Cookbook covers all the aspects of SSIS 2012 with lots of real-world scenarios to help readers understand usages of SSIS in every environment. Written by two SQL Server MVPs who have in-depth knowledge of SSIS having worked with it for many years. This book starts by creating simple data transfer packages with wizards and illustrates how to create more complex data transfer packages, troubleshoot packages, make robust SSIS packages, and how to boost the performance of data consolidation with SSIS. It then covers data flow transformations and advanced transformations for data cleansing, fuzzy and term extraction in detail. The book then dives deep into making a dynamic package with the help of expressions and variables, and performance tuning and consideration. What you will learn from this book <ul>
<li>Step-by-step instructions to create Data Flow; and working with different sources and destinations </li> <li>Focus on some best practices for raising the performance of packages and data flow</li> <li>Understand Containers and Loop structures in SSIS</li> <li>Explore all the aspects of event handlers in SSIS</li> <li>Gain knowledge to debug, troubleshoot, and migrate packages</li> <li>Master the different ways to deploy and execute packages</li> </ul>
Approach This book is written in a simple, easy to understand format with lots of screenshots and step-by-step explanations. Who this book is written for If you are an SQL database administrator or developer looking to explore all the aspects of SSIS and need to use SSIS in the data transfer parts of systems, then this is the best guide for you. Basic understanding of working with SQL Server Integration Services is required.

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook

Perfeito, Pedro

Packt Pub Ltd

Get to grips with Microsoft Business Intelligence and data warehousing technologies using this practi cal guideAbout This Book<ul>
<li>Discover the Dimensional Modeling concept while designing a data warehouse</li> <li>Learn Data Movement based on technologies such as SSIS, MDS, and DQS</li> <li>Design dashboards and reports with Microsoft BI technologies</li> </ul>Who This Book Is ForIf you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It's assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.What You Will Learn<ul>
<li>Perform Data Modeling with SSAS Multidimensional and MDX</li> <li>Use DAX and SSAS tabular for Data Modeling</li> <li>Manage Master Data with MDS</li> <li>Reveal Knowledge Driven Data Quality with DQS</li> <li>Understand prediction and Data Mining</li> <li>Identify data patterns and predictive models</li> <li>Design Dashboards with PerformancePoint and Power View</li> <li>Explore Power Query and Power Map as components of Power BI</li> <li>Create Reports with SQL Server Reporting Services and integrate them in applications</li> </ul>In DetailTake advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools.
This book starts with designing a data warehouse with dimensional modeling, and then looks at creating data models based on SSAS multidimensional and Tabular technologies. It will illustrate how to use SSIS for ETL, and MDS and DQS for data governance and data quality. The book is packed with real-world examples that will give you a good understanding of the BI and DW components of SQL Server 2014, Excel 2013, and SharePoint 2013.

Microsoft SQL Server 2014: Business Intelligence Development Beginner's Guide

Mastering Power Query in Power BI and Excel: Learning real-world Power Query and M Techniques for a better data analysis

Etaati, Dr Leila

Software

Power BI DAX Simplified: DAX and calculation language of Power BI demystified by practical examples

See the best price to sell, buy, or rent books by Rad, Reza. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Rad, Reza