BI-NSIGHT | Mobile BI from Microsoft – SQL 2014 SP1 – Power BI (Google Analytics Connector)
This is a slightly different post from what I have been posting in the past, which has been completely technically focused! I have decided that I read up and look into so many things relating to the Microsoft BI eco system, that I should also share this with the readers and followers of my blog. Where I can give my…
SSIS – Configuring SSIS Package to run job after data loading has completed
In our example below, we are going to be using a SharePoint 2013 Data Alert job which was created in SQL Server Agent, and then insert this into an existing SSIS Project. The reason for doing this, is so that every time our SSIS Project runs, as part of the process, it can then fire off a SQL Server Job….
Power Query – Adding Leading Zero to Number (EG: Month Number)
Below is an example if you have a requirement and you want to add a leading zero Example: You have a Month Number that starts with “1”, and you want it to start with “01” In your Power Query Window, click on Add Custom Column and then put in the following syntax Text.PadStart(Text.From([Month]),2,”0″) NOTE: In the above example, we have…
For SQL Server 2014 – Use the following link below to use an oData Source to get data from SharePoint List into your table
Below are the steps if you want to use SQL Server 2014 to get data from a SharePoint list into your database. The URL below explains how to download and install the OData Source for SQL Server 1. Click on the following link below a. http://www.microsoft.com/en-us/download/details.aspx?id=42295 2. Then once you load the page click on Download a. This will then…
SSRS – Microsoft sql server fitler table/matrix with 2nd row of data
What I wanted to do, was to create multiple table/matrix, but to have them separate. And then to have 5 of them in total. But I wanted to have the top 5. So I wanted the first one to be the top value, then top 2, top 3, top 4 and top 5. This is what the result looks like:…
The future for me
I was reading through the email from The Databse Weekly and I saw an article from Paul Randal with regards to Paul being your mentor. This really got me thinking and where is my future within Business Intelligence (BI). I really love what I do. I get great satisfaction and enjoyment when I can tell people a story about their…
Error: An Item with the same key has been already added – Unable to load the tables in the Power Pivot Window
NOTE: First thing to do is to make a copy of your Excel Workbook, before making any changes to your Power Query Source. If you do NOT, and change your Power Query source, your Power Pivot Model could become unusable! 1. I had an issue where if I changed the Power Query source from a CSV after I made changes…
Power QUery – Creating
Hi there, it has been quite a while since I have posted anything. After moving country and getting my first job. I have subsequently moved to my second job which is going really well. So I have started working on all the new BI Features that Microsoft has been offering and below is something that I needed to do, is…
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…
Book review – Chris Webb – Power Query for Power BI and Excel
It has been a while since my last blog post due to relocating overseas. It has been quite busy and a lot of new things to learn but worth all the effort. When I saw the opportunity to review the book I jumped at it for multiple reasons. The first is that whilst I had dabbled with Power Query, I…