Wednesday, April 15, 2015

New updates

I find what I think are a lot of great articles. I am going to start posting them here to share. Here is my list for today. I hope you enjoy reading. I should probably put these into categories, not that I will have something for every category each day.


Tech News and Info:

The Factless Fact table. Kimball is of course the master of dimensional databases.
http://www.kimballgroup.com/1996/09/factless-fact-tables/

How your day starts with Quantum Physics
http://www.forbes.com/sites/chadorzel/2015/04/15/how-your-morning-starts-with-quantum-physics/

Popular News:


Political (I used to be much more into politics but not so much anymore):

Tuesday, May 1, 2012

A managers guide to understanding business intelligence. 7 steps to success.

 Data Analytics, Business Intelligence, operation analytics, reporting system and KPI’s. No matter what you call it, the idea is to understand your data and to leverage data to help make informed business decisions. The task can be and often is daunting but it is doable.
The seven steps.
1.       Process flow. First you need to have a general understanding of the business process flow. This can be a simple flow or complex but every process has a flow with inputs and out puts.
While working at BYU as an assistant network architect I had the opportunity to develop a five year network migration plan and researched and wrote the section on network monitoring and health. The first task in starting this process was to understand the underlying platform, its connectors and the inputs and outputs. To help with this I diagramed a large network map to visualize the various components and connectors. With any business process a map can and should be created to give insight into the flow of the process. Once the process has been mapped out the next step is to collect data.

2.       Questions. Understanding the questions you want to ask. In the last 20 years of working with business managers, systems and data the most crucial step is to know what to ask. You might think that you need to have the data, the reporting system, the analytics horse power and everything else in place before you can ask questions, but in-fact you would be wrong or at least very frustrated when you turn the system on the first time. Questions are key to any reporting and analytics system. Its so important that this started out as step 4 then I moved it to 3 and now its number 2. I am considering moving it to number 1. You need to write a list of questions you have about your processes. Make it a list of 50, then add on another 50 or more until you are satisfied. When you hand this list over to your developer or consultant they will look at you strangely and probably think, “this person is crazy, they want the imposable” but don’t worry. When you sit down with them in a room and walk through each one of the item, don’t spend more than a minute on each one, they will quickly understand what you want and their minds will start to turn. Note: if you don’t see the turning going on in their mind find someone else to work with, you have the wrong person. There are at least three very good reasons to write the list, it will help you define what you think you need, it will focus the developer and when you are all done if the system doesn’t have a way to answer question number 38 you can renegotiate.

3.       Collecting data is both easy and difficult. In today’s technologically rich world data is being collected every second. In fact, a large portion of the data collected today is thrown out, often the most important part of the data for any organization that wants to improve. Have you ever asked a question in a meeting and gotten the response “the system doesn’t track that information” or something to that effect. Often it’s not that the system can’t track the data but no one thought about adding in that 30 second change to the code that would have provided that critical missing piece of data. If fact, I was on a call the other day when I was discussing the possibility of collecting a piece of data to segment out certain customers and was told, that data is not stored in the reporting system. So while on the call, I pulled up the reporting database and looked at the data table and found that the column for collecting the data was actually in the database so I blurted out “the column is in the table”. The response was that during the development process someone decided not to add the code to populate the field. To fully leverage the collecting data stage, just say yes whenever someone says, “which pieced of data do you want to collect”. And please ignore the complaints about, “there is not enough storage”, “it will slow down the processing”, and the big one “it will take too much time to do the work”. It is true that it will take more time but when put it into perspective the time is minimal. It might add an additional eight hours of coding (probably only 15 minutes) but in the future that piece of data may help reduce labor hours 100 fold or more, probably more. The risk reward ratio can truly be fantastic. So collect the data.

4.       Short section on where to store the data. There are two types of data in my world, production data or transactional data stored in your production systems and reporting data. Reporting data should be stored on a separate server and should be formatted to optimize reporting.

