Data Analytics with SQL

DATA ANALYTICS WITH SQL

Duration: 3 days (24 hours)
Workshop Date: 25-27 November 2020
Time: 9 am to 5 pm

Fees: $642 (inclusive of GST)
Venue: The workshop will be conducted online

Learning Objective

Gain fluency & experience in Excel, SQL & Dashboarding- the 3 core pillars of Data Analytics teams, globally. Dive deep & learn how businesses can identify bottlenecks, improve efficiencies alongside understanding & improving their performance.

  • Build New-Age Data Skills That Business Needs
    In this hands-on and lab-intensive class, you will learn to ask the right questions of your data, while learning basic analytics functionality with Excel & SQL. Your newfound data analytic skills will be applied to real-world datasets, allowing you to develop recommendations based on your findings
  • Learn How to Enable Data-Driven Decision Making Across New Fields
    Regardless of your industry or role, fluency in the new language of data analytics empowers you to contribute to data-driven decision making.The hands-on labs & practice sessions throughout the course put you in the driver’s seat to understand with Excel, analyze with SQL, and interpret data with Tableau so you too can join the data conversation & help drive real-life business value.
  • Get Instructor Feedback, Support & Insights
    Get guidance, feedback and more from experts who are dedicated to supporting your learning and career goals. Instructors are on hand in class and during office hours to offer real-time technical assistance and help you turn ideas into action
  • Key Skills & Concepts Learned:
    • Data Analytics: Microsoft Excel
    • Data Storage & Processing: SQL
    • QL Dashboarding: Power BI

Workshop Content

Module 1: Introduction to Excel

  • Intro to Excel
  • Sorting
  • Filtering alongside working with date & time
  • Automation using macros

Module 2: Advanced Excel

  • Vlookup
  • Pivot & Text Analysis

Module 3: Introduction to SQL

  • What is SQL
  • Data Retrieval
  • Filtering & Conditional Operators

Module 4: Advanced SQL

  • Joins & Unions
  • Aggregation & Filtering

Module 5: Introduction to Dashboarding

  • Intro to Charting- when, where & why
  • Intro to Data Viz on Visualization tools

Module 6: Putting it together

  • Intro to Business & Data problem solutioning
  • Understanding different types of challenges each participant’s industry faces in Data Analytics

Quick Enquiry