Data Analysis Course

Data Analysis Course

This course provides an introduction to data analysis techniques and methodologies, with a focus on practical applications in various fields. Students will learn how to collect, clean, analyze, and visualize data using popular tools and techniques. The course will cover both theoretical concepts and hands-on exercises to develop essential data analysis skills.

Learning Outcome

This course outline provides a structured approach to learning data analysis fundamentals, covering key topics and skills necessary for understanding and applying data analysis techniques in various contexts. You will be job ready after taking this course

  • Gain proficiency in exploratory data analysis (EDA)
  • Master statistical analysis methods
  • Develop skills in data visualization
  • Build job-ready portfolios

Course Outline

Here's a simple breakdown of what you'll learn if you enroll for the Data Analysis Course Today:.

  • Overview of data analysis process
  • Importance of data-driven decision-making
  • Basic concepts and terminology

  • Data sources and types
  • Data collection methods
  • Data cleaning and preprocessing techniques
  • Handling missing data and outliers

  • Advanced Excel Formulas & Functions
  • Structuring Source Data for Analysis in Excel
  • Excel tables
  • Advantage of Excel tables over regular ranges
  • Filter, sort and see totals
  • Use tables to add columns to the existing data in the Excel table
  • Raw data structure in Excel
  • Design & formatting options
  • Sorting, filtering, & grouping tools
  • Calculated fields, items & values
  • Interactive Excel dashboards

  • Why Pivot Tables?
  • Create pivot tables
  • Data Analysis with Excel PivotTables
  • Use pivot tables and pivot charts to create dashboards
  • Connect multiple slicers to the pivot tables
  • Configuring pivot table layouts & styles
  • Pivot Table layouts & styles
  • Pivot Charts, slicers & timelines

  • The full power of pivot tables
  • Filter pivot table data to achieve interesting subsets of the data
  • Apply calculated fields with pivot tables
  • Calculate profitability and find anomalies

  • Use formulas to aggregate data
  • Aggregate data as an alternative to pivot tables
  • Flexible reporting layouts
  • Pivot charts using more than one table

  • Set the lab environment up with Office applications
  • Data analysis in Excel using tools:
    • Pivot tables
    • Pivot charts and slicers
  • Excel data models
  • Power Pivot add-in
  • DAX expressions for calculated columns and measures

  • What are the queries?
  • Power Query for Excel 2010 and 2013
  • Excel data model built from a single flat table
  • Import multiple tables from a SQL database
  • Create an Excel data model using imported data
  • Create a collated result with data from text-files and data from a SQL database
  • Up & running with Power BI Desktop
  • Publishing to Power BI Service
  • SQL database analysis for beginners

  • How to establish measures to calculate each cell
  • Filter context for calculation
  • DAX functions
  • Enhanced queries to import data from a formatted Excel sheet
  • Queries beyond the standard user interface

  • Data visualisations in Excel
  • Cube functions for year-over-year comparisons
  • Create timelines, hierarchies, and slicers
  • Excel working together with Power BI
  • Excel workbooks with Power BI service
  • Excel on the mobile platform

  • Applying data analysis techniques to a real-world dataset
  • Project planning, data exploration, analysis, and visualization
  • Presentation of findings and insights