Phone: +1 (945) 900-6161
Email: arjun@abhitrainings.com

I. Introduction to Databases and SQL

1. Understanding Databases

What is a database?

Types of databases(Relational, NoSQL, etc.)

Database Management Systems (DBMS)

2. Introduction to SQL

What is SQL?

SQL as a language for relational databases

Importance and applicationsof SQL

3. MySQL Installation and Setup

Installing MySQL server andclient

Configuring MySQL server

MySQL command-line client and GUI tools

I. Introduction to Power BI

1. Understanding Business Intelligence (BI) and its importance

What is BI and why is it crucial for organizations?

The BI process (data collection, data modeling, data visualization, and sharing insights)

2. Overview of Power BI and its components

Power BI Desktop, Power BI Service, and Power BI Mobile

Power BI architecture and ecosystem

3. Setting up Power BI Desktop and licensing

II. SQL Basics

1. SQL Syntax and Structure

SQL statements and clauses

SQL keywords and identifiers

Comments and indentation

2. Creating and Managing Databases

Creating a new database

Dropping (deleting) a database

Accessing and using databases

3. Data Types

Numeric data types (INT, FLOAT, DECIMAL, etc.)

Character data types (CHAR, VARCHAR, TEXT, etc.)

Date and Time data types (DATE, TIME, DATETIME, etc.)

Other data types (BOOLEAN, ENUM, etc.)

II. Data Sources and Connections

1. Importing data from various sources

Excel workbooks (Excel files, CSV, Text files)

Databases (SQL Server, Oracle, MySQL, PostgreSQL, etc.)

Web sources (Web APIs, JSON, XML, etc.)

1. Creating Tables

Defining table structure (columns and data types)

Primary keys and unique constraints

Default values and autoincrement

2. Altering Tables

Adding, modifying, and dropping columns

Changing column data types and constraints

3. Dropping Tables

Deleting tables from the database

III. Data Transformation and Power Query Editor

1. Introduction to Power Query Editor

2. Applying transformations to data

Removing duplicates, handling null values

Data formatting (splitting, merging, changing data types, etc.)

Creating custom columns and measures

3. Advanced transformations

Unpivoting and pivoting data

Merging and appending queries

Working with functions and parameterized queries

4. Optimizing queries and performance tuning

IV. Data Manipulation

1. Inserting Data

INSERT INTO statement

Inserting single and multiple rows

2. Updating Data

UPDATE statement

Updating single and multiple rows

Updating with conditions and joins

3. Deleting Data

DELETE statement

Deleting single and multiple rows

Deleting with conditions and joins

Truncating tables

IV. Data Modeling

1. Understanding star schema and dimensional modeling

2. Creating relationships between tables

Cardinality (one-to-one, oneto-many, many-to-many)

Cross-filter direction and relationship behavior

3. Working with calculated columns and measures

Introduction to Data Analysis Expressions (DAX)

Basic DAX functions (SUM, COUNT, AVERAGE, etc.)

Calculated columns vs. measures

4. Implementing time intelligence

Working with date and time functions

Creating date hierarchies and calendar tables

5. Optimizing data models and performance tuning

V. Querying Data

1. SELECT Statement

Selecting columns and expressions

Aliases for columns and tables

Filtering data with WHERE clause

2. Sorting and Limiting Results

ORDER BY clause (ascending and descending order)

LIMIT and OFFSET clauses

3. Aggregate Functions

COUNT, SUM, AVG, MIN, MAX

GROUP BY clause and grouping data

HAVING clause for filtering groups

4. Joining Tables

Inner joins (INNER JOIN, JOIN)

Outer joins (LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN)

Cross joins (CROSS JOIN)

Self-joins

5. Subqueries and Derived Tables

Subqueries in SELECT, FROM, WHERE, and other clauses

Derived tables and common table expressions (CTEs)

6. Union and Intersection Operations

UNION and UNION ALL

INTERSECT and EXCEPT/MINUS

V. Data Visualization

1. Understanding different chart types and when to use them

Column, bar, line, area, pie, scatter, and more

Matrix, table, and card visualizations

Maps and geographic visualizations

2. Creating and customizing visualizations

Formatting options (colors, axes, labels, etc.)

Adding interactions and filters

Applying conditional formatting and data bars

3. Creating and customizing reports

Page layout and design

Adding bookmarks, buttons, and navigation

Applying report themes and branding

4. Creating dashboards

Configuring dashboard layout and design

Adding interactive elements (slicers, filters, etc.)

VI. Projects and Case Studies

1. Hands-on projects covering various domains

E-commerce database (products, orders, customers, etc.)

Human resources database (employees, departments, salaries, etc.)

Banking and finance database (accounts, transactions, loans, etc.)

Social media database (users, posts, comments, likes, etc.)

VI. Projects and Case Studies

1. Hands-on projects and case studies covering various business scenarios

Financial reporting and analysis

Operations and supply chain analytics

Human resources and workforce analytics

2. Building end-to-end Power BI solutions

Creating reports, dashboards, and interactive visualizations

Publishing and sharing insights

3. Presenting and communicating insights effectively

 

Enquiry form

    

Can't read the image? click here to refresh.