DATA ANALYTICS
Data Analytics – 6 Modules
Module – 1 : Excel Analytics Module – 4: Business Statistics & Visualization
Module – 2 : Sql Module – 5: Python for Analytics
Module – 3: PowerBi Module – 6: Hands-On-Project
Introduction to Data Analytics
a. What is Data Analytics ? Its importance in business and decision-making process ?
b. Skills required to become Data Analyst , Business Analyst, Business Intelligence
Analyst, Marketing Analyst, Research Analyst, Reporting Analyst
c. Difference between Data Analyst, Business Analyst, Business Intelligence Analyst
d. Tools Covered: Excel, Sql, PowerBi, Python
e. Career Opportunities, Roles, Jobs Description & Pay Packages for Data Analyst ?
f. Difference between Data Analytics, Business Analytics & Data Science
g. Learning Objectives of Data Analytics Course:
Data Collection & Cleaning
Data Exploration & Analysis
Data Visualization
Reporting & Dash boarding
Business Insights & Recommendations
Key Takeaways
a. Hands-On-Project delivered using Tools lime Exel ,Sql, PowerBi & Python for data
analytics project implementation
b. Resume preparation
c. All topics explained with REAL WORLD projects only
d. Data Analytics Project End to End Lifecycle explanation
e. Mock Interviews & Test for Data Science Interview preparation
f. Detailed assistance in Resume preparation. Special attention for experienced people
on previous experience
g. Real time interview questions and answers e-book
h. Trainer & Lab Coordinator available for doubt clarification
i. Latest resources, blogs and articles shared
Flat No: 212, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyd. And #101, Sree Swathi Anukar.
www.kellytechno.com Ph & Whatsapp: 998 570 6789, Online: 001 973 780 6789
, DATA ANALYTICS
Module – 1 Excel
i. Averageif & Averageifs
2. Excel Overview j. Match & Index
a. Creating a New Workbook k. Text Functions
b. Navigating in Excel l. Data Functions
c. Moving the Cell Pointer m. Editing & Copying Formulas Fixing
d. Using Excel Menus Errors in Your Formulas
e. Using Excel Toolbars: Hiding, n. Formulas with Several Operators
Displaying, and Moving Toolbars and Cell Ranges
f. Entering Values in a Worksheet
and Selecting a Cell Range 4. Data Analysis & Pivot Tables
g. Previewing and Printing a a. Creating a PivotTable
Worksheet b. Specifying the Data, a PivotTable
h. Switching Between Sheets in a Analyzes
Workbook c. Changing a PivotTable's Calculation
i. Inserting and Deleting Worksheets d. Selecting What Appears in a
j. Renaming and Moving Worksheets PivotTable
k. Hiding Columns, Rows and Sheets e. Grouping Dates in a PivotTable
l. Splitting and Freezing a Window f. PivotTable Formatting
m. Editing, Clearing, and Replacing g. Pivot Chart
Cell Contents h. Slicing
n. Cutting, Copying, and Pasting Cells i. Conditional-Formatting
o. Moving and Copying Cells with j. Data Validation
Drag and Drop k. Data Consolidation
p. Collecting and Pasting Multiple l. Text To Columns
Items Using the Paste Special m. Remove Duplicates
Command n. Record Macros
q. Inserting and Deleting Cells, Rows,
and Columns Using Undo, Redo 5. Data Visualization Using EXCEL
r. Checking Your Spelling Finding and a. Creating a Chart
Replacing Information b. Chart Formatting
s. Inserting Cell Comments c. Changing a Chart Type and
t. Sort Working with Pie Charts
u. Filter d. Adding Titles, Gridlines
3. Formulas 6. Conclusion
a. Creating a Basic Formula a. Dashboard Building Tips & Tricks
b. IF, Nested Ifs b. Data Cleaning Demo
c. IFNA, IF Error c. Sample Project Demo
d. Vlookup d. Review and Recap
e. HLookup e. Final Project: Call Centre Analysis
f. XLookup & Apparel Manufacture Analysis
g. Sumif & Sumifs
h. Countif & Countifs
Flat No: 212, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyd. And #101, Sree Swathi Anukar.
www.kellytechno.com Ph & Whatsapp: 998 570 6789, Online: 001 973 780 6789
Data Analytics – 6 Modules
Module – 1 : Excel Analytics Module – 4: Business Statistics & Visualization
Module – 2 : Sql Module – 5: Python for Analytics
Module – 3: PowerBi Module – 6: Hands-On-Project
Introduction to Data Analytics
a. What is Data Analytics ? Its importance in business and decision-making process ?
b. Skills required to become Data Analyst , Business Analyst, Business Intelligence
Analyst, Marketing Analyst, Research Analyst, Reporting Analyst
c. Difference between Data Analyst, Business Analyst, Business Intelligence Analyst
d. Tools Covered: Excel, Sql, PowerBi, Python
e. Career Opportunities, Roles, Jobs Description & Pay Packages for Data Analyst ?
f. Difference between Data Analytics, Business Analytics & Data Science
g. Learning Objectives of Data Analytics Course:
Data Collection & Cleaning
Data Exploration & Analysis
Data Visualization
Reporting & Dash boarding
Business Insights & Recommendations
Key Takeaways
a. Hands-On-Project delivered using Tools lime Exel ,Sql, PowerBi & Python for data
analytics project implementation
b. Resume preparation
c. All topics explained with REAL WORLD projects only
d. Data Analytics Project End to End Lifecycle explanation
e. Mock Interviews & Test for Data Science Interview preparation
f. Detailed assistance in Resume preparation. Special attention for experienced people
on previous experience
g. Real time interview questions and answers e-book
h. Trainer & Lab Coordinator available for doubt clarification
i. Latest resources, blogs and articles shared
Flat No: 212, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyd. And #101, Sree Swathi Anukar.
www.kellytechno.com Ph & Whatsapp: 998 570 6789, Online: 001 973 780 6789
, DATA ANALYTICS
Module – 1 Excel
i. Averageif & Averageifs
2. Excel Overview j. Match & Index
a. Creating a New Workbook k. Text Functions
b. Navigating in Excel l. Data Functions
c. Moving the Cell Pointer m. Editing & Copying Formulas Fixing
d. Using Excel Menus Errors in Your Formulas
e. Using Excel Toolbars: Hiding, n. Formulas with Several Operators
Displaying, and Moving Toolbars and Cell Ranges
f. Entering Values in a Worksheet
and Selecting a Cell Range 4. Data Analysis & Pivot Tables
g. Previewing and Printing a a. Creating a PivotTable
Worksheet b. Specifying the Data, a PivotTable
h. Switching Between Sheets in a Analyzes
Workbook c. Changing a PivotTable's Calculation
i. Inserting and Deleting Worksheets d. Selecting What Appears in a
j. Renaming and Moving Worksheets PivotTable
k. Hiding Columns, Rows and Sheets e. Grouping Dates in a PivotTable
l. Splitting and Freezing a Window f. PivotTable Formatting
m. Editing, Clearing, and Replacing g. Pivot Chart
Cell Contents h. Slicing
n. Cutting, Copying, and Pasting Cells i. Conditional-Formatting
o. Moving and Copying Cells with j. Data Validation
Drag and Drop k. Data Consolidation
p. Collecting and Pasting Multiple l. Text To Columns
Items Using the Paste Special m. Remove Duplicates
Command n. Record Macros
q. Inserting and Deleting Cells, Rows,
and Columns Using Undo, Redo 5. Data Visualization Using EXCEL
r. Checking Your Spelling Finding and a. Creating a Chart
Replacing Information b. Chart Formatting
s. Inserting Cell Comments c. Changing a Chart Type and
t. Sort Working with Pie Charts
u. Filter d. Adding Titles, Gridlines
3. Formulas 6. Conclusion
a. Creating a Basic Formula a. Dashboard Building Tips & Tricks
b. IF, Nested Ifs b. Data Cleaning Demo
c. IFNA, IF Error c. Sample Project Demo
d. Vlookup d. Review and Recap
e. HLookup e. Final Project: Call Centre Analysis
f. XLookup & Apparel Manufacture Analysis
g. Sumif & Sumifs
h. Countif & Countifs
Flat No: 212, 2nd Floor, Annapurna Block, Aditya Enclave, Ameerpet, Hyd. And #101, Sree Swathi Anukar.
www.kellytechno.com Ph & Whatsapp: 998 570 6789, Online: 001 973 780 6789
