- Description
- Curriculum
- Reviews
Data Analytics Training Program for Professionals using Power BI. Learn to make sense of your data.
Audience
Business professionals seeking to enhance their data analytics skills for practical application in their jobs. Learn all you need to know to start making sense of your data.
Overview
At the end of this program, learners shall be able to demonstrate practical understanding of Excel for data management and Power BI for creating meaningful visualisations to drive business insights. The focus is on practical skills and their application in a business context.
Why Power BI?
In today’s data-driven world, harnessing the true potential of information is key. Power BI stands out as the ultimate tool, empowering you to visualize data, extract valuable insights, and make informed decisions. Whether you’re a beginner or an experienced professional, this course caters to all skill levels.
What Makes Us Stand Out?
At Camanda Tech Academy, we’re dedicated to your success. Our industry-expert instructors bring years of experience to the table, ensuring you grasp complex concepts with ease. You’ll dive deep into data modeling, visualization techniques, and advanced analytics—all in an interactive, hands-on learning environment.
Key Highlights of the Course
- Comprehensive training in Power BI from basics to advanced techniques.
- Real-world case studies and projects to apply your learning.
- Interactive sessions and personalized guidance from industry experts.
- Certification upon completion, bolstering your professional profile.
Join countless professionals who’ve unlocked doors to new opportunities through our courses. With Camanda Tech Academy, take a leap towards a brighter, data-driven future!
Enroll now and transform your career with the Power BI Data Analytics Course.
-
1Session 1: Getting Started with Data
This week, we aim at preping your minds as you embark on this exciting journey into the world of possibilities. In this immersive exploration, we'll demystify the power of data, unraveling its secrets and uncovering the keys to harnessing its potential.
-
2Class Video 1 - Introductions
-
3Class Video 2 - Understanding the Relevance of Data Analytics in Business Decision-making
Topic: Understanding the Relevance of Data Analytics in Business Decision-making
What is Data Analytics?
What role does data analytics play in decision making?
Common data challenges
-
4Session 1 Assessment
-
5Session 2: Spreadsheet Fundamentals
-
6Class Video 3 - Spreadsheet Fundamentals
01. Introduction to Spreadsheet Fundamentals using Microsoft Excel as a case study
02. Alternative Spreadsheet Apps - Google Sheet, SharePoint, Smartsheet, etc.
03. Hands-on Activity: Creating and formatting spreadsheets for data entry.
-
7Session 2 Assessment
-
8Session 3 : Excel for Everyday Business Use
-
9Class Video 4 - LEVERAGING EXCEL FOR BUSINESS DATA MANAGEMENT & ESSENTIAL EXCEL FUNCTIONS FOR BUSINESS
SESSION 3: LEVERAGING EXCEL FOR BUSINESS DATA MANAGEMENT & ESSENTIAL EXCEL FUNCTIONS FOR BUSINESS
You will learn some data cleaning tricks on Excel. We'll go from having a raw dataset that has several errors, to a clean dataset that we can present to our managers. For this, we will learn tricks such as text-to-columns and remove duplicates, and several formulas such as the trim, proper, lower, iferror and more.
-
10Session 4: Data Visualization with Excel
-
11Class Video 5 - DATA VISUALIZATION WITH EXCEL
Week 2 --- EXCEL FOR EVERYDAY BUSINESS USE
Session 4 --- DATA VISUALIZATION WITH EXCEL
You will learn how to create an interactive dashboard using Pivot Tables and Pivot Charts. Do not worry if you have never created a Pivot Table before.
- We will cover some of the different pivot table calculation types.
- How to calculate the average, count, sum, and percentage of total.
- How to update your pivot table with more data, and also how to refresh your pivot tables.
Class: Data Analytics for Professionals [Jan 2024 Cohort]
Instructor: Kingsley Opara
Recording Date: 2024-02-04
Organised By: Camanda Tech Academy
Video Format: HD
-
12Cleaning Up data and Recreating Sessions 3 & 4 Classwork
-
13Session 5: Introduction to Power BI and Data Visualization
-
14Class Video 6 - Pivot Tables & Pivot Charts in Excel
Week 3 --- INTRODUCTION TO POWER BI AND DATA VISUALISATION
Session 6 --- Pivot Tables and Pivot Charts in Excel Class: Data Analytics for Professionals [Jan 2024 Cohort]
Instructor: Kingsley Opara Recording
Date: 2024-02-10
Organised By: Camanda Tech Academy
Video Format: HD
-
15Class Video 7 - An Introduction to Power BI
Week 3 --- INTRODUCTION TO POWER BI AND DATA VISUALISATION
Session 7 --- An Introduction to Power BI Class: Data Analytics for Professionals [Jan 2024 Cohort]
Instructor: Prof. Emmaxson
Recording Date: 2024-02-10
Organised By: Camanda Tech Academy
Video Format: HD
-
16Session 5 Assessment - Introduction to Power BI
-
17Session 6: Introduction to Power BI and Data Visualization (2)
-
18Class Video 8 - Introduction to Power BI & Data Visualisation
Week 3 --- INTRODUCTION TO POWER BI AND DATA VISUALISATION Session 8 --- An Introduction to Power BI & Data Visualisation
Class: Data Analytics for Professionals [Jan 2024 Cohort]
Instructor: Kingsley Opara
Recording Date: 2024-02-11
Organised By: Camanda Tech Academy
Video Format: HD