Items related to Data Modeling with Microsoft Excel: Model and analyze...

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

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

Synopsis

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

  1. Getting Started with Data Modeling – Overview and Importance
  2. Data Structuring for Data Models
  3. Preparing your Data for the Data Model
  4. Data Modeling with Power Pivot
  5. Creating DAX Calculations from your Data Model
  6. Creating Cube Functions from your Data Model
  7. Communicating insights from your Data Model using Dashboards
  8. Visualization Elements for your Dashboard
  9. Choosing the right Design Themes
  10. Publication and Deployment

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

About the Author

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

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

Buy Used

Condition: Very Good
Zustand: Gut | Seiten: 316 | Sprache...
View this item

£ 7.71 shipping from Germany to United Kingdom

Destination, rates & speeds

Search results for Data Modeling with Microsoft Excel: Model and analyze...

Stock Image

Boateng, Bernard Obeng
Published by Packt Publishing, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
Used Softcover

Seller: Buchpark, Trebbin, Germany

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Gut. Zustand: Gut | Seiten: 316 | Sprache: Englisch | Produktart: Bücher. Seller Inventory # 42950878/3

Contact seller

Buy Used

£ 16.59
Convert currency
Shipping: £ 7.71
From Germany to United Kingdom
Destination, rates & speeds

Quantity: 1 available

Add to basket

Stock Image

Boateng, Bernard Obeng
Published by Packt Publishing, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 47130113-n

Contact seller

Buy New

£ 32.09
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Bernard Obeng Boateng
Published by Packt Publishing, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New Softcover

Seller: Ria Christie Collections, Uxbridge, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. In. Seller Inventory # ria9781803240282_new

Contact seller

Buy New

£ 32.10
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Bernard Obeng Boateng
Published by Packt Publishing Limited, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New PAP
Print on Demand

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781803240282

Contact seller

Buy New

£ 32.65
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Boateng, Bernard Obeng
Published by Packt Publishing, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
Used Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 47130113

Contact seller

Buy Used

£ 34.72
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Bernard Obeng Boateng
Published by Packt Publishing Limited, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New Paperback / softback
Print on Demand

Seller: THE SAINT BOOKSTORE, Southport, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 526. Seller Inventory # C9781803240282

Contact seller

Buy New

£ 35.42
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Bernard Obeng Boateng
Published by Packt Publishing, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New Softcover

Seller: California Books, Miami, FL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # I-9781803240282

Contact seller

Buy New

£ 29.94
Convert currency
Shipping: £ 7.45
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Bernard Obeng Boateng
Published by Packt Publishing Limited, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New PAP
Print on Demand

Seller: PBShop.store US, Wood Dale, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781803240282

Contact seller

Buy New

£ 37.87
Convert currency
Shipping: FREE
From U.S.A. to United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Seller Image

Bernard Obeng Boateng
Published by Packt Publishing Limited, GB, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New Paperback

Seller: Rarewaves.com UK, London, United Kingdom

Seller rating 4 out of 5 stars 4-star rating, Learn more about seller ratings

Paperback. Condition: New. Data Modeling with Microsoft Excel is a practical guide to unlocking the benefits of Microsoft Excel's Data Model. The book simplifies the data modeling process to help you master effective ways to build relational data from multiple sources in Excel, create DAX and Cube calculations, and apply your learnings to build an interactive dashboard in Excel. Seller Inventory # LU-9781803240282

Contact seller

Buy New

£ 38.03
Convert currency
Shipping: FREE
Within United Kingdom
Destination, rates & speeds

Quantity: Over 20 available

Add to basket

Stock Image

Boateng, Bernard Obeng
Published by Packt Publishing, 2023
ISBN 10: 1803240288 ISBN 13: 9781803240282
New Softcover
Print on Demand

Seller: Majestic Books, Hounslow, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Print on Demand. Seller Inventory # 397854236

Contact seller

Buy New

£ 35.24
Convert currency
Shipping: £ 3.35
Within United Kingdom
Destination, rates & speeds

Quantity: 4 available

Add to basket

There are 10 more copies of this book

View all search results for this book