Learn Power BI : A Beginner’s Guide to Developing Interactive Business Intelligence Solutions Using Microsoft Power BI.

✍ Scribed by Deckler, Greg

• Publisher: Packt Publishing, Limited
• Year: 2019
• Tongue: English
• Leaves: 599
• Category: Library

✦ Synopsis

This book will help you bring business intelligence capabilities using Power BI in order to make smarter decisions. You will learn data modeling, visualizations, and analytical capabilities from scratch using hands-on examples. By the end of this book, you will learn the extensive features of Power BI and how to use them to unlock business ...

✦ Table of Contents

Cover
Title Page
Copyright and Credits
About Packt
Contributors
Table of Contents
Preface
Section 1: The Basics
Chapter 1: Introduction to Business Intelligence and Power BI
Key concepts of business intelligence
Domain
Data
Internal and external data
Structured, unstructured, and semi-structured data
Model
Organizing
Transforming and cleansing
Defining and categorizing
Analysis
Visualization
The Power BI ecosystem
Core, Power BI-specific
Core, non-Power BI-specific
Non-core, Power BI-specific
Natively integrated Microsoft technologies
The extended Power BI ecosystem Power BI licensingPower BI Free
Power BI Pro
Power BI Premium
Power BI Embedded
Power BI Report Server
Power BI Desktop and Service
Power BI Desktop
Getting data
Creating a data model
Analyzing data
Creating and publishing reports
Power BI Service
Viewing and editing reports
Creating dashboards
Sharing and collaborating with others
Accessing and creating apps
Refreshing data
Summary
Questions
Further reading
Section 2: The Desktop
Chapter 2: Up and Running with Power BI Desktop
Technical requirements
Downloading and installing Power BI Desktop Power BI Desktop (the trusted Microsoft Store app)Power BI Desktop (MSI)
Power BI Desktop (Report Server edition)
Running Power BI Desktop
Touring the Desktop
Title Bar and Quick Access Toolbar
The Ribbon
The Formula Bar
Understanding DAX
Views Bar
Panes
Canvas
Page tabs
Footer
Generating data
Creating a calculated table
Creating calculated columns
Formatting columns
Creating visualizations
Creating your first visualization
Formatting your visualization
Adding analytics to your visualization
Creating and using a slicer
Creating more visualizations Editing visual interactionsSummary
Questions
Further reading
Chapter 3: Connecting and Shaping Data
Technical requirements
Getting data
Creating your first query
Getting additional data
Transforming data
Touring the Power Query Editor
The Title Bar and Quick Access Toolbar
The Ribbon
Formula Bar
The Queries Pane
The Query Settings Pane
Data Canvas
Footer
Transforming budget and forecast data
Cleaning up extraneous bottom rows
Filtering rows
Unpivoting data
Using Fill
Changing data types
Transforming people, tasks, and January data
Transforming the People query Transforming the Tasks queryTransforming the January query
Merging, copying, and appending queries
Merging queries
Expanding tables
Disabling the loading of queries
Copying queries
Changing sources
Appending queries
Verifying and loading data
Organizing queries
Checking column quality, distribution, and profiles
Loading the data
Summary
Questions
Further reading
Chapter 4: Creating Data Models and Calculations
Technical requirements
Creating a data model
Touring the Model view
Title Bar and Quick Access Toolbar
Ribbon
Views Bar
Panes
Canvas
Layout Tabs
Footer