Book Image

Learn Power BI

By : Gregory Deckler
Book Image

Learn Power BI

By: Gregory 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.

Related Content you might be interested in

Current Title:

Small book image
Learn Power BI
Gregory Deckler
Sep, 2019 | 362 pages
Small book image
Microsoft Power BI Cookbook.
Brett Powell | Greg Deckler
Sep, 2021 | 656 pages
Small book image
Microsoft Power BI Quick Start Guide
Mitchell Pearson | Bradley Schacht | Devin Knight | Erin Ostrowsky
Nov, 2022 | 330 pages
Small book image
Mastering Microsoft Power BI
Brett Powell | Greg Deckler
Jun, 2022 | 712 pages
Table of Contents (16 chapters)
Title Page
Title Page
Copyright and Credits
Copyright and Credits
Learn Power BI
About Packt
About Packt
Why subscribe?
Contributors
Contributors
About the author
About the reviewers
Packt is searching for authors like you
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
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
2
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
3
Connecting and Shaping Data
Connecting and Shaping Data
Technical requirements
Getting data
Transforming data
Merging, copying, and appending queries
Verifying and loading data
Summary
Questions
Further reading
4
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
5
Unlocking Insights
Unlocking Insights
Technical requirements
Segmenting data
Using report navigation features
Advanced visualization techniques
Summary
Questions
Further reading
6
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
7
Publishing and Sharing
Publishing and Sharing
Technical requirements
Getting an account
Introducing the Service
Publishing and sharing
Summary
Questions
Further reading
8
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
9
Understanding Dashboards, Apps, and Security
Understanding Dashboards, Apps, and Security
Technical requirements
Understanding dashboards
Understanding apps
Understanding security and permissions
Summary
Questions
Further reading
10
Data Gateways and Refreshing Datasets
Data Gateways and Refreshing Datasets
Technical requirements
Installing and using data gateways
Refreshing datasets
Summary
Questions
Further reading
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

About the author

Greg Deckler is Vice President of Cloud Services at Fusion Alliance and has been a technology systems consultant for over 25 years. Internationally recognized as an expert in Power BI, Greg Deckler is a Microsoft MVP for Data Platform and an active member of the Power BI community, with over 100,000 messages read, more than 11,000 replies, over 2,200 answers, and more than 75 entries in the Quick Measures Gallery. Greg founded the Columbus Azure ML and Power BI User Group (CAMLPUG) and presents at numerous conferences and events, including SQL Saturday, DogFood, and Dynamic Communities' User Group/Power Platform Summit.

I would like to thank the dynamic and vibrant Power BI community as a whole, and especially Charles Sterling, for their dedication and support. Also, shout-outs to the following Power BI Community members: @ImkeF, @konstantinos, @parry2k, @Seth_C_Bauer, @Phil_Seamark, @GilbertQ, @Vvelarde, @MattAllington @marcorusso, and @Mike_Carlo.
Previous Section
Next Section