Data Connection and Functionalities in Power BI

This course is part of Mastering Power BI for Data Analytics & Storytelling Specialization

Instructor: Edureka

Access provided by Kalinga Institute of Industrial Technology

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Understand MS SQL Server basics and apply SQL queries for data preparation.
Work with advanced SQL commands to design normalized and reliable databases.
Connect Power BI to SQL Server and external data sources for analytics.
Apply enterprise-level practices for secure, scalable, and compliant data integration.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Mastering Power BI for Data Analytics & Storytelling Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 4 modules in this course

This course focuses on building a solid foundation in connecting and managing data using MS SQL Server and Power BI. Learners will gain practical knowledge of how to structure, format, and integrate databases for effective analysis and reporting in Power BI.

Key learning outcomes include: - Structuring relational databases with MS SQL Server for seamless Power BI integration - Establishing secure and optimized data connections - Managing, cleaning, and transforming datasets - Understanding query folding, DirectQuery vs. Import, and performance considerations Designed for aspiring data analysts, business intelligence professionals, and database practitioners, this course supports the development of job-ready Power BI skills focused on enterprise-scale data workflows. Basic knowledge of databases is recommended but not mandatory. Join us on this journey to enhance your Power BI and MS SQL Server skills and elevate your analytical and design capabilities.

Welcome to Data Connection and Functionalities in Power BI. In this module, we will understand the capabilities of MS SQL Server. Learn to model data with the help of ER diagrams to get a holistic view of the database that is to be designed in MS SQL Server. Improve data integrity by reducing redundancy while ensuring efficient database management by handling data with the help of SQL commands.

What's included

32 videos7 readings11 assignments1 discussion prompt

32 videos Total 118 minutes

Course Introduction 5 minutes
What is SQL? 4 minutes
Introduction to Microsoft SQL Server 4 minutes
Installation of MS SQL Server 3 minutes
SQL Server Interface - Object Explorer 7 minutes
SQL Server Interface - Basic Scripts 5 minutes
Data Modeling - ER Diagram Components 3 minutes
Data Modeling - ER Diagram Entities 3 minutes
Cardinality in ER Diagrams 3 minutes
Degrees of Relationships 4 minutes
ER Modeling Session - Building Tables 5 minutes
ER Modeling Session - Creating Diagrams 3 minutes
Operation on Keys 4 minutes
Normalization 4 minutes
Types of Normalization - 1NF 2 minutes
Types of Normalization - 2NF 1 minute
Types of Normalization - 3NF 2 minutes
Types of Normalization - 4NF 2 minutes
Types of Normalization - 5NF 4 minutes
DDL Commands 5 minutes
DQL Commands 5 minutes
DML Commands 2 minutes
DCL Commands 6 minutes
TCL Commands 4 minutes
MERGE Statement 4 minutes
ALTER Statement 3 minutes
Implementing Joins 5 minutes
Implementing Joins - Right, Full and Cross Joins 2 minutes
Implementing Restaurant Database - Creating Database 5 minutes
Implementing Restaurant Database - Commands 4 minutes
Implementing Restaurant Database - Transactions 3 minutes
Summary of MS SQL Server 2 minutes

7 readings Total 175 minutes

Welcome to Data Connection and Functionalities in Power BI 10 minutes
MS SQL Server User Guide 40 minutes
How to use Discussion Forums? 10 minutes
MS SQL Server Editions 40 minutes
Release notes for SQL Server Management Studio (SSMS) 30 minutes
Normalization 20 minutes
SQL Joins 25 minutes

11 assignments Total 55 minutes

Practice Quiz: Basics of SQL Server 2 minutes
Practice Quiz: ER Modeling 2 minutes
Practice Quiz: Data Normalization 2 minutes
Practice Quiz: SQL 2 minutes
Practice Quiz: SQL Queries and Commands 2 minutes
Knowledge Check: SQL Server 5 minutes
Knowledge Check: ER Diagrams 5 minutes
Knowledge Check: Normalization 5 minutes
Knowledge Check: SQL Commands 5 minutes
Knowledge Check: Practice Session 5 minutes
Knowledge Check: Introduction to MS SQL Server 20 minutes

