AI Engineering
Data Analytics
80-hour Data Analytics course with 6 chapters and 80 lessons.
0+
Learners
0.0
Rating
80
Days
80
Lectures
Courszo Faculty
Description
80-hour Data Analytics course with 6 chapters and 80 lessons.
What You Will Learn
- SQL & Database Fundamentals
- Core Python for Data Analytics
- NumPy, Pandas, Plotting & ETL
- Power BI
- Tableau
- Data Analytics Capstone Project
Video: Database concepts, DBMS and RDBMS
0.5
Video: MySQL setup, databases and tables
0.5
Video: SELECT, WHERE, ORDER BY and DISTINCT
0.75
Video: INSERT, UPDATE, DELETE and CRUD
0.5
Video: Functions, aggregations and GROUP BY
0.75
Video: Joins: INNER, LEFT, RIGHT and CROSS
1
Video: Subqueries, constraints, indexes and transactions
1
Video: Python setup, syntax and variables
1
Video: Data types and type conversion
1
Video: Operators and expressions
0.75
Video: Strings and string methods
1
Video: Lists, tuples, sets and dictionaries
1.5
Video: Conditional statements
1
Video: For loops, while loops and nested loops
1.25
Video: Functions, parameters and return values
1.5
Video: Lambda, map, filter and reduce
0.75
Video: Modules, packages and imports
0.75
Video: Exception handling
1
Video: File handling: CSV, TXT and JSON
1.25
Video: Comprehensions and Pythonic programming
0.75
Video: Object-oriented programming fundamentals
1.5
Video: Iterators, generators and decorators
1
Video: Virtual environments, pip and requirements
0.75
Video: Dates, time and regular expressions
0.75
Video: Python data-processing exercises and mini project
2.5
Video: NumPy arrays and vectorized operations
1.25
Video: NumPy indexing, slicing, reshaping and aggregation
1
Video: Pandas Series and DataFrames
1.25
Video: Reading CSV, Excel, JSON and database data
1
Video: Data selection, filtering and sorting
0.75
Video: Data cleaning: missing values, duplicates and types
1
Video: Merge, join, concatenate, groupby and pivot
1
Video: Matplotlib chart fundamentals
0.75
Video: Seaborn analytical visualizations
0.5
Video: ETL pipeline: Extract, Transform and Load
1.5
Video: Power BI ecosystem, Desktop and Service
0.75
Video: Connecting Excel, CSV and database sources
1
Video: Power Query interface and workflow
1
Video: Data types, profiling and query management
0.75
Video: Cleaning and transforming data with Power Query
1.25
Video: Merge, append and combine queries
1
Video: Parameters, custom columns and conditional logic
1
Video: Power Query M fundamentals
1
Video: Data modeling and star schema
1.25
Video: Relationships, cardinality and filter direction
1
Video: Date tables and time intelligence foundations
0.75
Video: DAX fundamentals and calculated columns
1.25
Video: Measures and evaluation context
1.5
Video: CALCULATE, FILTER and iterator functions
1.5
Video: Time intelligence DAX
1
Video: Text, logical, statistical and ranking DAX
1
Video: Power BI visuals and formatting
1
Video: Slicers, filters, drill-through and tooltips
1
Video: Bookmarks, buttons and interactive navigation
0.75
Video: Dashboard and report design principles
1
Video: Advanced visuals and KPI reporting
0.75
Video: Power BI Service, workspaces and publishing
0.75
Video: Scheduled refresh, gateways and sharing
0.75
Video: Row-level security and governance basics
0.75
Video: End-to-end Power BI dashboard project
1.25
Video: Tableau ecosystem, Desktop and interface
0.75
Video: Connecting Excel, CSV and database sources
0.75
Video: Dimensions, measures and data types
1
Video: Filters, sorting and groups
0.75
Video: Calculated fields and basic expressions
1
Video: Parameters and sets
1
Video: Charts: bars, lines, maps and scatter plots
1
Video: Advanced charts and analytical visuals
1
Video: Table calculations and aggregations
1
Video: LOD expressions: FIXED, INCLUDE and EXCLUDE
1.25
Video: Dashboards, containers and device layouts
1
Video: Actions, filters and interactive dashboards
0.75
Video: Story points and presentation of insights
0.5
Video: Publishing, Tableau Cloud/Server and sharing
0.75
Video: End-to-end Tableau dashboard project
2.5
Video: Business problem, KPI definition and data requirements
0.75
Video: Data extraction, cleaning and transformation
1
Video: SQL/Python analysis and insight generation
1
Video: Power BI/Tableau dashboard development
1.25
Video: Final presentation, insights and project documentation
1
Courszo Faculty
(4.5)
1 Courses
0 Enrolled
Experienced instructor focused on practical, project-driven learning.
0.0
0 Students Review
Reviews (0)
No reviews yet.
