Data Analytics Course in Chandigarh

Introduction and Overview

• Install and Setup Python and PYcharm IDE
• Variable Types and Input
• Basic Operators
• Decision Making
• Loops and Date & Time
• Numbers and Strings
• Lists,Tuples and Dictionary
• Built-in Functions,User  Defined Functions
• Built-In Modules
• File I/O
• Managing Directories
• Exception handling
• Python Slice and Slicing

• Classes and Self
•  Class Constructor( init )and Destructor
• Inheritance its Types and Polymorphism

• MySql Introduction
• Install MySql Connector for python
• Curd(Create,Update,Read,Delete)
• Basic functions
• All Types of Joins
• Wildcards
• Triggers
• Stored Procedure
• View
• Indexes , Constraints

Introduction to ML

• Regression Strategies
• Classication Strategies

• Basics
• Best Architecture
• Rest and Python

• Numy
• Pandas
• Matplotlib
• Seaborn

NUMPY

• Array creation methods
• Multi-dimensional arrays
• Linear algebra using Numpy
• Array Filtering and update methods

• Dataframe and Series
• Grouping and Merging
• Data formatting
• Excel File handling functions

• Line plot,scatter plot and bar graph
• Histogram
• Heatmaps
• Violin plot and box plot

Data Visualization

• Data Sampling
• Statistical Distribution Analysis
• Data Cleaning
• Handling large Data sets
• Clustering

• Machine learning algorithms
• Regression
• Classification
• Model Evaluation
• Encoding
• Dimensionality Reduction

• Introduction to Data Visualization and power of Tableau
• What is data Visualization
•  Comparison and benefits against reading Raw numbers
• Real usage examples from various Business Domains
• Connecting to Data Source
• Tableau Data types and data preparation


Introduction to Tableau

• Installation Of tableau Desktop
• Architecture of Tableau
• Interface of Tableau ( layout, Toolbars, Data pane , Analytics pane )

• Connection to Excels , PDFs and Cubes
• Managing Metadata and Extracts
• Data Preparation and dealing with Null values
• Data Joins ( Inner , Left , Right , Outer ) and Union
• Cross DataBase joining
• Data Blending , Data & Refresh Extraction , incremental Extraction
• How to build Extract?

• Marks, Highlighting, Sort and Group, working Sets
• Creating of Sets, Editing Sets, IN/OUT, Sets Hierarchies
• Constant Sets, Computed Sets, Bins

• Create Parameters, Parameters in Calculations
• Using Parameters with Filters
• Column Selection Parameters
• Chart selection parameters
• How to use Parameter in Filter Session
• How to use Parameter in Calculating Fields
• How to use Parameter in Reference Line

• Dual Axes Graphs, Histogram (Single and Dual Axes),
• Box Plot, Pareto Chart, Motion Chart, Funnel Chart
• Waterfall Chart, Tree Map, Heat Map, Market Basket analysis
• Using Show me Types of Charts, Text Table, Heat map,
• Highlighted Table, Pie Chart, Tree map, Bar chart, Line Chart
• Bubble Chart, Bullet chart, Scatter Chart
• Dual Axis Graphs, Funnel Charts, Pareto Chart, Maps, Hands on Lab,
• Assignment, Funnel Chart, Waterfall Chart, Maps

• Power BI Job Roles in Real -time
• Power BI Data Analyst Job Roles
• Business Analyst – Job Roles
• Power BI Developer – Job Roles
• Power BI for Data Scientists
• Comparing MSBI and Power BI
• Comparing Tableau and Power BI
• Types of Reports in Real-World
• Interactive & Paginated Reports
•  Analytical & Mobile Reports
• Data Sources Types in Power BI
• Power BI Licensing Plans – Types
• Power BI Training : Lab Plan
•  Power BI Dev & Prod Environments

Basics of Charts

• Stacked Charts and Clustered Charts
• Line Charts, Area Charts, Bar Charts
• 100% Stacked Bar & Column Charts
• Map Visuals: Tree, Filled, Bubble
• Cards, Funnel, Table, Matrix
• Scatter Chart : Play Axis, Labels
• Series Clusters & Selections
• Waterfall Chart and ArcGIS Maps

• Connection with CSV
•  AVERAGEX and AVERAGE in DAX
•  KEEPFILTERS and CALCULATE
• COUNTROWS, RELATED, DIVIDE
• PARALLELPERIOD, DATEDADD
• CALCULATE & PREVIOUS MONTH
•  USERELATIONSHIP, DAX Variables
• TOTALYTD , TOTALQTD
•  DIVIDE, CALCULATE, Conditions
• IF..ELSE..THEN Statement
•  SELECTEDVALUE, FORMAT
• SUM, DATEDIFF Examples in DAX
• TODAY, DATE, DAY with DAX
• Getting the data from mysql into powerbi and dealing with it
• AZURE and cloud computing concept with powerbi

Intoduction to
excel

• An overview of the screen,
• Navigation and basic spreadsheet concepts
•  Various selection techniques
•  Shortcut Keys

• Date, if, Date Add
  • MONTH, Weekday

•  Formatting Dates
• Custom and Special Format
• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
• Basic conditional formatting

• SumIf, SumIfs CountIf, CountIfs
• AverageIf, AverageIfs,
•  Nested IF, IF ELSE Statement
• AND, OR, NOT

• Paste Formulas, Paste Formats
• Data Validations
• Transpose Tables

• Filtering on Text, Numbers & Colors
• Sorting Options
• Advanced Filters on 15-20 different criteria(s)

• Goal Seek Analysis
• Prediction Analysis
• Data Tables (PMT Function)
•  Solver Tool

• Vlookup / Hlookup
• Index and Match
• Creating Smooth User Interface Using Lookup
•  Nested V lookup
•  Reverse Lookup using Choose Function
• Worksheet linking using Indirect
•  Vlookup with Helper Column
  Pivot Tables

Basics of Pivot Tables

• Creating Simple Pivot Tables
•  Basic and Advanced Value Field Setting
• Classic Pivot table
• Choosing Field
• Filtering Pivot Tables
• Modifying Pivot Table Data
• Grouping based on numbers and Dates
• Calculated Field & Calculated Items
• Arrays Functions
•  What are the Array Formulas, Use of the Array Formulas ?
• Basic Examples of Arrays (Using ctrl+shift+enter).
• Array with if, len and mid functions formulas.
• Array with Lookup functions.
• Advanced Use of formulas with Array.

• Stock Price Prediction
• Flipkart Reviews Sentiment Analysis
• Cryptocurrency Price Prediction for the next 30 days
• Apple Stock Price Prediction
• Insurance Prediction
• Worldwide Billionaires Analysis
• Unemployment Analysis
• Car Price Prediction Model