New Power BI and Analytics Features in PASS Summit 2017 Keynote – Live (Hit Refresh)

Posted on November 2, 2017November 2, 2017 by Reza Rad

PASS Summit 2017 Keynote in live now. Leila and I are sitting in bloggers table here, and will blog from here all new announcement through this post. Please Hit Refresh! Here we are at blogger’s table: Azure SQL Database and Machine Learning on a massive data set, demoed; Super fast loading 1.4 millions of records Read more about New Power BI and Analytics Features in PASS Summit 2017 Keynote – Live (Hit Refresh)[…]

Azure ML workbench-Data Wrangling -Part 3

Posted on October 31, 2017 by Leila Etaati

In the last posts, I have explained how to install Azure ML workbench and how to run a sample and check the accuracy. In this post, I am going to show how to do data wrangling using Azure ML workbench. Just click on the left menu, on the database icon. There are 2 separate groups Read more about Azure ML workbench-Data Wrangling -Part 3[…]

Azure ML workbench-Run Model-Part 2

Posted on October 25, 2017 by Leila Etaati

In the last post, I have shown how to install the Azure ML workbench. Also, I have shown an example of classification problem with iris data how to load it and run it I run the code on the local computer. as you can see in the below picture, the physical place is “local”, there is Read more about Azure ML workbench-Run Model-Part 2[…]

Measure vs Calculated Column: The Mysterious Question? Not!

Posted on October 21, 2017August 15, 2019 by Reza Rad

Despite all articles, blog posts, and videos on the topic of DAX Measures and Calculated columns, I still hear here and there that people ask what is the difference between Measure and Calculated Column? What situation should we use each of these? and on the other hand, what is the difference of creating column here, Read more about Measure vs Calculated Column: The Mysterious Question? Not![…]

Searching a Field or Table in Power BI Visualization: Power BI Helper

Posted on October 20, 2017October 20, 2017 by Reza Rad

Last week, we announced the very first version of Power BI Helper. Power BI Helper is a tool that helps clean up a Power BI solution. This week we have an updated version with a new interesting feature: Searching for a Field or Table in all visualizations in the PBIX file. The additional feature is helpful for further Read more about Searching a Field or Table in Power BI Visualization: Power BI Helper[…]

Azure ML workbench- Installation-Part 1

Posted on October 19, 2017October 21, 2017 by Leila Etaati

In Microsoft ignite 2017, Azure ML team announce new on-premises tools for doing machine learning. this tools much more comprehensive as it provides 1- a workspace helps data wrangling 2- Data Visualization 3-Easy to deploy 4-Support Python codes in this post and next posts, I will share my experiment with working this tools. first I got Read more about Azure ML workbench- Installation-Part 1[…]

Time series Series with Power BI- Forecast with Arima-Part 12

Posted on October 17, 2017 by Leila Etaati

In the last posts (Series of Time Series), I have explained about what is ARIMA, what is d,p, and q in ARIMA (p,d,q). In this post, I will talk about how to use ARIMA for forecasting and how to handle the seasonality parameters. in the last example for the age of death of the England king, Read more about Time series Series with Power BI- Forecast with Arima-Part 12[…]

Power BI Cleanup Tool; Time Saving with Power BI Helper

Posted on October 12, 2017October 12, 2017 by Reza Rad

Power BI files can easily get big. You can have 50 tables in a Power BI model, and 25 reports. When Power BI file gets in that size, maintenance is always an issue. It will take lots of time to find out if all of those 50 tables actually used in reports and visualization or not. Read more about Power BI Cleanup Tool; Time Saving with Power BI Helper[…]

File Managment in Azure Data Lake Store(ADLS) using R Studio

Posted on October 12, 2017October 13, 2017 by Leila Etaati

In this post, I am going to share my experiment in how to do file management in ADLS using with R studio environment, So how it works? we able to manage ADLS from Rstudio environment using R scripts, so without accessing the ADLS we able to manage the portal, bring Data from ADLS to R Read more about File Managment in Azure Data Lake Store(ADLS) using R Studio[…]

Download Slides of Presentations in Power BI World Tour San Francisco

Posted on October 7, 2017 by Reza Rad

Power BI World Tour in San Francisco ran on 4th and 5th of October in Bay Area (Microsoft Sunnyvale). As a speaker, it is always a great opportunity for me and Leila to speak in such events and meet new people in the community. In San Francisco world tour, Leila and I presented 4 topics Read more about Download Slides of Presentations in Power BI World Tour San Francisco[…]