Excel Data Analysis

  1. Home
  2. Data-analysis
  3. Excel Data Analysis

Tags: Data Analysis , Excel Analytics

Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts.

Last updated 2022-01-10 | 4.8

- Understand and Identify the principles of data analysis
- Build presentation ready dashboards in Excel
- Apply analysis techniques to datasets in Excel

What you'll learn

Understand and Identify the principles of data analysis
Build presentation ready dashboards in Excel
Apply analysis techniques to datasets in Excel
Become adept at using Excel functions and techniques for analysis
Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
Use effective design principles when creating and presenting data
Learn about Excel's Ubiquity And Strategic Importance as a BI Tool
Learn about the Excel Data Model
GeoFLow
Working with External Databases
Integration with Sharepoint

* Requirements

* Basic experience with Excel functionality

Description

  • Understand and Identify the principles of data analysis
  • Build presentation ready dashboards in Excel
  • Apply analysis techniques to datasets in Excel
  • Become adept at using Excel functions and techniques for analysis
  • Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
  • Use effective design principles when creating and presenting data
  • Learn about Excel's Ubiquity And Strategic Importance as a BI Tool
  • Learn about the Excel Data Model
  • GeoFLow
  • Working with External Databases
  • Integration with Sharepoint

Course content

9 sections • 39 lectures

Introduction 1 lectures

Introduction Preview 03:28

Excel as a BI Tool 2 lectures

Excel's Ubiquity And Strategic Importance Preview 03:50

Excel Analytics Facilities Preview 05:06

Data Management And Modeling: Core Excel and the Excel Data Model 8 lectures

Core Excel BI Preview 03:30

DEMO: Web Queries and the Data Connection Wizard Preview 07:33

Office Data Connections Preview 02:55

DEMO: Managing Office Data Connections Preview 02:13

Analysis Services Support Preview 01:31

DEMO: Querying an OLAP Cube Preview 08:48

The Excel Data Model Preview 07:16

The BI Semantic Model Preview 06:42

Data Management and Modeling: PowerPivot 5 lectures

Features Overview Preview 06:26

Obtaining the Add-In, Data Import Preview 04:46

DEMO: Data Import and Setting Relationships Preview 06:35

Advanced Modeling Preview 06:47

DEMO: Advanced Modeling, Querying In Excel Preview 09:42

Data Discovery and Visualization: Power View 6 lectures

Overview Preview 05:00

Creating Reports Preview 05:56

Demo: Power View Basics Preview 03:18

Maximize, Filters and Bubble Charts Preview 01:14

DEMO: Filters, Bubble Charts and the Play Axis Preview 03:45

Advanced Properties Preview 01:56

Data Acquisition: Data Explorer 6 lectures

Overview, Data Sources and Tie-Ins with Excel Data Model Preview 07:57

Demo: Importing Web and Facebook Data Preview 04:16

Data Shaping, Data Manipulation and Integrating Child Data Preview 02:35

Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data Preview 09:46

Data Formulas, Scripts and the 'M' langauge Preview 01:44

Demo: Working with Data Steps and Scripts Preview 02:29

Mapping: GeoFlow 6 lectures

Overview and First Steps Preview 03:49

Demo: Mapping the Hadoop Data Preview 05:10

Chart Types, Controls and Visual Elements Preview 03:34

Demo: Bubble Charts, Heat Maps, Panning, Zooming, and Themes Preview 04:38

Layers, Scenes and Tours Preview 02:12

Demo: Working with Layers, Building Scenes and Tours Preview 02:00

How SharePoint Ties In 4 lectures

Overview and Excel Services/Excel Web App Preview 03:11

Demo: Excel Analytics in the Excel Web App on Office 365 Preview 03:16

PowerPivot and Power View Preview 03:45

PerformancePoint/Reporting Services, Analysis Services Clients Preview 04:21

Wrap-Up 1 lectures

Review and Wrap Up Preview 04:29