The 70-778 exam focuses on using Microsoft Power BI for data analysis and visualization. About one fourth of the exam covers data acquisition and transformation, which includes connecting to various data sources by using Power Query, applying basic and advanced transformations, and making sure that data adheres to business requirements. Approximately half the questions are related to data modeling and visualization. Power BI is based on the same engine that is used in Analysis Services, and the exam covers a wide range of data modeling topics: managing relationships and hierarchies, optimizing data models, using What-if parameters, and using DAX to create calculated tables, calculated columns, and measures. The exam also covers selecting, creating and formatting visualizations, as well as bookmarks and themes. The remainder of the exam covers sharing data by using dashboards, reports, and apps in Power BI service. Furthermore, the exam tests your knowledge on managing custom reporting solutions, using Power BI Report Server, configuring security, and keeping your reports up to date