Learn Data science, Tableau and, Python from Expert

Learn Data science, Tableau and, Python from Expert

Amazing features to get online Assistant through our team

Qualify Teacher

Best Online data science lessons.We have qualified teacher who will help you to learn Data science, Python, Tableau, Advance excel from basic to advance level.

Live Coding

We have experts Who will help student to do their Programming Homework, or Programming assignment on live code sessions, this will help you to get A+ grade in your Programming Assignments.

Instant Doubt support

Our expert will help Students to clear doubt right there, You can ask multiple question while doing live sessions we will love to answers those.

Hassle Free Connectivity

We are here to help student in easy and fast way, you need to not download any complicated or personalised paid software , we are here to provide online tutoring via zoom call its easy and very quick.

Advance Excel Course details

  • Change in Charts Group
  • Chart Recommendations
  • Fine Tune Charts Quickly
  • Select / De-select Chart Elements
  • Format Style
  • Format Color
  • Filter Data being displayed on the Chart
  • Format Axis
  • Provision for Combo Charts
  • Ribbon of Chart Tools
  • Quick Layout
  • Change Colors
  • Chart Styles
  • Switch Row / Column
  • Select Data
  • Change Chart Type
  •  Move Chart
  • Formatting Data Labels
  • Look of the Data Labels
  • Shape of a Data Label
  • Resize a Data Label
  •  Add a Field to a Data Label
  • Add a Leader Line
  •   Format Leader Lines
  • Functions by Category
  • New Functions in Excel 2013
  • User Defined Functions in Add-ins
  •  Web Functions
  • Quick Analysis Features
  • Quick Analysis of Data
  • Conditional Formatting
  • Charts
  • Totals
  • Tables
  • Sparklines
  • Create a PivotTable to analyze external data
  • Connect to a new external data source
  • Using the Field List option
  •  PivotTables based on Multiple Tables
  • Explore Data Using PivotTable
  •  Create Relationship between Tables
  • Data Model using Calculated Columns
  •  Relationship using calculated columns
  • Update the Data Connections
  • Automatically Refresh Data
  • Automatically refresh data at regular intervals
  •    Enable Background Refresh
  • Source Data for a PivotTable
  • Change to a Different External Data Source
  • Delete a PivotTable 
  • Using the Timeline
  • Use a Timeline to Filter by Time Period
  •  Create a Standalone PivotChart

Create a Power View Sheet

  • Create Charts and other Visualizations
  • Visualization – Matrix
  • Visualization – Card
  •  Visualization – Charts
  • Bubble and Scatter Charts
  • Maps
  • Multiples: A Set of Charts with the Same Axes
  •  Visualization – Tiles
  • Modify the internal Data Model
  • Key Performance Indicators (KPIs)
  • Hierarchies
  •  Drill-Up and Drill-Down
  • Hyperlinks
  • Printing
  •  Support for right-to-left languages
  • Power Query
  •  Power BI Desktop

Excel – Templates

  • Ensure Inquire Add-in is Active
  •  Compare Two Workbooks
  • Diagrams
  • Workbook Relationship
  • Worksheet Relationship
  • Cell Relationship
  •  Clean Excess Cell Formatting
  • Embed Worksheet Data in a Web Page
  • Save a Workbook in another File Format
  • Excel File Formats
  • Text File Formats
  • Other File Formats
  • File Formats that Use the Clipboard
  •   File Formats not Supported in Excel 2013
  • Discontinued / Changed features
  • Save Workspace
  • New from Existing
  • Save as Template
  • Split Box Control
  • Blank Workbook
  • Save Options
  • Microsoft Clip Organizer
  • MS Office Picture Manager
  • Exit option
  • Browser View Options
  • Individual Data Series
  •  Pyramid and Cone Chart Types

Data Science (R Programming and Python) Course Details

  • Python data structures
   
  • Control statements Functions
   
  • Object Oriented programming concepts using classes, objects and methods
   
  • Exception handling
   
  • Implementation of user-defined Modules and Package
   
  •  File handling in python
   
  • Knowledge domains of Data Analysis
   
  • Understanding structured and unstructured data
   
  • Data Analysis process
   
  • Dataset generation
   
  • Importing Dataset: Importing and Exporting Data
   
  • Basic Insights from Datasets
   
  •  Cleaning and Preparing the Data: Identify and Handle Missing Values.
   
  • Data Formatting
   
  • Exploratory Data Analysis
   
  • Filtering and hierarchical indexing using Pandas
   
  • Data Visualization: Basic Visualization Tools
   
  • Specialized Visualization Tools
   
  •  Seaborn Creating and Plotting Maps.
   
  • Numpy and Scipy Package
   
  • Understanding and creating N-dimensional arrays
   
  • Basic indexing and slicing
   
  • Boolean indexing
   
  • Fancy indexing
   
  • Universal functions
   
  • Data processing using arrays
   
  • File input and output with arrays.
   

Data wrangling

  

Web scrapping

  
  • Combing and merging data sets
  
  • Reshaping and pivoting
  
  • Data transformation
  
  • String Manipulation
  
  •  case study for web scrapping.
  
  • Introduction to machine learning- Supervised and Unsupervised Learning
   
  • Model development using Linear Regression
   
  • Model Visualization
   
  • Prediction and Decision Making
   
  • Model Evaluation: Over-fitting, Under-fitting and Model Selection.
   
  • Importing necessary python package
   
  • Organizing data into training & testing sets
   
  • Model evaluation
   
  • Finding accuracy
   
  • Confusion Matrix
   
  • Various ML Classification Algorithms
   
  • Cross Validation & Hyper Parameter Tuning
   

