- Measure Of central tendency, Measures of Dispersion
- Graphical Techniques, Skewness & Kurtosis, Box Plot
- Descriptive Stats
- Random Variable, Probability, Probability Distribution, Normal Distribution, SND, Expected Value
- Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
- Introduction to Hypothesis Testing
- Hypothesis Testing (2 proportion test, 2 t sample t-test)
- ANOVA and Chi-Square
- Data Cleaning
- Imputation Techniques
- Scatter Diagram
- Correlation Analysis
Certified Business Analytics
Program Highlights
Data is the key to change the world. Join the Business Analytics program to enhance your employability in the area of data analytics.
Benefits from the program
- Skills you’ll gain: Data cleaning, problem-solving, critical thinking, data ethics, and data visualization.
- Platforms and tools you will learn: Presentations skills, Spreadsheets, SQL, Tableau and R Programming.
- Practices and processes used by data analysts in their day-to-day job
- Learn critical skills in data cleaning, analysis, & visualization and tools like spreadsheets, SQL, R programming, Tableau
- Understand how to clean & organize data for analysis, SQL & R programming
- Learn how to visualize & present data findings in various presentations, dashboards and other commonly used visualization platforms
Benefits with IIMARK
- Convenient Learning platform
- Dedicated career services
- Learn from industry veterans
- Well Structured program
- Industry Projects
Syllabus
- Business Statistics
- Excel: Basics to Advanced
- SQL
- Tableau
- Power BI
- SAS
- R Basics
- Python Basics
Course content
-
Business Statistics
-
Excel: Basics to Advanced
- Advanced Excel –Basic
- Advanced Excel -Sorting and Filtering Data
- Advanced Excel -Data Validations
- Advanced Excel -Text Function
- Advanced Excel -Function & Formula
- Advanced Excel -Pivot Tables
- Advanced Excel –Charts & Slicers
- Advanced Excel -Working with Templates
- Advanced Excel -VBA-Macro
- Advanced Excel -Variable in VBA
- Advanced Excel -Message-Box and Input-box functions
- VBA Coding Advanced function
-
SQL
-
Tableau
- What is Data Visualization
- Age of Big data
- Principles of Visualizations
- Tableau –Data Visualization Tool
- Introduction to Tableau
- Different Products of Tableau
- Extensions in Tableau
- Features of Tableau Desktop
- Tableau-Joins and Data Pane
- Tableau Data Pane
- Pivot Table and Split Tables in Tableau
- Inbuilt Charts in Tableau
- Maps in Tableau
- How to Interpret Bullet Graphs
- How to Interpret Scatter Plot.
- How to Interpret Histogram
- How to Interpret Box Plot chart
- Data Interpretation
- Creating Calculated Fields
- Logical Functions
- Case-If Function
- ZN Function
- Ad-Hoc Calculations
- Manipulating Text-Left & Right Functions
- Pre-Defined Analytics
- Dashboards Hands-On in Tableau
- Story Hands-On in Tableau
- Animated Visualization Hands-On
- Tools for Sharing Information
- Publishing our Workbooks in Tableau Server
- Connecting Tableau with Tableau Server
- What is R?
- Connecting Tableau with R
- How to integrate Tableau with R?
-
Basics Of R
-
Basics of Python
- Introduction to Python & Data Science Python Installation on laptops
- Variables -Python Built-in functions -Modules -Python Libraries installation using PIP
- Python Operators
- Flow Control Statements -If Statements -While Loops
- Data & time modules in python -Interfaces in Python -For Loops Python modules for Data Analysis
- Python Basics -Web scraping- Python custom functions -Lambda Function -Regular Expressions
- Numpy Module
- Pandas Module
- Matplotlib Module
-
Power BI