Sharepoint 2013 – refreshing excel workbook with direct connection to sql server analysis services (SSAS) cube
I have not blogged in a while, due to moving countries and starting a new job. So i do hope that this blog will help someone or let them know how easy it is to use SharePoint 2013 to refresh data in an Excel spreadsheet. What I needed to do, was to use an existing Excel spreadsheet which connected directly…
SSAS – KPI’s – Example of creating a KPI
Based on the previous BLOG post <font color="#ff000, we are going to explain how to create a KPI Example · Using our Internet Sales cube, we want to create a KPI in order to see if the guys are meeting their new target which is a 10% increase from their current sales. · So we will create a new…
SSAS – KPI’s – How Explanation of KPI Makeup
Below is an overall description of what is needed for the KPI’s when creating them in BIDS 1. After you click on New KPI you will have a window shown below and underneath the picture are the details required for each section: 2. a. Where it says Name: i. This will be the name for your…
Relocating to Australia – BI Job opportunities in Queensland
I thought I would let you guys know that I am about to relocate to Australia from South Africa. I have had an amazing time in South Africa, and learnt a whole lot whilst working at my past employer. So this is a plug at anyone who has any lead or potential BI work in Queensland, Australia. I would really…
SSIS & TSQL – Geo- location from IP Address to Country
Below are the details firstly from getting your Geo – location information from a table which has your IP Address to country information. And then getting your IP Address information from your source systems and quickly getting this to a Country so that you can see where the people are coming from. Geo – Location information There are a…