DAX入門(3) 相対日付 (Relative date) の実装 -地震速報の可視化-

Microsoft Japan Data Platform Tech Sales Team 土井 貴彦 DAX 入門 第 3 回目では、前回の応用として、相対日付の実装について触れます。 今回は 地震速報 データを使って、今日何時に地震が起きたか? 昨日起きた地震の最大震度は? 直近一週間何件地震があったか?といった形で相対日付で可視化するレポートを作ってみます。 作成するレポートは以下のようなイメージです。スマホで閲覧されている場合は こちらのリンク を参照ください   ■データの取得 まず、前回の記事で作成したカレンダーテーブルを使うので こちら からダウンロードください。 pbix ファイルを開いて、”データを取得” メニューから “Web” を選択します。   URL に http://typhoon.yahoo.co.jp/weather/jp/earthquake/list/ を入力し、OK をクリックします。 (データ出典:Yahoo! Japan 天気・災害)   ナビゲーター画面では “Table 0” のチェックボックスを選択し、”編集”をクリックします。   ■データの加工 取得したデータを分析しやすい形にするため、加工をしていきます。 まず、“発生時刻” 列を選択した状態で、”変換” メニューの ”値の置換” をクリックし、”ごろ” を削除します。…


HDinsight – How to use Spark-HBase connector?

Apache Spark is an open-source parallel processing framework that supports in-memory processing to boost the performance of big-data analytic applications. Azure HDInsight offers a fully managed Spark service with many benefits. Apache HBase is an open Source No SQL Hadoop database, a distributed, scalable, big data store. It provides real-time read/write access to large datasets….


Share some great quote from Ren Zhengfei , CEO of Huawei

Share some great quote from Ren Zhengfei , CEO of Huawei “Bigger than the world of the world, is your mind. ” we can’t use the term “fail” any more in the future,  you want to use “exploration”  instead, since “heroes, defeated heroes.” We need analyze the success or failure of the project, even it…


DSC Position Request with Standard Horizon GX2200 and Lowrance Link8

One of the challenges of using VHF is discussing your fishing secrets you are sharing them with the entire world. DSC Calling can briefly solve this by enabling you to call a particular person and having them switch to an obscure channel (like #6) -but this conversation is still in the “open” and as most boats will scan all the…


Small Basic – Traditional Patterns

Do you know any traditional patterns in your country?  In Japan, there are a lot of patterns.  Today I introduce some of them.  If you can decompose a pattern into some shapes (such like rectangles, ellipses, triangles or lines), you can code to draw the pattern. Yagasuri (矢絣) – designed feathers of arrows Asanoha (麻の葉)…


HDinsight – How to use Spark-HBase connector?

Apache Spark is an open-source parallel processing framework that supports in-memory processing to boost the performance of big-data analytic applications. Azure HDInsight offers a fully managed Spark service with many benefits. Apache HBase is an open Source No SQL Hadoop database, a distributed, scalable, big data store. It provides real-time read/write access to large datasets….


Happy First Birthday to Power BI!

Happy Birthday to Power BI! Today marks one year since Power BI released to GA (general availability) on July 24, 2015. Since then, it has had an incredible impact on the industry and on many individuals, including me. I’ve spent nearly the entire year learning and improving my skills with Power BI, and have had the chance to…


Froggy goes to Seattle: Dalam Perjalanan

Catatan: blog post ini dibuat selama dalam pesawat menuju Dubai, dan di-posting ketika sedang transit di Dubai. Wow, Froggy akhirnya sedang dalam perjalanan ke Seattle! Rombongan Froggy terpisah jadi dua, dengan rombongan utama (2 anggota tim, 1 mentor dan 2 pendamping dari Microsoft Indonesia) berangkat hari Minggu sore dengan Emirates (transit di Dubai), sedangkan 2…


Microsoft & SQL Pass, Lahore collaborate to bring an exclusive event for Data Professionals

Microsoft Innovation Center, Lahore in collaboration with SQL Pass, Lahore brings a unique meetup where Data Professionals Connect, Share & Learn on 3rd August, 2016 from 3:00 PM – 6:00 PM. Please note that Registration is mandatory. Registration Process Please send an email at lahore@sqlpass.org with title “SQL Pass Lahore Conference August 2016 Registration” and…