Learning Outcomes

Participants attending this program will;

• Demonstrate knowledge of big data analytics.
• Demonstrate the ability to think critically in making decisions based on data and deep analytics.
• Demonstrate the ability to use technical skills in predictive and prescriptive modeling to support business decision-making.
• Demonstrate the ability to translate data into clear, actionable insights.
• Demonstrate effective communication skills that facilitate the effective presentation of analysis results

Modules

Module 1

Microsoft Excel

• Introduction to Microsoft Excel.
• Basic Excel Functions
• Data Cleaning.
• Pivot Tables and Pivot Charts.
• Building Dashboards.
• Data Presentation with PowerPoint.
• Understanding Statistical Functions.
• Introduction to Power BI

 

Module 2

Power BI

• Introduction to Power BI.
• Data Modelling and DAX
• Data Visualization
• Introduction to SQL

 

Module 3

SQL

• Introduction to SQL.
• Basic Commands and Functions of SQL
• SQL for Data Administrations (To create tables, Indexes and Views
• SQL for Data Manipulation (To Add, Modify, Delete and Retrieve Data)
• Use of SQL to Query Databases to Extract Useful Information.

 

Module 4

End of Training

• Business case projects.