Data Analytics
-
Byadmin
Description
Materials Used
- Excel Database: https://elearn.darachinfotech.com/wp-content/uploads/2026/02/Dirty-Dataset-1.xlsx
- Mastering Excel Formatting and Data Cleaning: https://elearn.darachinfotech.com/wp-content/uploads/2026/02/Mastering-Excel-Formatting-and-Data-Cleaning-1.pptx
- Solution: https://elearn.darachinfotech.com/wp-content/uploads/2026/02/Solution-1.xlsx
Curriculum
- 9 Sections
- 54 Lessons
- 8 Weeks
Expand all sectionsCollapse all sections
- Module 1: Introduction and Excel Basics0
- Module 1:1 Introduction to Data6
- Module 1:2 Understanding Excel for Data Analytics9
- 3.1Lesson 1: Introduction to Excel
- 3.2Lesson 2: Basic Features of Excel
- 3.3Lesson 3: Understanding Excel Interface
- 3.4Lesson 4: Relative cell Referencing
- 3.5Lesson 5: AbsoluteCell Referencing
- 3.6Lesson 6: Structure Cell Referencing
- 3.7Lesson 7: Mixed Cell Referencing
- 3.8Lesson 8: Functions and Formulars
- 3.9Lesson 9: Mastering Excel Data Formatting
- Module 1:3 Data Cleaning3
- Module 2: Excel and Statistics7
- Module 3: Dashboarding with ExcelMaterials Used6
- Module 4: Getting started with Power BI11
- 7.1Lesson 1: introduction to PowerBI
- 7.2Lesson 2: PowerBI Achitecture
- 7.3Lesson 3: Downloading PowerBI
- 7.4Lesson 4: PowerBI Workflow
- 7.5Lesson 5: How does a company use powerBi to drive business
- 7.6Lesson 6: Data Modelling
- 7.7Lesson 7: Concept of Primary and Foreign Keys
- 7.8Lesson 8: What is ERD
- 7.9Lesson 9: Facts and Dimensions Tables
- 7.10Lesson 10: Building ERD with DRAW.IO
- 7.11Lesson 11: PowerBI interface
- Module 5: Intermediate Power BI (DAX and Dashboarding)6
- Module 6: SQL for Analytics6
Instructor
2 Students5 Courses
Price
₦30,000.00
You might be interested in
₦30,000.00
Get in touch
Need some help?
- © Darach InfoTech Academy.All rights reserved.