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

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

Synopsis

• BI tools and methods (ETL, OLAP, ODBC and a.) • Access and analyze external data with Power Query • Power Pivot in data model – import, link, calculation • Calculate with DAX functions and calculate KPIs • Visualize Excel data with Power BI, publish reports and dashboards to the cloud The growth of data across all business processes puts many users in the practice before new Challenges. Enterprise data needs to be processed combined with intelligent reporting and visualization. In the future, analyses should be available constantly, immediately and on all media. Microsoft Excel's easy-to-use BI tools are the first choice for managers and controllers. They help you identify trends and risks, understand relationships, and improve the basics for your decisions. 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. For Excel 2019 and Microsoft 365 Extra: e-book inside. System requirements for e-book inside: Internet connection and Adobe reader or ebook reader or Adobe Digital Editions.

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