Design a dashboard for the KPIs discussed using Visio or Excel.
Information Strategv for a Radio Station Who Executive management function Executive management sets CEO's What to Do Radio Station Example Executive management sets overall strategic targets for the overall business targets business Return on equity (KPI 1) 15% Market share (KP12) 25% Business function Functional Managers/directors set strategic target at the And operational decision makers in HR, sales, production marketing, finance Functional managers/ directors Program manager sets target: Average listening time (KPI 3) 30 minutes functional level Operational decision makers improve upon businessS processes using information created by the BA function DJ's and newsreaders improve their processes by broadcasting music and news in accordance with listeners tastes at different times of the da DJ's and newsreaders demand information about listeners tastes/ profiles at different times of he da perational decision makers demand and use information BA Function Analyst, controller, data manager, and report developer analytical methodology Identify business requirements Analyst identifies listeners and create information using profiles at different times of the day by using data mining methodology, and report developer creates reports Data warehouse function ETL developer and database specialist Gather, enrich, and supply data ETL developer and database for business use, based on specialist gather, enrich, store and deliver data on the listeners age, gender, tastes, moods, and listening times based on requirements from the analvst IT professional creates new requirements from analyst. Data source and IT infrastructure function IT professionals Maintain and develop IT infrastructure for data to be created urce data by developing an electronic questionnaire on the Web site to be completed by radio station listeners based on requirements from the data warehouse team Information Strategv for a Radio Station Who Executive management function Executive management sets CEO's What to Do Radio Station Example Executive management sets overall strategic targets for the overall business targets business Return on equity (KPI 1) 15% Market share (KP12) 25% Business function Functional Managers/directors set strategic target at the And operational decision makers in HR, sales, production marketing, finance Functional managers/ directors Program manager sets target: Average listening time (KPI 3) 30 minutes functional level Operational decision makers improve upon businessS processes using information created by the BA function DJ's and newsreaders improve their processes by broadcasting music and news in accordance with listeners tastes at different times of the da DJ's and newsreaders demand information about listeners tastes/ profiles at different times of he da perational decision makers demand and use information BA Function Analyst, controller, data manager, and report developer analytical methodology Identify business requirements Analyst identifies listeners and create information using profiles at different times of the day by using data mining methodology, and report developer creates reports Data warehouse function ETL developer and database specialist Gather, enrich, and supply data ETL developer and database for business use, based on specialist gather, enrich, store and deliver data on the listeners age, gender, tastes, moods, and listening times based on requirements from the analvst IT professional creates new requirements from analyst. Data source and IT infrastructure function IT professionals Maintain and develop IT infrastructure for data to be created urce data by developing an electronic questionnaire on the Web site to be completed by radio station listeners based on requirements from the data warehouse team
