Cancel Preloader
BCT Academy
Home
About Us
Our Courses
Digital Marketing
UI/UX Design
Data Science
Web Development with Spring Boot
Data Analysis
Front-End Development Course
Mobile Application Development with React Native
Web Development with ASP.NET Core
Backend Development with MERN Stack Course
Web Development with Django
Blog
Contact
BCT Academy
Home
About Us
Our Courses
Digital Marketing
UI/UX Design
Data Science
Web Development with Spring Boot
Data Analysis
Front-End Development Course
Mobile Application Development with React Native
Web Development with ASP.NET Core
Backend Development with MERN Stack Course
Web Development with Django
Blog
Contact
Home
Data Analysis
Data Analysis Course
Data Analysis Course
Curriculum
4 Sections
43 Lessons
12 Weeks
Expand all sections
Collapse all sections
Module 1
Microsoft Excel (Spreadsheet)
11
1.0
Introduction to Data Analytics
1.1
Introduction to Microsoft Excel
1.2
Menus and Cell Structures
1.3
Understanding General Formatting
1.4
Mathematical Operations
1.5
Understanding Formulars and Functions
1.6
Complex Formulars – Cell Referencing
1.7
Quick Formatting and Analysis
1.8
Pivot Tables in Excel
1.9
Working with Charts
1.10
Capstone Project – Business Analysis
Module 2
Microsoft PowerBI
12
2.0
Introduction to PowerBI and its components
2.1
ETL in PowerBI
2.2
Power Query Editor for Data Transform
2.3
Introduction to Data Modelling
2.4
Creating Visuals on Dashboards
2.5
Building a Simple Sales Report
2.6
Building a Sales Report with Calculated Fields and DAX
2.7
Building an Intermediate Sales Report using Time
2.8
Intelligent Functions and DAX
2.9
Creating a Simple Financial Report using PowerBI
2.10
Publishing and Saving PowerBI Reports
2.11
Capstone Project-Social Media Storytelling
Module 3
Tableau
11
3.0
Visualization Types in Tableau
3.1
Data visualization in tableau
3.2
Connecting to various data sources
3.3
Carrying out simple visualization
3.4
Aggregation
3.5
Tableau calculations
3.6
Saving to tableau public
3.7
Combining data together
3.8
Join & Creating calculated fields
3.9
Forecasting
3.10
Capstone Project-Dashboard Stories
Module 4
SQL
9
4.0
Introduction to SQL
4.1
Installing XAMP and PostgreSQL
4.2
Database and Table (SQL CRUD, Export & Import)
4.3
Select Statements
4.4
SQL Aggregate Functions
4.5
Operations, Concatenation
4.6
Column Aliasing, Where Clause, Order By and Group By
4.7
SQL JOINS Queries and Sub-Query
4.8
Capstone Project – Sakila Database Query
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content