Data Analytics
Data Analytics
Top skills you’ll learn with TechnoKraft!
Best data cleaning programming language skills with Python.
Excellent database querying skills.
Good understanding of Analytical tools.
Conceptual clarity towards Predictive performance & algorithm optimization.
Master data visualization & communication skills with our Data Analytics course.
TECHNOLOGIES COVERED
➢ Basic Excel
➢ Advanced Excel
➢ Python
➢ Python Libraries
➢ SQL
➢ Data Visualization
➢ PowerBI
➢ Tableau
PROGRAM CURRICULUM
MODULE 1 – BASIC EXCEL
This module provides a structured approach to learning Excel, gradually building from
basic concepts to excel features.
➢ Introduction to Excel
➢ Workbook, worksheets, cells and ranges
➢ Basic Spreadsheet Operations
➢ Formatting Data
➢ Basic Formulas
➢ Using basic functions (SUM, AVERAGE, COUNT)
➢ Introduction to common functions (IF, ELSE)
➢ Sorting and Filtering
➢ Data Validation
➢ Setting up data validation rules
➢ Creating dropdown lists
➢ Error alert messages
Data Analytics
MODULE 2 – ADVANCE EXCEL
Since we need to handle huge amounts of data to arrange and visualize, we will be
Implementing data handling techniques with Excel. And we will explore the different
miscellaneous functions of Excel in detail.
➢ Charts and Graph
➢ Creating basic charts (bar, line, pie)
➢ Formatting and customizing charts
➢ Conditional Formatting
➢ Highlighting cells based on conditions
➢ Using color scales and icon sets
➢ Managing conditional formatting rules
➢ Advanced Excel Features
➢ PivotTables and PivotCharts
➢ Analyzing data with PivotTables
➢ Creating PivotCharts from PivotTables
➢ VLookUp
➢ HLookUp
➢ XLookUp
➢ Flash Fill
➢ Match & Index
➢ Introduction to Macros
➢ Recording simple macros
➢ Running and editing macros
➢ Applying learned skills to a practical project
➢ Integrating multiple Excel features
➢ Presenting findings using charts and tables
MODULE 3 – PYTHON
We will go through the basics of python with all essential beginner friendly concepts of
Python programming like data types, loops, data structures and functions, followed by
assessments and assignments.
➢ Why Python
➢ Python IDE
➢ Hello World Program
➢ Variables & Names
➢ String Basics
➢ List
➢ Tuple
➢ Dictionaries
➢ Conditional Statements
➢ For and While Loop
Data Analytics
➢ Functions
➢ Numbers and Math Functions
➢ Common Errors in Python
➢ Python - Advanced
➢ Functions as Arguments
➢ List Comprehension
➢ File Handling
➢ Debugging in Python
➢ Class and Objects
➢ Filters and Map
➢ Regular Expressions
➢ Python PIP
➢ Read Excel Data in Python
➢ Iterators
MODULE 4 – PYTHON LIBRARIES
Since we need to handle huge amounts of data, we will be implementing data handling
techniques with Pandas library. As well as we need visualization library like Matplotlib
and Seaborn for plotting graphs and charts. And also be going with Numpy library.
➢ Introduction to Pandas
➢ Series Data Structure - Querying and Indexing
➢ DataFrame Data Structure - Querying, Indexing and loading
➢ Merging data frames
➢ Group by operation
➢ Date/Time functionality
➢ Example: Manipulating DataFrame
➢ Introduction to Matplotlib
➢ Basic Plotting
➢ Scatter Plots and Bar Charts
➢ Advanced Matplotlib Techniques
➢ Subplots, figures, histograms, box plots
➢ 3D plots, polar plots
➢ Introduction to Seaborn
➢ Categorical scatter plots, bar plots, violin plots
➢ Heatmaps, clustermaps, pair plots, facet grids
➢ Applying Matplotlib and Seaborn to a dataset
➢ Reviewing key concepts and best practices
➢ Introduction to NumPy
➢ Creating NumPy arrays
➢ Array indexing and slicing
➢ Array Operations
➢ Aggregation Functions
➢ Array Manipulation
Data Analytics
➢ Reshaping arrays
➢ Concatenation and splitting
➢ Indexing and Slicing
➢ NumPy and Integration with Pandas
➢ Understanding the efficiency of NumPy operations
MODULE 5 – SQL
We will continue with SQL beyond basics like embed documents, dealing with types of
data, schema types and Data relationships in SQL, etc.
➢ Overview of SQL in Business Analytics
➢ Installation of MySQL workbench, PHPMyAdmin
➢ Introduction to relational databases
➢ Basic SQL syntax and querying
➢ Retrieving and Filtering Data
➢ SELECT statements for data retrieval
➢ Filtering data using WHERE
➢ Sorting results with ORDER BY
➢ Joins and Subqueries
➢ Inner and outer joins for data combining
➢ Using aliases for table and column names
➢ Subqueries for advanced filtering
➢ Aggregation and Analysis
➢ Aggregating data using GROUP BY
➢ Filtering aggregated data with HAVING
➢ Basic statistical functions
MODULE 6 – POWER BI
This syllabus provides a structured approach to learning Power BI, covering data
preparation, modelling, visualization, and advanced features.
➢ Introduction to Power BI
➢ Key features and components of Power BI
➢ Installing Power BI Desktop
➢ Connecting to Data Sources
➢ Importing data from various sources (Excel, databases, online services)
➢ Cleaning and transforming data in Power BI
➢ Data Modelling in Power BI
➢ Understanding tables, relationships, and fields
➢ Introduction to DAX functions and formulas
➢ Calculated columns and measures
➢ Writing basic DAX expressions
Data Analytics
➢ Aggregating and summarizing data
➢ Creating different types of visualizations (charts, tables, maps)
➢ Formatting and customizing visuals
➢ Building interactive dashboards in Power BI
➢ Using slicers and filters
➢ Implementing drill-down features
➢ Creating hierarchical structures in visuals
➢ Publishing reports to Power BI Service
➢ Sharing and collaborating on reports
➢ Power BI and Excel Integration
➢ Applying Power BI concepts to a real-world dataset
➢ Building a comprehensive report and dashboard
MODULE 7 – TABLEAU
This curriculum provides a structured approach to learning Tableau, covering basic to
advanced features for data visualization and analysis.
➢ Introduction to Tableau
➢ Overview of Tableau
➢ Key features and capabilities
➢ Installing Tableau Desktop
➢ Importing and Data source management and connections
➢ Creating simple charts (bar, line, scatter)
➢ Customizing colours, labels, and formatting
➢ Applying filters to data
➢ Maps and Geographic Analysis
➢ Advanced Tableau Features
MODULE 8 – PROJECTS
➢ Final Project using integrations
"As we embark on this learning journey together, we encourage you to
explore and engage actively with the content. Feel free to ask questions,
share insights, and apply the knowledge gained to real-world scenarios.
Let's make this learning experience both informative and enjoyable. Best
wishes for a successful and enriching learning experience with
DATA ANALYTICS!!”
__________END____________