Data Analysis using Advance Excel and SQL - Dice Analytics
 

Data Analysis using
Advance Excel
and SQL

8 Weeks Industry Experts Led Training

About The Training

Learn how to master spreadsheets and, build and analyze a variety of SQL databases in 8 weeks online Microsoft Excel & SQL advanced training led by industry experts.

This 8 weeks training is designed for users who are experienced or want to learn advance level of Microsoft Excel & SQL. In this training you will gain a complete grasp of its capabilities and further utilize it more effectively in work environment.

Course Outline Register Now Pricing

Schedule

Date

30 July, 2022

Duration

8 Weeks

Timings

11:00 AM – 04:00 PM
(Sat – Sun only)

Seats Availability

Limited slots available

Meet your Instructors

qodef-fullwidth-slider

Ali Raza Anjum

Data Science Domain Expert | Co-Founder & MD @ Dice Analytics

Ali Raza Anjum Co-Founder & Managing Director at Dice Analytics Mr. Ali Raza Anjum has 12+ years of experience in well renowned telecom companies of Pakistan. His key expertise are in domain of Data Science, Machine Learning, Big Data, Data Visualization, Data driven Marketing & Customer value management. He is currently working with World Bank and analyzing data driven patterns and facts.

qodef-fullwidth-slider

Mr Neman Shahid

Director IT, Business Intelligence and Business Process Management

Mr. Neman is a Project Management and IT Governance and Compliance professional with an extensive 10+ years of industry experience in Business Process Management including Auditing and Compliance, Project Management and Technical Support domains. His expertise also include Reporting and KPI Evaluation using MS Excel & KNIME and Lead Auditor/Lead Implementer of ISO 27001, ISO 20000-1 & ISO 9001.

Course Outline

Week 1

  • What is a Database
  • Different Database Management Softwares
  • Microsoft SQL Server Overview
  • SQL Management Studio
  • Select Statement
  • Execution Order of SELECT Statements
  • Ordering Results/Orderby Clause
  • Additional SELECT Options
  • Column aliases
  • Table aliases
  • Where Clause
  • Rows Filtering using pattern matching
  • Date types and Date functions
  • DML and DDL Statements
  • Inserting rows (INSERT)
  • Inserting rows using subquery
  • Updating rows (UPDATE)
  • Deleting rows (DELETE)
  • Create Table
  • Delete/Turncate Table
  • Drop Table/Database
  • Primary Key & Foreign Key Concept

Week 2

  • Basics of ERD Diagrams
  • Group By Caluse
  • Count, Distinct Count, Sum, Average, Min, Max
  • Having Clause
  • Difference Between Where and Having Clause
  • Handling Multiple Tables Using Joins
  • Inner Join
  • Left Join
  • Right Join
  • Full Outer Join
  • Cross/Product Join
  • Joining Three or More Tables
  • Self-join
  • Alternate Syntax, Implicit Joins
  • Set Operations
  • Working with Multiple Set Operators
  • Viewing Graphical Execution Plans
  • CASE Statements in SQL
  • NULL vs Blank
  • = vs IS NULL
  • ISNULL function
  • COALESCE
  • Concatenating NULL Data
  • Subqueries in SQL
  • Subqueries in the SELECT Clause
  • Subqueries in the WHERE Clause

Week 3

  • Window Aggregate Functions
  • Partition By Clause
  • Over Clause
  • Qualification Clause
  • Rank, Row Number and Dense Rank Functions
  • Running Sum and Running Difference
  • Lag and Lead Functions
  • First and Last Function
  • NTILE
  • Range vs Row Function
  • Data Type Precedence
  • String Related Data Types
  • Numeric Data Types
  • Date and Time Data Types
  • Converting Between Data Types
  • How to Find Help on Functions
  • Understanding Data Type Conversion

Week 4

  • Microsoft Power Point Overview
  • Importance of Power Point in Data Analysis for Story Telling
  • Creating Presentations
  • Understanding Layouts and Sizing
  • Slides Basics
  • Text Basics
  • Applying Themes
  • Applying Transitions
  • Managing Slides
  • Slide Show Basics
  • Indent and Lince Spacing
  • Adding and Formating Pictures
  • Adding Videos in Slide Deck
  • Adding Shapes and 3D Diagrams
  • Using Slides Tempaltes
  • Animating Objects in Power Point
  • Insert Tables
  • Insert Charts
  • Shortcuts in Power Point

Week 5

  • Basic Excel Functions
  • Conditional Formatting
  • Data Cleaning
  • Intermediate Excel Functions
  • VLOOKUP, HLOOKUP and XLOOKUP
  • Array Formulas
  • How to create basic charts?

Week 6

  • What is Data Modelling and how to achieve it in Excel?
  • Understanding and exploring Pivot Table and Pivot Charts along with their applications
  • Learning Power Query basics with examples

Week 7

  • Power Pivot
  • Excel Slicers
  • Trend Analysis
  • Time Analysis
  • Comparison Analysis

Week 8

  • Interactive Dashboards
  • Dashboard Reporting
  • Build a KPI Dashboard
  • Protecting and Sharing your Dashboard
  • Linking your Dashboard to Power Point

Pricing Details

 

Online Banking details will be shared by our representatives after you reserve your seat

  • Actual Training Price
    • PKR 30,000 Per Person
    • Total Charges for the Training
    • Book a Seat

Reserve your Seat

You can reserve your seat  by filling the form below!

     

     

    Frequently Asked Questions

    Who should attend the course?

      • Recent graduates, third year and final year students of any degree
      • Professionals from any domain who want to learn Excel tool to create effective reports and spreadsheets for work assistance
      • Executives and Department Heads who want to gain better understanding of MS Excel.

    Who is the Instructor?

    What is the timing of the course?

    Duration: 8 weeks

    Class Days: Saturday & Sunday

    Timings: 11:00 AM to 04:00 PM

    Can I get a job after this course?

    Since our instructors are industry experts so they do train the students about practical world and also recommend the shinning students in industry for relevant positions.

    Can I rejoin this training/workshop?

    Yes, you can rejoin the training within the span of an year of your registration. Please note following conditions in case you’re rejoining.
    1) There are only 5 seats specified for rejoiners in each iteration.
    2) These seats will be served on first come first basis.
    3) If you have not submitted your complete fee, you may not be able to rejoin. Your registration would be canceled.

    What if I miss any of the lectures?

    Don’t worry! We have got you covered. You shall be shared recorded lectures after each session, in case you want to revise your concepts or miss the lecture due to some personal or professional commitment.

    How much hands-on will be performed in this course?

    Since our trainings are led by Industry Experts so it is made sure that content covered in workshop is designed with hand on knowledge of more than 70-75 % along with supporting theory.

    What are the PC requirements?

    For this professional workshop, you need to have a PC with minimum 4GB RAM and ideally 8GB RAM.

    Will I get a certificate after this course?

    Yes, you will be awarded with a course completion certificate by Dice Analytics. We also keenly conduct an annual convocation for the appreciation and recognition of our students.

    \