jsimonbi.wordpress.com
John Simon on BI | Microsoft Business Intelligence and Data WarehousingMicrosoft Business Intelligence and Data Warehousing
http://jsimonbi.wordpress.com/
Microsoft Business Intelligence and Data Warehousing
http://jsimonbi.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.2 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
6
SSL
EXTERNAL LINKS
67
SITE IP
192.0.78.12
LOAD TIME
0.219 sec
SCORE
6.2
John Simon on BI | Microsoft Business Intelligence and Data Warehousing | jsimonbi.wordpress.com Reviews
https://jsimonbi.wordpress.com
Microsoft Business Intelligence and Data Warehousing
jsimonbi.wordpress.com
SSRS Sparkline report using MDX | John Simon on BI
https://jsimonbi.wordpress.com/2011/03/23/ssrs-sparkline-report-using-mdx
John Simon on BI. Microsoft Business Intelligence and Data Warehousing. SSRS Sparkline report using MDX. Posted on March 23, 2011. In this post I am going to describe how to create a report with Sparklines using an MDX query. In my current role I do a lot of Proof Of Concept pre-sales work for different industries, and I’ve really grown to love sparklines. I think they are fantastic in giving users an understanding of how an object is tracking over time in a single glance. ALTER TABLE dbo.DimDate ADD...
Date Order | John Simon on BI
https://jsimonbi.wordpress.com/2011/11/19/date-order
John Simon on BI. Microsoft Business Intelligence and Data Warehousing. Posted on November 19, 2011. My friend and colleague Boyan Penev has a post on how to do ordering of attributes in SSAS here: : http:/ www.bp-msbi.com/2011/11/alternate-ordering-of-attributes-in-ssas/. The people requesting this change were eventually convinced that the change was not wise, and I’d like to present those reasons in this post. The main reason I refused and argued against this change boils down to useability. The date d...
Tracking History with Slowly Changing Dimensions | John Simon on BI
https://jsimonbi.wordpress.com/2011/09/24/tracking-history-with-slowly-changing-dimensions
John Simon on BI. Microsoft Business Intelligence and Data Warehousing. Tracking History with Slowly Changing Dimensions. Posted on September 24, 2011. The common way to track changes in an Inmon or 3. Normal Form data warehouse is to use the Natural/Business Key combined with a start and end date. So you many end up with a structure looking like this:. As I have noted in a previous post https:/ jsimonbi.wordpress.com/2011/05/16/dimensional-modeling-worst-practices/. In Fig2 you can see that Clark Kent h...
Process Modeling – Is this a fact or a dimension? | John Simon on BI
https://jsimonbi.wordpress.com/2011/11/23/process-modeling-is-this-a-fact-or-a-dimension
John Simon on BI. Microsoft Business Intelligence and Data Warehousing. Process Modeling – Is this a fact or a dimension? Posted on November 23, 2011. This is a question I see a lot on forums (and also get asked) and it’s generally based on confusion around events and processes (such as an incident, a bank application process etc). Let’s remember what the difference is between a fact and a dimension. A fact table stores a. What I’ve done is create a lifecycle status dimension table with values of O...
Dimensional Modeling Worst Practices | John Simon on BI
https://jsimonbi.wordpress.com/2011/05/16/dimensional-modeling-worst-practices
John Simon on BI. Microsoft Business Intelligence and Data Warehousing. Dimensional Modeling Worst Practices. Posted on May 16, 2011. As a consultant I see a lot of BI/DW solutions with various clients, and am often called in to fix performance issues. Often times developers/architects will ignore the Ralph Kimball methodology, or try to improve it by breaking a few rules. So I thought it might be worthwhile for me to post some of the Worst Practices for Dimensional Modeling. If we run the following code...
TOTAL PAGES IN THIS WEBSITE
6
Valuable Data: May 2012
http://valuabledata.blogspot.com/2012_05_01_archive.html
A Blog That Examines Data Warehousing Concepts With Examples. Friday, May 25, 2012. If mom goes to the grocery store alone, getting the groceries on her list will take a certain amount of time. If mom, dad, and the two kids all go and each takes responsibility for getting 25% of the items, the total duration will be lessened. However, this will require that the items in the four separate grocery carts are consolidated into one before being presented at the cash register. Posted by Brian Ciampa. KEY TRANS...
Will Thrash's Blog | Big Data, Business Intelligence | Page 2
https://willthrash.com/page/2
Will Thrash's Blog. Big Data, Business Intelligence. MSC-ERR-0008 An error has occured at the transport layer and OP-ERR-0181 At least one invalid member – Cognos and SSAS errors. MSC-ERR-0008 An error has occurred at the transport layer and OP-ERR-0181 At least one invalid member – Cognos and SSAS errors. A client has found a solution to two errors occurring in an environment with Cognos 10.1 and SQL Server 2008. MSC-ERR-008 An error as occurred at the transport layer. And tagged Analysis Services.
Cannot use Open with Explorer in a SharePoint library – solved. | Will Thrash's Blog
https://willthrash.com/2013/08/27/cannot-use-open-with-explorer-in-a-sharepoint-library-solved
Will Thrash's Blog. Big Data, Business Intelligence. Cannot use Open with Explorer in a SharePoint library – solved. Cannot use Open with Explorer in a SharePoint library – solved. (“Your client does not support opening this list with Windows Explorer”). The solution is to add a registry entry. The root problem is that in this situation, your credentials are not passed when the target URL has a dot in the address. The following procedure, from this Microsoft article. Describes how to fix things:. Two fre...
Netezza | Will Thrash's Blog
https://willthrash.com/tag/netezza
Will Thrash's Blog. Big Data, Business Intelligence. Using -1 for Uknown Dimension Entry with Netezza. Using -1 for Unknown Dimension member with Netezza Can Cause Slowness. If this is done when a large amount of data is associated with the unknown row, that data will be skewed to a single data slice. Since your query is only as fast as the slowest data slice, this will be the bottleneck. A solution to this problem can be found here. I never thought I would advocate adding 10,000 dummy records.) When...
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 ...
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?
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.
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.
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...
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.
TOTAL LINKS TO THIS WEBSITE
67
Joe's Development Blog
Joe's Development Blog. Perq Accepted for Google Summer of Code 2014. April 22, 2014. I am happy to announce that the. Project has a place. In the 2014 Google Summer of Code! This project will continue work from last summer, which hopes to enable a production print workflow suitable for graphics professionals (“perq”). It will do this by extending the CUPS web interface, and modifying its handling of PPD (PostScript Printer Description) files. In other words, I will be picking up where I left off. I wrot...
Jeffrey Simon | Architect Home - Jeffrey Simon | Architect
Please install Flash and turn on Javascript. Site by MediaPunch ≈ web design NYC.
Joe Simon, Artist, Pet Portraits in Oil, Stars of the Decades, Clowns, Milwaukee, WIsconsin.
JSimonART (Josh Simon) - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) " class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ". Join DeviantArt for FREE. Forgot Password or Username? Horror, Gore and Art. Traditional Art / Professional. Community, Critique, and Improve. Deviant for 9 Years. This deviant's full pageview. Community, Critique, and Improve. Bring your artwork to stage. 12 mont...
jsimonbai - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 2 Years. This deviant's full pageview. Last Visit: 54 weeks ago. This is the place where you can personalize your profile! Window&#...
John Simon on BI | Microsoft Business Intelligence and Data Warehousing
John Simon on BI. Microsoft Business Intelligence and Data Warehousing. Process Modeling – Is this a fact or a dimension? November 23, 2011. This is a question I see a lot on forums (and also get asked) and it’s generally based on confusion around events and processes (such as an incident, a bank application process etc). Let’s remember what the difference is between a fact and a dimension. A fact table stores a business process. A fact is therefore an […]. November 19, 2011. October 9, 2011. In this pos...
J. Simon Design Build
WELCOME TO J. SIMON DESIGN BUILD. We specialize in crafting building plans that will exceed your expectations, and executing them quickly and affordably. Our goal is making your space easier to live in and making the process easy on you. At J Simon, we believe our job means giving your home a sense of flow of good energy, of space used in a way that makes sense. To do that, we listen to you and help determine your specific wants and needs.
Lancaster Chiropractic Rehab Center - Chiropractor in Lancaster, OH
Would you like to switch to the accessible version of this site? Go to accessible site. Don't need the accessible version of this site? Hide the accessibility button. O-DOT / CDL Exams. We Create Healthy Families. Call or Make an Appointment Online Today. Your journey to wellness begins here. Call today. You've only got one spine. Take great care of it with supportive chiropractic care. Call or Make an Appointment Online Today. Your journey to wellness begins here. Call today. Weight Loss Medical Guidance.
j simon design :: digital design - :: jsimondesign is the freelance work of Jake Simon, a designer in St. Louis, MO, USAj simon design :: digital design | :: jsimondesign is the freelance work of Jake Simon, a designer in St. Louis, MO, USA
J simon design : digital design. Crowd funding video to promote Shalom House, a women’s shelter in St. Louis, MO. Gen Ray Johns provided a moving speech at the Airlift/Tanker Association Symposium. 17 phenomenal presentations were given at the first-ever DoD TEDx event in May 2012. FavorIt – Where Favorite Friends and Favorite Apps Meet is a iOS app developed to combine social networking with app discovery. This 6 minute video highlights the enduring mission behind Air Mobility Command’s purpose. Jake se...
SwitzerDeutsch
On media, multiculturalism and the quest to find decent mexican food in europe. Jan 30th, 2010 at 11:54 PM. This is the final post on this blog. I've recently added some back-dated entries regarding my return to the USA, so you might need to scroll back down this page and see if you've missed anything. You know, if you don't have anything better to do. I'm moving to London in September to start my MA. If you want to keep up with my further (non-missionary) musings in the meantime, I'm blogging. I suppose...
Home
Blog, Vids and Pics. Ms Simone's one woman show for Mensa. An erotic experience for a high IQ society. Join us at the Pandemic RG in Herdon, VA. 7th Annual Tea Experience! An afternoon of empowerment, etiquette and goal setting for women and girls of all ages! It is a spectacular, uplifting event! Oh, and there is tea. Want J. Simone to rock the mic at your venue? Host, Poet, Seduction Instructor, Glamazon Superhero, Author, Radio Personality, Keynote Speaker, Mother, Model (Supermodel), Survivor.
SOCIAL ENGAGEMENT