fbpx
Skip to content
DataChant
Menu
  • Book
    • Book Q&A
    • Excerpts & Extras
  • About
    • About Gil
    • Terms of service
    • Privacy Policy
  • Power BI Apps on AppSource
    • Compare data in Excel
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Custom Visuals Exploration Tool
    • Power BI Apps on AppSource – Exploration Tool
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Twitter Dashboard
    • Power BI Apps – Support Page
  • Book
    • Book Q&A
    • Excerpts & Extras
  • About
    • About Gil
    • Terms of service
    • Privacy Policy
  • Power BI Apps on AppSource
    • Compare data in Excel
    • Mailchimp
    • ActiveCampaign
    • ActiveCampaign PBIX Instructions
    • Custom Visuals Exploration Tool
    • Power BI Apps on AppSource – Exploration Tool
    • Dataflows Snapshot Analysis
    • Power Apps Dataflows Snapshot Analysis
    • Twitter Dashboard
    • Power BI Apps – Support Page

Tag: Bonus Exercise

Find overlapping time periods using #PowerQuery – Part 3 (Fast & Furious)

Gil RavivJuly 31, 20192
In the last post here, we walked through the steps to detect overlapping time periods and calculate their durations. We used Cartesian Product to match...

Find overlapping time periods using #PowerQuery – Part 2

Gil RavivJuly 22, 201918
In my last blog post here, I introduced the overlapping time periods challenge and shared the M queries for the solution. In today's post, we will go...
Book

Preserving context from multiple worksheets – Bonus Exercise – Chapter 5 – #PowerQuery Book

Gil RavivDecember 7, 20183
This is the third bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. Today's bonus exercise takes...
Book

Preserving Context from CSV – Bonus Exercise – Chapter 5 – #PowerQuery Book

Gil RavivNovember 15, 20180
This is the second bonus exercise for my book, Collect, Combine, and Transform Data using Power Query in Excel and Power BI. In Chapter 5 you learn how to...
Book

Finding mismatched headers and creating a conversion table – Bonus Exercise – Chapter 4 – #PowerQuery Book

Gil RavivOctober 26, 20182
This is the first post of a series of bonus exercises that will accompany my book, Collect, Combine, and Transform Data using Power Query in Excel and Power...

Write a Review

Install our Power BI Apps on AppSource

Tags

#MSDataSummit AppSource Bad Practices Bonus Exercise Book COVID-19 Custom Visuals Data Quality Automation DAX Excel Excel 2016 Facebook Facebook bug Facebook Insights Facebook Reactions Get & Transform Jedi List.Accumulate List.Generate Logs MailChimp Microsoft Cognitive Services Multiline records MVP Pitfalls PivotTable Power BI Power BI Governance Power Pivot Power Query Power Query Book Robust Queries Sentiment Analysis Star Wars Subscribers Tableau vs Power BI Template Apps Text Analytics Twitter Analytics Unpivot Update US Election Candidates US Presidential Candidates Webinar Web Scraping

Blog Stats

  • 1,667,488 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 2023 DataChant.com All Rights Reserved

 

Loading Comments...