For any inquiries, please contact us:

© Brain Words

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.

Excel BI ebook 2019.jpg

In this book you will learn how to:

  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  

Power BI STUDY ebook 2019 v5.jpg

Step-by-step guide to create an easy dashboard for healthcare

Power BI Academy - Healthcare

Power BI 2019.jpg

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

Power BI – Business Intelligence Clinic

Tableau ebook 2019.jpg

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

Tableau – Business Intelligence Clinic

Excel BI ebook 2019.jpg

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

Excel – Business Intelligence Clinic