BI is what you get when you analyze raw data and turn that analysis into knowledge. BI can help an organization identify cost-cutting opportunities, uncover new business opportunities, recognize changing business environments, identify data anomalies, and create widely accessible reports, among other things.
Dashboard reports allow managers to get high-level overview of the business. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.
How participants will benefit after the course:
Managements need the ability to step back from the details and see the bigger picture. Dashboards provide that picture. Most managers must report their performance to others. Managers of privately held businesses often must report to Board members, bankers, and spouses. Managers of public companies must report to others in the chain of command. Managers of both types of Organization need to provide a clear picture of business performance. Dashboards provide that picture.
Unfortunately, small companies and divisions typically can’t afford expensive software designed to support dashboard and other business reporting. This doesn’t need to be a problem, however, because small businesses typically have a simple organizational structure. They can use Excel to fulfill their requirement.
Workshop topics to be covered:
• Understanding the overall Philosophy of BI and Dashboard
o Why is it needed
o How it effects
o And why should you do it
• Constructing and Identifying the Key Components
• Understanding sample Workbooks, how they have been made, how they have been organized?
• Formatting the Dashboard
• Learning Basic Excel Components to Build the Dashboard:
o Pivot Table
o Sumifs Function
o Vlookup Functions
o Data Validation List
o Understanding Table
o Macros for the WOW Effect
• Building a Basic Business Intelligence Dashboard
• An Overview of PowerPivot [If Time is Available]