[{"id":2930,"date":"2015-10-17T03:35:48","date_gmt":"2015-10-17T03:35:48","guid":{"rendered":"http:\/\/digitalborn.org\/?p=2930"},"modified":"2017-10-28T16:05:03","modified_gmt":"2017-10-28T21:05:03","slug":"connect-blackboard-asr-to-power-bi","status":"publish","type":"post","link":"https:\/\/digitalborn.org\/connect-blackboard-asr-to-power-bi\/","title":{"rendered":"Blackboard Data: Connect Blackboard Advanced System Reporting to Power BI"},"content":{"rendered":"

Recently I was asked to provide business analysts with a regularly refreshed feed of Blackboard data from Blackboard’s Advanced System Reporting (ASR)<\/a>. The goal was to give analysts an updated set of data points that enabled quick reporting and visualization.<\/p>\n

Blackboard ASR is a statistics database that gives system administrators access to system-level data. Microsoft Power BI<\/a> is a \"Coursebusiness intelligence\u00a0tool that allows regular analysts to quickly put together reports and dashboards. The combination gave analysts the ability to develop and share reports with regularly refreshed data across the organization. A simple example would be a bar chart that shows courses available:<\/p>\n

 <\/p>\n

While it’s straightforward to connect Blackboard ASR to a SQL client (Blackboard recommends Dreamcoder), pulling this data into a business intelligence tool was much more challenging since documentation on the topic is sparse. After spending several hours running into dead ends, I successfully connected Blackboard ASR to Power BI. Hopefully these instructions save you time:<\/p>\n

How to Connect to Blackboard Data<\/h3>\n

1. Open Power BI Desktop
\n2. Click on Get Data -> Oracle\u2028 Database
\n\"Power<\/a>
\n3. In the Server field enter the quick connect information in this format
\n(host name):(port number)\/(service name)<\/strong><\/p>\n

For\u00a0example
\n55.555.555.555:10053\/ORACLE<\/em><\/p>\n

\"Server<\/a>
\nYou can read more on this string here<\/a><\/p>\n

4. Next enter the database username and password provided by Blackboard<\/p>\n

Once you have authenticated using the database credentials provided by Blackboard, you will select the tables to load into Power BI.<\/p>\n

Congratulations, you’re now ready to create reports and dashboards the easy way.<\/p>\n","protected":false},"excerpt":{"rendered":"

Recently I was asked to provide business analysts with a regularly refreshed feed of Blackboard data from Blackboard’s Advanced System Reporting (ASR). The goal was to give analysts an updated set of data points that enabled quick reporting and visualization. Blackboard ASR is a statistics database that gives system administrators access to system-level data. Microsoft […]<\/p>\n","protected":false},"author":5,"featured_media":2933,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[114],"tags":[140,139,135,138,136,137,134,142,141],"class_list":["post-2930","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-tips","tag-advanced","tag-asr","tag-bi","tag-blackboard","tag-business","tag-intelligence","tag-power-bi","tag-reporting","tag-system"],"_links":{"self":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/posts\/2930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/comments?post=2930"}],"version-history":[{"count":0,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/posts\/2930\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/media\/2933"}],"wp:attachment":[{"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/media?parent=2930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/categories?post=2930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalborn.org\/wp-json\/wp\/v2\/tags?post=2930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}]