Microsoft Excel Data Analysis Course
at just
$69
Enroll Now
Sign Up
Sign In
Microsoft Excel Data Analysis Course
Microsoft Excel Data Analysis Course
Section 1 : Introduction
lecture 1
Introduction
3:28
Section 2 : Excel as a BI Tool
lecture 2
Excel's Ubiquity And Strategic Importance
3:51
lecture 3
Excel Analytics Facilities
5:7
Section 3 : Data Management And Modeling Core Excel and the Excel Data M
lecture 4
Core Excel BI
3:30
lecture 5
DEMO Web Queries and the Data Connection Wizard
7:34
lecture 6
Office Data Connections
Preview
lecture 7
DEMO Managing Office Data Connections
2:13
lecture 8
Analysis Services Support
1:31
lecture 9
DEMO Querying an OLAP Cube
8:48
lecture 10
The Excel Data Model
Preview
lecture 11
The BI Semantic Model
6:42
Section 4 : Data Management and Modeling PowerPivot
lecture 12
Features Overview
6:26
lecture 13
Obtaining the Add-In, Data Import
4:47
lecture 14
DEMO Data Import and Setting Relationships
6:36
lecture 15
Advanced Modeling
6:48
lecture 16
DEMO Advanced Modeling, Querying In Excel
9:42
Section 5 : Data Discovery and Visualization Power View
lecture 17
Overview
5:1
lecture 18
Creating Reports
5:56
lecture 19
Demo Power View Basics
3:18
lecture 20
Maximize, Filters and Bubble Charts
1:14
lecture 21
DEMO Filters, Bubble Charts and the Play Axis.
Preview
lecture 22
Advanced Properties
1:56
Section 6 : Data Acquisition Data Explorer
lecture 23
Overview, Data Sources and Tie-Ins with Excel
7:57
lecture 24
Demo Importing Web and Facebook Data
4:16
lecture 25
Data Shaping, Data Manipulation and Integratin
2:36
lecture 26
Demo Importing, Shaping and Visualizing HDInsi
Preview
lecture 27
Data Formulas, Scripts and the 'M' langauge
1:45
lecture 28
Demo Working with Data Steps and Scripts
2:30
Section 7 : Mapping GeoFlow
lecture 29
Overview and First Steps
3:49
lecture 30
Demo Mapping the Hadoop Data
Preview
lecture 31
Chart Types, Controls and Visual Elements
3:34
lecture 32
Demo Bubble Charts, Heat Maps, Panning, Zoomin
4:38
lecture 33
Layers, Scenes and Tours
2:12
lecture 34
Demo Working with Layers, Building Scenes and
2:0
Section 8 : How SharePoint Ties In
lecture 35
Overview and Excel ServicesExcel Web App
3:11
lecture 36
Demo Excel Analytics in the Excel Web App on O
3:16
lecture 37
PowerPivot and Power View
3:45
lecture 38
PerformancePointReporting Services, Analysis S
4:21
Section 9 : Wrap-Up
lecture 39
Review and Wrap Up
4:30
$69
Take this course now.
Enroll Now
Lectures
39
Video
2:57:42 Hours
Skill level
intermdiate
level
Languages
English
Includes
Lifetime access
Certificate of Completion
Preview
×