SQL Server, Power BI & Power Apps

1. Introduction to SQL Server Database

• What is SQL Server?
• Key Features and Components
• Installation and Configuration

2. Understanding Database Concepts

• What is a Database?
• Relational vs NoSQL Databases
• Overview of DBMS

3. Connecting to SQL Server

• SQL Server Management Studio (SSMS)
• Connecting via SSMS
• Using Object Explorer, Query Window, Tools

4. SQL Query Language

• Data Definition Language (DDL)
• Data Manipulation Language (DML)
• Data Query Language (DQL)

5. Joins and Relationships

• Relational Database Design
• INNER, LEFT, RIGHT, FULL, CROSS Joins

6. Views

• Creating, Altering, Dropping Views

7. Aggregate & Window Functions

• COUNT(), SUM(), AVG(), MIN(), MAX()
• GROUP BY & HAVING
• Grouping Sets
• Roll Up & Cube
• Combining Aggregates with Joins

8. Clauses and Filtering

• WHERE Clause
• ORDER BY for Sorting
• LIKE, IN, BETWEEN, IS NULL
• CASE Statements (Conditionals)
• DISTINCT Keyword

9. Stored Procedures

• Creating and Managing Procedures
• Input/Output Parameters
• Modifying and Dropping Procedures
• Error Handling with TRY…CATCH

10. Introduction to Power BI & Data Analytics

• What is Power BI and Why Use It?
• Connecting Power BI to SQL Server
• Import vs Direct Query
• Creating Visuals
• Building Dashboards and Reports
• Building Power BI Apps
• Publishing Reports to Power BI Service

11. Power APPs

• Getting Started with Power Apps
• Types of Power Apps ( Canvas Vs Model-driven vs Portals )
• DataSources & Connectors
• Working with Dataverse
• Deployment & Sharing
• Capstone use case: Inventory Management

12. Optional Advanced Concepts

( * Concepts wise separate Fee; not included in the course )

• Row Level Security
• Incremental Refresh and Realtime Data for semantic models
• Power BI Embedded
• Streaming Analytics

13. Optional Live Project: Ecommerce Analytics

( * Separate Fee; not included in the course )

• Step into the world of real-time data with this hands-on project focused on developing Power BI reports, dashboards, and Power BI Apps for a full-scale e-commerce platform. This project is designed to give you end-to-end exposure to analytics across every stage of the customer journey and operational workflow.
• You'll gain practical experience in capturing and visualizing critical metrics, helping online businesses make smarter decisions, improve customer experiences, and boost revenue. The project begins by tracking visitor sessions and product views, and moves into analyzing key behaviors such as add-to-cart actions and checkout flows. You'll dive deep into payment success rates and customer acquisition channels, helping pinpoint conversion barriers.
• Operational insights will also be part of the solution, with dashboards for order fulfillment performance, returns and refunds, inventory movement, and overall revenue and profitability. By the end of the project, you'll have built a robust analytics suite that empowers stakeholders to monitor real-time performance and make data-driven improvements across the e-commerce value chain.
• Key analytics you will work on include:
  Sessions, Product Views, Add to Cart Events, Checkout Funnel, Payment Success Rate,
  Customer Acquisition, Order Fulfillment, Return & Refund Trends, Inventory Turnover
  Revenue & Profitability.