Mighty Ochs BI

Business Intelligence for the rest of us

Tag: Tutorial

How to Make a Simple API Call using C#

Web API’s open up a world of possibilities for us geeks.  When I first learned how to access API’s using C#, I went through the ringer trying to find out the best and easiest way to extract data.   For this post, we’ll be using OpenWeatherMap.org‘s free api to extract some weather information.

Continue reading

How to use Biml to extract data from SAGE SOTAMAS 90 into SQL Server

Sage can be a pain to extract data from and a while back I was given the mission of moving data from sage into SQL Server where we could more easily analyze the data.  I searched and searched for some documentation to help get me rolling.    The lack of helpful resources surrounding this problem is what inspired this post.

Continue reading

Olympic Power BI Application – First Post!

Ah the Olympics – a time to watch sports you never care about until it’s your country against the world.  There are plenty of places around the web to track the competition, but I thought there could be a better way of displaying such interesting data.  So I created a very quick and dirty Power BI application.  You can view it here – Power BI Application with live Rio 2016 data

Power BI Desktop is a free application that you can use to visualize all sorts of data.  Using Power BI to gather data from the web (as I’ve done for the Olympics) is remarkably simple.  In this post I’ll show you how to begin making your own Rio 2016 application.

Continue reading

© 2019 Mighty Ochs BI

Theme by Anders NorenUp ↑