• 0800 677 1232
  • info@robustittraining.com
  • Facebook:
  • LinkedIn:
  • Youtube:
  • Black Friday Sale Has Started: Click here to see deals

MCSA Analysing and Visualising Data with Microsoft Power BI

EXAM CODES 70-778

About

This certification demonstrates your expertise in analyzing data with both Power BI and Excel.

Earning an MCSA: BI Reporting demonstrates knowledge relevant to data analysis, data visualization, modeling, dashboards, and direct connectivity to data sources in Excel and Power BI. It is the first step on your path to becoming a Data Management and Analytics Microsoft Certified Solutions Expert (MCSE).

Who should take this exam?

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.

Benefits of training with us

  • Intuitive and rewarding online training resources

  • 24/7 access to our unique course materials

  • Custom built practical tasks and challenges
  • Official mock examinations to fully prepare you for any final exams
  • Career advice and CV support once training has been completed
  • Full printable course materials, allowing you take your learning offline at your own convenience

Enquiry Form

Request More Information

Consuming and Transforming Data By Using Power BI Desktop
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

Modelling and Visualizing Data
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

Configure Dashboards, Reports and Apps in the Power BI Service
Access on-premises data
  • May include: Connect to a data source by using a data gateway; publish reports to the Power BI service from Power BI Desktop; edit Power BI Service reports by using Power BI desktop
Configure a dashboard
  • May include: Add text and images; filter dashboards; dashboard settings; customize the URL and title; enable natural language queries
Publish and embed reports
  • May include: Publish to web; publish to Microsoft SharePoint; publish reports to a Power BI Report Server
Configure security for dashboards, reports and apps
  • May include: Create a security group by using the Admin Portal; configure access to dashboards and app workspaces; configure the export and sharing setting of the tenant; configure Row-Level Security
Configure apps and apps workspaces
  • May include: Create and configure an app workspace; publish an app; update a published app; package dashboards and reports as apps

  • Official Microsoft Exams
  • Online or classroom training
  • Interactive mock exams
  • Live Lab (access to LIVE software)
  • Free Phone Support
  • Online & Email Support
  • World wide Recognised Qualification
  • Unlimited access for 12 months
  • BI Reporting Analyst
  • BI Develope
  • Power BI Consultant
  • Reporting Lead (CRM, Transformation, Azure, Power BI)
  • Performance Analyst

Courses you might also be interested in

MTA Database Fundamentals


This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on...

Find out more

MCSA SQL Server 2012/2014


This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments. This exam is intended for SQL Server database administrators, system engineers...

Find out more

MCSA SQL Server 2016 Admin


This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently...

Find out more

MCSA SQL Server 2016 Development


This exam is intended for database professionals who build and implement databases across organisations and who ensure high levels of data availability. Their responsibilities include creating database files, data types ...

Find out more

Our training is trusted and accredited
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1
Brand 1