Use this quick start guide to collect all the information about Microsoft Analyzing and Visualizing Data with Microsoft Excel (70-779) Certification exam. This study guide provides a list of objectives and resources that will help you prepare for items on the 70-779 Analyzing and Visualizing Data with Microsoft Excel exam. The Sample Questions will help you identify the type and difficulty level of the questions and the Practice Exams will make you familiar with the format and environment of an exam. You should refer this guide carefully before attempting your actual Microsoft MCSA BI Reporting certification exam.
The Microsoft Analyzing and Visualizing Data with Microsoft Excel certification is mainly targeted to those candidates who want to build their career in Microsoft Excel domain. The Microsoft Certified Solutions Associate (MCSA) - BI Reporting exam verifies that the candidate possesses the fundamental knowledge and proven skills in the area of Microsoft MCSA BI Reporting.
Microsoft Analyzing and Visualizing Data with Microsoft Excel Exam Summary:
Exam Name | Microsoft Certified Solutions Associate (MCSA) - BI Reporting |
Exam Code | 70-779 |
Exam Price | $165 (USD) |
Duration | 120 mins |
Number of Questions | 40-60 |
Passing Score | 700 / 1000 |
Books / Training | 20779A: Analyzing Data with Excel |
Schedule Exam | Pearson VUE |
Sample Questions | Microsoft Analyzing and Visualizing Data with Microsoft Excel Sample Questions |
Practice Exam | Microsoft 70-779 Certification Practice Exam |
Microsoft 70-779 Exam Syllabus Topics:
Topic | Details | Weights |
---|---|---|
Consume and Transform Data by Using Microsoft Excel |
Import from data sources Perform data transformations Cleanse data |
30-35% |
Model Data |
Create and optimize data models Create calculated columns, measures, and tables Create performance KPIs Create hierarchies |
35-40% |
Visualize Data |
Create and manage PivotTables Create and manage PivotCharts Interact with Power BI |
30-35% |
To ensure success in Microsoft MCSA BI Reporting certification exam, we recommend authorized training course, practice test and hands-on experience to prepare for Analyzing and Visualizing Data with Microsoft Excel (70-779) exam.