Live BootCamp

Next Cohort

May 25, 2024

Duration

18 Weeks

Application closes on May 18

Build real-world, job-ready skills

Our curriculum is challenging and it is designed to equip you with the in-demand skills you need to grow and succeed as a Data Professional.

How you will learn

Live instructor-led sessions

Engage in dynamic and interactive live sessions led by industry experts.

You'll have the opportunities to ask questions and participate in discussions, making the learning experience engaging and fulfilling.

Self-paced courses

Our comprehensive self-paced courses empower you to learn at your own convenience.

Access high-quality pre-recorded lectures, interactive exercises, and downloadable resources that allow you to study at your preferred pace.

Virtual internship

Gain practical experience through virtual internships with renowned companies in your chosen field.

Apply your newfound knowledge to real-world projects, solving industry challenges, and building your professional portfolio.

Microsoft Excel for Analytics and Reporting

This course will teach you the fundamentals of data analytics and reporting using Microsoft Excel. You will learn how to clean and prepare data for analysis, use basic and advanced Excel functions and formulas, create pivot tables and charts, and analyze data with multiple data sources.

You will also learn how to create and manage data models using Power Pivot.

Introduction to Business Intelligence and Data Analytics

• Data analytics and Business Intelligence
• Becoming a BI and Data Analyst - Skills required
  

Microsoft Excel fundamentals

• Working with sheets and workbooks
  
• Excel formulas and functions

Advanced Excel formulas and Functions

• Using Defined names
  
• Dynamic Arrays
  

Analyzing Data with PivotTables and Charts

• Analyzing data with PivotTables and charts
  
• Slicers and Timelines

Introduction to Power Query

• Working with External Data sources such as Databases, folders, PDF etc
  

Cleaning and transforming Data

• Data transformation
  
• Merging and appending data
• Grouping and summarizing data

Data Modeling and Power Pivot

• Introduction to Data Modeling
  
• Dimensions and fact tables
  
• Primary and foreign keys
  
• Creating and managing relationships
  

Analyzing Data with DAX

• Analyzing Data with PivotTables with multiple tables
  

Designing automated reports and dashboards

Data Analytics and Reporting using Microsoft Power BI

This course will teach you how to use Power BI to visualize and report on data. You will learn how to prepare data for analysis, import data into Power BI, create data models, and create reports and dashboards.

You will also learn how to use Power BI to create data-driven stories.

Get started with Microsoft data analytics

• Getting started with Power BI
  

Importing Data into Power BI

• Work with external data sources such databases, excel workbooks, PDFs, Folder.
  

Cleaning and transforming Data

• Basic Data transformation
  
• Merging and appending data
• Grouping and summarize data

Modeling data in Power BI

• Design a data model in Power BI
  
• Schemas: Star and snowflake schemas
  
• Manage Relationships
  
• Cardinality and Cross Filter Direction
  

Analyzing Data with DAX

• DAX Functions
  
• Calculated Columns and Calculated Tables
  
• Aggregate functions and iterators
• Time Intelligence calculations
  

Visualize data in Power BI

• Work with Power BI visuals
  
• Improving users experience with Bookmarks, tooltips, drillthroughs and buttons
  
• Create a data-driven story with Power BI reports
  
• Creating reports and dashboards in Power BI
  

Sharing and consuming Power BI Reports

• Sharing reports on Microsoft Teams
  
• Generating Power BI reports as PowerPoint slides for presentations
  
• Sharing report on the web
  
• Embedding reports on websites
  

SQL for Analytics and Reporting

This course will teach you data analytics and reporting using SQL (Structured Query Language), the language used to communicate with databases. You will learn how to create and manage databases, select, insert, update, and delete data, group and filter data, and use joins and subqueries.

You will also learn how to use SQL functions and window functions.

Introduction to Databases, SQL, and Microsoft SQL Server

• Installing SSMS and Azure Data Studio
• SQL constraints
• Creating Databases and Tables
• Updating and managing databases

Data manipulation language

• Extracting data with SELECT
  
• Extracting data with conditions

Introduction to Aggregate functions

• Summarizing and aggregating data with aggregate functions
  

Grouping and Filtering Data

• GROUP BY with one column
• GROUP BY with multiple columns
• HAVING CLAUSE

Case Statement

• Creating conditional statements with CASE
  

SQL Joins

• Analyzing data from multiple tables with Joins
• Type of SQL Joins

Mastering SQL order of execution

Creating complext queries with Subqueries

Creating SQL Views

Working with SQL Advanced Functions

Working with Window functions

• Partitioning data
  
• Ranking data with RowNum, Rank and DENSE Rank
• Time intelligence with LAG and LEAD

Generative AI for Data Analysts

This course explains the techniques, approaches, and best practices for writing effective prompts.

You will learn about prompt techniques like zero-shot and few-shot, which can improve the reliability and quality of large language models (LLMs).You will also explore various prompt engineering approaches like Interview Pattern, Chain-of-Thought, and Tree-of-Thought, which aim at generating precise and relevant responses

Introduction to Generative AI

• Introduction and Capabilities of Generative AI 
• Applications and Tools of Generative AI 
• Applications of Generative AI
• Tools of Text Generation
  
• Tools for Image Generation
  
• Tools for Audio and video generation
  

Prompt Engineering

• Introduction to Prompt Engineering
  
• Techniques and Approaches for Writing Effective Prompts
  

Generative AI for Data Analytics

• Generative AI Tools for Data Analytics
  
• Examples of Generative AI in Data Analytics
  
• Generative AI for Data Generation and Augmentation
  
• Generative AI for Data Preparation
  
• Generative AI for Querying Databases
  
• Generative AI for Data Insights
  
• Generative AI for Data Visualization
  
• Generative AI for Creating Dashboards
  
• Generative AI for slides and presentations