top of page

Excel Power Suite – Business Intelligence Clinic

Power Excel PC_edited.png

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.

Get the ebook version:

US - UK - DE - FR - ES - IT - NL - JP - BR - CA - MX - AU - IN

Get the paperback version:

US - UK - DE - FR - ES - IT - JP

Excel BI ebook 2019.jpg

In this book you will learn how to:

Dashboard Details.png

  1. Use Excel Power Suite (Power Query, Data Model, and Power Pivot).

  2. Manipulate images, objects, and charts.

  3. Create custom calculations using DAX (Data Analysis Expressions).

  4. Create and configure Timelines.

  5. Create and configure Slicers.

  6. Create and edit Power Pivots, and Power Charts.

  7. Create special charts from formulas linked to Power Pivot.

  8. Advanced charts formatting.

  9. Share online, and setup printing.

Book content

1.     Introduction  

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.1.     Treemap  

11.2.     Field Map  

12.       Slicer and Timeline  

13.       Setup Printing  

14.       Sharing online  

15.       Final words  

The 100 Page Book - Python

Uncomplicated and easy to assimilate structure

Python The 100 page book - cover.png

Power BI – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Power BI 2019.jpg

Excel – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Excel BI ebook 2019.jpg

Power BI, Excel and Tableau – BI Clinic

Learn how to create Dashboard using Power BI, Excel and Tableau.

BI Clinic Complete Single cover.jpg

Power BI Academy: HR Recruitment

Create a complete dashboard for Human Resources. Bonus: 10 Templates

ebook.png

Tableau – Business Intelligence Clinic

One dataset multiple solutions. Start your journey into the Business Intelligence world with this book.

Tableau ebook 2019.jpg

Thanks for submitting!

​

Subscribe to get tips and free material

bottom of page