Envío gratis siempre a todo México.
Haz clic para hacer zoom
Not Available
Bernard Obeng
Data Modeling with Microsoft Excel
Cargando comentarios…
Comparte
$575
$546
Envío gratis siempre
Comentarios
Cargando el resumen…
Cargando comentarios…
product
1185171Data Modeling with Microsoft Excelhttps://www.gandhi.com.mx/data-modeling-with-microsoft-excel/phttps://gandhi.vtexassets.com/arquivos/ids/363580/302cdd34-17e7-4d18-9937-33aba41873c3.jpg?v=638429234427870000546575MXNPackt PublishingInStock/Ebooks/1175811Data Modeling with Microsoft Excel546575https://www.gandhi.com.mx/data-modeling-with-microsoft-excel/phttps://gandhi.vtexassets.com/arquivos/ids/363580/302cdd34-17e7-4d18-9937-33aba41873c3.jpg?v=638429234427870000InStockMXN99999DIEbook20239781803236926_W3siaWQiOiIyZTc4ZDcwYS02MzAxLTQwNTAtOGQ3ZS1mY2QzMDZhZjg2YzciLCJsaXN0UHJpY2UiOjU3NSwiZGlzY291bnQiOjI5LCJzZWxsaW5nUHJpY2UiOjU0NiwiaW5jbHVkZXNUYXgiOnRydWUsInByaWNlVHlwZSI6Ildob2xlc2FsZSIsImN1cnJlbmN5IjoiTVhOIiwiZnJvbSI6IjIwMjUtMDMtMTRUMDg6MDA6MDBaIiwicmVnaW9uIjoiTVgiLCJpc1ByZW9yZGVyIjpmYWxzZX1d9781803236926_<p><strong>Save time analyzing volumes of data using a structured method to extract, model and create insights from your data</strong></p><h4>Key Features</h4><ul><li>Master in using Excels Data Model and Power Pivot to connect and analyze multiple sources of data</li><li>Create key performance indicators for decision making using DAX and Cube Functions</li><li>Apply the knowledge to build an interactive dashboard that delivers key insights to your users</li></ul><h4>Book Description</h4><p>Microsoft Excel BI solutions have gradually evolved over the years to give users flexibility and more control in analyzing large volumes of data from multiple sources without stepping out of Excel. From the introduction of Pivot Tables, the x-velocity engine, the Data Model, Power Query, and Power Pivot, users of Microsoft Excel are now equipped to get, transform, model, aggregate, and visualize data using the worlds most popular spreadsheet</p><p>Data modeling with Microsoft Excel book offers a practical way to de-mystify the use and application of these tools using real-world examples and simple illustrations. The book will introduce to the world of Data Modeling in Excel, definitions, and best practices in data structuring (that is, normalized and denormalized data). It will then take a guided journey to make you understand the useful features of the Data Model and Power Pivot. You will learn the types of schemas, (snowflake and star), and create relationships within multiple tables. You will also understand how to create powerful and flexible measures using DAX and cube functions</p><p>By the end this book you will be able to apply the knowledge in a real-world case study and build an interactive dashboard for decision making</p><h4>What you will learn</h4><ul><li>Implement the concept of Data Modelling within and beyond Excel</li><li>Get, transform, model, aggregate and visualize data with Power Query</li><li>Understand the best practices with data structuring in MS Excel</li><li>Build powerful measures using DAX from the Data Model</li><li>Generate flexible calculations using Cube functions</li><li>Design engaging Dashboards for your users</li></ul><h4>Who This Book Is For</h4><p>This book is for Data Analysts looking for hands-on and effective methods to manage and analyze large volumes of data within Microsoft Excel using Power Pivot. If you are new or already conversant with Excels Data Analytics tools, this book will give you further insights on how you can apply Excels Power Pivot, Data Model, DAX Measures, and Cube Functions to save you time on routine data management tasks. This book can also be referred by students who are warming up to get into Data Science, the book offers a broad foundation for you to build on and transition into other tools like Power BI</p><h4>Table of Contents</h4><ol><li>Getting Started with Data Modeling Overview and Importance</li><li>Data Structuring for Data Models</li><li>Preparing your Data for the Data Model</li><li>Data Modeling with Power Pivot</li><li>Creating DAX Calculations from your Data Model</li><li>Creating Cube Functions from your Data Model</li><li>Communicating insights from your Data Model using Dashboards</li><li>Visualization Elements for your Dashboard</li><li>Choosing the right Design Themes</li><li>Publication and Deployment</li></ol>...(*_*)9781803236926_<p><b>Save time analyzing volumes of data using a structured method to extract, model, and create insights from your data</b></p><h2>Key Features</h2><ul><li>Acquire expertise in using Excels Data Model and Power Pivot to connect and analyze multiple sources of data</li><li>Create key performance indicators for decision making using DAX and Cube functions</li><li>Apply your knowledge of Data Model to build an interactive dashboard that delivers key insights to your users</li><li>Purchase of the print or Kindle book includes a free PDF eBook</li></ul><h2>Book Description</h2>Microsoft Excels 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. Youll also understand how to create powerful and flexible measures using DAX and Cube functions. By the end of this book, youll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions.<h2>What you will learn</h2><ul><li>Implement the concept of data modeling within and beyond Excel</li><li>Get, transform, model, aggregate, and visualize data with Power Query</li><li>Understand best practices for data structuring in MS Excel</li><li>Build powerful measures using DAX from the Data Model</li><li>Generate flexible calculations using Cube functions</li><li>Design engaging dashboards for your users</li></ul><h2>Who this book is for</h2><p>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 youre new or already familiar with Excels 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 Excels features like tables, PivotTable, and some basic aggregating functions will be helpful but not necessary to make the most of this book.</p>...9781803236926_Packt Publishinglibro_electonico_2b132fb6-9d5e-3d3e-9803-c220d3180e99_9781803236926;9781803236926_9781803236926Bernard ObengInglésMéxicohttps://getbook.kobo.com/koboid-prod-public/packt-epub-e7d4ba10-6a2a-4723-8f75-181a6a38d803.epub2023-11-30T00:00:00+00:00Packt Publishing