Power Query has number of Date and Time functions that convert values to date and time. However I haven’t found a function that converts a timestamp value. Fortunately it is easy to calculate a date time from a timestamp value. In this post I’ll explain an easy way of converting timestamp to date time. To Read more about Power Query; Convert Time Stamp to Date Time[…]
You have seen previously how we can use output of Azure ML model in a Power BI and visualize it with SandDance. In this video you will learn how to use R script as a source in Power BI desktop. Watch the video below;
You’ve seen a number of custom visualizations of Power BI that we’ve used in Power BI online book previously. In this post you will learn through a quick video how SandDance custom visualization of Power BI can be used to visualize clustering result set of an Azure Machine Learning model. In this video I’ll start Read more about Azure Machine Learning with Power BI SandDance Visualization[…]
Join me to learn about Data Preparation with Power Query and Power BI. This free webinar hosted by Power BI team and I will speak about techniques in Power Query that helps you transform the data and prepare it in the way required for your business. Expect many demos in this session from Power Query Read more about Data Preparation is the Keystone – Free Webinar[…]
It is my pleasure to speak in PASS 24 Hours session for Evolution of Data Platform on the topic above. I look forward to meet you all in this webinar. registration is free, but limited. So reserve your seat now. Here are some information about my session and 24HOP. 24HOP 24 Hours of PASS is Read more about Temporal Tables and Their Roles in ETL and Data Warehouse[…]
Sqlbits 2016 was my first SqlBits ever, after few efforts in past few years. This time I managed to go to Liverpool, and meet many friends from UK and Europe who I haven’t met in person before. It was a pleasure to meet you all there. In this post I’ve shared my session slides. I Read more about Slides of My Session at SqlBits 2016: Azure Data Factory vs SSIS[…]
I have to first and foremost thanks to all attendees to my session at PASS Business Analytics 2016 conference, It was pleasure to have you all. Some of you mentioned that you are already using some contents from my blog which is great, and I’m humbled to hear this. I’ll definitly do more effort to Read more about Slides and Materials for PASS BA 2016 Conference[…]
Previously You have seen in Part 1 and Part 2 of this series, that how you can use Power Query to do data transformation and turn the result of event date/time scheduler of timeanddate.com website to a better format. We’ve used number of basic transformations, and some functions such as Table.Transpose to fetch desired output. Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 3[…]
In first part of this series I’ve explained that Power Query can be used for non-BI scenarios, and here is a real-world use case example; Creating an event date and time scheduler which consider multiple time zones. In previous post you’ve learned how to use Power Query to do some data mash up to build Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 2[…]
Previously you have read how to use Power Query as the data transformation component of Power BI and you learned how to use it in BI applications. You can read more about Power Query usage in BI in Power BI online book from Rookie to Rock Star. In this series I will explain how to Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 1[…]