Muutke küpsiste eelistusi

E-raamat: Exam Ref PL-300 Power BI Data Analyst

  • Formaat: 224 pages
  • Sari: Exam Ref
  • Ilmumisaeg: 02-Aug-2022
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780137901159
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 30,41 €*
  • * 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: 224 pages
  • Sari: Exam Ref
  • Ilmumisaeg: 02-Aug-2022
  • Kirjastus: Addison Wesley
  • Keel: eng
  • ISBN-13: 9780137901159
Teised raamatud teemal:

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. 

Prepare for Microsoft Exam PL-300 and help demonstrate your real-world ability to deliver actionable insights with Power BI by leveraging available data and domain expertise; to provide meaningful business value through clear data visualizations; to enable others to perform self-service analytics, and to deploy and configure solutions for consumption. Designed for data analysts, business users, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Power BI Data Analyst Associate level.

 

Focus on the expertise measured by these objectives:

  • Prepare the data
  • Model the data
  • Visualize and analyze the data
  • Deploy and maintain assets

 

This Microsoft Exam Ref:

  • Organizes its coverage by exam objectives
  • Features strategic, what-if scenarios to challenge you
  • Assumes you are a data analyst, business intelligence professional, report creator, or other professional seeking to validate your skills and knowledge in analyzing data with Power BI

 

About the Exam

Exam PL-300 focuses on knowledge needed to get data from different data sources; clean, transform, and load data; design and develop data models; create model calculations with DAX; optimize model performance; create reports and dashboards; enhance reports for usability and storytelling; identify patterns and trends; and manage files, datasets, and workspaces.

 

About Microsoft Certification

Passing this exam fulfills your requirements for the Microsoft Certified: Power BI Data Analyst Associate certification, demonstrating your understanding of data repositories and data processes, and your skills in designing and building scalable data models, cleaning and transforming data, enabling advanced analytic capabilities to provide meaningful business value, and collaborating with key stakeholders to deliver relevant insights based on identified business requirements.

 

See full details at: microsoft.com/learn

Introduction xi
Organization of this book xi
Preparing for the exam xi
Microsoft certifications xii
Quick access to online references xii
Errata, updates, & book support xiii
Stay in touch xiii
Chapter 1 Prepare the data
1(52)
Skill 1.1 Get data from different data sources
1(1)
Identify and connect to a data source
2(4)
Change data source settings
6(1)
Select a shared dataset or create a local dataset
7(2)
Select a storage mode
9(3)
Use Microsoft Dataverse
12(1)
Change the value in a parameter
13(4)
Connect to a dataflow
17(1)
Skill 1.2 Clean, transform, and load the data
18(1)
Profile the data
19(4)
Resolve inconsistencies, unexpected or null values, and data quality issues
23(3)
Identify and create appropriate keys for joins
26(2)
Evaluate and transform column data types
28(2)
Shape and transform tables
30(11)
Combine queries
41(4)
Apply user-friendly naming conventions to columns and queries
45(1)
Configure data loading
46(1)
Resolve data import errors
47(1)
Chapter Summary
48(1)
Thought experiment
49(2)
Thought experiment answers
51(2)
Chapter 2 Model the data
53(58)
Skill 2.1 Design a data model
53(1)
Define the tables and design a data model that uses a star schema
54(2)
Configure table and column properties
56(2)
Design and implement role-playing dimensions
58(3)
Define a relationship's cardinality and cross-filter direction
61(5)
Create a common date table
66(2)
Skill 2.2 Develop a data model
68(1)
Create calculated tables
68(2)
Create hierarchies
70(1)
Create calculated columns
71(2)
Implement row-level security roles
73(6)
Use the Q&A feature
79(4)
Skill 2.3 Create model calculations by using DAX
83(1)
Create basic measures by using DAX
83(3)
Use CALCULATE to manipulate filters
86(5)
Implement Time Intelligence using DAX
91(2)
Replace implicit measures with explicit measures
93(1)
Use basic statistical functions
94(1)
Create semi-additive measures
95(2)
Use quick measures
97(3)
Skill 2.4 Optimize model performance
100(1)
Remove unnecessary rows and columns
100(1)
Identify poorly performing measures, relationships, and visuals
101(1)
Reduce cardinality levels to improve performance
102(2)
Chapter Summary
104(1)
Thought experiment
105(3)
Thought experiment answers
108(3)
Chapter 3 Visualize and analyze the data
111(66)
Skill 3.1 Create reports
111(1)
Add visualization items to reports
112(1)
Choose an appropriate visualization type
113(11)
Format and configure visualizations
124(1)
Use a custom visual
125(1)
Apply and customize a theme
126(2)
Configure conditional formatting
128(2)
Apply slicing and filtering
130(3)
Configure the report page
133(1)
Use the Analyze in Excel feature
134(1)
Choose when to use a paginated report
135(1)
Skill 3.2 Create dashboards
135(1)
Manage tiles on a dashboard
136(2)
Configure mobile view
138(1)
Use the Q&A feature
139(1)
Add a Quick Insights result to a dashboard
140(2)
Add a dashboard theme
142(1)
Pin a live report page to a dashboard
143(1)
Skill 3.3 Enhance reports for usability and storytelling
144(1)
Configure bookmarks
144(3)
Create custom tooltips
147(2)
Edit and configure interactions between visuals
149(1)
Configure navigation for a report
150(1)
Apply sorting
151(1)
Configure sync slicers
152(2)
Group and layer visuals by using the Selection pane
154(1)
Drill down into data using interactive visuals
155(1)
Export report data
156(1)
Design reports for mobile devices
156(1)
Skill 3.4 Identify patterns and trends
157(1)
Use the Analyze feature in Power BI
158(1)
Identify outliers
159(1)
Choose between continuous and categorical axes
160(1)
Use groupings, binnings, and clustering
161(3)
Use Al visuals
164(4)
Use the Forecast feature
168(1)
Create reference lines by using the Analytics pane
168(2)
Chapter Summary
170(2)
Thought experiment
172(2)
Thought experiment answers
174(3)
Chapter 4 Deploy and maintain assets
177(26)
Skill 4.1 Manage files and datasets
177(1)
Identify when a gateway is required
178(1)
Configure a dataset scheduled refresh
178(2)
Configure row-level security group membership
180(2)
Provide access to datasets
182(3)
Manage global options for files
185(1)
Skill 4.2 Manage workspaces
186(1)
Create and configure a workspace
186(2)
Assign workspace roles
188(1)
Configure and update a workspace app
189(4)
Publish, import, or update assets in a workspace
193(2)
Apply sensitivity labels to workspace content
195(1)
Configure subscriptions and data alerts
196(2)
Promote or certify Power Bl content
198(1)
Chapter Summary
199(1)
Thought experiment
200(1)
Thought experiment answers
201
Index 203