Introduction to Clustering

  
  • Hierarchical Clustering
  
  • K-Means Clustering
  
  • Visualize clusters
  
  • Elbow Method
  
  •  Clustering in Real World
  
  • Introduction to Clustering
  
  • Hierarchical Clustering
  
  • K-Means Clustering
  
  • Visualize clusters
  
  • Elbow Method
  
  •  Clustering in Real World
  
  • Data preprocessing
  
  • Training apriori model
  
  • Visualising the results
  
  • Support, Confidence and Lift
  
  • Association Rules
  
  • Regression
  
  • Moving Average
  
  • ARMA Models
  
  • Seasonality
  
  • p, d, q values
  
  • Visualization and forecasting
  

Tbleau Course Details

  • What is Tableau
  • Architecture of Tableau
  • Features of Tableau
  • Installation of Tableau Desktop/Public
  • Interface of Tableau (Layout, Toolbars, Data pane, Analytics pane etc)
  • How to start with Tableau
  • Top Chart in Tableau
  • Introduction to the various file type
  • Quick Introduction to the user interface in tableau
  • How to create data visualization using Tableau feature “show me”
  • Reorder and Remove Visualization Fields
  • How to create calculated field How to perform operation using cross tab
  •  Working with workbook data and Worksheet
  • Pivot table and Heat Map
  • Highlight Table
  • Bar Chart
  • Line Chart
  • Area Chart
  • Pie Chart
  • Scatter Plot
  • Word Cloud
  • Tree Map
  • Blended Axis
  •  Dual Axis
  • Bar Chart
    • Stacked Bar Chart
      
    • Bar in Bar Chart
      
    • Combo Chart
      
  • Line Chart

    • Single Axis
    • Dual Axis
    •  Blended Axis
    • Line
    • Bar
    • Lollipop Chart
    • Donut
    • Bullet Graph
    • Histogram Chart
    •  Animated Graph

      Dual Axis Chart

  • Other Advanced Chart

  • Explain latitude and longitude
  • Default location/Edit locations
  • Symbol map & Filled Map
  • Map Layer
  • Image in map
  •  Map option
  • Connecting to different Data Source
    • Excel
    • CSV
    •  SQL Server
  • Live vs Extract Connection

  • Pivoting and splitting

  • Data Interpreter: Clean Dirty Data

  • TWB vs TWBX

  • How to create a packaged workbook

  • Difference between .tde and .hyper file

  • Joins
    • Inner
    • Left
    • Right
    •  Outer
  • Complex Join

  • Referential Integrity

  • Union

  • Data Blending and when required

  • Cross DB Join

  • Why visualization came into the picture?
  • Importance of visualizing data
  • Poor visualization vs Perfect visualization
  • Principal of visualization
  •  Goal of Data visualization
  • Filter
    • Types of filter
    • Quick filter
    • Global filter
    • Normal filter
    • Relevant filter
    • Dimension filter
    • Measure filter
    • Condition based filter
    • Advanced filter using wild card

    Right click filtering

  • Top & Bottom N Filter

  • Filtering Order of Operation

    • Extract Filter
     
    • Data Source Filter
     
    • Context Filter
     
  • Action Filter
    • Filter
    • Highlight
    • Go to URL
    • Go to Sheet
    • Set Action
    •  Parameter Action
  • Action Jumps

  • Viz in Tool Tip

  • Sorting

  • Calculation – String, Basic, Date and Logic

  • Continuous and Discrete data

  • Working with Dates

  • Sorting

  • Calculation – String, Basic, Date and Logic

  • Continuous and Discrete data

  • Working with Dates

  • Creating calculated Fields

    • Logical Function
    • Case if Function
    • ZN Function
    • Else if Function
    • Ad-hoc Function
  • Manipulating Text – left and right function

  • Table Calculation
    • Running total
    • Percent
    • Percent total
    •  Year over Year Growth
  • Include
  • Exclude
  • Fixed
  • Groups
  • Sets

 

  • Dynamic Measure
  • Dynamic Dimension
  • Hierarchies
  • Bins
  •  Combined Field
  • Trend Line
  • Forecasting
  • Cluster
  • Reference Line
  • Box Plot(Understanding Outliers in Data)
  • Distribution Band
  •  Reference Band
  • Size
  • Updating Axis
  • Colors
  • Borders
  • Transparency
  • Chart Line
  • Reference Line
  • Mark Label
  • Annotation
  • Responsive Tool Tip
  • Canvas Selection
  • Tiled Object
  • Floating Object
  • Pixel Perfect Alignment
  • Summary Box
  • Chart Titles and Captions
  • Adding Image and Text
  • Adding Shading
  • Adding Separator Lines
  • Dynamic Chart Title
  • Information Icons
  •  Creating a Story
  • Publishing to PDF
  • Exporting to Pivot Table and Images
  • Exporting Packaged workbooks
  • Tableau Reader
  • Tableau Online
  • Tableau Server
  • Tableau Public
  • Version Control
  •  Publishing to Tableau Server
  • Financial Analysis Dashboard
  • HR Analysis Dashboard
  • Market Analysis Dashboard
  • Tourism Analysis Dashboard
  • New Business Analysis Dashboard
  •    Banking Sector Analysis
  • Issue & Bug reporting Analysis
  •  Population Trend Analysis