Username: Password:
 Home |  | Exam Engines | Study Packs | Labs |  | Sample | FAQ | Guarantee | Support | Order
Go
  Total (3799)
  3Com (14)
  AccessData (2)
  ACE (1)
  ACI (9)
  Acme Packet (1)
  ACSM (8)
  Adobe (129)
  AIIM (2)
  Alcatel Lucent (17)
  Altiris Exams (4)
  American College (1)
  APC (4)
  Apple (63)
  Arm (4)
  Aruba (2)
  ASQ (4)
  ASTQB (2)
  AUTODESK (2)
  Automotive (0)
  Avaya (58)
  Axis (2)
  Banking (2)
  BICSI (2)
  BlackBerry (17)
  Blue Coat (2)
  BMC (2)
  Business Objects (16)
  CA (31)
  Certiport (6)
  CheckPoint (44)
  CIPS (5)
  Cisco (736)
  Citrix (135)
  CIW (47)
  Cloudera (4)
  CLP (2)
  CompTIA (147)
  CWNA (16)
  Dassault (2)
  Dell (5)
  ECCouncil (19)
  EMC (136)
  ENTERASYS (16)
  Ericsson (4)
  Esri (4)
  Exam Express (18)
  EXIN (41)
  Extreme Networks (4)
  F5 Networks (21)
  FileMaker (11)
  Financial (56)
  Fitness (6)
  FORTINET (5)
  Fujitsu (4)
  GAQM (1)
  Genesys (2)
  GIAC (17)
  GRE (2)
  GuidanceSoftware (5)
  H3C (2)
  HDI (10)
  Healthcare (4)
  HIPAA (2)
  Hitachi (17)
  Hospitality (3)
  HP (751)
  HRCI (6)
  Huawei (13)
  Hyperion (15)
  IASSC (1)
  IBM (963)
  ICDL (8)
  IELTS (3)
  IFPUG (2)
  IIA (1)
  IIBA (4)
  IISFA (1)
  Intel (2)
  IRS (4)
  Isaca (5)
  ISC (15)
  ISEB-ITIL (37)
  Isilion (4)
  ISM (0)
  ISM (8)
  iSQI (12)
  Juniper (53)
  Legato (5)
  Lotus (135)
  LPI (18)
  LSI (6)
  Magento (4)
  Maintenance (4)
  Marketing (2)
  McAfee (7)
  McData (5)
  Microsoft (912)
  Mile2 (5)
  Motorola (6)
  MySQL (5)
  Network Appliance (31)
  Nework-GENERAL (16)
  NI-LabVIEW (1)
  NOKIA (3)
  Nortel (176)
  Novell (77)
  OMG (12)
  Open Group (4)
  Oracle (297)
  Pegasystems (4)
  PEOPLECERT (2)
  PMI (7)
  Polycom (3)
  PostgreSQL CE (1)
  Prince2 (1)
  PRMIA (2)
  Quality Assurance (6)
  Real Estate (2)
  RedHat (4)
  RES Software (8)
  Research (2)
  Riverbed (3)
  RSA (19)
  SAIR (16)
  SAP (45)
  SAS Institute (19)
  SCO (11)
  SCP (9)
  SDI (4)
  SeeBeyond (2)
  SNIA (9)
  SOA (15)
  SolarWinds (1)
  SpringSource (1)
  SPSS (8)
  Sybase (20)
  Symantec (158)
  The Open Group (4)
  Tibco (28)
  TruSecure (2)
  TSEP (2)
  Veritas (12)
  VMWare (16)
  XML Master (6)
 
New  Releases More...
 
   Study Pack
 
     Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel   
     
Lifetime member (All Exams and Study Packs Only $ 79.99)   
 
  Introduction

The 70-779 exam is designed for both Business Intelligence developers and Business power users that have used Excel for many years to help support Analytics in an organization. The book is an even split between the skills needed to Consume and Transform Data, Model Data, an-d then Visualize Data.In the Consume and Transform Data chapter the focus is on the sources that Excel can connect with for data, and then how to transfor-m data using the Power Query Editor. It is important to understand the M language that underlies the Power Query Editor and is generated when performing transform tasks using the GUI.The chapter on Modeling Data turns the focus to the Excel Data Model to build the necessary relationships that glue the data model togeth-er, and the how to optimize it for reporting. Next, we look at how to extend the model and make it easy to consume for users by utilizingDAX, KPIs, and Hierarchies.When Visualizing data, we spend time considering PivotTables and PivotCharts as the two primary methods in Excel for presenting data. L-astly, you will spend time investigating how to interact with Power BI as an additional means for distributing content to users.This book covers every major topic area found on the exam, but it does not cover every exam question. Only the Microsoft exam team has access to the exam questions, and Microsoft regularly adds new questions to the exam, making it impossible to cover specific questions. You s-hould consider this book a supplement to your relevant real-world experience and other study materials. If you encounter a topic in this book tha-t you do not feel completely comfortable with, use the “Need more review?” links you’ll find in the text to find more information and ta-ke the time to research and study the topic. Great information is available on MSDN, TechNet, and in blogs and forums.


  Index
 
 
Home | Training List | Study Pack | Free Demo | F A Q | Guarantee | Support | Order | Privacy Policy| Website Index
Copyright 2000 - 2018 ITExamWorld.net , All rights reserved.