Business Intelligence mit Excel: Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI Desktop. Für Microsoft 365. - Hardcover

Schels, Ignatz

 
9783446479524: Business Intelligence mit Excel: Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI Desktop. Für Microsoft 365.

Synopsis

- BI tools and methods (ETL, OLAP, ODBC and a.)
- Retrieve and analyze external data with Power Query
- Power Pivot in Data Model – Import, Links, Calculations
- Calculate with DAX functions and calculate KPIs
- Visualize Excel data with Power BI, publish reports and dashboards to the cloud
- New in the 3rd Edition: Use AI functions in Power Query, Power Query and VBA, write your own functions in M, Time Intelligence with DAX, BI support and dashboarding with dynamic arrays

Microsoft Excel's easy-to-use BI tools are the first choice in management and controlling, helping to identify trends and risks, understand relationships, and improve decision-making bases. Prepare business data associated with intelligent reporting and visualization. You can keep the analysis available constantly, immediately and on all media.

This practice book teaches the basics for getting started in business intelligence. It explains terms and methods, and shows how data from different sources is imported, transformed, and visualized using Microsoft Excel. Learn to prepare data with Power Query and the scripting language M, and practice building data models with Power Pivot and DAX. Create vivid visualizations, reports and dashboards with PivotTables, PivotCharts and Power BI.

"synopsis" may belong to another edition of this title.