20779: Analyzing Data with Excel

Course Overview

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

Schedule

Start DateDelivery FormatDaysTimeStatusPriceEnroll
3/24/2021Live Virtual Led310:00 amEnrolling Now$1,675
5/5/2021Live Virtual Led310:00 amEnrolling Now$1,675
6/16/2021Live Virtual Led310:00 amEnrolling Now$1,675
7/28/2021Live Virtual Led310:00 amEnrolling Now$1,675
9/8/2021Live Virtual Led310:00 amEnrolling Now$1,675

Looking for Corporate/Group Training?

Leave us a message

Who Should Attend

This Microsoft SQL Server 2016 Training Course is intended for anyone responsible for analyzing data with Excel.

The Microsoft SQL Server 2016 Training Course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

Before attending this Microsoft SQL Server 2016 Training Course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Good Knowledge of Excel spreadsheets, functions, and charts.
  • Working knowledge of relational databases.

Objectives

After completing this Microsoft SQL Server 2016 Training 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.

Course Outline