Coursera

Data Connection and Functionalities in Power BI (Coursera)

Offered by Edureka,
Data Connection and Functionalities in Power BI (Coursera)

Welcome to the course on Data Connection and Functionalities in Power BI. This course is strategically crafted to empower you with the skills needed to construct a robust database and efficiently manage intricate datasets using MS SQL Server. Throughout this course, you will acquire the expertise to develop well-formatted database that are seamlessly designed to integrate with Power BI.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

During this course, you will explore the industry-specific applications of Power BI and MS SQL Server. By the end of this course, you will be able to:

  1. Attain expertise in SQL for proficient data administration within SQL Server.
  2. Employ SQL's capacities in orchestrating data to meet the data processing needs of Power BI.
  3. Visualize the data from the SQL server to connect it to Power BI
  4. Strategies for enhancing data retrieval speed aligned with Power BI
  5. Construct DirectQuery connection with Power BI
  6. Implement M-functions for data modeling.

This long course is designed for Data Analyst, Data Engineer, Data Administrator, and Business Analyst seeking to enhance their analytical and design skills.
Prior experience with MS Excel and RDBMS is beneficial but not mandatory for this course.
Join us on this journey to enhance your Power BI and MS SQL Server skills and elevate your analytical and design capabilities.
This course is part of the Mastering Power BI for Data Analytics & Storytelling Specialization.

What you'll learn
Working with MS SQL Server and data connectivity with Power BI to visualize datasets.

Syllabus

Introduction to MS SQL Server
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.

Working with Advanced SQL
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.

Data Connectivity with Power BI
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.

Course Wrap-Up and Assessment
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.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Introduction to the Tidyverse (Coursera) Coursera
Johns Hopkins University

Introduction to the Tidyverse (Coursera)

Statistics & Data Analysis Data Science

This course introduces a powerful set of data science tools known as the Tidyverse. The Tidyverse has revolutionized the way in which data scientists do almost every aspect of their job. We will cover the simple idea of "tidy data" and how this idea serves to organize data for analysis and modeling. We will also cover how non-tidy can be transformed to tidy data, the data science project life cycle, and the ecosystem of Tidyverse R packages that can be used to execute a data science project.

Jul 27th 2026
4 Weeks
Data Management Data Analysis Data Science
Details
Programming Mobile Applications for Android Handheld Systems: Part 2 (Coursera) Coursera
University of Maryland, College Park

Programming Mobile Applications for Android Handheld Systems: Part 2 (Coursera)

CS: Software Engineering CS: Programming

This course introduces you to the design and implementation of Android applications for mobile devices. You will build upon concepts from the prior course, including handling notifications, using multimedia and graphics and incorporating touch and gestures into your apps.

Aug 3rd 2026
5-12 Weeks
Programming Mobile Interface
Details
Privacy Law and Data Protection (Coursera) Coursera
University of Pennsylvania

Privacy Law and Data Protection (Coursera)

Business

What does it take to comply with privacy laws? In this course, we’ll look at the practical aspects of navigating the complex landscape of privacy requirements. Better understanding privacy laws and data protection will enable you to protect your organization and the constituents that depend on your organization to safeguard their personal information.

Jul 27th 2026
4 Weeks
Security Data Management Risk Management
Details
Database Management Essentials (Coursera) Coursera
University of Colorado System

Database Management Essentials (Coursera)

CS: Software Engineering

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy.

Jul 27th 2026
5-12 Weeks
SQL MySQL Business Intelligence
Details
Player Evaluation, Team Performance and Roster Management (Coursera) Coursera
The State University of New York

Player Evaluation, Team Performance and Roster Management (Coursera)

Management & Leadership

This course will provide students with an introduction to using specific data techniques to address key sports administrative functions in team and roster management. The primary focus is on the use of data analysis in player acquisition and retention, as well as player and coach assessment. Students will learn how the collective bargaining agreement (CBA) and standard player contract (SPC) provide the framework for management decisions in which data analysis play a pivotal role.

Jul 27th 2026
5-12 Weeks
Data Management Contract Management Operations Management
Details
Getting Started with Data Visualization in R (Coursera) Coursera
Johns Hopkins University

Getting Started with Data Visualization in R (Coursera)

Statistics & Data Analysis Data Science

Data visualization is a critical skill for anyone that routinely using quantitative data in his or her work - which is to say that data visualization is a tool that almost every worker needs today. One of the critical tools for data visualization today is the R statistical programming language. Especially in conjunction with the tidyverse software packages, R has become an extremely powerful and flexible platform for making figures, tables, and reproducible reports. However, R can be intimidating for first time users, and there are so many resources online that it can be difficult to sort through without guidance.

Jul 27th 2026
3 Weeks
Data Software Data Management
Details
The Nature of Data and Relational Database Design (Coursera) Coursera
University of California, Irvine

The Nature of Data and Relational Database Design (Coursera)

CS: Information & Technology

This course provides a comprehensive overview of data, various data types, design of databases for storage of data, and creation and manipulation of data in databases using SQL. By the end of this course, students will be able to describe what business intelligence is and how it’s different from business analytics and data science, conduct a basic descriptive statistical analysis and articulate the findings, and differentiate between types of statistics. They will also be able to define normalization and ETL, create an ERD that shows progression from conceptual to logical to physical design, define DDL, DML, DCL, and TCL, and write SQL scripts to create a database and associated tables.

Jul 27th 2026
4 Weeks
Databases SQL Descriptive Statistics
Details
Preparing Data for Analysis with Microsoft Excel (Coursera) Coursera
Microsoft

Preparing Data for Analysis with Microsoft Excel (Coursera)

Statistics & Data Analysis Data Science

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis. 

Jul 27th 2026
4 Weeks
Excel Data Analysis Microsoft Excel
Details
Data Management and Sharing for NIH Proposals (Coursera) Coursera
Fred Hutchinson Cancer Center

Data Management and Sharing for NIH Proposals (Coursera)

Health & Society

The National Institutes of Health (NIH) has a new policy for the management and sharing of scientific data starting for (most) grants submitted January 25, 2023 or later. In this course we will describe what the new policy requires, places where you might want to share your particular kind of data, and how to deal with possible challenges associated with the policy.

Aug 3rd 2026
3 Weeks
Health Data Management Grant Writing
Details
Introducción a la Minería de Datos (Coursera) Coursera
Pontificia Universidad Católica de Chile

Introducción a la Minería de Datos (Coursera)

CS: Information & Technology

En este curso, aprenderás de manera gradual y práctica los conceptos básicos de Minería de Datos, junto a los algoritmos más utilizados hoy en día. Al finalizar el curso, serás capaz de entender la importancia de manejar la información y de explorar por ti mismo distintas bases de datos reales. Este curso es el primer paso para convertirte en un/a profesional con habilidades básicas de un científico de datos o Data Scientist, de manera tal que puedas abrirle la puerta al futuro.

Aug 10th 2026
5-12 Weeks
Algorithms Clustering Data Management
Details