learnmicrosoftbi.com

ssasbysss.blogspot.com

SSAS/MDX Concepts & Tools: February 2011

http://ssasbysss.blogspot.com/2011_02_01_archive.html

SSAS/MDX Concepts and Tools. Created this blog to share my experience and understanding on Analysis Services and MDX. Sunday, February 27, 2011. Calculated Member and Named Set Definition. Analysis Services provides flexibility to add business logic by creating Calculated Member/Named Set on Measures or Dimensions in existing Cube. These are custom MDX expressions defined and saved as part of cube definition. There are multiple options to create these calculations depending on scope of use. EXEC GET MEAS...

analytical-solution.com

Data Science is real » Data Analysis

http://analytical-solution.com/data-analysis

Data Science is real. What can your data do for you? What can your data tell you, that you don’t already know? Data Mining is about explaining the past and predicting the future by means of data analysis. We are collecting more data than ever before, yet many organizations are still looking for better ways to obtain value from their data and compete in the marketplace. I bet you can answer most of these questions with your existing data! Have millions of records, that my specialty! Bill Inmon vs. Ral...

bi.sqlpass.org

Business Intelligence VC > Links

http://bi.sqlpass.org/Links.aspx

PASS BIVC Twitter Feed. The PASS Business Intelligence and Data Warehousing Virtual Chapter serves to connect BI professionals globally over ongoing webinars. Session recordings are available from PASS DW BI VC YouTube Channel. SQL Bits - UK's free SQL Server technical conference. SQL Server Integration Services - SSIS. Top 10 SQL Server Integration Services Best Practices. An Introduction to Fast Track Data Warehouse Architectures. Best Practices for Data Warehousing with SQL Server 2008.

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...

ciobriefings.com

CIOBriefings

http://www.ciobriefings.com/Default.aspx

Monday, August 22, 2016. RootArrowImage="menu down.gif" RootArrow="-1" CSSMenuArrow="MainMenu MenuArrow" CSSMenuBreak="MainMenu MenuBreak" CSSMenuContainer="MainMenu MenuContainer" CSSMenuBar="MainMenu MenuBar" CSSSubMenu="submenu" CSSMenuIcon="MainMenu MenuIcon" CSSMenuItem="MainMenu MenuItem" CSSMenuItemSel="MainMenu MenuItemSel" CSSRootMenuArw="MainMenu RootMenuArrow". You are @ Home. TDD in .NET Webcast. Design Patterns in .NET. Design and Construction of Data Warehouses. CIOBriefings provides traini...