Data Analytics
Data analytics is the science of analyzing raw data to make conclusions about that information. Many of the techniques and processes of data analytics have been automated into mechanical processes and algorithms that work over raw data for human consumption.
Course Offer
- Introduction to Data Analytics
- Excel for Data Analytic
- Python with Libraries to use in Data Analytics
- SQL for Analytics
- Business Problem Solving, Insights and Storytelling
- Business Case Studies
- Predictive Modeling
- Data Warehouse
- Tableau
- Final Project
20% Scholarship
Fee :
$ 1200.0
$ 960.0
Duration : 4 months
Course Outline
- What is Data Analytic
- Data Analysis Steps
- Type of Data Analytics
- Data Analytics Use Cases
- Lifecycle of Data Analytics
- Benefits of Data Analytic
- Data Analytics Techniques
- Data Analytics Tools
- How to become a Data Analyst?
- Skills needed to become a data analyst
- Data Analyst and Data Scientist
- Data preparation with Excel Sheet, (Extraction)
- Data Warehouse (Load, find the missing value, invalid data)
- Data Transformation and Data Analyze
- Data Visualization (chart, statistics)
- Installation Python
- Tool to use (Jupyter)
- Array
- Matrix Operation
- Dictionaries
- Dataframe of Pandas with Python
- Series of Pandas with Python
- Dynamic Array of Numpy with Python
- Introduction to SQL
- Database Normalization and Entity Relationship Model
- SQL Operators
- Working with SQL
- Understanding Business domains
- Understanding the business problem and formulating hypotheses
- Exploratory data analysis
- Data storytelling
- Project on deriving business insights and storytelling
- Real world Business Analytics
- Focus on Real world problem
- Business Required
- Answer to business question
- Predictive Model based on Real Requirement
- Practice to Build a Model and Generate the Report
- Build model to analyze following defined questions of business
- Data Warehouse Concept
- Type of Data Warehouse
- Data Warehouse architecture
- Data Warehouse Characteristics
- Data Warehouse vs Database
- Create a Data Warehouse from a sample raw data
- Introduction to Data Visualization and The Power of Tableau
- Architecture of Tableau
- Charts and Graphs
- Working with Metadata and Data Blending
- Advanced Data Manipulations
- Organizing Data and Visual Analytics to report to Business owner
- Topic will be provided