Business Intelligence and Data Visualization

Description

This course Business Intelligence and Data Visualization equip participants with the skills needed to make better use of data at their disposal by either extracting valuable insights from the data, designing dashboards with an impressive flow of information with stunning visuals, creating reports, or performing data analysis.

As the shift towards data analysis and data-backed decision making intensifies in Nigerian organizations, the need to extract valuable insights from data and present the data, in such a way to easily pass on the information it contains, in a visually pleasing manner becomes highly valuable in every organization.

Although this training uses 3 platforms (PowerBI, Tableau, and Spotfire) for the practical aspects, it is designed in such a way to focus on the methodologies and thought process needed, through various case studies, rather than the platform itself. This is to enable participants to acquire skills that are platform-independent.

Training Objectives

At the end of the training, participants will be able to;

• Participants will be exposed to the frontiers of BI-intensive BIG data computing and information systems while providing a sufficiently strong foundation to encourage further research.
• Participants will learn in-depth knowledge of Business Intelligence (BI) principles and techniques by introducing the relationship between managerial and technological perspectives.
• Gain a comprehensive introduction to the vast Business Intelligence field from the business. requirement gathering to advanced topics such as Big Data and Predictive Analytics.
• Learn the fundamentals of database design, data warehousing, and various advanced techniques for retrieving and storing data.
• Gain knowledge of powerful analytics techniques and learn how to properly interpret the results

Become skilled at the development of effective visualization techniques that can effectively tell a story.

Learning Outcomes

At the end of this course, workshop participants will understand how to:

• Identify the major frameworks of computerized decision support: decision support systems (DSS), data analytics, and business intelligence (BI).
• Explain the foundations, definitions, and capabilities of DSS, data analytics, and BI.
• List the definitions, concepts, and architectures of data warehousing.
• Demonstrate the impact of business reporting, information visualization, and dashboards.
• Explain data mining, neural networks, support vector machines, text analytics, text mining, sentiment analysis, web mining, web analytics, social analytics, social network analysis.
• Outline the definitions, concepts, and enabling technologies of big data analytics.
• Apply big data technologies in business intelligence using geospatial data, location-based analytics, social networking, Web 2.0, reality mining, and cloud computing.
• Identify the major ethical and legal issues of analytics.
• Describe how analytics are powering consumer applications and creating a new opportunity for entrepreneurship for analytics.

Course Modules

Introduction to Analytics

• Defining Analytics
• Analytics groupings
• Analytical thinking
• Understanding data
• Analytical process

Introduction to Business Intelligence

• Understanding Business Intelligence
• Defining goals
• Extracting insights
• Making your case

Business Intelligence and Visualization tools

• Various tools
• Choosing your preferred tool
• Tools learning curve

Data sources and preparation

• Connecting to Data Sources
• Merging data
• Data transformation
• Creating new fields
• Case studies

Data Visualization

• Identifying the right information to display
• Choosing the right chart to best suit your goal
• Creating information flow
• Case studies

Designing Dashboards and Reports

• Summary tables
• KPI’s
• Trends
• Reports
• Case studies

Mining for insights/Intelligence

• Data exploration
• Drill-downs
• Identifying unique insights
• Creating a road map to insights
• Case studies

Descriptive and Predictive Analytics

• Segmentation Analysis
• Forecasts
• Regression/Logistic Regression Analysis
• Incorporating predictive analytics to Case studies
• Dashboards

Target Audience

This training is designed for Business analysts, Managers, anyone interested in Business Intelligence, and Visualizing data.

Mode Of Delivery

Virtual Class with instructor-led class exercises and project-based/assignments learning methodology
12 hours of learning sessions,
Course material and Course Certificate will be issued
Course video available on demand
Face- to- Face learning available on request