Data Modeling with Microsoft Excel | Model and analyze data using Power Pivot, DAX, and Cube functions
Idioma: inglés
Editorial: Packt Publishing, 2023
- Tapa blanda
- Nuevo



Librería: preigu, Osnabrück, Alemaniapreigu
Vendedor de IberLibro desde 5 de agosto de 2024
Condición: Nuevo
EUR 49,00
Cantidad disponible: 5 disponibles
Añadir al carritoDescripción del artículo del vendedor
Data Modeling with Microsoft Excel | Model and analyze data using Power Pivot, DAX, and Cube functions | Bernard Obeng Boateng | Taschenbuch | Englisch | 2023 | Packt Publishing | EAN 9781803240282 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.
N° de ref. del artículo 128092493
- Título
- Data Modeling with Microsoft Excel | Model and analyze data using Power Pivot, DAX, and Cube functions
- Autor
- Bernard Obeng Boateng
- Editorial
- Packt Publishing
- Año de publicación
- 2023
- Estado
- Neu
- Encuadernación
- Taschenbuch
- Idioma
- inglés
- ISBN 10
- 1803240288
- ISBN 13
- 9781803240282
- Peso del artículo
- 593 gramos
- Dimensiones
- 235 x 191 x 18 mm
- Catálogos de vendedores
- Bücher
Save time analyzing volumes of data using a structured method to extract, model, and create insights from your data
Key Features
- Acquire expertise in using Excel’s Data Model and Power Pivot to connect and analyze multiple sources of data
- Create key performance indicators for decision making using DAX and Cube functions
- Apply your knowledge of Data Model to build an interactive dashboard that delivers key insights to your users
- Purchase of the print or Kindle book includes a free PDF eBook
Book Description
Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data.
Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations.
This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You’ll also understand how to create powerful and flexible measures using DAX and Cube functions.
By the end of this book, you’ll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions.
What you will learn
- Implement the concept of data modeling within and beyond Excel
- Get, transform, model, aggregate, and visualize data with Power Query
- Understand best practices for data structuring in MS Excel
- Build powerful measures using DAX from the Data Model
- Generate flexible calculations using Cube functions
- Design engaging dashboards for your users
Who this book is for
This book is for Excel users looking for hands-on and effective methods to manage and analyze large volumes of data within Microsoft Excel using Power Pivot. Whether you’re new or already familiar with Excel’s data analytics tools, this book will give you further insights on how you can apply Power Pivot, Data Model, DAX measures, and Cube functions to save time on routine data management tasks. An understanding of Excel’s features like tables, PivotTable, and some basic aggregating functions will be helpful but not necessary to make the most of this book.
Table of Contents
- Getting Started with Data Modeling – Overview and Importance
- Data Structuring for Data Models
- Preparing your Data for the Data Model
- Data Modeling with Power Pivot
- Creating DAX Calculations from your Data Model
- Creating Cube Functions from your Data Model
- Communicating insights from your Data Model using Dashboards
- Visualization Elements for your Dashboard
- Choosing the right Design Themes
- Publication and Deployment
“Sinopsis” puede pertenecer a otra edición de este título.
Acerca del autor
Bernard Obeng Boateng is a Microsoft Excel MVP, Microsoft Certified Trainer, with over 10 years work experience in Banking, Insurance and Business Development. He is founder of Finex Skills Hub an approved Training Provider of the Financial Modeling Institute, Canada. Finex Skills Hub runs the Finex Project in Ghana, a pro bono student training outreach program for students in Data Analytics and Financial Modeling. Bernard also provides consultancy services for SMEs (start-ups and existing) in Financial Management, Business Planning and Research. He has an active audience online with about 17,000 followers on his LinkedIn Account. where he shares tips and tricks on Microsoft Excel and other Office Apps.
Michael Olafusi is a nine-time Microsoft Most Valuable Professional (MVP) who has been consulting in the data analytics and BI domain since 2014 He holds a bachelor's in Electrical Electronics Engineering, a Master of Business Administration, and a Master of Science in Financial Engineering. Despite holding dozens of certifications, he believes that true mastery in the data analytics domain comes from real-world experience Data is as ubiquitous as sand, and everyone can build sand castles. The only people companies value are those who can build lasting high-value glass structures and not just fancy just-for-showoff sand castles. Michael is on a mission to help analytics enthusiasts go from low-value fanciful report builders to builders of robust business-supporting valuable reports
“Acerca de” puede pertenecer a otra edición de este título.
preigu
Osnabrück, Alemania
Vendedor de IberLibro desde 5 de agosto de 2024
Tarifas de envío de Alemania a Estados Unidos de America
| Artículo | De 60 a 60 días hábiles | De 60 a 60 días hábiles |
|---|---|---|
| Primer artículo | EUR 70,00 | EUR 70,00 |
Métodos de pago
- PayPal
Descripción de la tienda
preigu betreibt einen Onlineversandhandel mit über 1 Mio. Produkten in verschiedenen Sortimenten. Das Kernsortiment besteht aus Büchern, Medien und Spielwaren. Ein gelungenes Einkaufserlebnis ist das Ziel einer jeden Bestellung bei preigu, denn der Kunde und seine Zufriedenheit stehen an erster Stelle. preigu setzt daher auf einen kompetenten Kundenservice, funktionierende Prozesse und schnelle Reaktion.
Especialidad
Bücher, SpielwarenInformación empresarial del vendedor
preigu GmbH & Co. KG
Lengericher Landstraße 19
Osnabrück, Alemania 49078
Condiciones de venta
About Us
Legal website operator identification:
preigu GmbH & Co. KG
Lengericher Landstr. 19
49078 Osnabrück
Germany
Telephone: +49 (0) 541 / 580 72 84
Email: mail@preigu.de
VAT No: DE 455 380 498
AG Osnabrück - HRA 209647
PhG: preigu Verwaltung GmbH
AG Osnabrück - HRB 221793
CEO: Ansas Meyer
We are neither willing nor obliged to participate in dispute resolution proceedings before consumer arbitration boards.
We are a member of the initiative "FairCommerce" since 30.11.2016.
For more information, see: https://www.haendlerbund.de/de/haendlerbund/interessenvertretung/faircommerce
Derecho al desistimiento
Instructions for revocation
Right of withdrawal for the sale of goods
Revocation right for consumers
(A ‘consumer' is any natural person who concludes a legal transaction which, to an overwhelming extent, cannot be attributed to either his commercial or independent professional activities.)
Instructions for revocation
Revocation right
You have the right to revoke this contract within 14 days without specifying any reasons.
The revocation period is 14 days with effect from the day,
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the products, provided you had ordered one or more products within the scope of a standard order and this/these product/products is/are delivered uniformly;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last product, provided you had ordered several products within the scope of a standard order and these products are delivered separately;
-
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last part delivery or the last unit, provided you had ordered a product, which is delivered in several part deliveries or units;
To exercise your right of withdrawal, you must inform us (preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Telephone number: +49 (0) 541 / 580 72 84, E-Mail address: mail@preigu.de) by means of a clear declaration (e.g. a letter sent by post, or an e-mail) of your decision to withdraw from this contract. You can use the attached model withdrawal form for this purpose, which is, however, not mandatory.
You can also exercise your right of withdrawal online by clicking on a button labelled accordingly (such as ‘Withdraw from contract' or similar) on the AbeBooks/ZVAB website. If you use this online function, you will immediately receive a confirmation of receipt on a durable medium (e.g. via email) containing information on the content of the withdrawal notice, as well as the date and time of its receipt.
In order to safeguard the revocation period, it is sufficient that you send the notification about the exercise of the revocation right before the expiry of the revocation period.
Consequences of the revocation
If you revoke this contract, we shall repay all the payments, which we received from you, including the delivery costs (with the exception of additional costs, which arise from that fact that you selected a form of delivery other than the most reasonable standard delivery offered by us), immediately and at the latest within 14 days from the day on which we received the notification about the revocation of this contract from you. We use the same means of payment, which you had originally used during the original transaction, for this repayment unless expressly agreed otherwise with you; you will not be charged any fees owing to this repayment.
We can refuse the repayment until the products are returned to us or until you have furnished evidence that you have sent the products back to us, depending on whichever is earlier.
You must return or transfer the products to us immediately and, in any case, at the latest within 14 days with effect from the day on which you inform us of the revocation of this contract. The deadline is maintained if you send the products before the expiry of the 14 day deadline.
You bear the direct costs for returning the products.
You must pay for any depreciation of the products only if this depreciation can be attributed to any handling with you that was not necessary for checking the condition, features and functionality of the products.
Criteria for exclusion or expiry
The revocation right is not available for contracts
-
for delivery of products, which are not prefabricated and for whose manufacturing an individual selection or stipulation by the consumer is important or which are clearly tailored to the personal requirements of the consumer;
-
for delivery of products, which can spoil quickly or whose use-by date would be exceeded quickly;
-
for delivery of alcoholic drinks, whose price was agreed at the time of concluding the contract, which however can be delivered 30 days after the conclusion of the contract at the earliest and whose current value depends on the fluctuations in the market, on which the entrepreneur has no influence;
-
for delivery of newspapers, periodicals or magazines with the exception of subscription contracts. The revocation right expires prematurely in case of contracts
-
for delivery of sealed products, which are not suitable for return for reasons of health protection or hygiene if their seal has been removed after the delivery;
-
for delivery of products if they have been mixed inseparably with other goods after the delivery, owing to their condition;
-
for delivery of sound or video recording or computer software in a sealed package if the seal has been removed after the delivery.
Specimen - revocation form
(If you wish to revoke the contract, please fill up this form and send it back to us.)
-
To preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabrück, Email address: mail@preigu.de :
-
I/we () herewith revoke the contract concluded by me/ us () regarding the purchase of the following products ()/
the provision of the following service () -
Ordered on ()/ received on ()
-
Name of the consumer(s)
-
Address of the consumer(s)
-
Signature of the consumer(s) (only in case of a notification on paper)
-
Date
(*) Cross out the incorrect option.