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” のチェックボックスを選択し、”編集”をクリックします。   ■データの加工 取得したデータを分析しやすい形にするため、加工をしていきます。 まず、“発生時刻” 列を選択した状態で、”変換” メニューの ”値の置換” をクリックし、”ごろ” を削除します。…


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 (麻の葉)…


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…


Get Inspired To Start Your Own Business!

Imagine Cup Poland Success Stories is a blog dedicated to young people who want to start their own business and are looking for inspiration. Here you can find stories about students from Poland who turn their innovative ideas into real business. They will share their experience on how they got started, what challenges they had on their way and how they overcame it. Read more about these…


Scripting learning resources

Scripting Guide https://technet.microsoft.com/en-us/library/ee692931.aspx FileSystemObject Managing Disk Drives Returning a Collection of Disk Drives Binding to a Specific Disk Drive Enumerating Disk Drive Properties Ensuring That a Drive is Ready Binding to a Folder Verifying That a Folder Exists Creating a Folder Deleting a Folder Copying a Folder and Its Contents Moving a Folder and Its…


My Personal Azure FAQ on Azure Networking and ARM

Last updated: July 24, 2016. IMPORTANT: The information I reported in this post is time sensitive since may change in the future. I will try to maintain the content updated, but you should double–check with official Azure documentation sources. This is a new article specifically focused on ARM, you can find a previous old one…


三緯國際力攻機器人市場,加速跨平台開發 以 Microsoft Xamarin 橫跨多重平台及開發團隊轉換程式,確保服務功能及效能一致性

對於未來科技的想像正在付諸實現,三緯國際以「XYZ robot」自有品牌行銷服務型機器人與教育娛樂型機器人,不僅在台灣嶄露頭角,並已打進美、日等地市場,商用化的速度和成熟度領先競爭對手。


MSN News app now supports a new Dark Theme

Hello, everyone! Dark Theme has been a consistent top feedback point for the MSN News app. Back in January we released dark theme for articles to help with nighttime reading, but this did not extend to the full MSN News experience. Now, we are very happy to respond to your feedback, and showcase a new and…