By: Daniel Calbimonte | Comments (9) | Related: More > Professional Development Certifications
Problem
I like your certification series and want to know what resources I can use to pass exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI (beta).
Solution
In this tip, I have included several links to resources you can use to pass Microsoft exam 70-778 Analyzing and Visualizing Data with Microsoft Power BI (beta).
FAQ
Is this exam a beta version?
When this tip was written in August, 2017, it was still a beta version.
Can I take the beta exam and be certified?
Yes, however your score will be published after the expiration of the beta period, which may be between September and October.
What is Power BI?
Power BI is software for Business Analysis. You can use Power BI in Azure or install the Power BI desktop edition to create reports on your local machine. There is also a Power BI Mobile edition to access reports from your local machine.
Do I need to have an Azure subscription to study for this exam?
Yes, however there are free versions that requires a credit card to sign up, but is free to use.
What Microsoft Certifications are related to this exam?
This exam will be an optional exam for the MCSE Data Management and Analytics certification.
Is the exam difficult?
Power BI is very simple, friendly and intuitive. However, you need to setup environments that have complex technologies to connect to Power BI. You need for example to have SSAS knowledge, SharePoint, Reporting Services, Big Data and Azure SQL. The exam is not hard, but learning all the technologies required for the exam, is definitely hard.
Which books would you recommend for this exam?
The following books may be useful:
- Introducing Microsoft Power BI
- Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016
- Analyzing Data with Power BI: Introduction to Power BI
- Analyzing Data with Power BI and Power Pivot for Excel (Business Skills)
- Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop 2nd ed. Edition
- Power BI in 24 Hours
- Power BI: For Beginners! Understanding Power BI And Business Analytics (Business Intelligence, Big Data)
- Power BI Business Analytics Kindle Edition
- Introduction To Microsoft Power BI: Bring Your Data To Life!
- Microsoft Power BI Cookbook
- Big Data Analytics with Microsoft HDInsight in 24 Hours, Sams Teach Yourself
- The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) 1st Edition
- HDInsight Essentials - Second Edition
- Microsoft Big Data Solutions
- SharePoint Online from Scratch: Office 365 SharePoint from basics to advanced
- SharePoint 2016 For Dummies 1st Edition
- Power Query for Power BI and Excel
- Power Query for Power BI and Excel
Are there some courses for this exam?
Yes, the following courses will be useful:
- Power BI courses
- List of Power BI Courses
- Analyze & Visualize Data with Power BI
- Power BI Tutorial For Beginners | Introduction to Power BI | Power BI Training | Edureka
- MVA Power BI Courses
- Analyzing and Visualizing Data with Power BI
- Power BI Training
- Power BI Training and Tutorials
- Power BI in Excel (Course)
Can you provide some links to study, for this exam?
Yes, here are some useful links:
Consume and Transform Data By Using Power BI Desktop
- Connect to data sources
- Perform transformations
- Cleanse data
Model and Visualize Data
- Create and optimize data models
- Create and manage relationships in Power BI Desktop
- How to Manage Your Data Relationships
- Optimize models for Power BI (2-4)
- Optimizing Data Models for Better Visuals
- Create reports optimized for the Power BI phone apps
- Optimize your data for Power BI Quick Insights
- Manually Enter Data
- Getting Started with Power Query - Part I
- Difference between PowerPivot, PowerQuery and PowerBI
- Creating Power BI solutions using Power Query and Power Pivot
- Create calculated columns, tables, and measures
- Create performance KPIs
- Create hierarchies
- Create and format interactive visualizations
- Visualization types in Power BI
- Style Your Reports With page layout and formatting
- Create and manage relationships in Power BI Desktop
- Duplicate a report page in Power BI
- Show Categories With No Data
- Data categorization in Power BI Desktop
- Align visualizations on the report page
- Change how a chart is sorted in a Power BI report
- Create Power BI visuals using R
- Percentage formatting for calculated measures
-
Manage custom reporting solutions
- Overview of Power BI REST API
- What can developers do with Power BI?
- Get started with Microsoft Power BI Embedded
- Embed Dashboards in Your Applications to Monitor Your Business in Context
- How to Authenticate to a REST API with basic Authentication in Power BI Blank Query
- What is Microsoft Power BI Embedded?
Configure Dashboards in the Power BI Service
- Configure a dashboard
- Dashboards in Power BI service
- SQL Server Analysis Services live data in Power BI
- Publish to web from Power BI
- Add image, text, video, and more to your dashboard
- Add a filter to a Power BI report (in Editing view)
- Add a hyperlink to a text box in a report
- Create and Configure A Dashboard
- Ask Questions of Your Data With Natural Language
- Publish dashboards
- Configure security for dashboards
- Configure organizational content packs and apps
As you can see, there are many interesting topics.
Also, at the moment it is a beta version, but this will change in a few months.
Next Steps
For more information about this exam, refer to these links:
- Power BI
- Power BI Forums
- Power BI - Wikipedia
- Microsoft Power BI Blog
- Guided Learning
- Microsoft Power BI
About the author
Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and 6-time Microsoft Certified IT Professional. Daniel started his career in 2001 and has worked with SQL Server 6.0 to 2022. Daniel is a DBA as well as specializes in Business Intelligence (SSIS, SSAS, SSRS) technologies.This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
