Muutke küpsiste eelistusi

E-raamat: Exam Ref 70-778 Analyzing and Visualizing Data with Microsoft Power BI

  • Formaat: 416 pages
  • Sari: Exam Ref
  • Ilmumisaeg: 07-Jun-2018
  • Kirjastus: Microsoft Press
  • Keel: eng
  • ISBN-13: 9780134857787
  • Formaat - PDF+DRM
  • Hind: 29,94 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
  • Formaat: 416 pages
  • Sari: Exam Ref
  • Ilmumisaeg: 07-Jun-2018
  • Kirjastus: Microsoft Press
  • Keel: eng
  • ISBN-13: 9780134857787

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI certification exam.

 

Exam Ref 70-778: Analyzing and Visualizing Data with Microsoft Power BI offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern IT professionals need to successfully analyze and visualize data with Power BI, including:

  • Consuming and transforming data with Power BI Desktop: connecting to data sources, performing transformations, and cleansing data
  • Modeling and visualizing data: creating and optimizing data models; creating calculated columns, tables, and measures; creating DAX queries; creating performance KPIs; establishing hierarchies; choosing, creating, and formatting visualizations; managing custom reporting, and more
  • Configuring, publishing, and securing dashboards in the Power BI Service; and configuring organizational content packs and apps

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro’s job role

For more information on Exam 70-778 and the MCSA: BI Reporting credential, visit microsoft.com/learning.

Acknowledgements xiii
Introduction xvii
Organization of this book xvii
Microsoft certifications xviii
Microsoft Virtual Academy xviii
Quick access to online references xviii
Errata, updates, & book support xix
Stay in touch xix
Important: How to use this book to study for the exam xxi
Chapter 1 Consuming and transforming data by using Power Bl Desktop
1(82)
Skill 1.1 Connect to data sources
1(30)
Connect to databases, files, and folders
2(2)
Data connectivity modes
4(1)
Importing data
5(1)
DirectQuery
5(1)
Implications of using DirectQuery
6(2)
When to use DirectQuery
8(1)
Live Connection
9(1)
Connecting to Microsoft SQL Server
10(2)
Connecting to Access database
12(1)
Connecting to an Oracle database
13(2)
Connecting to a MySQL database
15(1)
Connecting to PostgreSQL database
15(2)
Connecting to data using generic interfaces
17(1)
Connecting to Text/CSV files
17(1)
Connecting to JSON files
18(1)
Connecting to XML files
19(1)
Connecting to a Folder
20(2)
Connecting to a SharePoint folder
22(1)
Connecting to web pages and files
22(2)
Connecting to Azure Data Lake Store and Azure Blob Storage
24(1)
Import from Excel
25(1)
Import data from Excel
25(1)
Import Excel workbook contents
26(1)
Connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
27(1)
Connecting to Azure SQL Database and Azure SQL Data Warehouse
27(1)
Connecting to Azure HDInsight Spark
28(1)
Connecting to SQL Server Analysis Services (SSAS)
28(1)
Connecting to Power BI service
29(2)
Skill 1.2 Perform transformations
31(43)
Design and implement basic and advanced transformations
32(1)
Power Query overview
32(3)
Using the Power Query Editor interface
35(9)
Basic transformations
44(8)
Advanced transformations
52(3)
Appending queries
55(1)
Merging queries
56(4)
Creating new columns in tables
60(3)
Apply business rules
63(1)
Change data format to support visualization
64(10)
Skill 1.3 Cleanse data
74(9)
Manage incomplete data
74(1)
Meet data quality requirements
75(2)
Thought experiment
77(2)
Thought experiment answers
79(1)
Chapter summary
79(4)
Chapter 2 Modeling and visualizing data
83(188)
Skill 2.1 Create and optimize data models
83(24)
Manage relationships
84(11)
Optimize models for reporting
95(7)
Manually type in data
102(2)
Use Power Query
104(3)
Skill 2.2 Create calculated columns, calculated tables, and measures
107(99)
Create DAX formulas for calculated columns
107(27)
Calculated tables
134(39)
Measures
173(32)
Use What-if parameters
205(1)
Skill 2.3 Measure performance by using KPIs, gauges, and cards
206(11)
Calculate the actual
207(1)
Calculate the target
208(5)
Calculate actual to target
213(1)
Configure values for gauges
214(2)
Use the format settings to manually set values
216(1)
Skill 2.4 Create hierarchies
217(8)
Create date hierarchies
217(2)
Create hierarchies based on business needs
219(2)
Add columns to tables to support desired hierarchy
221(4)
Skill 2.5 Create and format interactive visualizations
225(30)
Select a visualization type
225(13)
Configure page layout and formatting
238(1)
Configure interactions between visuals
239(3)
Configure duplicate pages
242(1)
Handle categories that have no data
242(1)
Configure default summarization and data category of columns
242(3)
Position, align, and sort visuals
245(2)
Enable and integrate R visuals
247(2)
Format measures
249(1)
Use bookmarks and themes for reports
250(5)
Skill 2.6 Manage custom reporting solutions
255(16)
Configure and access Microsoft Power BI Embedded
256(1)
Enable developers to create and edit reports through custom applications
257(1)
Enable developers to embed reports in applications
257(2)
Use the Power BI API to push data into a Power BI dataset
259(2)
Enable developers to create custom visuals
261(1)
Thought experiment
262(4)
Thought experiment answers
266(1)
Chapter summary
267(4)
Chapter 3 Configure dashboards, reports, and apps in the Power BI Service
271(62)
Skill 3.1 Access on-premises data
271(8)
Connect to a data source by using a data gateway
272(5)
Publish reports to the Power BI service from Power BI Desktop
277(1)
Edit Power BI service reports by using Power BI Desktop
277(2)
Skill 3.2 Configure a dashboard
279(12)
Add text and images
279(3)
Filter dashboards
282(1)
Dashboard settings
283(1)
Customize the URL and title
283(1)
Enable natural language queries
284(7)
Skill 3.3 Publish and embed reports
291(11)
Publish to web
291(3)
Publish to Microsoft SharePoint
294(2)
Publish reports to a Power BI Report Server
296(6)
Skill 3.4 Configure security for dashboards, reports, and apps
302(18)
Create a security group by using the Admin Portal
302(3)
Configure access to dashboards and app workspaces
305(4)
Configure the export and sharing setting of the tenant
309(3)
Configure row-level security
312(8)
Skill 3.5 Configure apps and apps workspaces
320(8)
Create and configure an app workspace
321(1)
Publish an app
322(6)
Thought experiment
328(1)
Thought experiment answers
329(1)
Chapter summary
330(3)
Index 333
Daniil Maslyuk (MCSA: BI Reporting; MCSE: Data Management and Analytics) is a Microsoft business intelligence consultant who specializes in Power BI, Power Query, and Power Pivot; the DAX and M languages; and SQL Server and Azure Analysis Services tabular models. Daniil blogs at xxlbi.com and tweets as @DMaslyuk.