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
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
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...
bimonkey.com
Exploring Memory Usage in Tabular Models with DISCOVER_OBJECT_MEMORY_USAGE dmv | BI Monkey
http://www.bimonkey.com/2014/12/exploring-memory-usage-in-tabular-models
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Exploring Memory Usage in Tabular Models. December 4, 2014. Trying to understand what is going on under the hood with a Tabular model is possible using the SSAS DISCOVER OBJECT MEMORY USAGE Rowset. 8211; but the results aren’t going to win any prizes for accessibility. The mighty Kasper De Jonge. Had a crack at making it accessible back in 2012. A Tabular Model on DISCOVER OBJECT MEMORY USAGE. Filter for Se...
bimonkey.com
Video on Vertipaq Compression in SSAS Tabular / PowerPivot | BI Monkey
http://www.bimonkey.com/2015/02/video-vertipaq-compression-tabular-powerpivot
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Great PASS BIDW VC Video on how Vertipaq Compression works in SSAS Tabular / PowerPivot. February 12, 2015. Embedded below is a great video from Marco Russo. On how the compression engine works in SSAS Tabular / PowerPivot:. This is from the SQL PASS BI Virtual Chapter Youtube. Leave a Reply Cancel reply. Your email address will not be published. Required fields are marked *. You may use these.
bimonkey.com
PowerPivot Succinctly - free eBook by me! | BI Monkey
http://www.bimonkey.com/2015/04/powerpivot-succinctly-new-ebook-by-me
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. PowerPivot Succinctly – new eBook by me! April 16, 2015. Want to learn more about PowerPivot? Syncfusion have published a new eBook “ PowerPivot Succinctly. 8221; written by my good self. A quick overview of the contents:. Using your PowerPivot Model. Sharing your PowerPivot Model. A Note on Instability. Deep Dive: The xVelocity Engine. It’s a free download – so go help yourself! February 28, 2016 at 8:32 am.
bimonkey.com
BI Monkey ETL Control Framework | BI Monkey
http://www.bimonkey.com/framework
Consulting and Technical Services. SSIS Component Samples List. Using SSIS samples from this site. Why do I need an ETL Control Framework? What happens when your ETL process stops? How do you even know? Can you restart it? Can it restart itself? Should some errors just be ignored anyway? An SSAS tabular model, some SSRS reports and an underlying data model provide monitoring capability including execution progress and performance reporting. Save your organisation spending valuable development effort!
SOCIAL ENGAGEMENT