PKR. 50,000 Reserve Seat

Data Analysis using Advance Excel and SQL Training

PKR. 50,000

Batch Ending in

3,312+ ratings
Learn how to effectively analyze data using advanced Excel and SQL.
Start Date
Nov 25, 2023
End Date
Jan 14, 2024
Timing
09:45 AM-03:00 PM
Location
Online
Type
Instructor Led
Duration
80 Hours
training image

Overview

Learn the essentials of data analysis using Advance Excel and SQL in our 8-weeks live training. 

This 8-weeks training on data analysis using Advance Excel and SQL will equip you with the necessary skills to analyze data and make informed decisions. You will learn to use Excel and SQL to create powerful data visualizations, analyze data and create meaningful insights using pivot tables and advanced formulas.

By the end of this training, you will be able to use advanced formulas and functions to manipulate data in Excel, create meaningful data visualizations, analyze and interpret data to identify patterns and trends, master the use of pivot tables, write and execute SQL queries to filter and join data from multiple tables, use SQL to build reports and dashboards to visualize data and utilize data to gain insights and make data-driven decisions. This training is suitable for beginners and advanced users who want to improve their data analysis skills. 

Tools Covered

  • Understand the fundamentals of data analysis and data manipulation using Excel and SQL.
  • Learn to use basic formulas and functions in Excel.
  • Develop an understanding of SQL queries and how to use them to manipulate data.
  • Learn how to use PivotTables, charts, and other visualization techniques to effectively analyze data.
  • Understand the principles of data modeling and how to apply them to construct relational databases.
  • Learn how to use SQL to query and join multiple tables.
  • Develop an understanding of how to use Excel and SQL together to perform advanced data analysis.
  • Explore data mining techniques and how to use them to uncover patterns and trends.
  • Understand the principles of data visualization and how to use them to communicate complex data.
  • Develop proficiency in managing and analyzing large data sets.

  • Degree Levels: Academy Profession,Associate Degree,Bachelor's,Master
  • Field of Studies: Data Analytics,databases
  • Prior Job Experience: Not Required
  • Other Programs: Data Engineering using SQL Server Tools Training

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

Meet the Instructor

Fahad Jamshed

Data Analyst | Data Engineer | IT Expert | Fintech | DWH

Fahad Jamshed

Data Analyst | Data Engineer | IT Expert | Fintech | DWH


IT and Fintech Professional with 7 years of experience in IT & Banking industry with focus on Data Development, Data warehouse, Business Intelligence & Analytics Expertise: DWH & Business Intelligence, Modeling, Data Analytics, Business reporting and analysis, Data Modeling and Visualization. Tools: IBM COGNOS, Teradata RDBMS (Teradata SQL Assistant/TPT Utilities), Tableau, Power BI, SQL


Course Outline

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

  • 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

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

  • Microsoft PowerPoint 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 Line Spacing
  • Adding and Formatting Pictures
  • Adding Videos in Slide Deck
  • Adding Shapes and 3D Diagrams
  • Using Slides Templates
  • Animating Objects in Power Point
  • Insert Tables
  • Insert Charts
  • Shortcuts in Power Point

  • 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/Truncate Table
  • Drop Table/Database
  • Primary Key & Foreign Key Concept

  • Basics of ERD Diagrams
  • Group By Clause
  • 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

  • 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

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

Our Methodology

Industry Usecases

With real world projects and immersive content built in partnership with top tier companies, you’ll master the tech skills companies want.

Technical Support

Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track.

Career Mentorship

You’ll have access to resume support, portfolio review and optimization to help you advance your career and land a high-paying role.

Certificate

Testimonials

Fayaz Ahmed
Fayaz Ahmed
Business Intelligence Professional

Dice Camp's Data Analysis course exceeded my expectations. The structured curriculum, expert instructors, and hands-on learning, led by Sir Fahad, provided a solid foundation in Advanced Excel and SQL. Sir Fahad's real-world insights made complex topics accessible. This training added significant value to my career. Highly recommended for anyone aiming to elevate their data analysis skills.

Amna Tahir
Amna Tahir
Data Analyst

I enrolled in the Data Analysis using advanced Excel and SQL course at Dice Camp right after graduation, seeking to stand out in a competitive job market. The course not only equipped me with the technical skills but also provided valuable insights into industry best practices. Thanks to Dice Camp, I secured a data analyst position within weeks of completing the training

Rimsha Aly
Rimsha Aly
IT Consultant

As an IT professional, Dice Camp's Data Analysis course was the perfect catalyst for enhancing my analytical skills. The practical examples and industry projects allowed immediate application of newfound skills, making the investment truly worthwhile. Special thanks to Sir Fahad for his insightful guidance and expertise, and to Huzaifa, the training assistant, for seamless support. Grateful for Dice Camp's exceptional team for a rewarding learning experience.

Hamna Akhter
Hamna Akhter
Recent Graduate

I enrolled in Dice Camp's Data Analysis course in the year 2021 immediately after graduation, determined to stand out in a competitive job market. The course went beyond just teaching technical skills; it provided practical insights into industry best practices. Thanks to Dice Camp, I was able to directly apply what I learned, and within weeks of completing the training, I secured a data analyst position. The real-world applicability of the course content made all the difference in launching my career successfully!

Abdullah Awan
Abdullah Awan
Finance Manager

The Data Analysis training at Dice Camp was a game-changer for me. The instructors seamlessly combined theoretical knowledge with practical applications using Advanced Excel and SQL. The weekend schedule worked well with my busy work life, and I can already see the positive impact on my data-driven decision-making processes.

Video Reviews

Frequently Asked Questions

  • 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.

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.

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.

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.

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.

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

Yes! You will be awarded with a course completion certificate by Dice Analytics.
So, what's your plan?

Follow the footsteps of thousands of successful alumni...

Reserve Seat
svg img
Reserve Seat