5.       Getting to the data. The next step in the process is to pull some data. The availability of systems on the market to help you understand your data can be overwhelming but don’t be. You can spend $0 using a free database system and a free reporting system downloaded from the web (they actually work quite well) to tens of millions of dollars for a complex “over the top” system with every bell and whistle including the ERP, iPhone graphs and automated outbound reminder phone calls to customers. I’ve used both and many in between. Buy what you need. I have worked in small organizations with limited budgets where the business has hired someone with web programming and SQL query skills to write a series of reports to track daily performance and I have worked in an organization that had a team the size of a small company dedicated to supporting a multimillion dollar reporting package. In both cases the management team was only served when the system could answer the most pressing questions on that day.
 Note: SQL is the language used to pull data out of a database or in other words, the language used to ask the data questions and if written correctly, provide an answer.
 To get to the point pick a system that is affordable for you.

6.       Talent.  The system you buy is not as important as the people you hire to write the questions. If you have been in business long you probably already know this to be true. I would like to run through the list of available talent:

               Level i.            This is your basic level SQL programmer. They can pull a simple SQL statement out of a database and put it into Excel. Level i’s usually have no formal training but are great in a small organization. It may be a good idea to have mid level managers learn this skill.
              Level ii.            Advanced SQL programmers with training in one or more reporting applications. These guys are great at writing reports but require very good documentation in order to deliver what you expect. In the past few years India has trained a large number of Level ii resources.
            Level iii.            Advanced SQL programmers with training in multiple reporting platforms, custom programming skills and most importantly the ability to both understand the questions you need answered and how and where to pull the data themselves and how to direct others in pulling the data.
            Level iv.            This next level is a bit of a jump and many level iii’s don’t connect the dots to level iv but it is real. A Level iv can do and has done the previous levels but also has an understanding and the ability to use statistics to truly understand and answer your questions. The unfortunate thing is there are very few level iv’s in the market place. The good news is you can pair a level iii with a statistics major (maybe even an intern, maybe) and get a Level iv by grouping talent. You may be thinking to yourself, I can just stick with a level iii and we will be fine. I used to think so too. The issue is that I have seen more mistakes made by managers who interpret the data from a level iii incorrectly and as a result mis-spent countless hours and 100’s of thousands of dollars trying to fix the wrong thing. I’m not exaggerating, I have seen it time and again. The manager gets the data, says “a-ha!” look at that pink, there is way too much pink and its costing so much money but when a regression or sample-T test or whichever statistical measurement is appropriate its discovered that the real opportunity is with blue. There was a reason for the statistics class I took in my undergrad degree and a reason why it was included in my MBA curriculum at Kellogg. More importantly it is why Nielsen is able to generate over $5 billion a year in revenue. Statistics matter and if used correctly will produce results!
Get good talent.

The final step. Believe. Okay what does that mean? It means you and your management team and your employees all need to believe the data. Numbers don’t lie and contrary to popular belief, statistics don’t lie. If your team does not believe in the data you have wasted your time and your company’s money. Everyone needs some level of training to know how to use the system and to understand the data. Training has to be constant; a one-time push will not have the desired effect. In a typical installation I have to train every new hire and I have to retrain everyone else about once a year. It’s not that it’s hard to understand and the training doesn’t have to be long or intense, people just need to be reminded and helped through the process. You will find that people, trained or not, will come up with all kinds of ways to misuse the information or forget what this or that means. I chalk it up to being human, which is not a bad thing. Well trained employees will believe and they will use the data and they will find ways to become more efficient and your team will succeed.

Thursday, December 15, 2011

Graduation Day



On 12/10/2011 I graduated from the Kellogg School of Business with a Masters in Business Administration. I loved it! The best people, the best professors, the best school and the best program I could have hoped for. On 12/15/2011 my graduating class photo was published in the Wall Street Journal.






Tuesday, August 31, 2010

Evaluating good leaders

