jsimonbi.wordpress.com jsimonbi.wordpress.com

jsimonbi.wordpress.com

John Simon on BI | Microsoft Business Intelligence and Data Warehousing

Microsoft Business Intelligence and Data Warehousing

http://jsimonbi.wordpress.com/

WEBSITE DETAILS
SEO
PAGES
SIMILAR SITES

TRAFFIC RANK FOR JSIMONBI.WORDPRESS.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

CUSTOMER REVIEWS

Average Rating: 3.3 out of 5 with 3 reviews
5 star
1
4 star
1
3 star
0
2 star
0
1 star
1

Hey there! Start your review of jsimonbi.wordpress.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

Desktop Preview Tablet Preview Mobile Preview

LOAD TIME

0.2 seconds

FAVICON PREVIEW

  • jsimonbi.wordpress.com

    16x16

  • jsimonbi.wordpress.com

    32x32

CONTACTS AT JSIMONBI.WORDPRESS.COM

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

SCORE

6.2

PAGE TITLE
John Simon on BI | Microsoft Business Intelligence and Data Warehousing | jsimonbi.wordpress.com Reviews
<META>
DESCRIPTION
Microsoft Business Intelligence and Data Warehousing
<META>
KEYWORDS
1 about me
2 subscribe rss feed
3 tagged
4 dimensional modeling
5 scd type 2
6 slowly changing dimension
7 t sql
8 posted in
9 data modeling
10 date order
CONTENT
Page content here
KEYWORDS ON
PAGE
about me,subscribe rss feed,tagged,dimensional modeling,scd type 2,slowly changing dimension,t sql,posted in,data modeling,date order,ssas,ssrs,date dimension,fact table,kimball,datepicker,reporting services,sparkline,sql server,strtomember,date parameter
SERVER
nginx
CONTENT-TYPE
utf-8
GOOGLE PREVIEW

John Simon on BI | Microsoft Business Intelligence and Data Warehousing | jsimonbi.wordpress.com Reviews

https://jsimonbi.wordpress.com

Microsoft Business Intelligence and Data Warehousing

INTERNAL PAGES

jsimonbi.wordpress.com jsimonbi.wordpress.com
1

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

2

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

3

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

4

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

5

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

UPGRADE TO PREMIUM TO VIEW 1 MORE

TOTAL PAGES IN THIS WEBSITE

6

LINKS TO THIS WEBSITE

valuabledata.blogspot.com valuabledata.blogspot.com

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

willthrash.com willthrash.com

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.

willthrash.com willthrash.com

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

willthrash.com willthrash.com

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

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

UPGRADE TO PREMIUM TO VIEW 57 MORE

TOTAL LINKS TO THIS WEBSITE

67

SOCIAL ENGAGEMENT



OTHER SITES

jsimon3.wordpress.com jsimon3.wordpress.com

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

jsimonarchitect.com jsimonarchitect.com

Jeffrey Simon | Architect Home - Jeffrey Simon | Architect

Please install Flash and turn on Javascript. Site by MediaPunch ≈ web design NYC.

jsimonart.com jsimonart.com

Joe Simon, Artist, Pet Portraits in Oil, Stars of the Decades, Clowns, Milwaukee, WIsconsin.

jsimonart.deviantart.com jsimonart.deviantart.com

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.com jsimonbai.deviantart.com

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

jsimonbi.wordpress.com jsimonbi.wordpress.com

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

jsimonbuilds.com jsimonbuilds.com

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.

jsimondc.com jsimondc.com

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.

jsimondesign.com jsimondesign.com

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

jsimone.livejournal.com jsimone.livejournal.com

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

jsimone.net jsimone.net

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.