Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions by Boateng, Bernard Obeng
Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions by Boateng, Bernard Obeng

Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions

Save time analyzing volumes of data using a structured method to extract, model, and create insights from...
BD$80.24 BMD
BD$80.24 BMD
SKU: 9781803240282
Product Type: Books
Please hurry! Only 159 left in stock
Author: Bernard Obeng Boateng
Format: Paperback
Language: English
Subtotal: BD$80.24
10 customers are viewing this product
Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions by Boateng, Bernard Obeng

Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions

BD$80.24
Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions by Boateng, Bernard Obeng

Data Modeling with Microsoft Excel: Model and analyze data using Power Pivot, DAX, and Cube functions

BD$80.24
Author: Bernard Obeng Boateng
Format: Paperback
Language: English
Description

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.

Author: Bernard Obeng Boateng
Publisher: Packt Publishing
Published: 11/30/2023
Pages: 316
Binding Type: Paperback
Weight: 1.20lbs
Size: 9.25h x 7.50w x 0.66d
ISBN: 9781803240282

This title is not returnable

Shipping & Return

Returns Policy

You may return most new, unopened items within 30 days of delivery for a full refund. We'll also pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.).

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, simply login to your account, view the order using the "Complete Orders" link under the My Account menu and click the Return Item(s) button. We'll notify you via e-mail of your refund once we've received and processed the returned item.

Shipping

We can ship to virtually any address in the world. Note that there are restrictions on some products, and some products cannot be shipped to international destinations.

When you place an order, we will estimate shipping and delivery dates for you based on the availability of your items and the shipping options you choose. Depending on the shipping provider you choose, shipping date estimates may appear on the shipping quotes page.

Please also note that the shipping rates for many items we sell are weight-based. The weight of any such item can be found on its detail page. To reflect the policies of the shipping companies we use, all weights will be rounded up to the next full pound.

Review

Related Products

Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD
Example product title
BD$80.24 BMD
BD$80.24 BMD

Recently Viewed Products