fbpx
Skip to content
DataChant
Menu
  • Shop
    • All Products
  • Book
    • Book Q&A
    • Excerpts & Extras
  • Subscribe
  • Popular Articles
    • Popular
    • Facebook Insights
    • Sentiment Analysis
    • What is Power Query?
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery
  • Shop
    • All Products
  • Book
    • Book Q&A
    • Excerpts & Extras
  • Subscribe
  • Popular Articles
    • Popular
    • Facebook Insights
    • Sentiment Analysis
    • What is Power Query?
  • About
    • About Gil
    • Subscriber’s Corner
    • Archived Gallery

Tag: PivotTable

Power Query

Transform ANY nested table to Pivot Table with function query

Gil RavivJanuary 3, 20163
Get ready to be amazed :) This is the fourth post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you...
Power Query

Transform a nested table to PivotTable

Gil RavivJanuary 3, 20160
This is the third post in the series The Definitive Guide to Unpivot with Power Query in Excel. In this series we walk you through one of the coolest data...
Power Query

Back to School – Transform class schedule to PivotTable

Gil RavivJanuary 3, 20161
Back to school with Excel & Power Query This is the second post in the series The Definitive Guide to Unpivot with Power Query in Excel. For today's post...
Excel for Security Analysts

Excel for Security Analysts – Intro

Gil RavivJanuary 3, 20160
(Originally published here) The demo I will share with you today is something that I was itching to try for a while. Before I joined Microsoft and Excel team,...

Write a Review

Install DataChant Template Apps from AppSource

Custom Visuals Exploration Tool

Tags

#MSDataSummit 2017 Year in Review Add Column by Example AppSource Bonus Exercise Book Columns From Example Custom Visuals DAX Event Excel Excel 2016 Facebook Facebook bug Facebook Insights Facebook Reactions Get & Transform Jedi List.Accumulate List.Generate Logs Microsoft Cognitive Services Multiline records MVP Opponent Mentions Pitfalls PivotTable Power BI Power Pivot Power Query Pulse Chart RLS Robust Queries Sentiment Analysis Star Wars Subscribers Tableau vs Power BI Template Apps Text Analytics Twitter Analytics Unpivot US Election US Election Candidates US Presidential Candidates Web Scraping

Blog Stats

  • 737,914 Views
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
  • Home
  • Shop
  • Book
  • About

Copyright 2019 DataChant All Rights Reserved