This is a video from WSJ.com interviewing the CEO of American Express.
What AmEx's Ken Chenault Looks for in Hires


Friday, November 13, 2009

Buffett, Gates and Blankfein

I have read two very good articles this week and wanted to share. They are about investing and business so beware. The first was a town hall meeting with Bill Gates and Warren Buffett at Columbia University. The second was an article by John Arlidge about Goldman Sachs.

Here are some memorable quotes from the Town Hall:

"projecting out into the years ahead ... are we making the right investments, are we gaining on the competition, are we making it a little bit harder for people to replace what we're doing?"
- Gates

"the best systems are ones where you have good short-term metrics, great accounting, looking at profits, looking at risk and willing to do things long-term"
- Gates

"run this business like it's the only business that your family can own for the next 100 years. You can't sell it. ... Measure it by whether the moat around that business, what gives it competitive advantage over time has widened or narrowed. ... If the reason for doing something is everybody else if doing it, it's not good enough. If you have to use that as a reason, forget it"
- Buffett

Full transcript http://www.cnbc.com/id/33901003/

Insights from the Goldman Article
Inspect
"Staff rigorously price ... the bank's assets every day, down to the last cent, and forensically examine daily profit and loss. This helps the bank to see market trends clearly and early and, it believes, to manage risk better than most other banks. 'We think we make better decisions' says Beshel"

Work harder than everyone else
"you have to work harder than the average bear ... 'it's a 24/7 culture, When you're needed, you're here. and if you're needed and you're not answering your phone, you won't be needed very long"

Learn all you can
"You are programmed at an early stage to go out more than the other guy, to see more people - clients, hedge funds or private equity guys ... brain pick. You ask what's their best trade. How do they see the market? You offer something in return, but you always come back with something."

Work as a team
"then you feed it to colleagues who go to work trying to use the information to make money. It's a team effort" "we're in this together"

Develop systems that drive your values
"You can have a great career in banking as an individual, but it won't be here. The system weeds out those who can't play nicely with others"

Recruit the best talent you can find
"Most applicants are interviewed at least 20 times before they are made an offer and some more than 30 times."

Pay the best talent very very well
"Sachs isn't nicknamed 'Goldmine Sachs' for nothing. Some 953 employees got bonuses of at least $1 million in 2008"

Article http://www.timesonline.co.uk/tol/news/world/us_and_americas/article6907681.ece?token=null&offset=0&page=1

Monday, November 2, 2009

To Think

I heard or read a great statement the other day, "I want to think things I have never thought before."

Thursday, August 13, 2009

You must obey: Unwritten laws of technology

Here is a great list of all the reasons why your computer, cell and gadget never work like they should.

Law 1: For every fix that a Windows Update patches, the update will break two more things on your PC. — Darren Gladstone, PC World


Law 1: For every fix that a Windows Update patches, the update will break two more things on your PC. — Darren Gladstone, PC World

Law 2: The likelihood that Windows will automatically install time-sucking critical updates is directly proportional to your need to get your PC started. — Steve Fox, PC World

Law 3: The hard drive always fails just before you were going to back it up. — Denise Paolucci, Dreamwidth Studios via Help A Reporter Out (HARO)

Law 4: Your data will get corrupted just before you plug in your new backup external drive. —Darren Gladstone, PC World

Law 5: Your backup plan is only as good as your last successful restore. — Michael Fisher, ElephantDrive.com via HARO

Law 6: The number of USB ports on your Mac will always be one less than you need at any given time. — Blair Hanley Frank, Macworld

Law 7: Feeling time pressure to make a computer fix quickly will cause you to take longer. —David Marshak, via PC World Facebook page

Law 8: If you close the PC case with screws before testing, it won't work. If you test before closing, it will. — Harry Liebman via HARO


There are more: click the link to read the whole story.
http://www.msnbc.msn.com/id/32393717/ns/technology_and_science-tech_and_gadgets//