Data Analytics
Professional Certification Course to enter in IT Industry with Knowledge and Experience

Complete Course Curriculum
Course Duration: 6 - Months
Course Fees: 30000/-
Business Statistics
Introduction to Statistical Analysis
- Counting, Probability, and Probability Distributions
- Sampling Distributions
- Estimation and Hypothesis Testing
- Scatter Diagram
- Anova and Chisquare
- Imputation Techniques
- Data Cleaning
- Correlation and Regression
Introduction to Data Analytics
- Data Analytics Overview
- Importance of Data Analytics
- Types of Data Analytics
- Descriptive Analytics
- Diagnostic Analytics
- Predictive Analytics
- Prescriptive Analytics
- Benefits of Data Analytics
- Data Visualization for Decision Making
- Data Types, Measure Of central tendency, Measures of Dispersion
- Graphical Techniques, Skewness & Kurtosis, Box Plot
- Descriptive Stats
- Sampling Funnel, Sampling Variation, Central Limit Theorem, Confidence interval
Excel: Basics to Advanced
- Excel tutorial
- Text to Columns
- Concatenate
- The Concatenate Function
- The Right Function with Concatenation
- Absolute Cell References
- Data Validation
- Time and Date Calculations
- Conditional Formatting
- Exploring Styles and Clearing Formatting
- Using Conditional Formatting to Hide Cells
- Using the IF Function
- Changing the “Value if false” Condition to Text
- Pivot Tables
- Creating a Pivot Table
- Specifying PivotTable Data
- Changing a PivotTables Calculation
- Filtering and Sorting a PivotTable
- Creating a PivotChart
- Grouping Items
- Updating a PivotTable
- Formatting a PivotTable
- Using Slicers
- Charts
- Creating a Simple Chart
- Charting Non-Adjacent Cells
- Creating a Chart Using the Chart Wizard
- Modifying Charts
- Moving an Embedded Chart
- Sizing an Embedded Chart
- Changing the Chart Type
- Chart Types
- Changing the Way Data is Displayed
- Moving the LegendFormatting Charts
- Adding Chart Items
- Formatting All Text
- Formatting and Aligning Numbers
- Formatting the Plot Area
- Formatting Data Markers
- Pie Charts
- Creating a Pie Chart
- Moving the Pie Chart to its Own Sheet
- Adding Data Labels
- Exploding a Slice of a Pie Chart
- Data Analysis − Overview
- types of Data Analysis
- Data Analysis Process
- Working with Range Names
- Copying Name using Formula Autocomplete
- Range Name Syntax Rules
- Creating Range Names
- Creating Names for Constants
- Managing Names
- Scope of a Name
- Editing Names
- Applying Names
- Using Names in a Formula
- Viewing Names in a Workbook
- Copying Formulas with Names
- Difference between Tables and Ranges
- Create Table
- Table Name
- Managing Names in a Table
- Table Headers replacing Column Letters
- Propagation of a Formula in a Table
- Resize Table
- Remove Duplicates
- Convert to Range
- Table Style Options
- Table Styles
- Cleaning Data with Text Functions
- Removing Unwanted Characters from Text
- Extracting Data Values from Text
- Formatting Data with Text Functions
- Date Formats
- Conditional Formatting
- Sorting
- Filtering
- Lookup Functions
- Pivoting
SQL
- Data Introduction to Oracle Database
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Use Sub-Queries to Solve Queries
- The SET Operators
- Data Manipulation Statements
- Use of DDL Statements to Create and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data Dictionary ViewsManipulate Large Data Sets
- Data Management in Different Time Zones
- Retrieve Data Using Sub-queries
- Regular Expression Support
Tableau
Tableau Course Material
- Counting,Start Page
- Show Me
- Connecting to Excel Files
- Connecting to Text Files
- Connect to Microsoft SQL Server
- Connecting to Microsoft Analysis Services
- Creating and Removing Hierarchies
- Bins
- Joining Tables
- Data Blending
Learn Tableau Basic Reports
- Parameters
- Grouping Example 1
- Grouping Example 2
- Edit Groups
- Set
- Combined Sets
- Creating a First Report
- Data Labels
- Create Folders
- Sorting Data
- Add Totals, Sub Totals and Grand Totals to Report
Learn Tableau Charts
- Bar Chart
- Box Plot
- Bubble Chart
- Bump Chart
- Bullet Graph
- Circle Views
- Dual Combination Chart
- Dual Lines Chart
- Funnel Chart
- Traditional Funnel Charts
- Gantt Chart
- Grouped Bar or Side by Side Bars Chart
- Heatmap
- Highlight Table
- Histogram
- Cumulative Histogram
- Line Chart
- Lollipop Chart
- Pareto Chart
- Pie Chart
- Scatter Plot
- Stacked Bar Chart
- Text Labe
- Tree Map
- Word Cloud
- Waterfall Chart
Learn Tableau Advanced Reports
- Dual Axis Reports
- Blended Axis
- Individual Axis
- Add Reference Lines
- Reference Bands
- Reference Distributions
- Basic Maps
- Symbol Map
- Use Google Maps
- Mapbox Maps as a Background Map
- WMS Server Map as a Background Map
Learn Tableau Calculations & Filters
- Calculated Fields
- Basic Approach to Calculate Rank
- Advanced Approach to Calculate Ra
- Calculating Running Total
- Filters Introduction
- Quick Filters
- Filters on Dimensions
- Conditional Filters
- Top and Bottom Filters
- Filters on Measures
- Context Filters
- Slicing Fliters
- Data Source Filters
- Extract Filters
Learn Tableau Dashboards
- Create a Dashboard
- Format Dashboard Layout
- Create a Device Preview of a Dashboard
- Create Filters on Dashboard
- Dashboard Objects
- Create a Story
Server
- Tableau online.
- Overview of Tableau Server.
- Publishing Tableau objects and scheduling/subscription
Power BI
Introduction to Power BI
- Get Started with Power BI
- Overview: Power BI concepts
- Sign up for Power BI
- Overview: Power BI data sources
- Connect to a SaaS solution
- Upload a local CSV file
- Connect to Excel data that can be refreshed
- Connect to a sample
- Create a Report with Visualizations
- Explore the Power BI portal
Viz and Tiles
- Overview: Visualizations
- Using visualizations
- Create a new report
- Create and arrange visualizations
- Format a visualization
- Create chart visualizations
- Use text, map, and gauge visualizations and save a report
- Use a slicer to filter visualizations
- Sort, copy, and paste visualizations
- Download and use a custom visual from the gallery
Reports and Dashboards
- Modify and Print a Report
- Rename and delete report pages
- Add a filter to a page or report
- Set visualization interactions
- Print a report page
- Send a report to PowerPoint
- Create a Dashboard
- Create and manage dashboards
- Pin a report tile to a dashboard
- Pin a live report page to a dashboard
- Pin a tile from another dashboard
- Pin an Excel element to a dashboard
- Manage pinned elements in Excel
- Add a tile to a dashboard
- Build a dashboard with Quick Insights
- Set a Featured (default) dashboard
- Ask Questions about Your Data
- Ask a question with Power BI Q&A
- Tweak your dataset for Q&A
- Enable Cortana for Power BI
Publishing Workbooks and Workspace
- Modify Share Data with Colleagues and Others
- Publish a report to the web
- Manage published reports
- Share a dashboard
- Create an app workspace and add users
- Use an app workspace
- Publish an app
- Create a QR code to share a tile
- Embed a report in SharePoint Online
Other Power BI Components and Table Relationship
- Use Power BI Mobile Apps
- Get Power BI for mobile
- View reports and dashboards in the iPad app
DAX functions
- New Dax functions
- Date and time functions
- Time intelligence functions
- Filter functions
- Information functions
- Logical functions
- Math & trig functions
- Parent and child functions
- Text functions
Python Basics
- The print statement
- Comments
- Python Data Structures & Data Types
- String Operations in Python
- Simple Input & Output
- Simple Output Formatting
- Deep copy
- Shallow copy
- Operators in python
Course Name | Fees | Duration |
---|---|---|
Complete C Programming Course | 3000/- | 45 Days |
Complete C ++ Programming Course | 3000/- | 45 Days |
Core Java Development Course | 6000/- | 2 Months |
Basic Python Development | 6000/- | 2 Months |
Basic Android Development | 6000/- | 2 Months |
Web Designing | 6000/- | 2 Months |
JavaScript | 6000/- | 2 Months |
Graphic Designing | 6000/- | 2 Months |
Digital Marketing | 6000/- | 2 Months |
PHP & MySQL | 6000/- | 2 Months |
Internet of Things (IOT) | 6000/- | 2 Months |
Angular JS | 6000/- | 2 Months |
Node JS | 6000/- | 2 Months |
React JS | 6000/- | 2 Months |
C # | 6000/- | 2 Months |

