Calculating Travel Distance/Time in Power BI using Bing Map API
[2017-July-24] Map visualization in Power BI has drawn many data professionals into a field of ?reating visual data stories with...
2017-07-24
4,856 reads
Data Adventures
Geo Location of Twitter messages in Power BI
[2017-June-25] There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of...
2017-07-05 (first published: 2017-06-25)
2,085 reads
Power BI with Narrative Science: Look Who's Talking (Part 3: On or Off premises)
[2017-May-08] Listening to a car radio with many different talk shows available, it comes more often to my mind, that...
2017-05-08
665 reads
DAX calculations with hierarchies: Set the order straight.
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,727 reads
SSIS Web Service Task: misleading role of WSDL file
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,478 reads
External SQL files vs. Stored procedures in SSIS development
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,266 reads
How to compare two SSAS databases with a custom MDX query
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,678 reads
Open Data is like a soup
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
608 reads
Power BI with Narrative Science: Look Who's Talking (Part 2: Predicting the Future)
[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well...
2016-10-28 (first published: 2016-10-18)
1,745 reads
Historical Reports vs. Predictive analytics: Rear view mirror look vs. Forward-looking view. Really?
[2016-Sep-30] Working with reports based on historical data is like driving a car while looking in the rear view mirror. I heard...
2016-09-30
1,548 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...