BIG DATA ANALYSIS AND DASHBOARD WITH MICROSOFT EXCEL FOR BUSINESS ANALYSTS

Live-Online Training: N220,000
Classroom Training: N300,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount

(Available also for Customised Training by Duration, Venue & Fee)

Course Description

This intensive 4-day training program is designed to equip business analysts with the knowledge and skills necessary to leverage Microsoft Excel for Big Data analysis and dashboard creation. Participants will learn how to harness the power of Excel's advanced features to analyze large datasets, extract valuable insights, and create interactive and informative dashboards for data-driven decision-making. The course covers key concepts, techniques, and best practices for working with Big Data, ensuring that business analysts can effectively analyze and visualize data to drive business success.

Prerequisites

Participants should have a basic understanding of Microsoft Excel. Familiarity with basic statistics is a plus but not required.

Course Objectives

By the end of this training program, participants will be able to:

• Understand the fundamentals of Big Data and its relevance to business analysis.
• Proficiently use Microsoft Excel for advanced data analysis tasks.
• Employ various data cleaning and preparation techniques for Big Data.
• Apply statistical and analytical tools to extract meaningful insights from large datasets.
• Create interactive and visually appealing dashboards in Excel.
• Effectively communicate complex data findings to stakeholders.
• Optimize data analysis workflows for improved efficiency and accuracy.

Course Content

DAY ONE

Introduction to Big Data and Excel for Business Analysts

• What is Big Data and what they mean to businesses
• Introduction to Microsoft Excel for data analysis
• Data import techniques for large datasets
• Data cleaning and preparation
• Subtotal Application
• Pivot Table.

 DAY TWO

Advanced Data Analysis in Excel

• PivotTables and PivotCharts for summarizing data
• Data modeling and analysis with Power Query
• Introduction to data analysis functions (e.g., SUMIFS, COUNTIFS, AVERAGEIFS)
• PowerPivot for Data Mining
• Power Map.

DAY THREE

 Big Data Analytics Techniques

• Understanding and working with structured and unstructured Big Data
•  Predictive modeling with Excel
• Charting Large Data
• Understanding the principles that guide visualizing large data
• Making charts that bring insights to a large data
• Building a large data dashboard.

Making Professional Reports in Excel and Dashboards

• Linking sheets 
• Duplicating sheets (better than copy and paste)
• Inserting sheets, labeling and coloring the professional way
• Freezing Panes and splitting windows
• Conditional formatting.

DAY FOUR

Designing and creating interactive dashboards in Excel

• Incorporating slicers, timelines, and sparklines
• Sharing and presenting data dashboards with stakeholders
• Excel to PowerPoint
• Linking PowerPoint Charts to Excel
• Embedding Excel sheets in PowerPoint

Excel to Word

• Mail Merge: Sending a personalized mail to a list of people
• Linking PowerPoint Charts to Excel
• Embedding Excel sheets in Word