Bring your data to life with Power BI
Key Features
- Get 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 implemented
What you will learn
- Connect 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 Contents
- Getting 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.
Brian Knight is the owner and founder of Pragmatic Works, and is a serial entrepreneur, starting up other companies. Brian is a contributing columnist at several technical magazines. He is the author of 16 technical books. Brian has spoken at conferences like PASS Summit, SQL Connections, TechEd, SQLSaturdays, and Code Camps. He has received a number of awards from the State of Florida, governor, and press, including the Business Ambassador Award (Governor) and Top CEO (Jacksonville Magazine). His blog can be found at Pragmatic Works website.
Mitchell Pearson has worked as a Data Platform Consultant and Trainer for the last 8 years. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure. Mitchell is very active in the community: Running the local Power BI User Group, presenting at user groups locally and virtually, and creating YouTube videos for MitchellSQL
