Muutke küpsiste eelistusi

Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel [Pehme köide]

  • Formaat: Paperback / softback, 272 pages, kõrgus x laius x paksus: 230x190x10 mm, kaal: 451 g
  • Sari: Exam Ref
  • Ilmumisaeg: 11-Sep-2018
  • Kirjastus: Microsoft Press
  • ISBN-10: 1509308040
  • ISBN-13: 9781509308040
  • Pehme köide
  • Hind: 50,49 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
  • Formaat: Paperback / softback, 272 pages, kõrgus x laius x paksus: 230x190x10 mm, kaal: 451 g
  • Sari: Exam Ref
  • Ilmumisaeg: 11-Sep-2018
  • Kirjastus: Microsoft Press
  • ISBN-10: 1509308040
  • ISBN-13: 9781509308040

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-779 Analyzing and Visualizing Data by Using Microsoft Excel certification exam.

 

Exam Ref 70-779 Analyzing and Visualizing Data by Using Microsoft Excel 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 consume, transform, model, and visualize data with Excel 2016. Coverage includes:

  • Importing data from external data sources
  • Working with Power Query
  • Designing and implementing transformations
  • Applying business rules
  • Cleansing data
  • Creating performance KPIs
  • And much more

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-779 and the MCSA: BI Reporting credential, visit microsoft.com/learning.

Acknowledgements xi
Introduction xv
Organization of this book xv
Microsoft certifications xvi
Microsoft Virtual Academy xvi
Quick access to online references xvi
Errata, updates, & book support xvii
Stay in touch xvii
Important: How to use this book to study for the exam xix
Chapter 1 Consume and transform data by using Microsoft Excel
1(86)
Skill 1.1 Import from data sources
2(30)
Connect to and import from databases, files, and folders
2(22)
Connect to Microsoft SQL Azure and Big Data
24(3)
Import from Excel workbooks
27(1)
Link to data from other sources
27(3)
Privacy Levels
30(2)
Skill 1.2 Perform data transformations
32(47)
Design and implement basic and advanced transformations
32(39)
Apply business rules
71(2)
Change data format to support visualization
73(1)
Filter data
74(5)
Format data
79(1)
Skill 1.3 Cleanse data
79(8)
Manage incomplete data
80(1)
Handle data received as a report
81(2)
Thought experiment
83(2)
Thought experiment answers
85(1)
Chapter summary
85(2)
Chapter 2 Model data
87(84)
Skill 2.1 Create and optimize data models
87(29)
Understanding the Excel data model
88(3)
Get & Transform
91(6)
Manually enter data
97(2)
Manage data relationships
99(9)
Optimize models for reporting
108(8)
Skill 2.2 Create calculated columns, measures, and tables
116(36)
Create DAX formulas
116(25)
Create DAX queries
141(8)
Create Excel formulas
149(3)
Skill 2.3 Create Hierarchies
152(8)
Create date hierarchies
153(3)
Create business hierarchies
156(2)
Resolve hierarchy issues
158(2)
Skill 2.4 Create Performance KPIs
160(11)
Calculate the actual value
160(1)
Calculate the target value
161(1)
Calculate actual-to-target values
162(1)
Thought experiments
163(3)
Thought experiment answers
166(1)
Chapter summary
167(4)
Chapter 3 Visualize data
171(68)
Skill 3.1 Create and manage PivotTables
171(27)
Format PivotTables
172(20)
Format calculated measures
192(1)
Filter data
193(5)
Group and summarize data
198(1)
Skill 3.2 Create and manage PivotCharts
198(23)
Select a chart type
199(18)
Format PivotCharts
217(3)
Filter data
220(1)
Skill 3.3 Interact with Power BI
221(18)
Power BI overview
222(2)
Import Excel data from Power BI
224(8)
Manipulate Excel data in Power BI
232(1)
Thought experiment
232(2)
Thought experiment answers
234(1)
Chapter summary
234(5)
Index 239
Chris Sorensen, MCSE (Data Management and Analytics) and MCT, is the Founder and President of Iteration Insights Ltd. He is a consultant, architect, educator, and coach who has been working in the Analytics space for nearly 20 years. Over his career, he has provided strategic and architectural advisory services to many clients and most recently he has been involved with leading numerous Power BI and Excel PowerPivot projects. He has evangelized both Excel and Power BI with Microsoft since July 2015. Follow him on both Linkedin and Twitter as @wjdataguy.