+91 9760004085 | brilliantmakers@rediffmail.com | Geeta Nagar, Rishikesh

Advanced Data Analysis Course Syllabus

diploma-in-computer-course-in-rishikesh

Advanced Data Analysis Course Details

Module 1: Advance Excel

  • Import Data from Different Sources
  • Conditional & Lookup Functions.
  • Statistical functions, Math Functions.
  • Data Cleaning Techniques and Power Query
  • 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.
  • Project –Educational Dashboard

Module 2: Power BI

  • Working with different datasets
  • Data cleaning and transformation using power query
  • Basics of DBMS and RDBMS
  • Creating data modeling.
  • Advance DAX Measures.
  • Data Visualization Using Charts, Map, Cards.
  • Conditional formatting in Charts.
  • Decomposition Tree.
  • Asking AI Based Q & A.
  • Reporting in Power BI.
  • Project - Sales Dashboard

Module 3: SQL

  • Creating database, Tables and Schemas in Microsoft SQL Server
  • Writing Basic SQL Queries.
  • Data Manipulation Commands and Operations.
  • Functions in SQL.
  • Analytics functions and query in SQL
    • 1. 2. 3. 4.
  • Joining & Union Operations
  • Advance SQL Queries using windows functions and subqueries.
  • Recording Store Procedures and Views.
  • End Project – Exploratory Data Analysis

Module 4:Python & Data Analysis Library

  • Data structure in pythons.
  • Conditional statements and loops.
  • Creating user-defined functions.
  • Creating and working with dataframes.
  • Creating plots using matplotlib and seaborn.
  • Univariate, Bivariate and Multivariate Analysis.
  • Exploratory data analytics using pandas, seaborn and matplotlib.
  • Final Project – Explore marketing datasets to find customers’ buying pattern

Please fill this information

Loading

Course Duration

6 Months

Eligibility

10th 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