Now that you should be more comfortable working within the Power Query Editor, let's take the next step in working with it. Often, you will find the need to go beyond these basic transforms when dealing with data that requires more care. In this section, you will learn about some of the more common advanced transforms that you may have a need for, which include Conditional Columns, Fill down, Unpivot, Merge Queries, and Append Queries.
-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Microsoft Power BI Quick Start Guide
By :

Microsoft Power BI Quick Start Guide
By:
Overview of this book
Microsoft Power BI is a cloud-based service that helps you easily visualize and share insights using your organization's data.This book will get you started with business intelligence using the Power BI toolset, covering essential concepts such as installation,designing effective data models, as well as building basic dashboards and visualizations to make your data come to life
You will learn how to get your data the way you want – connecting to data sources sources and how to clean your data with the Power BI Query Editor. You will next learn how to properly design your data model to make your data easier to work with.. You will next learn how to properly design your data model to navigate table relationships and build DAX formulas to make your data easier to work with.
Visualizing your data is another key element of this book, and you will learn how to follow proper data visualization styles and enhanced digital storytelling techniques.
By the end of this book, you will understand how to administer your organization's Power BI environment so deployment can be made seamless, data refreshes can run properly, and security can be fully implemented
Table of Contents (10 chapters)
Preface
Getting Started with Importing Data Options
Data Transformation Strategies
Building the Data Model
Visualizing Data
Digital Storytelling with Power BI
Using a Cloud Deployment with the Power BI Service
On-Premises Solutions with Power BI Report Server
Other Books You May Enjoy
Customer Reviews