bimonkey.com
IAPA 2014 Salary Survey | BI Monkey
http://www.bimonkey.com/2015/01/iapa-2014-salary-survey
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. IAPA 2014 Salary Survey. January 13, 2015. The IAPA salary survey. Came out a couple of months back, and though it is Analytics focused it has some interesting results for those of us in the BI world. My key takeaways follow. Despite all the market enthusiasm, a significant proportion of respondents said there is an ongoing challenge reported that analysts struggle to get their organisation to value or act ...
bimonkey.com
Managing complex security in SSAS Tabular | BI Monkey
http://www.bimonkey.com/2015/03/managing-complex-security-in-ssas-tabular
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Managing complex security in SSAS Tabular – Yeah Nah edition. March 15, 2015. A couple of times recently I have come up against requirements which have required some fairly complex logic to apply security. One involved some fairly gnarly relationships coming from multiple directions, the other involved grinding through Hierarchies from parent nodes down to permitted viewable children. Do it in the Cube?
bimonkey.com
Migrating Package Connections to Project Connections in SSIS | BI Monkey
http://www.bimonkey.com/2015/04/migrating-package-connections-to-project-connections-in-ssis
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Migrating Package Connections to Project Connections in SSIS. April 27, 2015. However a recent task I got handed was to migrate a 2008 project to the 2012 project model. All very sensible, to ease maintenance, eliminate XML configurations and generally bolster security. Then I got to work…. Converting a Package Connection to a Project Connection. You have a project connection! Fortunately thanks to this post.
bimonkey.com
Agile | BI Monkey
http://www.bimonkey.com/tag/agile
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. The fine art of starting to adopt Agile with a Zero sprint. March 18, 2015. Agile methodologies have a patchy track record in BI/DW projects. A lot of this is to do with adopting the methodologies themselves – as I’ve alluded to in prior posts there are a heap of obstacles in the way that are cultural, process and ability based. What is this Zero sprint anyway? How to structure and sell the Zero sprint.
bimonkey.com
Productivity issues for Agile in BI/DW - part 1: People | BI Monkey
http://www.bimonkey.com/2015/01/productivity-issues-for-agile-in-bidw-part-1-people
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Productivity issues for Agile in BI/DW – part 1: People. January 15, 2015. Productivity nirvana is hard to find. Meditations on the path. Once again its about people. A topic I like to hammer home is that most of your project concerns are not technical or process driven – it’s all about people, specifically people’s ability and willingness to adapt and learn. Picking team members who c...Required fields are...
bimonkey.com
Azure | BI Monkey
http://www.bimonkey.com/tag/azure
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Download data from a Hadoop on Azure cluster. August 29, 2012. January 18, 2013. So you’ve run a job on Hadoop on Azure, and now you want that data somewhere more useful, like in your Data Warehouse for some analytics. If the Hive ODBC Driver. Isn’t an option (perhaps because you used Pig), then FTP is the way – there isn’t a Javascript console fs.get() command available. As described in my Upload data.
bimonkey.com
Automation | BI Monkey
http://www.bimonkey.com/tag/automation
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. BIML and MIST – a first encounter. June 16, 2014. The MIST developers – Varigence. 8211; have been waving their product at me for a wee while now and I’ve finally had a chance to get into the IDE and get a better feel for it. Before I get too carried away, here’s a quick 101. There’s this thing called BIML. A thing you should have if you are an active BI developer) or the more focused BIML IDE MIST. First u...
bimonkey.com
Microsoft SQL Server Business Intelligence (BI) and Consulting in Sydney, Australia with the BI Monkey - Part 2
http://www.bimonkey.com/page/2
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Dynamic Time Variant calculations in DAX. February 26, 2015. A common requirement in any set of calculations is to create a range of time variants on any measure – Prior Period, Year to Date, Prior Year to Date, Prior Quarter… you think of a time slice and someone will find it useful. There is a way that is a very specific variant of the idea of Parameter Tables. Time for the Variants. Add it all up. TotalT...
bimonkey.com
The fine art of starting to adopt Agile with a Zero sprint | BI Monkey
http://www.bimonkey.com/2015/03/the-fine-art-of-starting-to-adopt-agile-with-a-zero-sprint
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. The fine art of starting to adopt Agile with a Zero sprint. March 18, 2015. Agile methodologies have a patchy track record in BI/DW projects. A lot of this is to do with adopting the methodologies themselves – as I’ve alluded to in prior posts there are a heap of obstacles in the way that are cultural, process and ability based. What is this Zero sprint anyway? How to structure and sell the Zero sprint.
bimonkey.com
Dynamic Time Variant calculations in DAX | BI Monkey
http://www.bimonkey.com/2015/02/dynamic-time-variant-calculations-dax
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Dynamic Time Variant calculations in DAX. February 26, 2015. A common requirement in any set of calculations is to create a range of time variants on any measure – Prior Period, Year to Date, Prior Year to Date, Prior Quarter… you think of a time slice and someone will find it useful. There is a way that is a very specific variant of the idea of Parameter Tables. Time for the Variants. Add it all up. TotalT...