Muutke küpsiste eelistusi

Power BI Data Analysis and Visualization [Pehme köide]

2.67/5 (3 hinnangut Goodreads-ist)
,
  • Formaat: Paperback / softback, 287 pages, kõrgus x laius: 230x155 mm, kaal: 476 g, 20 Tables, black and white; 100 Illustrations, black and white
  • Ilmumisaeg: 10-Sep-2018
  • Kirjastus: De|G Press
  • ISBN-10: 1547416785
  • ISBN-13: 9781547416783
Teised raamatud teemal:
Power BI Data Analysis and VisualizationSuurem pilt
  • Formaat: Paperback / softback, 287 pages, kõrgus x laius: 230x155 mm, kaal: 476 g, 20 Tables, black and white; 100 Illustrations, black and white
  • Ilmumisaeg: 10-Sep-2018
  • Kirjastus: De|G Press
  • ISBN-10: 1547416785
  • ISBN-13: 9781547416783
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781547416783.html
Märksõnad:

Power BI Data Analysis and Visualization provides a roadmap to vendor choices and highlights why Microsoft’s Power BI is a very viable, cost effective option for data visualization. The book covers the fundamentals and most commonly used features of Power BI, but also includes an in-depth discussion of advanced Power BI features such as natural language queries; embedding Power BI dashboards; and live streaming data. It discusses real solutions to extract data from the ERP application, Microsoft Dynamics CRM, and also offers ways to host the Power BI Dashboard as an Azure application, extracting data from popular data sources like Microsoft SQL Server and open-source PostgreSQL.

Authored by Microsoft experts, this book uses real-world coding samples and screenshots to spotlight how to create reports, embed them in a webpage, view them across multiple platforms, and more. Business owners, IT professionals, data scientists, and analysts will benefit from this thorough presentation of Power BI and its functions.

Chapter 1 Introducing Data Visualization
1(42)
Overview of Technology
1(1)
Importance of Data Visualization
1(1)
Data Visualization Tools
2(1)
Understanding Power BI
2(1)
Comparing Microsoft Power BI and Tableau
3(1)
Key Features of Power BI
4(2)
Sign Up for Free
5(1)
Receive Data from Multiple Data Sources
5(1)
Obtain Key Metrics of Your Business
5(1)
Quick Insights
5(1)
Data-Driven Decision Making from Anywhere
6(1)
Advanced Features of Power BI
6(1)
Embed Power BI Reports and Dashboards into a Web App
6(1)
Real-Time Streaming
6(1)
Support for Natural Language Query
6(1)
Share Content Pack
7(1)
Integration with Cortana
7(1)
Variants of Power BI
7(31)
Power BI Desktop
7(23)
Power BI Service
30(8)
Publishing a Report
38(3)
Summary
41(2)
Chapter 2 Power BI Azure Application
43(22)
Embedding Power BI Reports into a Web App
43(4)
Real-Time Streaming
47(17)
Exploring Real-Time Streaming Datasets
47(1)
Different Ways of Pushing Data
48(1)
Viewing Real-Time Streaming of Data
48(10)
Quick Insights
58(6)
Summary
64(1)
Chapter 3 Power BI on Microsoft Stack
65(86)
Getting Data into Power BI from SQLServer
65(9)
Using the Import Option
65(4)
Using the DirectQuery Option
69(5)
Data Modeling
74(14)
Creating Relationships Among Tables
74(8)
Using Data Analysis Expressions
82(2)
Using Calculated Columns
84(2)
Using Calculated Tables
86(2)
Creating a Report
88(12)
Creating a Report Using the DirectQuery Option
89(6)
Creating a Report Using the Import Option
95(1)
Saving the Report
96(2)
Publishing the Report
98(2)
Gateway Setup
100(16)
Understanding Gateways
100(1)
Types of Gateways
100(1)
Downloading and Installing the On-Premises Data Gateway
101(6)
Configuring Gateway
107(3)
Adding a Data Source
110(6)
Natural Language Querying
116(7)
Data Refresh in Power BI
123(6)
Configuring Scheduled Refresh
124(5)
Creating Content Packs
129(4)
Power BI Integration with Cortana Suite
133(16)
Creating a Cortana Answer Page and Publishing It
133(3)
Enabling Cortana to Access the Dataset
136(4)
Adding Power BI Credentials to Windows 10
140(4)
Accessing the Report through Cortana
144(5)
Summary
149(2)
Chapter 4 Power BI on Open Source Stack
151(60)
Integrating PostgreSQL with Power BI
151(1)
Downloading and Installing Npgsql Connector
151(4)
Getting Data into Power BI
155(3)
Data Modeling
158(7)
Creating Relationship between Tables
159(3)
Data Analysis Expressions
162(1)
Creating a Calculated Column
163(2)
Creating a Report
165(21)
Saving the Report
185(1)
Publishing the Report
186(2)
Data Refresh in Power BI
188(16)
Setting Up Scheduled Refresh
189(15)
Creating Content Packs
204(6)
Summary
210(1)
Chapter 5 Power BI on ERP Applications
211(40)
Defining CRM
211(1)
Functions of a CRM Solution
211(1)
Microsoft Dynamics CRM
212(1)
Benefits of Microsoft Dynamics CRM
212(1)
Sign Up for Microsoft Dynamics CRM Online
213(4)
Creating Sample Data for Dynamics CRM
217(2)
Getting Data into Power BI
219(3)
Creating Reports
222(11)
Leads Revenue by Employee
222(6)
Leads Revenue by Company
228(2)
Loans by Category
230(1)
Loans Summary
231(2)
Deep Linking in Power BI
233(1)
Adding a New User
233(4)
Row-Level Security in Power BI
237(10)
Defining Roles and Rules
238(2)
Validating the Role within Power BI Desktop
240(2)
Deploying the Report
242(1)
Managing Security
242(2)
Working with Members
244(2)
Validating the Role within Power BI Service
246(1)
Sharing the Report
247(2)
Summary
249(2)
Chapter 6 Conclusion
251(4)
Introducing Data Visualization
251(1)
Power BI Azure Application
252(1)
Power BI on Microsoft Stack
252(1)
Power BI on Open Source Stack
253(1)
Power BI on ERP Applications
254(1)
Index 255
Suren Machiraju is Technical Business Partner with the Bill & Melinda Gates Foundation where he provides technology guidance and designs software solutions to help partners achieve organization objectives. Previously he was Engineering Manager, Azure Services at Microsoft; the founding member/manager of the Azure Customer Advisory Team; and Group Program Manager of the Connected Systems, Windows Server Customer Advisory Team. He is an innovator with over 20 patents relating to Electronic Document Interchange and Transport Protocols.

Suraj Gaurav is a cloud technologist and previously worked at Microsoft as Principal Engineering Manager where he led a team of talented engineers who built and ran the Exchange datacenter services. Prior to that, he worked on the Commerce Platform where he designed the first consumption based billing model for Microsoft which was used by Azure for its commercial launch in February 2010. Suraj specializes in cloud services, commerce transactions, B2B messaging, EDI, and healthcare protocols.