Data Analysis Course in Rishikesh

Admission open for all Courses ::: Notes of WORD, EXCEL is available for degree college students,

Data Analysis Course Syllabus

diploma-in-computer-course-in-rishikesh

Data Analysis Course Details

Module 1: Advance Excel

Import Data from Different Sources
Conditional & Lookup Functions.
Statistical functions, Math Functions.
Data Cleaning Techniques.
Data Modeling Using Dimension & Fact Tables.
Creating Reports using Pivot Table, Reporting functions, and Data Modeling.
Data Visualization using Charts, Sparkline, Condi-tional Formatting and Shapes.
Analysis Tool Scenario Manager, Solver, Goal Seek

Module 2: Power BI

Import Data from Different Sources
Writing M Code.
Basics of DBMS and RDBMS.
Primary Keys, Foreign Keys, Dimension and Fact Tables.
Advance DAX Measures.
Data Visualization Using Charts, Map, Cards.
Conditional formatting in Charts.
Decomposition Tree.
Asking AI Based Q & A.
Key Influencers Chart.

Module 3: SQL

RDBMS Database.
Basic SQL Commands.
Data Manipulation Commands and Operations.
SQL Operators.
SQL Tables.
SQL Functions.
SQL Joining Data.
Basic to Advance SQL Queries.
SQL Data Constraints.
SQL Queries and Sub Queries.

Module 4: Python & Its Libraries

String, List, Tuple, Dictionaries
Conditional statements and loops.
Built in functions in python.
Import different libraries.
Web Scraping using python.
Python Numpy Liabrary.
Dataframe using Pandas Libraries.
Data Visualization using python matplotlb library.

Please fill this information

Course Duration

6 Months

Eligibility

10^th Qualified

Tags

Diploma in Computer Application

DCA Course

DCA in Rishikesh

DCA ourses in Rishikesh

Computer Courses in Rishikesh

Computer Centre in Rishikesh

Computer Institute in Rishikesh

Computer Coaching in Rishikesh

Contact Fee Courses in Rishieksh