Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Learn Power BI
  • Toc
  • feedback
Learn Power BI

Learn Power BI

By : Greg Deckler
3.5 (8)
close
Learn Power BI

Learn Power BI

3.5 (8)
By: Greg Deckler

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.
Table of Contents (15 chapters)
close
close
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
Free Chapter
1
Section 1: The Basics
Section 1: The Basics
2
Introduction to Business Intelligence and Power BI
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
3
Section 2: The Desktop
Section 2: The Desktop
4
Up and Running with Power BI 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
5
Connecting and Shaping Data
chevron up
Connecting and Shaping Data
Technical requirements
Getting data
Transforming data
Merging, copying, and appending queries
Verifying and loading data
Summary
Questions
Further reading
6
Creating Data Models and Calculations
Creating Data Models and Calculations
Technical requirements
Creating a data model
Creating calculations
Checking and troubleshooting calculations
Summary
Questions
Further reading
7
Unlocking Insights
Unlocking Insights
Technical requirements
Segmenting data
Using report navigation features
Advanced visualization techniques
Summary
Questions
Further reading
8
Creating the Final Report
Creating the Final Report
Technical requirements
Preparing the final report
Creating the final report pages
Finishing up
Summary
Questions
Further reading
9
Section 3: The Service
Section 3: The Service
10
Publishing and Sharing
Publishing and Sharing
Technical requirements
Getting an account
Introducing the Service
Publishing and sharing
Summary
Questions
Further reading
11
Using Reports in the Service
Using Reports in the Service
Technical requirements
Viewing reports
Exporting reports
Embedding reports
Editing and creating reports
Summary
Questions
Further reading
12
Understanding Dashboards, Apps, and Security
Understanding Dashboards, Apps, and Security
Technical requirements
Understanding dashboards
Understanding apps
Understanding security and permissions
Summary
Questions
Further reading
13
Data Gateways and Refreshing Datasets
Data Gateways and Refreshing Datasets
Technical requirements
Installing and using data gateways
Refreshing datasets
Summary
Questions
Further reading
14
Other Books You May Enjoy
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...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 2
Next Section
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete