- Overview
- Installing
- Features
- Loading Data
- Data Model
- Managing Data Model
- PowerPivot Table Creation
Descriptive Analytics with Excel | |
|---|---|
| Outline: | Outline |
| Introduction: | intro.pptx |
| Reading Material: | Material |
| Day | Modules |
| 1 |
|
| 2 |
|
| Recommanded Books | ||
|---|---|---|
 | Title | Collect, Transform and Combine Data using Power BI and Power Query in Excel |
| ISBN | 978-1-509-30795-1 | |
| Author | Gil Raviv | |
| Year | 2018 | |
| Publisher | Microsoft Press | |
 | Title | Power Pivot and Power BI. The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 |
| ISBN | 978-1-615-47039-6 | |
| Author | Rob Collie, Avichal Singh | |
| Year | 2017 | |
| Publisher | Holy Macro | |
 | Title | Supercharge Excel: When you learn to Write DAX for Power Pivot |
| ISBN | 978-1-615-47053-2 | |
| Author | Matt Allington | |
| Year | 2018 | |
| Publisher | Holy Macro! Books | |
 | Title | Data Mashup with Microsoft Excel Using Power Query and M: Finding, Transforming, and Loading Data from External Sources |
| ISBN | 978-1-484-26017-3 | |
| Author | Adam Aspin | |
| Year | 2020 | |
| Publisher | Apress | |
 | Title | Excel Power Pivot and Power Query for dummies |
| ISBN | 978-1-119-84448-8 | |
| Author | Michael Alexander | |
| Year | 2022 | |
| Publisher | For Dummies; 2nd edition | |