Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Suraj Gaurav, Suren Machiraju
Power BI Data Analysis and Visualization
Cover
Title Page
Copyright
Dedication
Contents
Chapter 1: Introducing Data Visualization
Overview of Technology
Importance of Data Visualization
Data Visualization Tools
Understanding Power BI
Comparing Microsoft Power BI and Tableau
Key Features of Power BI
Sign Up for Free
Receive Data from Multiple Data Sources
Obtain Key Metrics of Your Business
Quick Insights
Data-Driven Decision Making from Anywhere
Advanced Features of Power BI
Embed Power BI Reports and Dashboards into a Web App
Real-Time Streaming
Support for Natural Language Query
Share Content Pack
Integration with Cortana
Variants of Power BI
Power BI Desktop
Power BI Service
Publishing a Report
Summary
Chapter 2: Power BI Azure Application
Embedding Power BI Reports into a Web App
Real-Time Streaming
Exploring Real-Time Streaming Datasets
Different Ways of Pushing Data
Viewing Real-Time Streaming of Data
Quick Insights
Summary
Chapter 3: Power BI on Microsoft Stack
Getting Data into Power BI from SQL Server
Using the Import Option
Using the DirectQuery Option
Data Modeling
Creating Relationships Among Tables
Using Data Analysis Expressions
Using Calculated Columns
Using Calculated Tables
Creating a Report
Creating a Report Using the DirectQuery Option
Creating a Report Using the Import Option
Saving the Report
Publishing the Report
Gateway Setup
Understanding Gateways
Types of Gateways
Downloading and Installing the On-Premises Data Gateway
Configuring Gateway
Adding a Data Source
Natural Language Querying
Data Refresh in Power BI
Configuring Scheduled Refresh
Creating Content Packs
Power BI Integration with Cortana Suite
Creating a Cortana Answer Page and Publishing It
Enabling Cortana to Access the Dataset
Adding Power BI Credentials to Windows 10
Accessing the Report through Cortana
Summary
Chapter 4: Power BI on Open Source Stack
Integrating PostgreSQL with Power BI
Downloading and Installing Npgsql Connector
Getting Data into Power BI
Data Modeling
Creating Relationship between Tables
Data Analysis Expressions
Creating a Calculated Column
Creating a Report
Saving the Report
Publishing the Report
Data Refresh in Power BI
Setting Up Scheduled Refresh
Creating Content Packs
Summary
Chapter 5: Power BI on ERP Applications
Defining CRM
Functions of a CRM Solution
Microsoft Dynamics CRM
Benefits of Microsoft Dynamics CRM
Sign Up for Microsoft Dynamics CRM Online
Creating Sample Data for Dynamics CRM
Getting Data into Power BI
Creating Reports
Leads Revenue by Employee
Leads Revenue by Company
Loans by Category
Loans Summary
Deep Linking in Power BI
Adding a New User
Row-Level Security in Power BI
Defining Roles and Rules
Validating the Role within Power BI Desktop
Deploying the Report
Managing Security
Working with Members
Validating the Role within Power BI Service
Sharing the Report
Summary
Chapter 6: Conclusion
Introducing Data Visualization
Power BI Azure Application
Power BI on Microsoft Stack
Power BI on Open Source Stack
Power BI on ERP Applications
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Halftitle Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset