Analytics Edge – Business Analyst Course
A comprehensive Business Analyst training to head start your career in Analytics!
220 Hours
26 Classes
19APR
Bangalore
04 MAY
Gurgaon
04 MAY
Noida
Learning Modes
Classroom & Bootcamp
INR 6496*/-
With No Cost EMI
Fully Interactive Live Online
INR 6387*/-
With No Cost EMI
Blended eLearning
INR 6387*/-
With No Cost EMI
Courses Included
Artificial Intelligence Engineering
₹ 20000/-
Artificial Intelligence Engineering
₹ 20000/-
Artificial Intelligence Engineering
₹ 20000/-
₹ 65000/-
₹ 48000*/-
Optional Course
Data Science using R
₹ 20,000
₹ 4000/-
No of classes X Hours
18 x 3 = 54 Hours
Self Study Hours
110 Hours
(8-10 hrs/week)
12 Assignments & Projects
Placement Readiness Program
With the advent of information technology, demand for Business Intelligence and Business Analyst professionals has surged from the beginning of this century. Data explosion since 2010 has further increased the value of professionals with analytics skills by manifolds. It’s a well-known fact that data analysis has become an indispensable component of overall business strategy as well as other functions, like marketing & sales, supply chain management, customer operations, accounting & finance, etc.
This Business Analyst course in India is specially curated for candidates who have no prior knowledge about any BI or data analytics tools. Focussed coverage of key skills using the blend of in-demand Analytics tools, along with their applications, makes this data analytics certification course unique.
Post certificate completion you will acquire professional competency in skills required for various types of Analytics related jobs, such as Business Analyst, Data Analyst, Marketing Analyst, CRM Analyst, etc.
Course Curriculum
Analytics Edge is one of the best Business Analyst training courses to learn Data Mining, Statistical & Predictive Modelling skills using an in-demand analytics tool. This business analyst certification course would help you to target analytics jobs requiring hands-on skills in R, Excel-VBA, SQL, and Tableau (most popular data visualization and rapid BI tool).
Building Blocks & Excel
Building Blocks
- Excel Environment
- Key Terminologies
- Short Cuts
- Key Functionalities
- Copy-paste-paste special
- Formatting & conditional Formatting
- Basic Excel Functions – Types of Functions
- Relational operators
- Data Sorting, Filtering and Data Validation
- Understanding of Name Ranges
- Pivot tables – Charts
- Basics of charts
Data Analytics & Visualization with Excel
- Overview of programming languagesÂ
- Basics of programming elements
- variables, data types, data structures, loops, conditional statements, inputs, outputs, functions etc
- Understanding key terms
- Client/server
- Database
- Hosting/deployment
Data Analytics with SQL
Quick Recap of RDBMS & Basic SQL
Apply learning's on Business Case study
Apply learning’s on Business Case study
Data based objects creation (DDL Commands)
- Creating databases and tables. Understanding data typesÂ
- Inserting values into the tableÂ
- Altering table propertiesÂ
- Introduction to Keys and constraintsÂ
- Creating, Modifying & Deleting TablesÂ
- Create Table & Create Index statementsÂ
- Drop & Truncate statements – Uses & DifferencesÂ
- DDL Statements with constraintsÂ
- Import and Export wizard to get the data in SQL server from excel files or delimited files
Data manipulation (DML Commands)
- Data Manipulation statementsÂ
- Insert, Update & Delete statementsÂ
- Select statement – Sub setting, Filters, Sorting. Removing Duplicates, grouping and aggregations etcÂ
- Operators, predicates and built in functions(Top, distinct, Limit)
- Where, Group By, Order by & Having clausesÂ
- SQL Functions – Number, Text, Date, etcÂ
- SQL Keywords – Top, Distinct, Null, etcÂ
- SQL Operators –Â Relational (single valued and multi valued), Logical (and, or, not), Use of wildcard operators and wildcard characters, etc
Accessing data from Multiple Tables using SELECT
- Append and JoinsÂ
- Union and Union All – Use & constraintsÂ
- Intersect and Except statementsÂ
- Table Joins – inner join, left join, right join, full join
- Cross joins/cartesian products, self joins, natural joins etcÂ
- Inline views and sub-queries & it’s typesÂ
- Optimizing your workÂ
- Update operations with and without joins
Advanced SQL
- Creating table copy and database copyÂ
- ViewsÂ
- TransactionsÂ
- Stored Procedures in SQLÂ
- Crud operations using stored proceduresÂ
- Window functions in SQLÂ
- Miscellaneous Topics: Rollup and cube
Data Analytics & Visualization with Tableau
Getting Started
- What is Tableau?
- Tableau product suite
- How Does Tableau Work?Â
- Tableau ArchitectureÂ
- Connecting to Data & data source conceptsÂ
- Understanding the Tableau workspaceÂ
- Dimensions and MeasuresÂ
- Data Types & Default PropertiesÂ
- Tour of Shelves & Marks CardÂ
- Using Show MeÂ
- Saving and Sharing your work-overview
Data handling & summaries
- Date Aggregations and Date parts
- Cross tab & Tabular chartsÂ
- Totals & SubtotalsÂ
- Bar Charts & Stacked BarsÂ
- Line Graphs with Date & Without Date
- Tree maps/Scatter PlotsÂ
- Individual Axes, Blended Axes, Dual Axes & Combination chart/Edit axisÂ
- Parts of Views
- SortingÂ
- Trend/Reference Lines/Forecasting
- Filters/Context filters
- Sets (In/Out Sets/Combined SetsÂ
- Grouping/Bins/HistogramsÂ
- Drilling up/down – drill throughÂ
- HierarchiesÂ
- View dataÂ
- Actions (across sheets)
Building Advanced Reports/ Maps
- Explain latitude and longitudeÂ
- Default location/Edit locationsÂ
- Building geographical mapsÂ
- Using Map layers
Calculated Fields
- Aggregate vs. Disaggregate dataÂ
- Explain – #Number of RowsÂ
- Basic Functions (String/Date/Numbers etc)Â
- Usage of Logical conditions
Table calculations
- Explain scope and direction
- Percent of Total, Running / Cumulative calculationsÂ
- Introduction to LOD (Level of Detail) Expressions
- User applications of Table calculations
Parameters
- Using Parameters in
- Calculated fieldsÂ
- Bins/Reference LinesÂ
- Filters/SetsÂ
- Display Options (Dynamic Dimension/Measure Selection)Â
- Create What-If/ Scenario analysis
Building Interactive Dashboards
- Combining multiple visualizations into a dashboard (overview)
- Making your worksheet interactive by using actions
- Filter/URL/Highlight
- Complete Interactive Dashboard for Sales & Services
Building Stories
- Story PointsÂ
- Options in Formatting your VisualizationÂ
- Working with Labels and AnnotationsÂ
- Effective Use of Titles and Captions
Working with Data
- Multiple Table JoinÂ
- Data BlendingÂ
- Difference between joining and blending data, and when we should do eachÂ
- Toggle between to Direct Connection and Extracts
Sharing work with others
- Sharing WorkbooksÂ
- Publish to Reader/PDFÂ
- Publish to Tableau Server and sharing on the web
R for Data Science
Dimensionality Reduction & Collaborative Filtering (e-learning)
- Dimensionality Reduction: Feature Extraction & Selection
- Collaborative Filtering & Its Challenges
Data Importing/Exporting
- Introduction R/R-Studio – GUI
- Concept of Packages – Useful Packages (Base & Other packages)
- Data Structure & Data Types (Vectors, Matrices, factors, Data frames, and Lists)Â
- Importing Data from various sources Â
- Exporting Data to various formats
- Viewing Data (Viewing partial data and full data)
- Variable & Value Labels – Date Values
Data Manipulation
- Creating New Variables (calculations & Binning)
- Dummy variable creation    Â
- Applying transformations    Â
- Handling duplicates/missing’s
- Sorting and Filtering Â
- Sub setting (Rows/Columns) Â
- Appending (Row/column appending)Â
- Merging/Joining (Left,right,inner,full,outer) Â Â
- Data type conversions Â
- Renaming   Â
- Formatting
- Reshaping data
- Sampling    Â
- Operators
- Control Structures (if, if else)Â
- Loops (Conditional, iterative loops)
- apply functions
- Arrays Â
- R Built-in Functions
- Text, Numeric, Date, utility   Â
- R User Defined Functions
- Aggregation/Summarization
Data Analysis
- Introduction exploratory data analysis
- Descriptive statistics, Frequency Tables and summarization  Â
- Uni-variate Analysis (Distribution of data)
- Bivariate Analysis (Cross Tabs, Distributions & Relationships)
Using R with Databases
- R and Relational Databases  Â
- Connecting to Relational Databases using RJDBC and RODBCÂ Â
- Database Design and Querying Data  Â
- Modifying Data and Using Stored Procedures
- In-Database Analytics with R
Data Visualization with R
- Basic Visualization Tools     Â
- Bar Charts/Histograms/Pie Charts    Â
- Scatter Plots
- Line Plots and Regression
- Specialized Visualization Tools
- Â Word Clouds/ Radar Charts
- Â Waffle Charts/ Box Plots
- How to create Maps Â
- Creating Maps in R
- How to build interactive web pages  Â
- Â Introduction to Shiny
- Â Creating and Customizing Shiny Apps
- Â Additional Shiny Features
Introduction to Statistics (e-learning)
- Basic Statistics – Measures of Central Tendencies and Variance
- Building blocks – Probability Distributions – Normal distribution – Central Limit Theorem
- Inferential Statistics -Sampling – Concept of Hypothesis Testing
- Statistical Methods – Z/t-tests (One sample, independent, paired), Anova, Correlations and Chi-square
Linear Regression: Solving regression problems (e-learning)
- Introduction – Applications
- Assumptions of Linear Regression
- Building Linear Regression Model
- Understanding standard metrics (Variable significance, R-square/Adjusted R-square, Global hypothesis, etc)
- Assess the overall effectiveness of the model
- Validation of Models (Re running Vs. Scoring)
- Standard Business Outputs (Decile Analysis, Error distribution (histogram), Model equation, drivers etc.)
- Interpretation of Results – Business Validation – Implementation on new data
Machine Learning vs Statistical Modeling & Supervised vs Unsupervised Learning (e-learning)
- Machine Learning Languages, Types, and Examples
- Machine Learning vs Statistical Modelling
- Supervised vs Unsupervised Learning
- Supervised Learning Classification
- Unsupervised Learning
Supervised Learning I (e-learning)
- K-Nearest Neighbors
- Decision Trees
- Random Forests
- Reliability of Random Forests
- Advantages & Disadvantages of Decision Trees
Supervised Learning II (e-learning)
- Regression Algorithms
- Model Evaluation
- Model Evaluation: Overfitting & Underfitting
- Understanding Different Evaluation Models
Unsupervised Learning (e-learning)
- K-Means Clustering plus Advantages & Disadvantages
- Hierarchical Clustering plus Advantages & Disadvantages
- Measuring the Distances Between Clusters – Single Linkage Clustering
- Measuring the Distances Between Clusters – Algorithms for Hierarchy Clustering
- Density-Based Clustering
Industrial & Functional Sessions (Domain Understanding)
- Introduction to Data Sources for Various Industries
- Introduction to Analytics Project Management Â
- Marketing Analytics                 Â
- Risk Analytics        Â
- Operation Analytics  Â
- Digital Analytics (Web Analytics)Â Â Â Â Â Â
- Social Network Analytics            Â
- Banking & Financial Services, Insurance
- Retail & E-Commerce                Â
- Pharma & Health Care               Â
- Telecom & Network
Request a Call back
Who Should Do?
Beginner candidates from various quantitative backgrounds, like Engineering, Finance, Maths, Business Management who want to target job profiles based on R programming and statistical analysis skills or Excel-VBA or Tableau based MIS/BI analyst profiles can benefit greatly from our business analyst certification for beginners.
Job Roles
- BI Analyst
- MIS Analyst
- Data Analyst
- Data Visualization Analyst
- Business Analyst
- Statistical Analyst
- Data Scientist
Key Skills
- MIS Reporting Analytics
- Data Visualization
- Data Mining & Analysis
- Predictive Modelling
- Statistical Analysis & Modelling
- Data Blending & Manipulation
- R Programming
- Data Science Methods
- Check your eligibility
Capstone Projects
Analytics Edge is one of the best business analyst courses which offers multiple case studies for class sessions. Our Business Analyst certification in India also includes following assignments and projects for self-study and hands-on skills.
Assignments
- 3 Analytics case studies
- 2 Exercises for statistical analysis
- 4 Basic exercises ( Excel, VBA, SQL & Tableau)
Projects
- Consumer electronics pricing data analysis & visualization
- Telecom Attrition Prediction (Logistic Regression)
- Credit Card Spend Prediction (Linear Regression)
- Sports event analysis and reporting
- Airlines data analysis and reporting
- Sports equipment retail data analysis and visualization
- Marketing & Sales data manipulation and analysis
Programming Tools and Languages
Delivery Format
Classroom & Bootcamp
Skill mastery with immersive, hands-on learning guided by mentors. Opt for either our intensive weekday bootcamps or flexible weekend classes to suit your schedule. Experience firsthand the power of in-person mentorship, available in weekday classroom bootcamps, ensuring a rich, experiential learning environment.
Fully Interactive Live Online
Blend the dynamic experience of traditional classroom with engaging, real-time interactive sessions, carefully tailored to meet the demand of busy schedules. This innovative approach ensures effective learning, fostering a deeper understanding and retention of knowledge.
Classroom Blended with eLearning
Fuse the rich atmosphere of classroom instruction with the flexibility and accessibility of eLearning modules, meticulously integrated to accommodate learning preferences. This unique blend ensures an optimal learning experience, empowering participants to delve into subjects deeply.
Business Analyst Certification
Owing to our well established domain expertise and prestigious clientele in India and overseas, AnalytixLabs certification is highly regarded in the industry. Being India’s top ranked Data Science institute it is imperative that we uphold the sanctity of our certification process.
You shall be awarded a certificate only post the submission and fair evaluation of mandatory project work, provided as a part of the course. There is no pass/fail for these assignments and projects.
In case the assignments and projects are not up-to-the-mark, trainees are welcome to take help and support for improvisation. But no kind plagiarism will be tolerated during evaluation.
There is no pass/fail for these assignments and projects, except MCQ tests. In the case of the dual certification program, you will get two attempts to clear MCQ assessments.
Our objective is to ensure that trainees get vital hands-on experience so that they are well-prepared for job interviews along with a performance at their jobs.
Course Fees
Select the course you want to Enroll:
Classroom & Bootcamp
₹ 30,000 + taxes
EMI starts @ 6496
EMI Options
*Pay in easy EMIs starting at INR ₹6387 per month.
Skill mastery with immersive, hands-on learning guided by mentors. Opt for either our intensive weekday bootcamps or flexible weekend classes to suit your schedule. Experience firsthand the power of in-person mentorship, available in weekday classroom bootcamps, ensuring a rich, experiential learning environment.
- Fees payable in up to 3 installment​s
- 12 months EMI available at 0% interest (though education financing partners).
- Cost-effective courses with high ROI, making it worth every penny you invest.
Fully Interactive Live Online
₹ 30,000 + taxes
EMI starts @ 6496
EMI Options
*Pay in easy EMIs starting at INR ₹6387 per month.
Blend the dynamic experience of traditional classroom with engaging, real-time interactive sessions, carefully tailored to meet the demand of busy schedules. This innovative approach ensures effective learning, fostering a deeper understanding and retention of knowledge.
- Fees payable in up to 3 installment​s
- 12 months EMI available at 0% interest (though education financing partners).
- Cost-effective courses with high ROI, making it worth every penny you invest.
Blended eLearning
₹ 25,000 + taxes
EMI starts @ 6496
EMI Options
*Pay in easy EMIs starting at INR ₹6387 per month.
Fuse the rich atmosphere of classroom instruction with the flexibility and accessibility of eLearning modules, meticulously integrated to accommodate learning preferences. This unique blend ensures an optimal learning experience, empowering participants to delve into subjects deeply.
- Fees payable in up to 3 installment​s
- 12 months EMI available at 0% interest (though education financing partners).
- Cost-effective courses with high ROI, making it worth every penny you invest.
Career Support
Profile Building
A team of seasoned professionals will provide you personalized help for preparing CV and online profiles, based on your educational background and experience.
Interview Preparation
This will be followed by one to one interview preparation along with mock interviews (if required).
Job Referrals
We get different types of job requirements from various organizations, our clients, HR consultants, and a large pool of AnalytixLabs’ alumni working in various companies.
Continuous Support
There will be continuous support from our side for as long as you need it. Most of our students do get multiple interview calls and good career options based on the skills they learn during the course.
How To Apply
select your course, complete the registration form, and make payment.
Submit your application
Submit your application by filling out the form, providing necessary details, and clicking submit to complete the process.
Give a selection test
Take the selection test to demonstrate your skills and knowledge. This will help us assess your readiness for the course.
Reserve your seat
Reserve your seat today to secure your spot in the course. Act fast, as spaces are limited and fill quickly!
Payment
Complete your payment to finalize your enrollment in the course. Choose your preferred payment method and follow the prompts to proceed.
What Students Say About Us?
True Stories, Transformative Career Experience
Piyush Ganar, Class of 2012 IIM Ahmedabad
(Director of Operations, Kenty.AI)
The course material is very easy to understand and the case studies were based on real time business problems. What I love the most about Sumeet and his team is that they never operated the institute like a typical commercial enterprise but more like a temple for learning. The gates of Alabs are always open for students for any kind of help and guidance. I would recommend ALabs to all.
Raajeev Kumar Sahu
(Senior Manager – Data Science, FinTech Startup)
I am from Advance Big Data Science course of Nov 2016 batch. The course was very structured and got real world problems to practice during the final case studies. It has also boosted my skills to start participating in the hackathons. Chandra sir was really helped me in preparing my resume right from very beginning of the course. Also, the placement team was very well organized and connected to industry leaders so that people get the right opportunity right after completing the course. I really recommend this institute, who are interested to transition into analytics field.
Sumit Asthana
(Assistant Manager, Senior Data Scientist)
The rapid pace at which the institutes are mushrooming all over India and Facebook newsfeed being inundated with thousands of options for analytics training, there are only handful of training institutes or rather say only couple of places where they prepare you to foray into rapidly growing analytics vertical. I have been working into legacy systems for past 5 years and was quite apprehensive if I will ever break into data science successfully.
Surbhi Sultania
(Analytics Manager, Mastercard Data & Services)
I took three months Big Data training from Analytix labs. Before joining this course, I had so many questions and doubts that will this course be worthy enough but later I found myself lucky to join this program. All trainers are amazing and always ready to help. Live examples and Case Studies are given which helps in understanding the concept and hands on practice.Not only they help in quality in depth knowledge transfer but also tend to give right direction to your career.
Vibhu Gautam
(Professor of Practice – Computer Science, UPES)
I had been associated with AnalytixLabs since 2012. This has been possible because of the mentor ship and support you get from faculty there specially from Sumeet and Chandra.I did a Business Analytic course with a focus on Marketing Analytic. The course deliver had been great and most importantly you never feel like you are part of formal classroom teaching. You are mentored there at every step, from Code Errors to Understanding Statistics behind it.Â
Upcoming Batches
Sign up for a Free Demo Class
Benefits of Demo Account
- Get access to trial sessions to choose the most suitable course.
- SAVE UP TO 40% on specialization learning tracks.
- JOB ORIENTED COURSES crafter and delivered by industry experts.
- INDUSTRY RELEVANT programs with latest curriculum.
Want to see how it works?
Frequently Asked Questions
What if I miss a class?
Don’t worry! You will always get a recording for the class in your Learning Management System (LMS) account. Have a look at that and reach out to the faculty in case of doubts. All our live classes are recorded for self-study purpose and future reference, and these can also be accessed through our LMS. Hence, in case you miss a class, you can refer to the video recording and then reach out to the faculty during their doubts clearing time or ask your question at the beginning of the subsequent class.
You can also repeat any class you want in the next one year after your course completion. Batch change policies will, however, apply in this case.
Please note that in case you are not able to complete your course within one year of course validity, due to reasons at your end, limited support might be available post the completion of one year.
What if I share my learning account details with a friend?
The sharing of LMS login credentials is unauthorized, and as a security measure, if the LMS is accessed by multiple places, it will flag in the system and your access to LMS can be terminated.
For how long class recordings and LMS access is available?
LMS and course access are available for one year. If needed, you can also repeat any number of classes you want in the next one year after course completion. Batch change policies will, however, apply in this case.
This is valid for AnalytixLabs content. In the case of co-branded global certification, the general duration of access to partner content is limited to 6 months.Â
In case required because any genuine reasons, the recordings access can be extended further for upto 1 year post the completion of one-year validity. Please note that given the constant changes in the Analytics industry, our courses continue to be upgraded and hence old courses might no longer hold relevance. Hence, we do not promise lifetime access just for marketing purposes.
Can I download the recordings?
No. Our recordings can be accessed through your account on LMS or stream them live online at any point in time though.
Recordings are an integral part of AnalytixLabs’ intellectual property by Suo Jure. The downloading/distribution of these recordings in anyway is strictly prohibited and illegal as they are protected under the copyright act. In case a student is found doing the same, it will lead to an immediate and permanent suspension in the services, access to all the learning resources will be blocked, the course fee will be forfeited and the institute will have all the rights to take strict legal action against the individual.
How do I get the course completion certificate?
As part of the business analyst course online, students get weekly assignments and module-wise case studies. Once all your submissions are received and evaluated well (without any plagiarism), the certificate shall be awarded. Without fairly submissions and evaluation of the assignments and projects so certificate shall be issued.
Please note that in case you are not able to complete the course within the one-year validity, AnalytixLabs might hold a mock interview/viva, apart from your submissions, before issuing the certificate.
Do you provide guaranteed placements?
No institute can provide a blanket placement guarantee unless they are doing so as a marketing gimmick! Â
We provide a job guarantee or money back for some selected learning tracks, mentioned in the course details wherever applicable, subjected to the stipulated requirements and terms. You can read more about it here.Â
For all other course modules meant for professional upskilling, our business analyst course with placement support is on a best effort basis, with you in the driving seat! We have transparently explained our career support in the course details. For us, it is on a best-effort basis but not time-bound – in some cases, students reach out to us even after three years for career guidance.
Excited?
Talk to Expert
Counselor
to gain insights into your profile and
strategize your next career move!
