Still no participant
Still no reviews
On successful completion of this course, students will be able to:
Module: I
Data Visualization Principles for Dashboard Design:
Data Visualization: Principles and Types of Data Visualization
Dashboard: Meaning, purpose and benefits of dashboards, understanding dashboard design principles, layout, colour and display, common issue when building dashboards, choosing the right data visualization to communicate information effectively, displaying trends with charts. CFO Scorecard, Types of Dashboards: Business Dashboards, Management Dashboard, Strategic Dashboard, Analytical Dashboard, Operational Dashboard. Create a Dashboard based on real-time data: Practice Dashboard Design in Excel and Tableau with Graphs.
Module: II
Visualization of Financial Statement Analysis for Dashboard Design:
Preparation of different Dashboard with visualization of Financial Statement Analysis: Financial Key Performance Indicators (KPI) Dashboard, Profit and Loss Dashboard, Accounts Receivable & Accounts Payable Dashboard, Financial Performance Dashboard, Balance Sheet Dashboard, The Right Business Dashboards for every Users. Preparation of Dashboard for Financial Data Comparison Analysis: Development Trend Analysis and Key Financial Analysis. Project on preparation of the above with Excel and Tableau
Module: III
Visualization of Corporate Finance for Dashboard Design:
Preparation of different Dashboard with visualization of Corporate Finance: Financial Investment Dashboard, Funds Raising Dashboard, Components of Working Capital Dashboard, Dividend Dashboard, Cash Management Dashboard, CFO Dashboard, Project on preparation of the above with Excel and Tableau
Module: IV
Visualization of Stock Market for Dashboard Design: Visualizing Company Profits, Visualizing by Sector, Financial results by business segment in a Small Multiples Dashboard, KPI & Sparkline in Stock dashboard, Top PerformerStock Performance dashboard, PE ratio, Investment Returns, Investment Summary, Investment Comparisons, Stock Dividend Tracker, Stock Market Dashboard - Trend Analysis of Stock Performance, Dashboard for comparing Rates of Return, Security’s Rate of Return, Portfolio of Securities' Rate of Return, Security’s Risk, Project on preparation of the above with Excel and Tableau.
Text Book:
Reference Book:
Dashboard: Meaning, purpose and benefits of dashboards
https://www.youtube.com/watch?v=m7T8xBM7hSk
https://www.slideshare.net/matthieua/dashboard-definition-example
https://www.slideshare.net/J-Nevil/the-benefits-of-dashboard-reporting-for-business
Understanding dashboard design principles, layout, colour and display
https://www.youtube.com/watch?v=n3JdFWmoESQ
https://www.logianalytics.com/dashboarddesignguide/dashboard-design-fundamentals/
Strategic dashboards and Tactical dashboards
https://www.youtube.com/watch?v=NIQj-AiBajU
https://www.youtube.com/watch?v=0JBhwh2smAU
MANAGEMENT DASHBOARD
https://www.datapine.com/dashboard-examples-and-templates/management
Data Visualization Design Best Practices (Students’ Project)
https://www.youtube.com/watch?v=xYjmSVd6CyY
https://www.slideshare.net/jsi/data-visualization-design-best-practices
https://mschermann.github.io/data_viz_reader/introduction.html
Data Visualization Best Practices (Students’ Project)
Data Visualization: 7 Steps for Effective Visualizations (Students’ Project)
Financial Reporting Dashboard (Students’ Project)
https://www.youtube.com/watch?v=93WsSpm3pow
https://www.qlik.com/us/dashboard-examples/financial-dashboards
Financial Dashboards: 5 Must-Know Tips for CFOs (Students’ Project)
https://www.youtube.com/watch?v=2cV00jP_bwY
https://www.youtube.com/watch?v=ENkcbpByWYY
https://www.solvexia.com/blog/financial-dashboards-5-must-know-tips-for-cfos
Key Capabilities of a Financial Dashboard (Students’ Project)
https://www.qlik.com/us/dashboard-examples/financial-dashboards
Financial Dashboard Templates – Financial Statements (Students’ Project)
https://www.youtube.com/watch?v=Th0mUf-PSaU
MONTHLY FINANCIALS Accounts Payable & Receivable (Students’ Project)
Financial Performance Dashboard (Students’ Project)
https://www.klipfolio.com/resources/dashboard-examples/executive/financial-performance
Stock trading platform dashboard
http://courseware.cutm.ac.in/courses/financial-analysis-and-visualization/
Working as an Associate Professor (Finance) in the School of Management, Centurion University, and Management, Bhubaneswar. Completed MBA from Kanchipuram University in 1998 with specialization in Finance and done Ph.D. entitled “The Impact of Inflation on Business Performance under Conditions of Limited Financial Disclosure: Case of Firms Operating in India”. Have 15 years of teaching […]
Recent Comments