Spronet Hub Courses

Course Curriculum & What To Expect

Overview of data analytics and its importance in various industries

Introduction to key concepts: data, information, knowledge

Types of data: structured, unstructured, semi-structured

Introduction to data analysis process: Define, Prepare, Analyze, Interpret, Act

Introduction to Microsoft Excel interface and basic functionalities

Data entry and formatting techniques

Using basic formulas and functions (SUM, AVERAGE, MAX, MIN)

Sorting and filtering data

Introduction to charts and graphs for data visualization

Understanding logical functions (IF, AND, OR)

Introduction to lookup functions (VLOOKUP, XLOOKUP, HLOOKUP ,INDEX MATCH)

Date and time functions/manipulation.

Text functions for data manipulation

Conditional formatting for visual data analysis

 Introduction to PivotTables for data summarization and analysis

Creating Pivot Charts for visual representation of data

Using slicers to filter PivotTable data.

Introduction to Excel's What-If Analysis tools (Goal Seek, Scenario Manager)

Overview of Power BI and its capabilities

Installing and setting up Power BI Desktop

Importing data into Power BI from different sources

Data transformation and cleaning techniques using Power Query Editor

Introduction to data modeling in Power BI

Creating interactive reports and dashboards in Power BI

Understanding different types of visualizations (bar chart, line chart, pie chart, etc.)

Using slicers, filters, and drill-through for interactivity

Enhancing reports with custom visuals and themes

Publishing reports to the Power BI Service

Introduction to DAX (Data Analysis Expressions) language

Creating calculated columns and measures in Power BI

Understanding relationships between tables and their impact on data analysis

Implementing row-level security in Power BI reports

Introduction to Power BI Mobile App and sharing options

Overview of relational databases and SQL

Understanding SQL syntax: SELECT, FROM, WHERE, GROUP BY, ORDER BY

Retrieving data from a single table using SELECT statement.

Filtering data using WHERE clause.

Sorting data using ORDER BY clause.

Introduction to key concepts: data, information, knowledge

Types of data: structured, unstructured, semi-structured

Introduction to data analysis process: Define, Prepare, Analyze, Interpret, Act

Understanding different types of SQL joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL

OUTER JOIN)

Performing joins to retrieve data from multiple tables.

Introduction to aggregate functions (COUNT, SUM, AVG, MAX, MIN)

Grouping data using GROUP BY clause

Filtering grouped data using HAVING clause

 Working with subqueries to perform complex data analysis tasks.

Introduction to window functions for advanced data processing

Modifying data in a database using INSERT, UPDATE, and DELETE statements.

Creating and modifying database objects: tables, views, indexes

Introduction to stored procedures and user-defined functions (UDFs)

Participants work on a hands-on data analysis project using Excel, Power BI, and SQL

Project involves collecting, cleaning, analyzing, and visualizing real-world data.

Emphasis on applying concepts and skills learned throughout the course to solve a

practical problem.

Facilitator provides guidance and feedback throughout the project.

Students present their data analysis projects to the class.

Peer review and feedback session to evaluate project outcomes and presentation skills.

Facilitator provides final assessment and reviews key learnings from the course.

Introduction to portfolio building and project documentation.

Discussion on next steps and further learning opportunities in the field of data analytics

Get a Discount offer when you pay for the Data Analysis Course on/before 7th April, 2024

To Get Started

Call OR Send us a Message Via WhatsApp: 09037135958