Instant Creating Data Models with PowerPivot How-to
Language: English
Published by Packt Publishing Limited, GB, 2023
- Softcover
- New
Seller: Rarewaves.com USA, London, London, United KingdomRarewaves.com USA
AbeBooks seller since June 11, 2025
Condition: New
£ 26.59
Quantity: Over 20 available
Add to basketItem description from seller
Build better business intelligence with this practical guide to creating Excel data models with PowerPivot.Key FeaturesLearn something new in an Instant! A short, fast, focused guide delivering immediate resultsDetailed, step-by-step interactive tutorial guide to learning PowerPivotCarefully organized topics for users of all levelsLearn how to make your data accessible and attractiveBook DescriptionMicrosoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computer's powers to draw data from various sources, do analysis across millions of rows of data, and present results in a very unique format.Instant Creating Data Models with PowerPivot How-to is a concise and to-the-point guide that helps you get a jump start on using this strong business intelligence tool, while still working in an environment similar to Excel. You will begin with data generation and manipulation, learning a new feature at each step by building onto the old file, and ultimately creating a comprehensive file.Instant Creating Data Models with PowerPivot How-to will guide the user through database installation, importing data from various sources, creating pivot charts and tables, utilizing a unique feature of PowerPivot called slicers,adding custom columns, and setting custom relationships between data to generate the ultimate customized dataset for analysis. By the end of the book and all the sections of Microsoft PowerPivot for Excel, the reader will be fully experienced and ready to utilize this powerful software.What you will learnInstall a database and import/export data freelyCollect and combine data across various sources and formatsUnderstand relationships between various dataDevelop complex tables and models for future analysisDesign meaningful charts and tables easy for everyone to understandWrite custom codes to modify data to a required formExtend PowerPivot with external programs for further collaborationWho this book is forThis is an introductory book on PowerPivot for basic Excel users who handle lots of data and are willing to go beyond the limitations of Excel without the need to learn a new language from scratch.…
Seller Inventory # LU-9781849689564
- Title
- Instant Creating Data Models with PowerPivot How-to
- Author
- Taehyung Lee
- Publisher
- Packt Publishing Limited, GB
- Publication year
- 2023
- Condition
- New
- Binding
- Digital
- Language
- English
- ISBN 10
- 1849689563
- ISBN 13
- 9781849689564
- Dimensions
- 23.49 x 19.05 x 0.36 cm
Build better business intelligence with this practical guide to creating Excel data models with PowerPivot
Overview
- Learn something new in an Instant! A short, fast, focused guide delivering immediate results
- Detailed, step-by-step interactive tutorial guide to learning PowerPivot
- Carefully organized topics for users of all levels
- Learn how to make your data accessible and attractive
In Detail
Microsoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computers powers to draw data from various sources, do analysis across millions of rows of data, and present results in a very unique format.
Instant Creating Data Models with PowerPivot How-to to is a concise and to-the-point guide that helps you get a jump start on using this strong business intelligence tool, while still working in an environment similar to Excel. You will begin with data generation and manipulation, learning a new feature at each step by building onto the old file, and ultimately creating a comprehensive file.
Instant Creating Data Models with PowerPivot How-to to will guide the user through database installation, importing data from various sources, creating pivot charts and tables, utilizing a unique feature of PowerPivot called slicers,adding custom columns, and setting custom relationships between data to generate the ultimate customized dataset for analysis. By the end of the book and all the sections of Microsoft PowerPivot for Excel, the reader will be fully experienced and ready to utilize this powerful software.
What you will learn from this book
- Install a database and import/export data freely
- Collect and combine data across various sources and formats
- Understand relationships between various data
- Develop complex tables and models for future analysis
- Design meaningful charts and tables easy for everyone to understand
- Write custom codes to modify data to a required form
- Extend PowerPivot with external programs for further collaboration
Approach
Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This is a practical, recipe-based book, taking the reader through the hands-on steps required to set up and use PowerPivot with as little fuss as possible.
Who this book is written for
This is an introductory book on PowerPivot for basic Excel users who handle lots of data and are willing to go beyond the limitations of Excel without the need to learn a new language from scratch.
"Synopsis" may belong to another edition of this title.
About the Author
Leo Taehyung Lee
Leo Taehyung Lee is an outgoing individual with a diverse background and experiences. His studies in engineering along with the pursuit of a career in finance helped him work in various positions across diverse fields from R&D to patents as well as financial risk management. He has over 3 years of extensive experience in Excel, VBA, and is a Microsoft Certified Excel Expert in Excel 2010.
"About the title" may belong to another edition of this title.
Rarewaves.com USA
London, London, United Kingdom
AbeBooks seller since June 11, 2025
Shipping rates from United Kingdom to U.S.A.
| Item | 9 to 14 business days | 9 to 14 business days |
|---|---|---|
| First item | £ 0.00 | £ 0.00 |
Payment methods
Seller's business information
RAREWAVES.COM LIMITED
Elsley Court, 20-22 Great Titchfield Street
London, United Kingdom W1W 8BE
Right of withdrawal
If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.
Information regarding the right of withdrawal
Statutory right to withdraw
You have the right to withdraw from this contract within 14 days without giving any reason.
The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.
To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.
To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.
Effects of withdrawal
If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).
We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.
We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.
We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.
We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.
You shall send back the goods or hand them over to Rarewaves.com USA, Unit 144 The Lightbox, 111 Power Road, W4 5PY, London, London, United Kingdom, without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.
Exceptions to the right of withdrawal
The right of withdrawal does not apply to:
- The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
- The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.
Shipping terms
Please note that we do not offer Priority shipping to any country.
We currently do not ship to the below countries:
Russia
Belarus
Ukraine
Please do not attempt to place orders with any of these countries as a ship to address - they will be cancelled.