DATA ANALYTICS
Superior Training Methodology
ABOUT THE COURSE
Data analytics is the science of analysing raw data in order to make valuable insights about customer or process information. Many processes of data analytics are automated into mechanical processes and algorithms, that take input as raw data for human consumption. Popular Data Analytics products include Tableau, SAS and SSPS.
Data Analytics, program is specifically designed with an objective to provide a sound platform and prepare attendees for a successful career in the field of Analytics. The course content, the advanced lab, 1:5 classroom strength allows special focus on individual performance
QUALIFICATIONS
TRAINERS
Trainer, has deep development experience into Analytics and Machine Learning, along with a M.S in Computer Engineering (USA). He worked with top companies includingABB, Seimens at USA and has extensive experience analyzing data and implementation. He managed technical teams, which delivered top class web products.
SELECTION
INTERNSHIP
Data Analytics internships are designed for final year electronics / electrical engineering students of B.Tech/ M.Tech/ Phd (INDIA) and M.S/Phd (USA) and it starts with learning of concepts on Excel, SQL, Analytics, Data Processing, Statistical tools and Predictive Modelling which will be highly required to start an industry standard project. Doing this internship will make you a hands-on Data Analytics Expert or a Data Scientist.
RESEARCH
Data Analytics research projects are designed for final year electronics / electrical engineering students of B.Tech/M.Tech/Phd (INDIA) and M.S/Phd (USA) and it starts with learning of concepts on Excel, SQL, Analytics, Data Processing, Statistical tools and Predictive Modelling which will be highly required to start an industry standard project. Doing these research projects will make you a hands-on Data Analytics experience suitable for industry and MS/Phd studies.
KEY FEATURES
1. 24×7 Support on exercises.
2. Case studies
3. 4.7/5 rating
4. Industry standard tools
5. Two decade of experience
6. World class course structure
7. Expert mentorship on Data Analytics career
8. 100% Placement Support
9. Lifelong membership
1. Scholarship will be provided based on online test and technical interview performance.
2. Candidates with score 80% in Engineering and 90% above in online test will be selected.
3. Candidates with good GATE score can avail additional scholarship.T&C Apply
COURSE CURRICULUM
Introduction to Excel
Customizing tabs, options in excel
Name managers
Data validation: Options in data validation for list, whole numbers, dates
Using name manager for data validation
Sorting
Custom sorting
Subtotals
Sorting left to right
Advanced sorting with multiple options
Advanced filter options
Sorting and filtering with color options
Pivot tables
Short cuts to create pivot tables
Changing row and column labels
Custom format tables and default tables
Changing number formats
Value field settings and summarizing values by 11 different options
Value field settings and showing values as different options
Grouping of continuous fields
Pivot charts, compared regular charts
Slicers, Slicer settings, advanced slicer
Calculated fields in pivot tables
Vlookup and Hlookup
Syntax for Vlookup
What-if there are errors
Vlookup with data validation
Approximation for Vlookup
Using column function for dynamic column numbers
Using Choose function to select a table for Vlookup
Using Match function to identify column number
Locking cells for absolute and relative cells
Formulae
Auto sum functions
Logical functions
Text functions
Date and Time functions
Lookup and reference functions
Information functions
Charts
Column charts
Line charts
Pie charts, Pie in pie and Bar of pie, Donut
Stacker bar and clustered bar charts
Area
Scatter charts
Radar charts
Tree maps
Histogram
Waterfall
Funnel
Combo
Conditional formatting
Duplicate values
Alternate rows
Multiple criteria
Negative numbers
Gantt charts and Formula
Advanced topics
What-if analysis
Text to columns
Flash fill
Remove duplicates, Consolidate
Grouping, ungrouping and sub-totals
Freezing and unfreezing panes
Start
Understanding the start pane
Connecting to data source
Data sources that can be connected
Various file formats
Bookmarks
TDS, TDE
Connecting to excel, Joins, Splitting data
Live and extract
Dimensions and measures
Clearing sorts and filters
Views: Standard fit width and height
Drilling down
Expanding the marks in pane
Swapping axis
Renaming sheets
Editing color pane
Adding highlighters
Understanding show me
Sorting and hierarchy
Data pane and analytics pane
Different view options at bottom of sheet
Managing data and extracts
Hiding and unhiding fields
Creating folders to move dimensions and measures
Adding default colors and properties
Adding multiple data sources
Extracting workbook
Replacing data sources
Data cleansing
Database joins
Blending
Sorting and Filtering
Default charts
Highlighter for color and shape
Sorting from axis, color, category, manually and clearing sort
Creating groups from pane, manually, visually, parameters, and bins
Adding filter, show filter, wildcards, Top N parameters
Discrete and continuous dates
Types of filters: Applying to specific sheets, Editing page shelf
Hiding cards
Sets and parameters
Sets
Parameters
Tool tips
Cluster analysis
Formatting
Dashboards and storyboards
Building dashboards
Hiding and unhiding sheets
Interface between sheets, dashboard and storyboard
Elements in dashboard
Formatting
Actions in dashboard
Device designer
Story points
Charts
Word cloud
Bump charts
Box and whisker
Funnel
Step and Line
Pareto
Waterfall
Donut
Lollipop
Pie
Heat map
Waffle
Show me charts
Calculations
Basic syntax
Regular calc and table calc
Adding totals
Date calc
Logic calc
String calc
Number calc
LODs
Maps
Mapbox
WMS>Layers
Converting geo to non-geo
Chart default
Options for maps
Unrecognized locations
Groups
Basics
Selections
Importing data
Scripting basics
Configuring sheets
Creating and configuring sheets
List boxes
Input boxes
Pivots and Sets
Pivot tables
Set analysis
Lookup and apply map functions
Expressions
List boxes
Joins
Sliders
Resident load
Text objects
Statistics box
Creating PDFs
Scripting basics
Cyclic dimensions
Multiple topics
Table box
Multi box
Button objects
Combo charts
Expressions
Bar charts
Line charts
Pie charts
Scatter charts
Load inline
Concatenation
Straight table
Waterfall
Block charts
Trellis bar
Grid charts
Mekko
Funnel
Mini
Interchanging bar and Line
Radar
Step/line
Magic quadrant
Heat map
References in chart
Custom labels
Bookmarks
Before and after functions
Triggers
Pareto
Container objects
Search objects
Creating blank database
Creating table at backend table design view
Adding data
Creating select query
Queries
Query criteria
Action queries
Create queries
Delete query
Table query
Parameter queries
Relationships
Defining relationships between tables
One-One
One-many
Many-many
Wildcards
Calculated expressions
Indexing
Grouping
Summarizing data
Joins
Inner
Outer
Left
Right
Self
Query wizard
Forms
Multiple forms
Split forms
Modify forms
Themes
Navigation forms
Combo box
SQL view
Formatting
Controls and properties
Reports basics
Formatting reports
Functions
Intro
Syntax
Select
Distinct
Where
And Or Not
Order By
Insert into
Null values
Update
Delete
Top
Min and Max
Count, Avg, sum
Like
Wildcards
In
Between
Alias
Joins
Inner
Left
Right
Full
Self
Union
Group By
Having
Exists
Create table
Drop table
Alter table
Not null
Unique
Primary key
Default
Views
Operators
Intro
Connecting to database, basic transformation
Managing queries, splitting columns
Modifying data types
Dates
Re-ordering columns, conditional columns
Connecting to folders
Merge queries
Query dependency
Transform data
Enter data
Query parameter
Data modeling
Data modeling
Data relationships
Calculated columns
Quick measures
Optimize models
Calculated measures
Hierarchies
Calculated tables
Time intelligence
Insert new data tables
Include/Exclude
Grouping and Binning
Visualizations
Create and format visualizations
Hierarchical axis and concatenating
Filters
Combo charts
Forecasting
Clustering data
Slicers
Data behind visualization
Date slicers
Maps, ESRI maps
Tables and matrixes
Table style
Scatter charts
Waterfall and funnel charts
Gauge, cards and KPIs
Coloring charts
Shapes, grid lines, page settings
Duplicates, categories with no data
Aligning, hierarchies
Charts
Combo charts
Custom visual store
Date slicer
Waterfall and funnel charts
Grouping and binning
Map visualizations
Report measures
Tables and matrices
Turn off visual headers
Persistent filters
Sync slicers
Buttons
Custom date tables
Default summarization
Measure filtering
Excel data and collaboration
Upload an excel table
Excel data with BI content
Pinning excel tables
Analyze in excel
Workspaces
Power BI service
Overview of dashboards
Publish from Power BI
Get insights
Pinning on dashboards, dashboard tiles, display options
Adding widgets
Navigating content
Filter the list in navigating pane
Dashboard settings
Sharing, print and export dashboards
Focus mode
Export to csv or excel or ppt
Notifications, alerts
Subscriptions
Publishing
- Introduction to Analytics
- Market & Use cases
- Analytics Tools
- Introduction to Data & Data Types
- Analytics Methodology
- Case Study
- Role of Statistics & Mathematics
- Descriptive Statistics
- Concepts of Sample, Population, Probability
- Probability Distributions
- Data Visualization
- Correlation Analysis
- Regression Analysis
- What is “R”& importance of R
- R installation, Basic Function in R
- Loading Data File, Saving
- Descriptive statistics using R
- Data Visualization
- Data Cleaning
- Data Transformation
- Correlation & Regression Analysis
- Multicollinearity
- Introduction to Factory Analysis
- Principal Component Analysis
- Supervised & unsupervised Techniques
- Hierarchical Clustering
- K-Means Clustering
- Case study uisng R
- Introduction
- Apriori algorithm
- Case study using R
- Linear Regresion
- Logistic Regression
- Case study using R
- Introduction to Classification
- Decision Trees
- Decision Tree Modeling
- Case study using R
Modeling Development using “R”
Frequently Asked Questions
Most frequent questions and answers
Can I get a job into Data Analytics Industry, as I am fresh college graduate?
Yes, industry is hiring trained fresh college graduates for entry level jobs. Many of our students have got placed in top product and services companies. Along, startups are relying on new college grads for fresh ideas and out of box thinking.
Do you have a free demo session, to get a feel of the trainer and understand my choice of field better, before payment?
Yes. You are always welcome! Send us a query or call us. We will arrange a 1 to 1 meeting with the trainer and counselor. They explain you course content, job opportunities and prerequisites.
Can I get an internship, after the coursework? What do I need to ensure?
We are connected with companies focused on IT, Analytics, IoT, VLSI and Embedded. After every training session, we send our candidate profiles to these companies based on their interest. Companies interview and select the candidates of their choice. However, we try our level best to get you an entry into your dream job.
I am not from electronics, neither do I have a engineering degree. Can I join?
At industry, degree is no constrain, but Skill is. At design nation, qualification is not prerequisite, but passion is. If you are passionate to shine in the area of interest, come and talk to us. We are here to help you!
Do you provide a certificate after completion of the course?
Yes. We provide a certificate after the course completion. You can add it to LinkedIn profile, resume and mention during the interviews. Companies prefer trained resources than untrained candidates.
Can I avail the scholarship at Design Nation?
Yes, our scholarships are for people like you, with great talent and financial needs. We are more than happy to help you, with the process. Please check the cutoffs for scholarships in above section. We helped many, and still counting!!
