Gå til innhold

MS 20779: Analyzing Data with Excel

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.

Du får 15% rabatt på kursprisen ved å oppgi medlemsnummeret ditt i NITO når du melder deg på.

Påmelding gjennom Glasspaper


Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals. vBasic knowledge of data analytics equivalent to having attended course 10994.

Course goal:

After completing this course, students will be able to:

  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel.

Read the official course description here: 
MS 20779: Analyzing Data with Excel 


This course is recommended as preparation for exam 70-779 which is the first of two exams leading to MCSA BI Reporting certification. 

Kurset arrangeres av:


Bli medlem i NITO

Gjør som over 88.000 andre ingeniører og teknologer. Med gode medlemsfordeler får du mer å rutte med i hverdagen.

Ordinær fagforeningskontingent er fradragsberettiget. For 2018 kan du trekke fra inntil kr. 3850,- i din skattepliktige inntekt!

Bli medlem i dag