Build Your Own Dashboard of Key Indicators


by scott pickard

One of the most important responsibilities of the CEO is to communicate the current and projected future performance of the organization. A well accepted technique for this is called a “dashboard of key indicators.” If you sit on a Board of Directors, you want to see regular updates of key indicators in an easily accessible, simple, visual format. I’ve found that Prezi provides a perfect platform to do this.

Corporations have the capital to purchase and deploy fancy enterprise systems (or cloud-based systems) and the financial staff to take care of this kind of thing. But if you’re an entrepreneur or small business person, you’ve got to figure out a way to do this for yourself. I will show you a way to do this using Prezi and other common off-the-shelf tools (software) that you probably already have access to.

But first, let me show you what the end product can look like and talk about the benefits of using Prezi.

The beauty of the Prezi dashboard

Online, anytime, anywhere, on any mobile device: I think this benefit is pretty self-explanatory. Click on the following link and it will take you to a public dashboard which we can use as a demonstration:

The picture below shows you that a Prezi dashboard looks great on any device: PC, laptop, iPad, and smartphone.

The infinite whiteboard: Prezi is famous for what they call the “infinite whiteboard” concept. The navigation functionality made possible by this is what makes it so powerful and appealing as a presentation tool.

The first thing most users will do is click on the home icon along the right-hand border of the window which will pop the entire dashboard inside the window giving you the big picture overview of the dashboard.

From this vantage you can navigate one of several ways:

Click on the full-screen mode icon and a slide will fill the monitor screen (similar to presentation mode in PowerPoint). This is the preferred mode when making a presentation to an audience.

The user can either manually advance through each slide by clicking on the right or left arrows on the bottom of the window; or, the user can set “autoplay” to one of several different timing intervals.

On any given slide, the user can zoom in or out at will thanks to the “infinite whiteboard” of Prezi. Back-and-forth, zoom in and out, pop back to home, this is the kind of easy flexibility a user wants when navigating a dashboard.

Privacy: You can share online your dashboard using Prezi’s three-level privacy functionality:

  • Private: only you can view and edit.
  • Hidden: you can view and edit. Collaborators can view if they have the link.
  • Public: it can be viewed by the world if they have the link.

DIY dashboard

To get started you need the following:

  • Microsoft Excel spreadsheet
  • Microsoft PowerPoint
  • Adobe PDF maker
  • Prezi

Creating the graphs: Microsoft Excel gives you everything you need to set up all of your key indicator data and then convert that data into visually impactful graphs and charts. Each chart can be copied and pasted into a PowerPoint presentation file as an image.

Once all your slides are transferred into PowerPoint, you then need to “save as” the PowerPoint file as a PDF file. It is true that you can directly import a PowerPoint file into Prezi but I have found that sometimes formatting of the slides can be lost. By converting it to a PDF file, the formatting of each slide is “locked” and when you import the PDF file into Prezi, each slide comes out perfect.

Next, you import the PDF file into your new Prezi presentation space which you have created online. When you do this, Prezi magically unbundles each slide within the PDF file and arranges them separately in their correct original order.

And finally, you click “edit path” in the lower left-hand corner of your Prezi window to then click on each slide in the order you want them presented, and then click “done”.

You have now created a world-class dashboard!

- sp -

Fourth Industrial Revolution

Human Society Production and Utilization of Wealth  Are we on the cusp of a Fourth Industrial Revolution?  Will it be a force for good or evil?  Will it provide new opportunities for all, or will it exacerbate inequalities? Davos ‘16 > Randomness/unintended Economic Theory and Systems Economic Theory: index of economic freedom Economic Systems Historical development of economic systems Capitalism Centrally-planned systems Appraising economic systems The Consumer and the Market Scarcity, utility, and value: behavioral economics: | Valuation Consumer behavior: Buying Decisions | inelasticity Markets: markets hate uncertainty Price system in capitalist economies Organization of Production and Distribution Organization of the production of goods Marketing and Merchandising Inputs of the productive process Institutions that facilitate business formation, production, output Money Currency & Exchange Stock exchanges: AI Banks International: Bank for International Settlements BIS economic statistics business organization stock markets: Volatility Index (VIX) fear index Agricultural economics International trade Government’s role in production & distribution: privatization Methods of business organization Advertising & Promotion Distribution of risk Consumer credit: Don’t use a credit card for a loan sp Distribution of Income and Wealth the rich get richer and the poor get poorer Matthew Effect Distribution by categories of the population: Forbes 400 | gini coefficient How government affects the distribution Capitalism Taxation Laffer Curve postulates that no tax revenue will be raised at the extreme tax rates of 0% and 100% and that there must be at least one rate where tax revenue would be a non-zero maximum. Poverty Macroeconomics National income and employment theory misery index unemployment: U3 and U6 Intl. equilibrium and disequilibrium Business cycles Inflation and deflation key indicators: monetary velocity Economic Growth and Planning Nature and causes of economic growth Planning for economic growth and stability Government Finance Growth  books, forums, journals: innovation: The Fourth Industrial Revolution Schwab | behavioral: Misbehaving Thaler | Capital in the Twenty-First Century Piketty big ideas | Stealth of Nations by Neuwirth | The Mystery of Capital De Soto | The Wealth of Nations Smith | Wall Street Journal | World Economic Forum Davos

