Excel Power Suite – Business Intelligence Clinic
If you want to learn Business Intelligence software, if you are looking for specific BI tool, or if you are trying to decide on your next new BI solution, you will love the Business Intelligence Clinic.
Each book is about a different BI tool, and you will follow step-by-step instructions to create a professional sales Dashboard with the same friendly dataset. This BI Clinic series will help you to compare different Business Intelligence tools, learn the basics, and decide the best for your project, company, customers, or personal needs.
In this Create and Learn book, Excel Power Suite – Business Intelligence Clinic, with more than 250 images, you will you go through important topics of Microsoft Excel and its Power Suite (Power Query, Data Model, and Power Pivot) a powerful set of Business Intelligence tools.. You will learn how to Get Data from, Model your Data, work with Visuals and Reports, create a Sales Dashboard, and Share your work with others.
You will follow step-by-step instructions to create a professional Sales Dashboard, and eight warm-up Dashboards to help you rapidly increase your knowledge.
In this book you will learn how to:
Use Excel Power Suite (Power Query, Data Model, and Power Pivot).
Manipulate images, objects, and charts.
Create custom calculations using DAX (Data Analysis Expressions).
Create and configure Timelines.
Create and configure Slicers.
Create and edit Power Pivots, and Power Charts.
Create special charts from formulas linked to Power Pivot.
Advanced charts formatting.
Share online, and setup printing.
2. About this book
3. Windows and Excel System Requirements
4. Important to know
5. Get Started
5.1. Business Intelligence and Excel “Power Suite”
5.2. Power Query (Get & Transform)
5.3. Where is Power Query (Get & Transform), and Power Pivot?
5.4. The Business Intelligence Clinic Dataset
6. Starting the Dashboard: Get Data
7. Data Model
8. Creating (Power) PivotCharts
8.1. Clustered Column
8.2. Doughnut Chart
8.3. Line Chart
8.4. Stacked Bar
9. Creating (Power) Pivot Tables
9.1. PivotTable Revenue By Product Line
9.2. PivotTable Revenue
9.3. PivotTable Gross Margin
9.4. PivotTable Countries
10. Linking Data
11. Creating Special Visuals
11.2. Field Map
12. Slicer and Timeline
13. Setup Printing
14. Sharing online
15. Final words