Empowering learners with industry-ready skills through interactive teaching and hands-on guidance.


ExcelR Edtech Pvt. Ltd.

Learners will gain expertise in Excel, Power BI, Tableau, and MySQL, covering data analysis, visualization, and database management. They will master functions, formulas, pivot tables, dashboards, Power Query, DAX, and Tableau advanced visualizations. Additionally, they will build proficiency in SQL queries, joins, procedures, and data handling, enabling them to analyze, visualize, and manage data efficiently across multiple tools.

Data Analytics  Long Term Internship

Demo

LMS, Assignments & Placements KT Session

Intro of Excel and usage of excel navigations etc

Merge, wrap, number formatting, Fill series etc

Operators & Cell references, Aggregate & Arithmetic functions etc

Basic & advance Arithmetic function with cell reference and name range etfc

logical conditions like if, nested if, Or, And formulas & Date functions

Advance Date & Text functions	

Text and Advance Text functions

Conditional formatting & Data validations etc

Assignments Session

Data validations, Sort & Filter basic and advance, match vlookup & hlookup with match functions etc

Group & ungroup and protect sheet and range & match and lookup functions

Vlookup, Hlookup, Index and match functions etc

Pivot table Understanding the data and its components.

Pivot table and visual Charts and dashboard

Intro of Power Query to Power Pivot

Power Query and Power Pivot and Create relationship and power pivot table and creating visual

VBA if logic and VBA form etc

Technical Presentation

Intro of Power BI and Installation

Creating sample report with sample data and page navigations etc

Create financial sample reports with page navigation and themes

Append Query ,Transform Tab, Pivot & Unpivot columns and Transform tab and Add column

Add Column Tab & Custom Column and how to create custom Column and Format Data etc

Visual Formatting & Visualizations & Clustered and stacked bar charts and conditional formatting & Pie & Donut

Visualization like Cards, card new, table and conditional formatting

Line Chart, Area Chart, area stacked chart, line & Column clustered chart, line column stacked chart, Gauge chart, map & Scatter Plot etc

AI & Custom Visuals & Types of Filters

Types of Filters & Usage of Filters & Drill down & Drill through etc

RLS, Sync Slicer, Bookmarks & Tooltip etc

Data Model & How to create relationship and cross filter direction

Table Dax & Column Dax

Table Dax & Measure Dax

Dax Measure etc

Quick Measure & Power BI Online Service

TP session & PBI Online Service Workspace, Reports etc

TP &Doubts Sessions

Intro of Tableau and Basic Charts and formatting

Basic & Advance VIsualizations

Table visual & Formatting and Types of Filters and usage of filters

Filters & Quick Table Calculations & Table Calculations

Table & Basic Calculation

Advance calculations with visualizations etc

Advance Formula & Custom Charts

Groups, sets , parameter & Bins etc

Types of Data Combine Technic etc

LOD's Level of Details and intro of dashboard types

Dashboard Creation how to use filters and containers etc

Action Dashboard & Storytelling and etc.

Intro of MYSQL & UI of MYSQL & Data types etc

DDL & DML Commands etc

How to import CSV file and DDL Alter & DML Commands

How to import SQL file to workbench &DQL Where & order by with operators etc

DQL Queries where clause with Pattern matching and Aggregate functions with group by

Where clause & Having Clause & Group by etc

Text & Date functions etc

Logical Conditions and Windows functions

TP -1 & TCL Commands

Sub queries & Windows functions etc

Windows functions Partition by lag and lead formulas etc

Joins inner left right & Outer with union and union all etc

Cross join & Self join & Constraint with Primary key etc

Index & unique indexes Null and error handing

Store procedures and User Defined functions & in & out parameter etc

Assignment session

Number forrmatting, error handling & Before Trigger etc

Basic Stats its types

Descriptive Statistics

Hypothesis testing,Probability, Normal Distribution

Data Cleaning ,Test Z and T test

Operators,Function,Data types

Loops,Analysis with mean,mode,median

Joins ,Import data,Charts

dplyr Library,Plots,Export

Python Introduction,Data types,List ,Tuples

Data Structure-Sets, List, Dictionaries

Data Frame,Loops,Conditional Statement

Series,Dataframe,Pandas,Numpy,Charts

Basics of R, Python and Statistics

Intro to chat gpt, LLM

Zero shot, one shot and other prompts

what other prompts can be tried, DallE, SORA

ChatGPT

Agile

ExcelR

Data Analytics Long Term Internship

What you'll get out of this course

Course content

Data Analytics / Business Analytics

Basics of R, Python and Statistics

ChatGPT

Agile

Your Instructor

ExcelR Edtech Pvt. Ltd.