Davos 2016: Fourth Industrial Revolution


China’s Social Credit System

World Since 1920 / East Asia in the 20th century China since 1912 When America China sneezes, the whole world gets a cold. Long term, is it a good idea to take China’s money? Will China’s model for growth which extracts a heavy sacrifice and toll from its people, be sustainable? Development of republic 1912-20: old order disintegrated Interwar years 1920-37: growth of Chinese Communist Party (CCP) War against Japan 1937-45: 2nd Sino-Japanese War after 1st 1894–95 Kuomintang: anti-communism, Chinese nationalism, reunification Chinese Communist ideologies: dynamic to safeguard the party's rule Emergence of the People’s Republic of China economic reform: 60-point plan Internet  social credit: Sesame Credit > Gamification | e-Commerce: alibaba | internet sovereignty | messaging: tencent | search: Baidu orphans: Half the Sky social radar: dissent 2015 population: two-child policy | economy: market meltdown | October: Conflict in South China Sea in general: communist propaganda hip-hop…what!?: rap-aganda | food safety | buy anything: lightinthebox | consumer marketing: prcdirect      books/movies: propaganda: Propaganda Bernays | #1 movie: Monster Hunt | fragile: Red Capitalism Walter | history: In Search of History White | investing: The Chinese are coming, and they’d like to buy your house Francis

China’s social credit system (BBC)


Absorption of new technologies accelerates

big picture Technology Who are the world's most valuable tech companies? We wanted flying cars, instead we got 140 characters founders fund Is it evil? How fast is technology accelerating? - The Universe was created 13.8 billion years ago - Humans arrived 200,000 years ago - Machines arrived 100 years ago - What’s the next milestone? Development of Technology Elements of Technology Fields of Technology  in general: mapping the future: Metaculus > Future | early adoption: leveling the playing field | kids: uTech | news: re/code

Why is this guy the #1 ranked CEO in the world?

Management and Best Practices CEO CEOs make 300X more than workers, but are they doing 300X the work? performance evaluation What are the metrics for the top performing CEOs? > Board  Is the CEO in touch with the employee rank and file?  Does the CEO have employees' respect? Does the board require the CEO to complete a self-evaluation?  Has the board benchmarked the strategic performance of CEOs at peer companies?  Is the board responsive to the concerns of shareholders about the effectiveness and responsiveness of management?  On what grounds is the board considering firing the CEO? (a) poor company performance; (b) strategic disagreement with the board; (c) personality clashes; (d) consolidation of control due to merger; (e) unwillingness of CEO to comply with a board mandate; (f) personal problems; (g) illegal/improper behavior succession Promoting insiders is a strategy to maintain consistency, whereas hiring outsiders is a strategy for change. Sessions Has the board challenged the heir-apparent to be compared against external candidates?  Has the board been able to observe and evaluate the heir-apparent in representative trial assignments?  Is competition among internal candidates getting out of hand?  Does the board have a healthy collaboration with the incumbent CEO in the succession process?  Has the board established clear performance benchmarks and an exit timetable for the incumbent CEO?  Is the incumbent CEO attracting, hiring, and developing key employees worthy of succession candidacy?  Is there a turnover problem with top management candidates?  Does the incumbent CEO restrict access by the board to top management?  Should the board consider removing the incumbent CEO from the board?  Is the board developing and maintaining a familiarity with top succession candidates within and external to the company?  Is retirement of the incumbent CEO being delayed by lack of a successor? For the incumbent CEO close to retirement, has the board structured a compensation package to incentivize cooperation with a successful transition? interim CEO Does the board have a plan for an interim CEO in the event of a sudden and unexpected departure or death of the CEO? Does the board need to consider an outside turnaround specialist to manage the current crisis in the company? interviews Are we getting continuous improvement after each interview process? | interviews: Conversations from the Corner Office | videos: CEOcast  books/movies, articles, blogs: Steve Jobs: book, movie | CEO Succession Carey | Effective Succession Planning Rothwell Intersections | Poverty/income gap