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[…]
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[…]
Almost couple of weeks ago Power BI update added the new functionality in security. This functionality enables you to apply row level security to roles and add users under each role. This is really helpful when you want people from one branch, city, department, or store to be able to only see their part of Read more about Row Level Security in Power BI; Regardless of Data Source[…]
In every reporting solution you might feel KPI as a requirement. KPI or Key Performance Indicator is a measure for business to understand how they are acting in specific area that is very import for their business. Power BI supports built-in visualization for KPI, and there are also some good custom visuals that can be Read more about KPIs and Power BI; Visualization Aspect[…]