Analyzing and Visualizing Data with Power BI 70-778 Practice

Enhance your certification score. Even though you're working at a top company, you'll want to keep your certification score up. It's important for your job search, especially if you want to go for a higher level position. When you're looking for new jobs, people are going to be screening your resume a bit with certifications.

Understand the test structure and what to expect; then walk through each topic area, quiz yourself with practice questions and answers, and ensure you’re ready to take the certification.

Scenario based exam questions for Analyzing and Visualizing Data with Microsoft Power BI Certification

Online practice exam to be completed in Specified Time Duration.

Practice tests are created by Subject Matter Experts. Your results are immediately available, while you stay focused on your exam results. Practice tests provides the answer to a test/questions you haven't already learned.

Exam Questions similar to actual Certification Exam.

Life time Access to practice tests to try as many times until you master the subject. You have access to practice test answers 24 hours a day, 365 days a year. If you're not satisfied, you can easily return to the practice test to make corrections.

The practice test have been designed carefully by maintaining the exam structure , syllabus, topic weights , cut score and time duration same as actual certification exam.

The aim of the practice exam is to allow the candidate to identify the risks related to a exam topics and be able to recognise them when analysing a real practice scenario.

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis. Candidates should be proficient in connecting to data sources and performing data transformations, modeling and visualizing data by using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service. Candidates should also be proficient in implementing direct connectivity to Microsoft SQL Azure and SQL Server Analysis Services (SSAS), and implementing data analysis in Microsoft Excel. Candidates may include BI professionals, data analysts, and other roles responsible for creating reports by using Power BI.

Official Exam Details:

Exam Name : Analyzing and Visualizing Data with Microsoft Power BI

Exam Code : 70-778

Exam Level : Associate

Exam Length: 150 minutes

Passing Score: 700 is passing score out of 1000 points(70%)

Number of questions: 45-55

Certification path: MCP, MCSA

Total Questions to check your knowledge: 300 (Actual exam contains 80 questions)

Exam Topics

Consuming and Transforming Data By Using Power BI Desktop (20-25%)

• Connect to data sources.

  • May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)

• Perform transformations.

  • May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization

• Cleanse data.

  • May include: Manage incomplete data; meet data quality requirements

Modeling and Visualizing Data (45-50%)

• Create and optimize data models.

  • May include: Manage relationships; optimize models for reporting; manually type in data; use Power Query

• Create calculated columns, calculated tables, and measures.

  • May include: Create DAX formulas for calculated columns, calculated tables, and measures; Use What If parameters

• Measure performance by using KPIs, gauges and cards.

  • May include: calculate the actual; calculate the target; calculate actual to target; configure values for gauges; use the format settings to manually set values

• Create hierarchies.

  • May include: Create date hierarchies; create hierarchies based on business needs; add columns to tables to support desired hierarchy

• Create and format interactive visualizations.

  • May include: Select a visualization type; configure page layout and formatting; configure interactions between visual; configure duplicate pages; handle categories that have no data; configure default summarization and data category of columns; position, align, and sort visuals; enable and integrate R visuals; format measures; Use bookmarks and themes for reports

• Manage custom reporting solutions.

  • May include: Configure and access Microsoft Power BI Embedded; enable developers to create and edit reports through custom applications; enable developers to embed reports in applications; use the Power BI API to push data into a Power BI dataset; enable developers to create custom visuals