Our data warehousing course a comprehensive walk through from source data base to stage data base and finally the data warehouse, that is also called the target data base. Entire course is designed on real project experience and take you through all design concepts and techniques. We shall start from the raw data and we will see how this raw data is stored in the data warehouse. We complete the course with many real example. While covering the course we shall get a feel of very popular too, INFORMATICA. We shall also learn how reporting can be done on the top of the data warehouse we just built. And learn all these from an NIT IIM Alumni, who has about 15 years of experience in Business Intelligence, Data Analytics fields.
So, join our demo courses or speak with our training coordinator now!
Pre-requisite for the course
- Familiar with Statistics
- Programing knowledge
- Basic Excel knowlede
What you will learn
- Perform complex mathematical calculations
- Generate complex reports
- Use advanced excle feaures for statistical data analysis, sales forecasting, dashboard
Formating: fonts, numbers, tables, charts
Hide / Unhide
Sort / filter
Paste special
Find and select
Functions: Sum / Average / Count / Max / Min
Basic Text / date / time / lookup / information functions
Name manager
Formula Auditing
Data
Import from web
Import from text
Text to columns
Remove duplicates
Grouping and ungrouping
Basic Formula
Formulae that Add Subtract Multiply Divide
BODMAS Formula Error Checking
The Sum Function
Absolute Referencing
Problems with Absolute Relative Cell Referencing
Creating Absolute Mixed References
LOOKUP Functions
VLOOKUP
HLOOKUP Functions
MATCH with VLOOKUP Functions
INDEX & MATCH Functions
OFFSET, INDIRECT functions
PivotTables
Creating and Formatting Simple PivotTables
Page Field in a PivotTable
Formatting a PivotTable
Creating Modifying a PivotChart
Adding new calculated Fields Items
Changing the Summary Function
Consolidate Pivot table
Logical Functions
IFs and Nested IF Functions
Using AND OR NOT Functions
If Loop and Nested IF Loop Functions
Using IF ISERROR Functions
Statistical Functions
Using SUMIF, COUNTIF Functions
Using AVERAGE, COUNT, LARGER, SMALLER Function, Anova, Variance, standard diviations
Graphical Charts
The Chart Wizard
Chart Types
Adding Title, Legends, Lables
Printing Charts
Adding Data to a Chart
Formatting Renaming Deleting Data Series
Changing the Order of Data Series
Date / Time Functions
Using The Today
Now & Date Functions
Using The Datedif , Networkdays, Eomonth Functions
Using The Weeknum Functions
Using The Edate, Networkdays, INTL Weekdays INTL Functions
Modelling Regression Analysis
Creating a Clustering Model
Loan Prediction Problem
Working on Iris Data Set
Titanic Data
Boston Housing Data Set
Predict Stock Prices
Classifying MNIST digits using Logistic Regression
Intrusion Detection using Decision
CIFAR Data set
ImageNet Data Set
Credit Risk Analytics using SVM in Python
Valigence technologies benefits
- Provide students the in-depth hands on practices on Microsoft excel
- Each chapter is thoroughly explained in the classroom
- Get all concepts and formulae explained by IIM alumni and industry experts
- Get your resume free written by our industry HR
- Mock interviews and additional lectures on how to stand out from others in the interview room
- Placement Assistance through our wide alumni base
- Opportunity to speak with industry leaders who belong the communities including IITs, IIMs, NIT and other top management colleges in India
Quick Link for Other Courses
Join our demo class
Our Esteemed faculties
Other Courses
What Our Students Have to Say
