Latest Power BI and AI articles from RADACAD team
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[…]
After sponsoring PASS BA Conference 2016 in US, we will fly to Liverpool and sponsor SqlBits 2016, the biggest SQL Server gathering in Europe and UK. It will be our pleasure to see you all there. We’ve previously announced that we will speak in this conference. So it would be great to see you either Read more about RADACAD sponsors SqlBits 2016[…]
It is great pleasure to announce that we will be sponsoring PASS Business Analytics Conference 2016 which happens between 2nd and 4th of May 2016 in San Jose, California, USA. This conference targets business and data analysts. There will be sessions in four main tracks in this conference which takes you through the Analyst’s Journey; Read more about RADACAD Sponsors PASS BA 2016[…]
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[…]
Power BI free allows you to have 1GB data per user, and pro 10GB. However in many organizations you have much bigger size of data than 10GB, sometimes you deal with Tera bytes, even Peta bytes of data. Is Power BI limiting you for the visualization? Short answer; No! In this post I’ll explain you Read more about Step Beyond the 10GB Limitation of Power BI[…]
Turning columns to rows, or rows to columns is easy with Power Query and Power BI. There are many situations that you get a name, value data source, and wants to convert that into columns with values underneath. On the other hand many times you get multiple columns and want to change it to name, Read more about Pivot and Unpivot with Power BI[…]