Microsoft 20779 – Analyzing Data with Excel

Length

3 days

Price

$2750.00 inc GST

Version

Overview

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.

Key Topics

Detailed Info

Data Analysis in Excel
The Excel Data Model
Importing Data from Files
Importing Data from Databases
Importing Data from Excel Reports
Creating and Formatting Measures
Visualizing Data in Excel
Using Excel with Power BI

Skills Gained

Key Topics

Target Audience

Prerequisites

Skills Gained

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.

Key Topics

Module 1: Data Analysis in Excel

This module looks at the classic Excel dashboard and at ways to extend it.

Lessons

Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis

Lab : Building a Classic Excel Dashboard

Filtering and Formatting Data
Building a Pivot Table
Building a Pivot Chart
Building a Dashboard

Module 2: The Excel Data Model

This module looks at the classic Excel data model and at ways to extend it.

Lessons

Using an Excel Data Model
DAX

Lab : Explore an Excel Data Model

Create Calculated Columns
Format Data Model Data
Create Measures
Analyze the Data

Module 3: Importing Data from Files

This module looks at pre-formatting and importing CSV files.

Lessons

Importing Data into Excel
Shaping and Transforming Data
Loading Data

Lab : Importing Data from a CSV File

Import and Transform Data from a CSV File
Add Data from a Folder
After completing this module, students will be able to:
Import data into excel.
Shape and transform data.
Load data.

Module 4: Importing Data from Databases

This module looks at how to import data into Excel from a SQL Server database.

Lessons

Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data

Lab : Import Data from Multiple Sources

Import Data from SQL Server
Import Data from a CSV File
Create a Data Table

Module 5: Importing Data from Excel Reports

This module describes how to import data from a report.

Lessons

Importing Data from Excel Reports
Transforming Excel report Data

Lab : Importing Data from a Report

Import Data from Excel
Transform the Excel Data
Load the Data into an Excel Data Model

Module 6: Creating and Formatting Measures

This module describes how to create and format measures.

Lessons

DAX
Measures
Advanced DAX Functions

Lab : Creating Measures using Advanced DAX Functions

Last year comparison
Year to date
Market Share

Module 7: Visualizing Data in Excel

This module describes how to visualize data in Excel.

Lessons

Pivot Charts
Cube Functions
Charts for Cube Functions

Lab : Data Visualization in Excel

Create a Tabular Report
Create a Pivot Chart
Add Slicers to Charts

Module 8: Using Excel with Power BI

This module describes how to use Excel with Power BI.

Lessons

Power BI
Uploading Excel Data to Power BI
Power BI Mobile App

Lab : Creating a Power BI Dashboard with Excel

Uploading Excel Data
Creating a Power BI Dashboard

Target Audience

This course is intended for both novice and experienced programmers who have a minimum of three months programming experience and have basic Windows navigation skills.This course is intended for anyone responsible for analyzing data with Excel.
The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us on 1800 853 276.

Prerequisites

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.
Basic knowledge of data analytics equivalent to having attended course 10994.

Print course details

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

You don't appear to have Javascript enabled, our contact forms & booking process unfortunately requires it.

If you'd like more information, or to book a course please email us

Email Course Outline

Request a Callback

Enter your details below and we'll email you a pdf of the course outline.

Enter your details below and one of our team will give you a call to answer any questions you may have.

Length

Price

Version

Overview

Key Topics

Skills Gained

Key Topics

Target Audience

Prerequisites

Request Course Information

Testimonials

YOUR IT TRAINING PARTNER

FOLLOW US