This is the 5th in series of posts on datawarehousing. To see the entire post list, click here. The Dimensional Design Process The four key decisions that are made when designing a Kimball-style dimensional star schema are as follows: Identify the Business Process Identify the Grain Identify the Dimensions Identify the Facts When embarking upon the design process, your final deliverable Read the article >>
I’ve never seen someone rise in an organization as fast as when they become an expert in something important to that organization. There something organic about leadership that occurs because an engineer is the subject-matter expert in a piece of scope that the rest of the organization is betting on strategically. I’ve seen engineers be most successful at this when It’s a subject they Read the article >>
Boulder Startup Week is a free, five day celebration of the Boulder Startup Community. And it’s next week! If you want to volunteer, click here. If you want to see the full event schedule, click here. If you want to see the data science track schedule, click here. If you want to see my schedule, click here. See you there! Read the article >>
If gmail is still slow for you in 2015, you are not alone: gmail is slow remains a consistent search term on google trends: As it turns out, my 9 Tips To Fix Slow Gmail Load Times post is one of the all top posts on this blog. But it was written in 2012 and it is time for an update. If, like many others, you are still having problems in 2015, here are some things you can try: If you Read the article…
If facebook is slow for you, you are not alone: facebook is slow remains a consistent search term on google trends: If, like many others, you are still having slowness problems on Facebook, here are some things you can try: Check if your internet connection is slow …. Your network connection may be the problem. Try: Switching to your 5GHz network, if your router supports it. Do Read the article >>
If I could name *the* one most important quality of a potential team member, friend, or pretty-much anyone I am going to bring into my life, this is it: If you say you’re going to do something, you go do it. It’s such a straightforward principle. And yet, crazily enough, people (even professionals) don’t always follow through on their committments. Maybe people commit to things they don’t plan Read the article >>
One thing that I’ve seen in Simple Energy’s culture over the last 6 months that is very exciting to me is watching firsthand the virtuous cycles that happen in enthusiastic teams. If I try to decompose the contributing factors to this, based upon my experience at Simple Energy, into their own discrete tenets, I think it would look like this: Culture Have fun together. Values must be Read the article >>
This is the 4th in series of posts on datawarehousing. To see the entire post list, click here. Star Schemas A star schema is the simplest type of data mart in dimensional modeling. A star schema is one or more fact tables foreign key’d to any number of dimensions, and, when viewed through a visual schema planning tool, looks like a star: —————————————————————————- |_______dim_user Read the article >>
This is the 3rd in series of posts on datawarehousing. To see the entire post list, click here. Onto the schema design portion of the the series! There are two main types of tables used to store information in a data warehouse: Table Type #1: Dimension Table A dimension table contains the attributes by which users will query your data warehouse. They are the content of the WHERE clause in Read the article >>
I’ve been brushing on technologies since putting in my notice at Simple Energy, and I’m proud to announce the launch of my latest product, built in Ruby on Rails with gratuitous reliance on Amazon CloudSearch as my persistence layer : HNTrends.com: Google Trends for Hacker News TLDR — Check it out here, click here to download the source data as a PostGres Database. The thesis behind this Read the article >>