1 discussion prompt Total 10 minutes

Introduce Yourself 10 minutes

In the second week of this course, Learn to use built-in functions in SQL Server to simplify functions that can be used for faster data processing. Harnessing the abilities of T-SQL to interact with and manage relational databases in various ways.

What's included

18 videos6 readings7 assignments1 discussion prompt

18 videos Total 64 minutes

What is T-SQL? 3 minutes
Aggregate Functions 2 minutes
Convenient Aggregate Functions – AVG() and MAX() 3 minutes
Convenient Aggregate Functions – MIN() and SUM() 2 minutes
Convenient Aggregate Functions – COUNT() and COUNT_BIG() 2 minutes
Statistical Aggregate Functions 4 minutes
User Defined Aggregate Functions 2 minutes
Querying using Built-in Functions 5 minutes
Composing T-SQL 4 minutes
Introduction to Sub - Queries 5 minutes
SQL Server Views - Describing Views 2 minutes
SQL Server Views Operations 3 minutes
Case Expressions 2 minutes
Stored Procedures 2 minutes
Operating Views 11 minutes
Implementing Stored Procedures 4 minutes
Executing Stored Procedures 3 minutes
Summary of Working with Advanced SQL 2 minutes

6 readings Total 200 minutes

ODBC Scalar Functions 20 minutes
T-SQL 25 minutes
SQL Functions 40 minutes
Database Functions 45 minutes
Understanding concurrency control 25 minutes
Views 45 minutes

7 assignments Total 44 minutes

Practice Quiz: SQL Functions 2 minutes
Practice Quiz: Queries and Views 2 minutes
Knowledge Check: Built-in Functions and T-SQL 5 minutes
Knowledge Check: T-SQL and Functions 5 minutes
Knowledge Check: Views and Queries in SQL 5 minutes
Knowledge Check: Practice Session on Views and Queries 5 minutes
Knowledge Check: Working with Advanced SQL 20 minutes

1 discussion prompt Total 10 minutes

Describe a scenario where views are useful? 10 minutes

In the third week of this course, Apply concepts of data management to prepare a dataset which is suitable for data visualization. Establish a stable connection with Power BI to transfer data from MS SQL Server to Power BI and visualize the data to display hidden insights.

What's included

15 videos8 readings5 assignments

15 videos Total 76 minutes

Installation of Power BI Desktop and Service 6 minutes
Problem Description 5 minutes
Inserting Data 3 minutes
Applying Data Records 1 minute
Adjusting the data 7 minutes
Performing Basic Operations 4 minutes
Connecting with Power BI 9 minutes
Visualizing the Data 7 minutes
Creating Reports 7 minutes
Formatting Dashboards 7 minutes
Gateway 2 minutes
Installing Gateway 2 minutes
M - Functions 7 minutes
Deep Dive in M - Functions 6 minutes
Summary: Data Connectivity with Power BI 5 minutes

8 readings Total 215 minutes

Requirements for Installing Power BI Desktop 10 minutes
Power BI Licenses 10 minutes
Building Block of Power BI 10 minutes
Basics of Power BI 30 minutes
Power BI Tutorial 70 minutes
Problem Statement 20 minutes
Date and Time Features 40 minutes
Overview of Power BI Service 25 minutes

5 assignments Total 25 minutes

Practice Quiz: Introduction to Power BI 3 minutes
Practice Quiz: Connecting with Power BI 2 minutes
Knowledge Check: Data Connection with Power BI 5 minutes
Knowledge Check: M - functions 5 minutes
Knowledge Check: Data Connectivity with Power BI 10 minutes

This module is designed to assess an individual on the various concepts and teachings covered in this course. Answer a comprehensive quiz which marks you as a learner who is confident in working with Power BI.