Get Started
Development

Data Analytics Bootcamp

Dive deep into the world of Data Analytics with our Ultimate Data Analytics BootCamp. Master essential skills in data manipulation, analysis, and visualization using tools like Excel, SQL, Python, and PowerBI. Learn to clean, process, and analyze data to make informed decisions and drive business insights. Elevate your data expertise and take the first step toward a successful career in analytics!
4.7 (253 user ratings)
★★★★★ 4.7/5
  • 4.721 students
  • Last updated 1/2025

Carefully Curated Curriculum

  1. Introduction to Excel Interface: Workbook, worksheets, rows, columns, cells, and basic navigation.
  2. Data Entry and Formatting: Formatting cells, conditional formatting.
  3. Basic Formulas and Functions: SUM, AVERAGE, COUNT, MIN, MAX.
  4. Cell Referencing: Absolute vs. relative referencing.
  5. Data Sorting and Filtering: Sorting columns, filtering rows.
  6. Introduction to Charts: Basic charts (bar, pie, line).
  1. Advanced Formulas: VLOOKUP, HLOOKUP, INDEX-MATCH, IF, nested IFs.
  2. PivotTables and Pivot Charts: Creating and analyzing data.
  3. Data Cleaning Tools: Text to Columns, Remove Duplicates.
  4. What-If Analysis: Goal Seek, Data Tables, Scenarios.
  5. Introduction to Power Query: Basic data import and transformation
  6.  
  1. Introduction to Power BI: Overview, installing Power BI Desktop.
  2. Connecting to Data Sources: Excel, CSV, web, databases.
  3. Data Transformation: Basic Power Query operations like removing duplicates, splitting columns.
  4. Creating Simple Visualizations: Bar charts, line charts, pie charts.
  5. Reports and Dashboards: Building your first report and publishing it to the Power BI service
  6.  
  1. Understanding Data Models: Relationships between tables.
  2. Creating Calculated Columns: Adding new fields.
  3. Creating Measures: Basic DAX (SUM, COUNT, AVERAGE).
  4. Using Hierarchies: Drill-down in reports
  5.  
  1. Advanced DAX: CALCULATE, ALL, FILTER.
  2. Time Intelligence: Working with date tables and time-based calculations (YTD, MTD).
  3. Custom Visualizations: Using marketplace visuals.
  4. Conditional Formatting and Dynamic Visuals: Enhancing reports with interactivity
  5.  
  1. Publishing Reports: Publishing from Power BI Desktop to Power BI Service.
  2. Creating Dashboards in Power BI Service: Pinning tiles, creating dashboards.
  3. Sharing and Collaboration: Sharing reports, managing permissions.
  4. Data Refresh and Scheduled Refresh: Automating report updates.
  5. Introduction to Power BI Mobile: Viewing and interacting with reports on mobile devices.
  6.  
  1. Introduction to Databases and SQL: Understanding RDBMS, basic SQL syntax.
  2. Basic Queries: SELECT, WHERE, ORDER BY.
  3. Filtering Data: Using operators, LIKE, IN, BETWEEN.
  4. Basic Aggregations: SUM, COUNT, AVG, MIN, MAX.
  1. Joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.
  2. Combining Data from Multiple Tables: Understanding relationships.
  3. Subqueries: Writing subqueries within SELECT statements
  1. Advanced SQL Functions: String manipulation, date functions.
  2. CASE Statements: Conditional logic in queries.
  3. Window Functions: ROW_NUMBER(), RANK(), PARTITION BY
  1. Data Insertion: INSERT INTO.
  2. Data Updates and Deletions: UPDATE, DELETE.
  3. Transactions and Rollbacks: BEGIN TRANSACTION, COMMIT, ROLLBACK
Instructors
Muhammad Abbas

Data Analyst

This course includes:
  • 62 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Free Webinar
  • Certificate of completion
Enroll now
share it :