Book Overview & Buying
Table Of Contents

Learn Power BI

By : Greg Deckler

3.5 (8)

Buy this Book

Learn Power BI

3.5 (8)

By: Greg Deckler

Buy this Book

Overview of this book

To succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This Power BI book is an entry-level guide that will get you up and running with data modeling, visualization, and analytical techniques from scratch. You'll find this book handy if you want to get well-versed with the extensive Power BI ecosystem. You'll start by covering the basics of business intelligence and installing Power BI. You'll then learn the wide range of Power BI features to unlock business insights. As you progress, the book will take you through how to use Power Query to ingest, cleanse, and shape your data, and use Power BI DAX to create simple to complex calculations. You'll also be able to add a variety of interactive visualizations to your reports to bring your data to life. Finally, you'll gain hands-on experience in creating visually stunning reports that speak to business decision makers, and see how you can securely share these reports and collaborate with others. By the end of this book, you'll be ready to create simple, yet effective, BI reports and dashboards using the latest features of Power BI.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Section 1: The Basics

Introduction to Business Intelligence and Power BI

Key concepts of business intelligence

The Power BI ecosystem

Power BI licensing

Power BI Desktop and Service

Summary

Questions

Further reading

Section 2: The Desktop

Up and Running with Power BI Desktop

Technical requirements

Downloading and installing Power BI Desktop

Touring the Desktop

Generating data

Creating visualizations

Summary

Questions

Further reading

Connecting and Shaping Data

Technical requirements

Getting data

Transforming data

Merging, copying, and appending queries

Verifying and loading data

Summary

Questions

Further reading

Creating Data Models and Calculations

Technical requirements

Creating a data model

Creating calculations

Checking and troubleshooting calculations

Summary

Questions

Further reading

Unlocking Insights

Technical requirements

Segmenting data

Using report navigation features

Advanced visualization techniques

Summary

Questions

Further reading

Creating the Final Report

Technical requirements

Preparing the final report

Creating the final report pages

Finishing up

Summary

Questions

Further reading

Section 3: The Service

Publishing and Sharing

Technical requirements

Getting an account

Introducing the Service

Publishing and sharing

Summary

Questions

Further reading

Using Reports in the Service

Technical requirements

Viewing reports

Exporting reports

Embedding reports

Editing and creating reports

Summary

Questions

Further reading

Understanding Dashboards, Apps, and Security

Technical requirements

Understanding dashboards

Understanding apps

Understanding security and permissions

Summary

Questions

Further reading

Data Gateways and Refreshing Datasets

Technical requirements

Installing and using data gateways

Refreshing datasets

Summary

Questions

Further reading

Other Books You May Enjoy

Leave a review - let other readers know what you think

Technical requirements

You will need the following requirements in order to successfully complete the instructions in this chapter:

An internet connection.
Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2, Windows Server 2012, or Windows Server 2012 R2.
Microsoft Power BI Desktop.
Download LearnPowerBI.pbix and the Budget and Forecast.xlsx, People and Tasks.xlsx, and Hours.xlsx files from GitHub at https://github.com/gdeckler/LearnPowerBI/tree/master/Ch3.
If you have skipped any chapters, download LearnPowerBI_Ch3Start.zip from https://github.com/gdeckler/LearnPowerBI/tree/master/Ch3 and extract the LearnPowerBI_Ch3Start.pbix file.
By the end of this chapter, your Power BI file should look like the LearnPowerBI_Ch3End.pbix file contained within LearnPowerBI_Ch3End.zip, which can also be downloaded at https://github.com/gdeckler...