20779 Analysing Data with Excel

Course Summary

Training levelMOC
Duration2 days / 16 Hours
Delivery methodIn Class
Level100
LanguageBulgarian/English
List price435 Euro VAT Excl.

Click Tabs for Detailed info

Microsoft Official Course – 20779

  • This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.
  • The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.
  • 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.
  • Module 1: Data Analysis in Excel
  • Module 2: The Excel Data Model
  • Module 3: Importing Data from Files
  • Module 4: Importing Data from Databases
  • Module 5: Importing Data from Excel Reports
  • Module 6: Creating and formatting measures
  • Module 7: Visualizing Data in Excel
  • Module 8: Using Excel with Power BI

Next planned dates:

Trainer: Ivan Donev

Ivan-Donev

Reserve your seat





Subscribe me to your mailing list

Reserving a seat does not imply any obligations for payment

Next training starts in:
Stay tuned for the next training date
Days
Hours
Minutes
Seconds