Collect, Combine, and Transform Data Using Power Query in Excel and Power BI
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Business applications > Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: (Business Skills)
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: (Business Skills)

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: (Business Skills)


     0     
5
4
3
2
1



International Edition


X
About the Book

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you're finished, you'll be ready to wrangle any data - and transform it into actionable knowledge. Samples Preview sample pages from Collect, Combine, and Transform Data Using Power Query in Excel and Power BI >

Table of Contents:
Section 1: Transforming Data Chapter 1: Introduction to Power Query Chapter 2: Basic Data Challenges Chapter 3: Combining Data from Multiple Sources Chapter 4: Unpivoting and Transforming Data Chapter 5: Pivoting & Handling Multiline Records Section 2: Exploring Data Chapter 6: Ad-Hoc Analysis Chapter 7: Using Query Editor to Further Explore Data Section 3: Scaling Up Queries for Production or Larger Data Sets Chapter 8: Introduction to the M Query Language Chapter 9: Lightweight modification of M formulas to improve query robustness Section 4: Real Life Challenges Chapter 10: Solving Real-Life Data Challenges Chapter 11: Social Listening Chapter 12: Text Analytics Chapter 13: Concluding Exercise – Hawaii Tourism Data

About the Author :
Gil Raviv is a Microsoft MVP and a Power BI blogger. As a Senior Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query as the next-generation Get Data and data-wrangling technology in Excel 2016, and he has been a devoted M practitioner ever since. With 20 years of software development experience, and four U.S. patents in the fields of social networks, cyber security, and analytics, Gil has held a variety of innovative roles in cyber security and data analytics, and he has delivered a wide range of software products, from advanced threat detection enterprise systems to protection of kids on Facebook.


Best Sellers


Product Details
  • ISBN-13: 9781509307951
  • Publisher: Microsoft Press,U.S.
  • Publisher Imprint: Microsoft Press
  • Height: 230 mm
  • No of Pages: 432
  • Series Title: Business Skills
  • Weight: 884 gr
  • ISBN-10: 1509307958
  • Publisher Date: 19 Dec 2018
  • Binding: Paperback
  • Language: English
  • Returnable: Y
  • Spine Width: 25 mm
  • Width: 190 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: (Business Skills)
Microsoft Press,U.S. -
Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: (Business Skills)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Collect, Combine, and Transform Data Using Power Query in Excel and Power BI: (Business Skills)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!