Data Analytics

200,000.00

The value of Data Analytics has been recognized by practically every industry because of digital transformation. With the surge in data generation, the term “Data Analytics” has gained significance by assisting organizations in making critical decisions.

Lonadek’s Data Analytics course is a multi-level program designed to equip both new and experienced professionals and enthusiasts at all levels with relevant knowledge and skill in data analytics thus, preparing them for opportunities in the field of data science. This course provides a practical understanding of Microsoft Excel, Power BI, and SQL.

Description

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.