This course enables you to take raw data and uncover patterns to extract valuable insights from it and leverages software and services to transform data into actionable insights that inform an organization's (Departmental) strategic and tactical business decisions.
Delivery Mode: Online [Self-paced, self-directed]
Course Duration: 8 Hours
Certificate: Successful completion e-Certificate
Pre-requisite: Attendance at a mandatory orientation session is required.
This session will provide:
* An overview of course logistics.
* A detailed discussion of software and system requirements.
* Key information to ensure a smooth learning experience.
This course comprises 5 Modules such as follows:
Module 1: MS Power Pivot which is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models.
Module 2: MS Power Query, a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs.
Module 3: MS Excel VBA, an Excel macro is an action or a set of actions that you can record, give a name, save and run as many times as you want and whenever you want
Module 4: MS Power BI Desktop, is a free application you install on the local computer that lets you connect to, transform, and visualize your data. This Module is designed for beginner to intermediate-level Power BI users.
Module 5: MS Power BI Dashboard, This Module will show you how to link and model data in Power BI and create visual reports that reveal data insights.