Part 1 - Data Modeling with Power BI and Power Query
Blog: https://www.taygan.co/blog/2018/06/10...
Part 2: • Part 2 - Data Visualization and Report Aut...
Part 3: • Part 3 - Dashboard Building and Power BI S...
In part 1 of our "Getting Started with Power BI" series, we look at how Power BI Desktop can connect to various data sources (an Excel spreadsheet, a CSV file and a JSON document) and how that data can be enriched, transformed and modeled for reporting.
** Resources **
Logo: https://www.taygan.co/s/icon.png
Market Values (XLS): https://www.taygan.co/s/values.xlsx
Currencies (CSV): https://www.taygan.co/s/names.csv
Marketshare (JSON): https://www.taygan.co/s/marketshare.json
** Formulas **
Add a column to uniquely identify each row prior to appending the queries together
Symbol = "BTC"
Note: Bitcoin = BTC, Bitcoin Cash = BTH, Ethereum = ETH, Ripple = XRP
Convert the Epoch value into a Date/Time
Date = #datetime(1970,1,1,0,0,0)+#duration(0,0,0,[Epoch]/1000)
Create a Date table using DAX
Date = CALENDARAUTO(6)
Date Attributes
Year = YEAR('Date'[Date])
Month = FORMAT('Date'[Date], "Mmm")
Day = DAY('Date'[Date])