Have a look on Exciting Project ideas on C Programming
You can build a simple calculator with C using switch cases or if-else statements. This calculator takes two operands and an arithmetic operator (+, -, *, /) from the user, however, you can expand the program to accept more than two operands and one operator by adding logic. Then, based on the operator entered by the user, it conducts the computation on the two operands. The input, however, must be in the format “number1 operator1 number2” (i.e. 2+4).
Using C language, you can also create a student management system. To handle students’ records (like Student’s roll number, Name, Subject, etc.) it employs files as a database to conduct file handling activities such as add, search, change, and remove entries. It appears a simple project but can be handy for schools or colleges that have to store records of thousands of students.
If you have ever lost track of which day of the week is today or the number of days in that particular month, you should build a calendar yourself. The Calendar is written in the C programming language, and this Calendar assists you in determining the date and day you require. We can implement it using simple if-else logic and switch-case statements. The display() function is used to display the calendar and it can be modified accordingly. It also has some additional functions.
This Phone book Project generates an external file to permanently store the user’s data (Name and phone number). The phone book is a very simple C project that will help you understand the core concepts of capacity, record keeping, and data structure. This program will show you how to add, list, edit or alter, look at, and delete data from a record.
An online voting system is a software platform that enables organizations to conduct votes and elections securely. A high-quality online voting system strikes a balance between ballot security, convenience, and the overall needs of a voting event. By collecting the input of your group in a systematic and verifiable manner, online voting tools and online election voting systems assist you in making crucial decisions. These decisions are frequently taken on a yearly basis – either during an event (such as your organization’s AGM) or at a specific time of the year. Alternatively, you may conduct regular polls among your colleagues (e.g. anonymous employee feedback surveys).
With this voting system, users can enter their preferences and the total votes and leading candidate can be calculated. It’s a straightforward C project that’s simple to grasp. Small-scale election efforts can benefit from this.
Tic-tac-toe, also known as noughts and crosses or Xs and Os, is a two-person paper and pencil game in which each player alternates marking squares in a three-by-three grid with an X or an O. The winner is the player who successfully places three of their markers in a horizontal, vertical, or diagonal row. You can implement this fun game using 2D arrays in the C programming language. It is important to use arrays while creating a Tic Tac Toe game in the C programming language. The Xs and Os are stored in separate arrays and passed across various functions in the code to maintain track of the game’s progress. You can play the game against the computer by entering the code here and selecting either X or O. The source code for the project is given below.
Mathematical operations are an everyday part of our life. Every day, we will connect with many forms of calculations in our environment. Matrices are mathematical structures in which integers are arranged in columns and rows. In actual life, matrices are used in many applications. The most common application is in the software sector, where pathfinder algorithms, image processing algorithms, and other algorithms are developed. Some fundamental matrix operations are performed in this project, with the user selecting the operation to be performed on the matrix. The matrices and their sizes are then entered. It’s worth noting that the project only considers square matrices.
Library management is a project that manages and preserves electronic book data based on the demands of students. Both students and library administrators can use the system to keep track of all the books available in the library. It allows both the administrator and the student to look for the desired book. The C files used to implement the system are: main.c, searchbook.c, issuebook.c, viewbook.c, and more.
The Electricity Cost Calculator project is an application-based micro project that predicts the following month’s electricity bill based on the appliances or loads used. Visual studio code was used to write the code for this project. This project employs a multi-file and multi-platform strategy (Linux and Windows). People who do not have a technical understanding of calculating power bills can use this program to forecast their electricity bills for the coming months; however, an electricity bill calculator must have the following features:
- All loads’ power rating
- Unit consumed per day
- Units consumed per month, and
- Total load calculation
The project’s goal is to inform a consumer about the MOVIE TICKET BOOKING SYSTEM so that they can order tickets. The project was created with the goal of making the process as simple and quick as possible. The user can book tickets, cancel tickets, and view all booking records using the system. Our project’s major purpose is to supply various forms of client facilities as well as excellent customer service. It should meet nearly all the conditions for reserving a ticket.
Snakes and ladders, also known as Moksha Patam, is an ancient Indian board game for two or more players that is still considered a worldwide classic today. It’s played on a gridded game board with numbered squares. On the board, there are several “ladders” and “snakes,” each linking two distinct board squares. The dice value can either be provided by the user or it can be generated randomly. If after moving, the pointer points to the block where the ladder is, the pointer is directed to the top of the ladder. If unfortunately, the pointer points to the mouth of a snake after moving, the pointer is redirected to the tail of the snake.
This system is built on the concept of booking bus tickets in advance. The user can check the bus schedule, book tickets, cancel reservations, and check the bus status board using this system. When purchasing tickets, the user must first enter the bus number, after which the system will display the entire number of bus seats along with the passengers’ names, and the user must then enter the number of tickets, seat number, and person’s name.
We will be using arrays, if-else logic, loop statements, and various functions like login(), cancel(), etc. to implement the project.
Pacman, like other classic games, is simple to play. In this game, you must consume as many small dots as possible to earn as many points as possible. The entire game was created using the C programming language. Graphics were employed in the creation of this game. To create the game, you have to first define the grid function to manage the grid structure. To control the movement, you can define functions such as move_right(), move_left(), move_up() and move_down(). C files to add ghosts and their functionalities, positions check, etc. can be added to make the game more fun. The customers will find this C Programming game to be simple to comprehend and manage.
Have a look on Exciting Project ideas on Data Analytics
Color Detection Project
Exploratory Data Analysis Projects (EDA)
Sentiment Analysis
Social Media Reputation Monitoring
Fake News Detection
Chatbots
Handwritten digit recognition
Gender and Age detection
Detection of Global Suicide Rates
Real-time pollution density measurement
COVID19 Data Visualization Using Python
Most followed on Instagram
Frequently Asked Questions

Who can apply for this course?
- All branch graduates students or undergraduate students who want to become professional in C programming.
- All stream students eg. Engineering, BCA, BSc, BBA, Bcom, BA.
- Any who wants to learn a new skill or improve skill for there career.
One should have any prior knowledge?
- Basic computer knowledge.
- General knowledge of what are programming languages.
Any Completion Certificate is there?
- Yes, a course completion certificate is given after the completion of this course.
Is the course offline or online?
- Both the offline and online modes are available for this course.
Why to join Webdroid
Webdroid is a leading IT Training and Software Development Company. Our Features include Internships, Training, and College Projects on almost every technologies.
- 1 Year of Membership
- Daily doubt Solving Session.
- Interview Preparation.
- Personal Attention
- Live and Practical Projects.