Analytics

• Analyze Flights Delays
  • Workflow
  • Reading from Dataset
  • Print the sample datasets results
  • Column to be cast for new datatype double
  • Column to be cast for new datatype string
  • Updates the column name of datatype string
  • Prints the Results
  • Executes the SQL queries
  • Prints the Results
• Distribution Graphs
  • Workflow
  • Reading CSV file
  • Distribution of data by Week
  • Distribution of data by Month
  • Distribution of data by Year
• Farmers Markets On Geo Maps
  • Workflow
  • Reading from Dataset
  • Execute SQL Query
  • Prints the Results
  • Analyze using Graph
  • Execute SQL Query
  • Analyze using Graph
• General Payment Data Analysis
  • Workflow
  • Reading from Dataset
  • Calculate count transactions by speciality
  • Summary of transactions
  • Number of transaction per state
  • Prints the results
• Jetrail Data Analysis
  • Workflow
  • Reading from Dataset
  • Extract date time field
  • Calculate count per month
  • Execute query for months
  • Prints the Results
  • Graphical analysis
• NYC Taxidata Analysis
  • Workflow
  • Reading from Dataset
  • Extract hour from pickup time
  • Calculate the speed per hour
  • Calculate the average speed per hour
  • Prints the results
  • Analyze using Chart Graph
• Transaction Data Analytics
  • Workflow
  • Reading from Dataset
  • Prints the sample Dataset Results
  • Analysing using Graph