Course Single

Data Analysis

image description

  • Introduction and Installations
  • Intro to Data Analysis and Installation of BI Tools.
  • Data Analysis with Microsoft Excel
  • Excel Interface - Navigation & Shortcuts
  • Understanding Data Types
  • Data Cleaning
  • Conditional Formatting
  • Handing Outliers
  • Excel Functions
  • Pivot Table
  • Data Visualization and Mining
  • Interactive Dashboard Design
  • Data Analysis with PowerBI
  • Data Loading from different sources
  • Data Transformation
  • Data Cleaning in PowerBI.
  • Data Modelling
  • Visualization techniques
  • Explore chats
  • DAX Measures
  • Interactive Dashboard
  • Overview of MySQL Workbench
  • SQL Operators
  • SQL Data types
  • DDL, DQL, DML.
  • Importing Data
  • Data Manipulation
  • SQL Functions
  • Data Mining
  • Joining multiple data (Left, Right, Outer, Inner)
  • SubQueries
  • Exporting Data
  • Presentation with Microsoft PowerPoint
  • Intro to PowerPoint
  • Creating slides and uploading content
  • Connect Excel to PowerPoint
  • Slide Shows
  • How to organize a data analysis project for presentation
  • Capstone Project

loader