Why Ivy
IVY Pro School is a Top Ranked Data Science and Analytics schools in the country consistently since the last 5 years (Analytics India magazine, Silicon India Magazine). We are the official training partners of companies like Honeywell, Cap Gemini, Genpact, HSBC, Cognizant, eBay/Paypal etc and more than 100 Analytics companies have recruited our students. Our prized faculty are associated with esteemed organizations like ISI, IIMs IITs and prestigious US universities.
Course Outline of Data Analytics with Visualization Certification Course
Dashboarding and Automation Using Advanced Excel
- Introduction to MS Excel, Cell Ref, Basic Functions and Usage
- Sorting, Filtering, Advance Filtering, Subtotal
- Pivot Tables and Slicers
- Goal Seek and Solver
- Different Charts Graphs – Which one to use and when
- Vlookup, Hlookup, Match, Index
- Conditional Formatting
- Worksheet & Workbook Reference, Error Handling
- Logical Operators & Functions – IF and Nested IF
- Data Validation
- Text Functions
- Form Controls
- Dashboard
- 6 Case Studies from App Cab Aggregators, Insurance, Sports, Sales, Marketing, Web Analytics Industry
SQL Queries & Relational Database Management
- Relational Database Fundamentals
- Steps to Design Efficient Relational Database Models
- Case Studies on Designing Database Models
- Case Study Implementation on Handling Data
- Importing / Exporting Large Amount of Data into a database
- SQL Statements – DDL, DML, DCL, DQL
- Writing Transactional SQL Queries, Merging, joining, sorting, indexing, co-related queries, etc.
- Hands-on Exercises on Manipulating Data Using SQL Queries
- Creating Database Models Using SQL Statements
- Individual Projects on Handling SQL Statements
- 6 Case Studies from App Cab Aggregators, Ecommerce, Sports Industry
Tableau Full Module
- Introduction to Data Visualization
- Introduction of Data Visualization using Tableau
- Tableau Basics
- Working with Sorting and Filters
- Creating Dual Axis and Combo Charts
- Table Calculations
- Calculated Field
- Logical Calculations
- Date Calculations
- Parameters
- Using Actions to Create Interactive Dashboards
- Advanced Charts
- Working with data
- Sets
- Drilling Up/Down using Hierarchies
- Grouping
- Bins/Histograms
- Analytics using Tableau
- Building dashboards
- Story Telling with Data
- Data Interpreter
- 4 Case Studies on Retail, Airline, Bank datasets
Business Statistics
- Types of data, Graphical representation
- Correlation, Data Modeling & Index Numbers
- Measures of Central Tendency & Dispersion
- Forecasting & Time Series Analysis
- Probability, Bayesian Theory
- Probability Distribution and Mathematical Expectation
- Sampling and Sampling Distribution
- Theory of Estimation and Testing of Hypothesis
- Analysis of Variance
- Regression Models
Predictive Modeling with Power BI Full Module
- Connecting with various data sources
- Power Query
- Data Transformation
- Data Modeling
- Create Report and Dashboard
- Advance Visualization techniques
- Analytics
- AI visuals
- Publishing Report
Data Science with Python/R (Anyone)
- Python Essentials
- Scientific Distribution
- Accessing / Importing and Exporting Data using Python modules
- Data Manipulation
- Visualization using Python
- Introduction to Predictive Modeling
- Modeling on Linear Regression
- Modeling on Logistic Regression
- Time Series Forecasting
Machine Learning Essentials
- Supervised learning : Decision Tree
- Supervised Learning : Ensemble Learning
- Text Mining and Analytics
Course Duration Data Analytics with Visualization Certification Course
Total – 195 hours
Course Fee for Data Analytics with Visualization Certification Course
INR 46,500 + GST
Inclusive of All Taxes
No Cost EMI Avaliable
We also facilitate loans to students
Eligibility
Any Graduates or pursuing Graduation
Industry Projects
Make it Python instead of R/SAS
- B2B Chemical Sales: Predict Customer Churn Score for a Chemical Manufacturing Company
- Banking & Finance: Create a Customer Ranking Scorecard for a Cross-selling Insurance Product in a Bank
- Banking & Finance: Predict Probability of Default of Customers for a Money Lending Firm
- Pharma: Predict Drug Efficacy for a Pharmaceutical Company
- Automobile Insurance: Predict Customer Total Claim Amount
- Retail: Predict Product Affinities for 100+ Products
- Rental / Real-Estate: Predict Rental Rates considering 100+ Parameters
- Aviation: Predict Airlines Revenue & Ticketing Pricing Mix
- HR: Predict Employee Attrition
- Retail Marketing: Analyse Marketing Campaign Effectiveness
Enquire / Enroll for the course
Launch Your Global Analytics Career with IVY
Why Analytics?
As organisations and SMEs become increasingly data-driven, there arises the need to make sense of all that data and convert it into meaningful insights. In a competitive environment, analytics becomes the driving force that facilitates decision making – to leverage the insight for innovative strategies as well as for an effective ROI on investment.