Power BI mit Excel

Thanks to Power BI, large datasets can be analyzed and processed using Excel. This book provides everything you need for your daily work: comprehensive and understandable explanations based on practical scenarios. Stephan Nelles demonstrates how to handle raw data from various data sources, including cleaning, linking, analyzing, and visualizing it. You will learn how to efficiently combine Excel with Power Query, Power Pivot, and Power BI Desktop.

Contents:

What is Self-BI? What do the tools offer?
Power Query – Basics of operation
Power Query instead of text functions
Merging/Appending queries
Power Query Formula Language: M for advanced users
Power Pivot – Basics of operation
Conditional calculations: CALCULATE()
Creating calculations across multiple tables
Incorporating a calendar table
Using sparklines and conditional formatting
Power BI Desktop – Basics of operation
Fundamentals of data visualization
Standard charts
Interactions & Slicers
Publishing dashboards
Power BI Service – More efficient teamwork.