Exam 70-778: Analyzing and Visualizing Data with Microsoft Power BI
Microsoft 70-778 Exam demonstrates the real-world mastery of Power BI data analysis and visualization. This exam is designed for experienced BI professionals and data analysts ready to advance their status. However, the professionals focus on the critical thinking and decision-making acumen needed for success at the MCSA level.
Who should take the exam?
Candidates applying for the exam should have a good understanding of using Power BI to perform data analysis. They must be familiar with 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.
Target Audience
This exam is best for:
- BI professionals
- Data analysts
- Candidates will have knowledge of creating reports by using Power BI
Microsoft 70-778 Exam Learning Objectives
After passing the exam candidates will be able to understand and perform the following tasks:
- Describing self-service BI.
- Describing the Power BI suite of products.
- Connecting to data sources and optimizing data models.
- Shaping and combining data from different sources.
- Modeling data with creating reports and managing solutions.
- Explaining the Power BI developer API and Power BI mobile app.
Exam Format
Microsoft 70-778 exam includes 40-60 number of questions that can be of type like a case study, short answers, multiple-choice, mark review, drag, and drop, etc. However, for completing this exam you will be given time duration of 120 minutes. And, to pass the exam it is required to score a minimum of 700 (on a scale of 900). Further, the exam will cost you $165 USD including the additional taxes. Candidates can give the exam in the English language.
Exam Scheduling
Candidates can schedule for the Microsoft Analyzing and Visualizing Data with Microsoft Power BI (70-778) using the Microsoft website. Candidates have to create the Microsoft account. After that,
- Sign in with your Microsoft account credentials.
- Then, select the exam you want to take, click Schedule exam.
Course Structure
Consuming and Transforming Data By Using Power BI Desktop
1.1 Connecting to the data sources.
- Connecting to databases, files, folder (Microsoft Documentation: Data sources in Power BI Desktop)
- Importing from Excel (Microsoft Documentation: Import Excel workbooks into Power BI Desktop)
- Having a connection with SQL Azure, Big Data, SQL Server Analysis Services (SSAS) (Microsoft Documentation: Connect to Analysis Services tabular data in Power BI Desktop)
1.2 Performing transformations.
- Designing and implementing basic and advanced transformations (Microsoft Documentation: Get started with Power BI Desktop)
- Applying business rules
- Changing data format to support visualization (Microsoft Documentation: Getting started with the formatting pane, Customize visualization titles, backgrounds, and legends)
1.3 Cleansing data.
- Managing incomplete data
- Meeting data quality requirements
Modeling and Visualizing Data
2.1 Creating and optimizing data models.
- Managing relationships (Microsoft Documentation: Create and manage relationships in Power BI Desktop)
- Optimizing models for reporting (Microsoft Documentation: Optimization guide for Power BI)
- Manually typing data (Microsoft Documentation: Enter data directly into Power BI Desktop)
- Using Power Query (Microsoft Documentation: Using Power Query in Power BI Desktop)
2.2 Creating calculated columns, calculated tables, and measures.
- Creating DAX formulas for calculated columns, calculated tables, and measures (Microsoft Documentation: Create calculated columns in Power BI Desktop, Create calculated tables in Power BI Desktop)
- Using What-If parameters (Microsoft Documentation: Create and use what-if parameters)
2.3 Measuring performance by using KPIs, gauges and cards.
(Microsoft Documentation: Key performance indicator (KPI), Create measures for data analysis in Power BI Desktop)
- Calculating both the actual and the target
- Calculating actual to target
- Configuring values for gauges (Microsoft Documentation: Radial gauge charts in Power BI)
- Using the format settings to manually set values (Microsoft Documentation: Use conditional formatting in tables)
2.4 Creating hierarchies.
- Creating date hierarchies (Microsoft Documentation: Set and use date tables in Power BI Desktop)
- Creating hierarchies based on business needs
- Adding columns to tables to support the desired hierarchy
2.5 Creating and formatting interactive visualizations.
- Selecting a visualization type (Microsoft Documentation: Visualization types in Power BI)
- Configuring page layout and formatting (Microsoft Documentation: Apply page display settings in a Power BI report)
- Configure interactions between visual (Microsoft Documentation: Understand how visuals interact in a report)
- Configure duplicate pages
- Handling categories that have no data (Microsoft Documentation: Show items with no data in Power BI)
- Configuring default summarization and data category of columns (Microsoft Documentation: Work with aggregates (sum, average, and so on) in the Power BI service, Specify data categories in Power BI Desktop)
- Positioning, aligning, and sorting visuals
- Enable and integrate R visuals (Microsoft Documentation: Create Power BI visuals using R)
- Using bookmarks and themes for reports (Microsoft Documentation: Create bookmarks in Power BI Desktop)
2.6 Managing custom reporting solutions.
- Configuring and accessing Microsoft Power BI Embedded (Microsoft Documentation: Embedded analytics with Power BI)
- Enabling developers to create and edit reports through custom applications (Microsoft Documentation: Embed Power BI content into an application for your customers)
- Enable developers to embed reports in applications
- Using the Power BI API to push data into a Power BI dataset (Microsoft Documentation: Push data into a Power BI dataset)
- Enable developers to create custom visuals (Microsoft Documentation: Developing a Power BI visual)
Configure Dashboards, Reports and Apps in the Power BI Service
3.1 Accessing on-premises data.
- Connecting to a data source by using a data gateway (Microsoft Documentation: Manage data sources, data sources in Power BI Desktop)
- Publishing reports to the Power BI service from Power BI Desktop (Microsoft Documentation: Publish datasets and reports from Power BI Desktop, create a Power BI report for Power BI Report Server)
- Editing Power BI Service reports by using Power BI desktop (Microsoft Documentation: Download a report from the Power BI service to Power BI Desktop)
3.2 Configuring a dashboard.
- Adding text and images (Microsoft Documentation: Add images, videos, and more to your dashboard)
- Filtering dashboards and dashboard settings (Microsoft Documentation: Design filters in Power BI reports, Add a filter to a report in Power BI)
- Customize the URL and title (Microsoft Documentation: Edit or remove a dashboard tile)
- Enable natural language queries (Microsoft Documentation: Intro to Power BI Q&A)
3.3 Publishing and embedding reports.
- Publishing to web and Microsoft SharePoint (Microsoft Documentation: Publish to the web from Power BI, Embed a report web part in SharePoint Online)
- Submitting reports to a Power BI Report Server (Microsoft Documentation: Create a Power BI report for Power BI Report Server)
3.4 Configuring security for dashboards, reports and apps.
- Creating a security group by using the Admin Portal (Microsoft Documentation: Administering Power BI in the admin portal)
- Configuring access to dashboards and app workspaces (Microsoft Documentation: Publish an app in Power BI, Organize work in the new workspaces in Power BI)
- Checking the export and sharing setting of the tenant (Microsoft Documentation: Tenant admin settings guidance)
- Configure RowLevel Security (Microsoft Documentation: Row-level security (RLS) with Power BI)
3.5 Configuring apps and apps workspaces.
- Creating and configuring an app workspace (Microsoft Documentation: Create the new workspaces in Power BI)
- Publishing an app (Microsoft Documentation: Publish an app in Power BI)
- Updating a published app
- Packaging dashboards and reports as apps
Microsoft Exam Policies
Microsoft provides exam policies to support the candidates by providing every detail related to the certification program. However, candidates during the studying for the 70-778 exam should first go through and understand the Microsoft Certification exam policies. On this page, the candidates will get information about after the exam or before exam procedures. This includes the exam retaking process, rules to be followed during the exam time, and other information about the exams and its testing centers.
For More Queries Visit: Analyzing and Visualizing Data with Microsoft Power BI (70-778) Exam FAQs
Microsoft 70-778 Exam Preparation ways
For 70-778 exam, Microsoft provides best methods and ways to help candidates successfully prepare and pass the exam.
Microsoft Learning Platform
The Microsoft Learning Platform provides access to candidates to get information about the exam using the learning resources. For the 70-778 exam, these study resources can be accessed from the official exam page. That is to say, you just have to search for the 70-778 exam and the essential information will be provided that will help you in understanding it better.
Instructor Led Training
Microsoft has given an advantage to candidates providing Instructor-led training. This is a three-day instructor-led course that provides students with the knowledge and skills to analyze data with Power BI. However, the primary audience for this course is BI professionals who need to analyze data utilizing Power BI. And, the secondary audiences for this course are technically proficient business users. After completing this, candidates will be able to describe self-service BI, Power BI suite of products including connecting to data sources and optimizing data models.
Microsoft Online Training
In this course, candidates will learn from the Power BI product team at Microsoft with a series of short, lecture-based videos, complete with demos, quizzes, and hands-on labs. They will walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. Moreover, they will learn to create dashboards and share with business users–on the web and on mobile devices.
Reference Books
Microsoft provides the official study guide for the Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI certification exam. This guide provides professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. Moreover, it focuses on the specific areas of expertise modern IT professionals need to successfully analyze and visualize data with Power BI
Joining Study Groups
One thing that will be beneficial during the exam preparation time is to join study groups. As these groups will help you to stay connected with the other people who are on the same pathway as yours. Moreover, here you can start any discussion about the issue related to the exam or any query. By doing so, you will get the best possible answer to your query.
Exam Practice Tests
This can be a very essential part that can help you to prepare better for the exam. That is to say, practice tests are important as by assessing yourself with these tests you will know about your weak and strong areas. We all know time plays an essential role during the exam. So, by practicing you will be able to improve your answering skills that will result in saving a lot of time. Moreover, the best way to start doing practice tests is after completing one full topic as this will work as a revision part for you. So, make sure to find the best practice sources.
Start preparing for Analyzing and Visualizing Data with Microsoft Power BI (70-778 exam) Now!