towards data science logo

Drag And Drop Data Analysis With Datameer: A Walkthrough

  • Towards Data Science
  • December 3, 2021

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;

    More Resources We Think You Might Like

    The Impact of the Data Engineering Talent Shortage

    The demand for data engineers has consistently been more significant than the supply ever since t...

    • John Morrell
    • January 28, 2022

    Announcing the Datameer + Snowflake Partnership

    Datameer announces partnership with Snowflake to enable customers, regardless of programming skil...

    • Press Release
    • January 25, 2022
    tdwi logo

    How to Create an Agile Analytics Process: RIP, ...

    Having the proper data modeling and transformation tools will help you create an agile, modern an...

    • TDWI
    • January 24, 2022