Drag And Drop Data Analysis With Datameer: A Walkthrough

  • Towards Data Science
  • December 3, 2021
towards data science logo

This was originally published on Towards Data Science

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author

Image by author
select * from F_STREAMS_DATES_TRACKS_AGG_G1 AS FG1
ORDER BY FG1.TIME_STAMP;

Image by author
SELECT TO_DATE(FS.Time_Stamp) as Stream_Date, DT.Track_Name, COUNT(FS.Streams_Key)
FROM EDW.FACTS.F_STREAMS as FS
INNER JOIN EDW.DIMS.D_Tracks DT ON FS.Tracks_Key = DT.Tracks_Key
GROUP BY TO_DATE(FS.Time_Stamp), DT.Track_Name
HAVING COUNT(FS.Streams_Key) > 1;

    Related Posts

    Data Collection: A Definitive Guide

    • Jeffrey Agadumo
    • February 8, 2023