Excel Power Pivot und Power Query für Dummies

Michael Alexander

Michael Alexander
Excel Power Pivot und Power Query für Dummies [EPUB ebook]

Support

Couverture du Michael Alexander: Excel Power Pivot und Power Query für Dummies (ePUB)

Wie Sie mit Microsoft Power Pivot und Power Query große Datenmengen in Excel zusammenführen, untersuchen und weiterführende Erkenntnisse daraus gewinnen, zeigt Ihnen dieses Buch. Angefangen bei der Anbindung an Datenbanken bis hin zur Verwendung eigener Formeln und Funktionen: Sie erfahren, wie Sie Daten aus verschiedenen Datenquellen in einem einheitlichen Datenmodell verarbeiten, interpretieren und übersichtlich in Berichten darstellen. Schritt-für-Schritt-Anleitungen und wertvolle Praxistipps unterstützen Sie dabei, Analysen und Geschäftsprozesse weiter zu optimieren.

€18.99

Table des matières

Über den Autor 9

Einführung 19

Teil I: Fortgeschrittenes Reporting mit Power Pivot 23

Kapitel 1: Denken wie eine Datenbank 25

Kapitel 2: Einführung in Power Pivot 35

Kapitel 3: Die grundlegende Pivot- Tabelle 49

Kapitel 4: Verwendung externer Daten mit Power Pivot 85

Kapitel 5: Direkt mit dem internen Datenmodell arbeiten 113

Kapitel 6: Hinzufügen von Formeln zu Power Pivot 127

Kapitel 7: Dax 147

Teil II: Daten mit Power Query verarbeiten 165

Kapitel 8: Einführung in Power Query 167

Kapitel 9: Power- Query- Verbindungstypen 185

Kapitel 10: Bessere Daten durch Transformation 201

Kapitel 11: Abfragen miteinander verknüpfen 233

Kapitel 12: Power Query mit benutzerdefinierten Funktionen erweitern 251

Teil III: Der Top-Ten-Teil 271

Kapitel 13: Zehn Wege zur Verbesserung der Power- Pivot- Leistung 273

Kapitel 14: Zehn Tipps für die Arbeit mit Power Query 281

Abbildungsverzeichnis 293

Stichwortverzeichnis 303

A propos de l’auteur

Michael Alexander ist Microsoft Certified Application Developer und hat mehrere Bücher zu Access und Excel geschrieben.

Achetez cet ebook et obtenez-en 1 de plus GRATUITEMENT !

Langue Allemand ● Format EPUB ● ISBN 9783527842988 ● Taille du fichier 90.7 MB ● Maison d’édition Wiley-VCH GmbH ● Pays DE ● Publié 2023 ● Édition 1 ● Téléchargeable 24 mois ● Devise EUR ● ID 8857344 ● Protection contre la copie Adobe DRM

Nécessite un lecteur de livre électronique compatible DRM

Plus d’ebooks du même auteur(s) / Éditeur

Michael Alexander

16 931 Ebooks dans cette catégorie

Mike McGrath: Coding for Beginners in easy steps, 3rd edition

Now in its third edition, this bestseller will appeal to anyone, of any age, who wants to begin coding. Use Coding for Beginners in easy steps to help you quickly create a programming environment on …

EPUB

Adobe DRM

€18.50

Information Resources Management Association: Big Data: Concepts, Methodologies, Tools, and Applications

EPUB

Adobe DRM

€3,072.51

Eran Boudjnah: Clean Architecture for Android

"Clean Architecture for Android" was written to help developers apply Clean Architecture to their projects.The book will explain why Clean Architecture is so valuable. It will demonstrate h …

EPUB

Adobe DRM

€25.22

Ashwin (Senior Technical Manager, HCL technologies, Bangalore, INDIA) Shriram & Nataraj (Global Operations Director, Technology Solutions Group, HCL Technologies Ltd, INDIA) Venkataramanan: Data Privacy

The book covers data privacy in depth with respect to data mining, test data management, synthetic data generation etc. It formalizes principles of data privacy that are essential for good anonymizat …

EPUB

Adobe DRM

€64.49

Mike McGrath: C, C++ & C# in easy steps

C, C++ & C# in easy steps is a comprehensive guide to help you create your own programs in the C, C++ and C# programming languages, combining knowledge from the latest C, C++ and C# books in the In E …

EPUB

Adobe DRM

€38.57

Nakul Shah: Blockchain and DLT

Blockchain secures individual transactions with cryptography, creating a tamper-proof chain. In contrast, distributed ledger technologies cover various technologies that may not adhere strictly to bl …

EPUB

Adobe DRM

€25.32

Alessandro Del Sole: Xamarin with Visual Studio

For any mobile developer, it’s clear that Xamarin knowledge is vital, thanks to the reintroduction of .NET MAUI. This book provides the reader with complete hands-on experience in designing cross-pla …

EPUB

Adobe DRM

€25.46

Lukasz Gasior: ReSharper Essentials

In Detail Re Sharper is one of the best tools that extends Microsoft Visual Studio. It adds a lot of features which increases a developer’s productivity. It started with providing support for C# and …

EPUB

Adobe DRM

€29.16

Gavin Powell: Database Modeling Step by Step

With the aim of simplifying relational database modeling, Database Modeling Step-by-Step presents the standard approach to database normalization and then adds its own approach, which is a more simpl …

EPUB

Adobe DRM

€70.76

Rathinaraja Jeyaraj & Anand Paul: Big Data with Hadoop MapReduce

The authors provide an understanding of big data and Map Reduce by clearly presenting the basic terminologies and concepts. They have employed over 100 illustrations and many worked-out examples to c …

ERROR	Vi är ledsna - även om vi gjorde vårt bästa: ett fel inträffade
Type	database
Message	You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
Query	SELECT (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 17 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 17 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

ERROR

Table des matières

A propos de l’auteur

Plus d’ebooks du même auteur(s) / Éditeur

16 931 Ebooks dans cette catégorie

Changer la langue de l'utilisateur

Modal