Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Study material for exam 70-779 Analyzing and Visualizing Data with Microsoft Excel

By:   |   Updated: 2017-09-01   |   Comments (3)   |   Related: More > Professional Development Certifications


I'd like to take and pass Microsoft exam 70-799 Analyzing and Visualizing Data with Microsoft Excel. What resources are available to help me learn more and prepare for this exam?


 In this tip, we will talk about Microsoft exam 70-779, Analyzing and Visualizing Data with Microsoft Excel.


Is this exam in Beta version?

Yes, it is. When this tip was written 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.

Why is Excel used in BI?

BI experts work with Visual Studio, SSDT or SSMS, Power BI and many other tools. However, many data analysts feel very comfortable with Excel. That is why they are using it. The BI Tools are not so popular compared with Excel. It has some limitations, but it is definitely a very powerful tool.

Do I need to have an Azure subscription to study for this exam?

Yes, however there are free versions that require a credit card, but are free to use. The exam contains some topics related to Azure like connecting from Excel to SQL Azure or Big Data.

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?

Excel is not that hard to use, however, you need to setup environments like Azure, Big Data, SSAS and other environments that require a lot of knowledge for the setup. Once that the environments are configured, using Excel is not so difficult.

Which books would you recommend for this exam?

The following books may be useful:

Are there some courses for this exam?

Yes, the following courses will be useful:

Can you provide some links to study, for this exam?

Yes, here you have some useful links:

Consume and Transform Data by Using Microsoft Excel Connect to data sources

Model Data

Visualize Data

Next Steps

For more information about this exam, refer to these links:

Last Updated: 2017-09-01

get scripts

next tip button

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Monday, January 22, 2018 - 11:45:45 AM - Ian Back To Top



Please note the following two hyperlink (text versions) don't point to the expected destinations.

  • Connect Excel to Hadoop in Azure HDInsight with the Microsoft Hive ODBC driver
  • Create a relationship between tables in Excel 

Thursday, November 16, 2017 - 6:54:01 AM - Neysha Back To Top

 Very useful. Thank you!


Thursday, November 16, 2017 - 6:17:48 AM - Kieran Wood Back To Top

This article is absolutely awesome!!!

Learn more about SQL Server tools