AI  And Data Analytics

Unlock the full potential of data analysis with our ultimate course. Gain the skills to gather, analyze, and interpret data effectively using Business Intelligence tools and techniques. Dive into real-world case studies and learn how to derive actionable insights that drive business success. Don’t miss this opportunity to become a master in the field of data analysis.

Objectives :-

After Completion of this Course student will be able to :

• Scrap web site
• Data Cleaning and Visualization
• SQL developer.
• Data Analyst.
• Business Analyst
• Tableau Developer.
• Power BI Developer
• Data Analyst Intern

Brief Contents (Syllabus:)

Logic Building

• Introduction to programming languages
• Introduction to Algorithms
• Baseline for programming Language

Structure Query Language

Introduction to SQL 

• What is data and Database
• what is database management system.
• what is SQL?
• SQL vs MYSQL.

DDL vs DML 

• Data Types, Expressions, Operators
• Data definition Language (DDL)
• Creation of table
• Dropping a Table
• INSERT, UPDATE, DELETE Statement

DQL 

• SELECT Statement
• WHERE CLAUSE Search condition
• Arithmetic, Comparison and Logical Operator
• Range Operator
• List Operator
• Like Operator
• Using ORDER BY, DISTINCT and TOP
• Using IS NULL and IS NOT NULL.

Built in SQL Function

• String Function
• Math Function
• Date Function
• Aggregate Function
• GROUP BY clause with HAVING
• HAVING VS WHERE

Joins and Sub Query 

• Introduction to Joins
• Types of Joins
• What are nested/sub queries
• Introduction Types of Sub-queries

Stored procedure and triggers and window functions

• Understanding meaning of stored procedure
• Creating first stored procedure using SQL
• What are triggers?
• Creating triggers for beginners
• Introduction to window functions

Python Programming

• Python Installation and Basic
• Syntax and programming Structures
• Variables, Operators, Keywords, Expressions
• Decision Making: if, elif, else
•  Loops: while, for, break, continue, pass
• List, Tuple, Dictionary, Set
• Functions, Modules
•  Object Oriented Programming

Libraries for data manipulation and data Visualization 

• Introduction to numpy and its function
• Introduction to Pandas and its function
• Introduction to matplotlib and seaborn for data visualization.

CASE STUDY -: IPL Data Analysis , Netflix and Hotstar data analysis

Dive into Excel :- Introduction to Excel

• Understanding different ribbons and tabs
• Entering data
• Fonts , formatting , finding replacing values in excel

Dealing with dates , numbers and filters in excel

• Currency and date format
• Custom formats
• Sorting and applying filters on data
• Sorting data as per need

Excel Formulae

• Performing different calculations using excel formulae.

Data Visualization and reporting using excel

• Lookup and Reference
• Pivot Tables
• Charts
• What-if Analysis
• Intro to Macros

Tableau

Introduction to Tableau

• What is Tableau
• Architecture of Tableau
• Features of Tableau
• Installation of Tableau Desktop/Public
• Interface of Tableau (Layout, Toolbars, Data pane, Analytics pane etc)
• How to start with Tableau
• Top Chart in Tableau
• Introduction to the various file type
• Quick Introduction to the user interface in tableau
• How to create data visualization using Tableau feature “show me
• Reorder and Remove Visualization Fields
• How to create calculated field
• How to perform operation using cross tab
• Working with workbook data and Worksheet

Organizing data using tableau 

• Sort data
• Filter data
• Generating groups
• Building sets

Data Visualization/Graph

•  Pivot table and Heat Map
•  Highlight Table
•  Bar Chart
•  Line Chart
•  Area Chart
•  Pie Chart
•  Scatter Plot
•  Word Cloud
•  Tree Map
•  Blended Axis
•  Dual Axis
•  Reference lines
•  Reference bends
•  Trend lines

Dashboards and Actions

• Dashboard design
• Dashboards
•  Dashboard actions
•  Drilldown report

PowerBI

Introduction to PowerBI

• Get Power BI Tools
• Introduction to Tools and Terminology
• Dashboard in Minutes
• Understanding PowerBi Desktop
• Connecting to a data sources

Dealing with Power Query

• Preparing data with query editor
• Merging and appending
• Case study on Sales analysis

DAX Query and data visualization

• Understanding syntax of DAX
• DAX functions
• Drawing different charts using PowerBI
• Creating and Manipulating with slicer
• Creating KPIs

Certificate

• MIT Certification

For More Details contact us:

Note: We provide Industrial based training as we provide Engineering Design Services  under Milestone PLM Solutions PVT LTD.