Rayis Imayev

My personal journey in an intricate world of data and continuous effort to make it more structured and well understood can be found in this blog.

I live and work in Canada - see my profile on LinkedIn.

Website: http://datanrg.blogspot.com/

All authors

Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS

by Rayis Imayev

Data Adventures

[2016-May-31] Two different metrics, two different datasets, one may represent a very high value and the other one is very low....

2016-05-31

1,687 reads

Power BI Box and Whisker visualization vs. Box Plot chart in SSRS

by Rayis Imayev

Data Adventures

[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...

2016-04-30

4,348 reads

Excel Power Map vs. Power BI Globe Map visualization

by Rayis Imayev

Data Adventures

[2016-02-02] PowerMap in Excel is a great tool with good design and comprehensive user experience. I’ve started using it about...

2016-02-09 (first published: 2016-02-02)

5,851 reads

Specifying Paths to External Items (Report Builder and SSRS) in SharePoint with PowerShell

by Rayis Imayev

Data Adventures

[2015-Dec-24] My story: two SSRS items (main report and its sub-report) need to be deployed to SharePoint. Trivial task, and...

2015-12-24

1,770 reads

PowerMap with Custom Region shapefiles - Demystified

by Rayis Imayev

Data Adventures

[2015-Nov-18] Today is a global GIS Day (http://www.gisday.com/) where people across the globe celebrate and promote the use of various geo...

2015-11-25 (first published: 2015-11-18)

10,597 reads

Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting

by Rayis Imayev

Data Adventures

[2015-Oct-20] A sourcing system failed to return correct results (returned value was a very high figure with double digit number...

2015-10-26 (first published: 2015-10-20)

2,270 reads

Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better

by Rayis Imayev

Data Adventures

[2015-Aug-12] It’s quite obvious that in present time there is a growing audience for all the latest changes and updates...

2015-08-12

1,290 reads

Single value filters and custom error messages in Power BI

by Rayis Imayev

Data Adventures

"Let me be the one for you, otherwise we need to work on communication". Basically this was a very brief...

2015-07-27

1,121 reads

Setting specific colors for PowerView charts

by Rayis Imayev

Data Adventures

I was listening for Phil Collins' "True Colors" song in my car audio this morning and it reminded me about...

2015-07-21

5,380 reads

Updating PowerPivot model and PowerView report with PowerShell

by Rayis Imayev

Data Adventures

Before I start describing a problem that my PowerShell script helps to resolve, these are a few blog posts of...

2015-06-18

4,787 reads

All authors

Rayis Imayev

Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS

Power BI Box and Whisker visualization vs. Box Plot chart in SSRS

Excel Power Map vs. Power BI Globe Map visualization

Specifying Paths to External Items (Report Builder and SSRS) in SharePoint with PowerShell

PowerMap with Custom Region shapefiles - Demystified

Too Big To Be Visible - SQL Server vs. Oracle data in SSRS reporting

Why I still like Excel PowerPivot models in SharePoint however Tabular solutions in SSAS are better

Single value filters and custom error messages in Power BI

Setting specific colors for PowerView charts

Updating PowerPivot model and PowerView report with PowerShell

Blogs

The fundamental requirements of a reporting system

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

A New Word: Foilsick

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

count the number of NULLs in a row

Deleting data in large table

Question of the Day

SQL Server Ghosts