Extending Power BI with Python and R: Ingest, transform, enrich, and visualize data using the power of analytical languages
Language: English
Published by Packt Publishing, 2021
- Softcover
- Used
Condition: Used - Very good
£ 29.27
Quantity: 1 available
Add to basketItem description from seller
Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages.
Seller Inventory # M01801078203-V
- Title
- Extending Power BI with Python and R: Ingest, transform, enrich, and visualize data using the power of analytical languages
- Author
- Luca Zavarella
- Publisher
- Packt Publishing
- Publication year
- 2021
- Condition
- very good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 1801078203
- ISBN 13
- 9781801078207
Perform more advanced analysis and manipulation of your data beyond what Power BI can do to unlock valuable insights using Python and R
Key Features
- Get the most out of Python and R with Power BI by implementing non-trivial code
- Leverage the toolset of Python and R chunks to inject scripts into your Power BI dashboards
- Implement new techniques for ingesting, enriching, and visualizing data with Python and R in Power BI
Book Description
Python and R allow you to extend Power BI capabilities to simplify ingestion and transformation activities, enhance dashboards, and highlight insights. With this book, you'll be able to make your artifacts far more interesting and rich in insights using analytical languages.
You'll start by learning how to configure your Power BI environment to use your Python and R scripts. The book then explores data ingestion and data transformation extensions, and advances to focus on data augmentation and data visualization. You'll understand how to import data from external sources and transform them using complex algorithms. The book helps you implement personal data de-identification methods such as pseudonymization, anonymization, and masking in Power BI. You'll be able to call external APIs to enrich your data much more quickly using Python programming and R programming. Later, you'll learn advanced Python and R techniques to perform in-depth analysis and extract valuable information using statistics and machine learning. You'll also understand the main statistical features of datasets by plotting multiple visual graphs in the process of creating a machine learning model.
By the end of this book, you’ll be able to enrich your Power BI data models and visualizations using complex algorithms in Python and R.
What you will learn
- Discover best practices for using Python and R in Power BI products
- Use Python and R to perform complex data manipulations in Power BI
- Apply data anonymization and data pseudonymization in Power BI
- Log data and load large datasets in Power BI using Python and R
- Enrich your Power BI dashboards using external APIs and machine learning models
- Extract insights from your data using linear optimization and other algorithms
- Handle outliers and missing values for multivariate and time-series data
- Create any visualization, as complex as you want, using R scripts
Who this book is for
This book is for business analysts, business intelligence professionals, and data scientists who already use Microsoft Power BI and want to add more value to their analysis using Python and R. Working knowledge of Power BI is required to make the most of this book. Basic knowledge of Python and R will also be helpful.
Table of Contents
- Where and How to Use R and Python Scripts in Power BI
- Configuring R with Power BI
- Configuring Python with Power BI
- Importing Unhandled Data Objects
- Using Regular Expressions in Power BI
- Anonymizing and Pseudonymizing Your Data in Power BI
- Logging Data From Power BI To External Sources
- Loading Large Datasets Beyond the Available RAM in Power BI
- Calling External APIs to Enrich Your Data
- Calculating Columns Using Complex Algorithms
- Adding Statistics Insights: Associations
- Adding Statistics Insights: Outliers and Missing Values
- Using Machine Learning Without Premium or Embedded Capacity
- Exploratory Data Analysis
- Advanced Visualizations
- Interactive R Custom Visuals
"Synopsis" may belong to another edition of this title.
About the Author
"About the title" may belong to another edition of this title.
Shipping rates from Germany to U.S.A.
| Item | 10 to 20 business days | 10 to 20 business days |
|---|---|---|
| First item | £ 8.34 | £ 16.69 |
Payment methods
Store description
**WILLKOMMEN** im AbeBooks Shop von medimops - dein Onlineshop mit der größten Auswahl an Second Hand Büchern. Stöber dich durch über 4 Millionen Artikel und spare bis zu 70 % im Vergleich zum Neupreis. Wir prüfen alle Artikel sorgfältig auf Qualität und Funktionalität. **WELCOME** to the medimop's AbeBooks shop, the online shop with a large range of second-hand books. Browse more than 4 million articles and save up to 70% on the new price. All our articles are quality checked. ** BIENVENUE ** dans la boutique AbeBooks de momox shop! Spécialiste des articles culturels d'occasion, nous vous offrons une gamme diversifiée de livres d'occasion. Découvrez nos offres et économisez jusqu'à 70% du prix neuf! Nous grarantissons tous nos articles en bon état. ** BENVENUTI ** nello shop medimops di AbeBooks, lo shop online per i libri usati. Abbiamo piu´di 4 milioni di articoli e potete risparmiare fino al 70% rispetto al nuovo. Tutti i nostri prodotti sono controllati a mano per garantire la massima qualità. ** BIENVENIDO ** a la tienda de medimops en AbeBooks, la tienda online con una gran oferta de libros de segunda mano. Navegue por más de 4 millones de artículos y ahorre hasta un 70% sobre el precio nuevo. Todos nuestros artículos son de calidad comprobada. …
Seller's business information
momox SE
Schreiberhauer Straße 30
Berlin, Germany 10317
momox SE | Schreiberhauer Straße 30 | 10317 Berlin
represented by the Board of Management Heiner Kroke (spokesman) and Christian von Hohnhorst
VAT ID: DE266608643
Commercial Register HRB 236261 B | AG Berlin Charlottenburg
Terms of sale
1. Scope
For all orders via our store on the AbeBooks Marketplace, the following terms and conditions apply. Unless otherwise agreed, the inclusion of any terms and conditions of your own used by you is contradicted.
2. contracting party, conclusion of contract, correction options
The purchase contract is concluded with momox SE.
The subject of the contract is the sale of goods.
If an article is posted by us on AbeBooks, the activation of the offer page on AbeBooks is the binding offer to conclude a contract under the conditions contained in the article page.
The presentation of the products in the online store does not constitute a legally binding offer, but a non-binding online catalog. You have the option to complete the ordering process via the shopping cart system or the buy now function. You can initially place our products in the shopping cart without obligation and correct your entries at any time before submitting your binding order by using the correction tools provided and explained for this purpose in the order process. By clicking the order button you make a binding offer for the goods contained in the shopping cart. By pressing the button "Buy now" an order is automatically created, which will be sent to the delivery address you have provided and for which a payment is made with the specified payment method.
The confirmation of receipt of your order will be sent by e-mail immediately after sending the order. We accept your order within 2 days by us or AbeBooks on our behalf submitting/issuing a declaration of acceptance or shipping confirmation in a separate email or, if applicable, the payment transaction is carried out by the service provider or the selected payment service provider. The time of execution of the payment transaction depends on the respective selected payment method (see under "Payment"). The relevant alternative for you depends on which of the listed events occurs first.
3. contract language, contract text storage
The language(s) available for the conclusion of the contract: German
We store the text of the contract on our systems, which, however, are not accessible to you.
However, you have the possibility to view your last orders via your AbeBooks account. The full text of the contract is not accessible there.
4. delivery conditions
Shipping costs will be added to the indicated product prices. You can find out more about the amount of the shipping costs at the offers.
5. payment
The payment processing is done by AbeBooks. You can pay the invoice amount by credit card.
6. retention of title
The goods remain our property until full payment.
7. transport damage
If goods are delivered with obvious transport damage, please complain about such defects to the deliverer as soon as possible and contact us immediately. Failure to make a complaint or contact us has no consequences for your legal claims and their enforcement, especially your warranty rights. However, they help us to be able to assert our own claims against the carrier or the transport insurance.
8. warranty
The statutory liability for defects shall apply.
Customer service: Phone number: 0049 (0) 30/488288200
9 a.m. to 6 p.m., e-mail: service@momox-shop.uk
9. liability
For claims based on damage caused by us, our legal representatives or vicarious agents, we shall always be liable without limitation - in the event of injury to life, limb or health - in the event of intentional or grossly negligent breach of duty - in the event of warranty promises, insofar as agreed, or - insofar as the scope of application of the Product Liability Act is opened. In the event of a breach of essential contractual obligations, the fulfillment of which is a prerequisite for the proper execution of the contract and the observance of which the contractual partner may regularly rely on (cardinal obligations) due to slight negligence on our part, on the part of our legal representatives or vicarious agents, liability shall be limited to the amount of the damage foreseeable at the time of the conclusion of the contract, the occurrence of which must typically be expected. Otherwise, claims for damages are excluded.
10. dispute resolution
The European Commission provides a platform for online dispute resolution (ODR), which can be found here: https://ec.europa.eu/consumers/odr/. Consumers have the possibility to use this platform for the settlement of their disputes.
To settle disputes arising from a contractual relationship with a consumer or whether such a contractual relationship exists at all, we are obliged to participate in dispute resolution proceedings before a consumer arbitration board. The responsible body is the Universalschlichtungsstelle des Bundes am Zentrum für Schlichtung e.V., Straßburger Straße 8, 77694 Kehl am Rhein, www.verbraucher-schlichter.de. We will participate in a dispute resolution procedure before this body.
11. protection of minors
If your order includes goods whose sale is subject to age restrictions, we ensure that the customer has reached the required minimum age by using a reliable procedure involving a personal identity and age check. The delivery person will hand over the goods only after the age check has been carried out and only to the customer in person.
Delivery to packing stations is not possible in this case.
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 medimops, Leipzig, Germany, 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.
Privacy and security
Unless otherwise stated below, the provision of your personal data is neither required by law or contract, nor is it necessary for the conclusion of a contract. You are not obliged to provide the data. Failure to provide it will have no consequences. This applies only insofar as no other indication is made in the following processing operations.
"Personal Data" means any information relating to an identified or identifiable natural person.
Collection, processing and forwarding of personal data for orders
When ordering, we collect and process your personal data only to the extent necessary for the fulfillment and processing of your order and to process your requests. The provision of the data is necessary for the conclusion of the contract. Failure to provide it will result in no contract being concluded. The processing is based on Art. 6 para. 1 lit. b) DSGVO and is necessary for the performance of a contract with you.
Your data is passed on, for example, to the shipping companies and dropshipping providers you have chosen, payment service providers, service providers for order processing and IT service providers. In all cases, we strictly observe the legal requirements. The scope of the data transfer is limited to a minimum.
Duration of storage
After the contract has been fully processed, the data will initially be stored for the duration of the warranty period, thereafter taking into account statutory, in particular tax and commercial law retention periods and then deleted after expiry of the period, unless you have consented to further processing and use.
Rights of the data subject
If the legal requirements are met, you have the following rights according to Art. 15 to 20 DSGVO: the right to information, to correction, to deletion, to restriction of processing, to data portability.
In addition, according to Art. 21 (1) DSGVO, you have the right to object to processing based on Art. 6 (1) f DSGVO and to processing for the purpose of direct marketing.
Contact us if you wish. You can find the contact details in our imprint.
Right of complaint to the supervisory authority
In accordance with Art. 77 DSGVO, you have the right to lodge a complaint with the supervisory authority if you believe that the processing of your personal data is not lawful.
Right of objection
If the personal data processing listed here is based on our legitimate interest according to Art. 6 (1) lit. f DSGVO, you have the right to object to this processing with effect for the future at any time for reasons arising from your particular situation.
After the objection has been made, the processing of the data concerned will be terminated unless we can demonstrate compelling legitimate grounds for the processing which override your interests, rights and freedoms, or if the processing serves the purpose of asserting, exercising or defending legal claims.
If personal data is processed for direct marketing purposes, you may object to this processing at any time by notifying us. After the objection has been made, we will terminate the processing of the data concerned for the purpose of direct marketing.