Bring your data to life with Power BIKey FeaturesGet to grips with the fundamentals of Microsoft Power BI and its Business Intelligence capabilities
Build accurate analytical models, reports and dashboards
Get faster and more intuitive insights from your data using Microsoft Power BI
Book Description
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 implementedWhat you will learnConnect to data sources using both import and DirectQuery options
Use the Query Editor to apply data transformations and data cleansing processes, including learning how to write M and R scripts
Design optimized data models by designing relationships and DAX calculations
Leverage built-in and custom visuals to design effective reports
Use the Power BI Desktop and Power BI Service to implement Row Level Security on your model
Administer a Power BI cloud tenant for your organization
Deploy your Power BI Desktop files into the Power BI Report Server
Who this book is for
This book is for aspiring Business Intelligence professionals who want to get up and running with Microsoft Power BI. If you have a basic understanding of BI concepts and want to learn how to apply them using Microsoft Power BI, this book is for you.Table of ContentsGetting Started with Importing Data Options
Data Transformation Strategies
Building the Data Model
Leveraging DAX
Visualizing Data
Digital Storytelling with Power BI
Using a Cloud Deployment with the Power BI Service
On-Premises Solutions with Power BI Report Server

Devin Knight a Microsoft Data Platform MVP and the President at Pragmatic Works Training. At Pragmatic Works, Devin determines which courses are created, delivered, and updated for customers, including 15+ Power BI courses. This is the tenth SQL Server and Business Intelligence book that he has authored. Devin often speaks at conferences such as PASS Summit, PASS Business Analytics Conference, SQL Saturdays, and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is a contributor at the local Power BI User Group.