[{"Value":"","Discard":false,"Expires":9999999999}] Analyzing Data with Excel – iBtech – Institute of Business and Technology

Analyzing Data with Excel

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
  • Must have good knowledge of MS-Excel and SQL Querying, preferably MCSA SQL Database Development

Course Details