- Introduction
Online
₹ 449 3,399
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹3,399
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Excel as a BI Tool
- Excel's Ubiquity And Strategic Importance
- Excel Analytics Facilities
Data Management And Modeling: Core Excel and the Excel Data Model
- Core Excel BI
- DEMO: Web Queries and the Data Connection Wizard
- Office Data Connections
- DEMO: Managing Office Data Connections
- Analysis Services Support
- DEMO: Querying an OLAP Cube
- The Excel Data Model
- The BI Semantic Model
Data Management and Modeling: PowerPivot
- Features Overview
- Obtaining the Add-In, Data Import
- DEMO: Data Import and Setting Relationships
- Advanced Modeling
- DEMO: Advanced Modeling, Querying In Excel
Data Discovery and Visualization: Power View
- Overview
- Creating Reports
- Demo: Power View Basics
- Maximize, Filters and Bubble Charts
- DEMO: Filters, Bubble Charts and the Play Axis
- Advanced Properties
Data Acquisition: Data Explorer
- Overview, Data Sources and Tie-Ins with Excel Data Model
- Demo: Importing Web and Facebook Data
- Data Shaping, Data Manipulation and Integrating Child Data
- Demo: Importing, Shaping and Visualizing HDInsight (Hadoop) Data
- Data Formulas, Scripts and the 'M' langauge
- Demo: Working with Data Steps and Scripts
Mapping: GeoFlow
- Overview and First Steps
- Demo: Mapping the Hadoop Data
- Chart Types, Controls and Visual Elements
- Demo: Bubble Charts, Heat Maps, Panning, Zooming, and Themes
- Layers, Scenes and Tours
- Demo: Working with Layers, Building Scenes and Tours
How SharePoint Ties In
- Overview and Excel Services/Excel Web App
- Demo: Excel Analytics in the Excel Web App on Office 365
- PowerPivot and Power View
- PerformancePoint/Reporting Services, Analysis Services Clients
Wrap-Up
- Review and Wrap Up