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

Evaluation of Digital Health Interventions (Coursera) Coursera
Imperial College London

Evaluation of Digital Health Interventions (Coursera)

Health & Society

This course focuses on data, evaluation methods and the economic evaluation of digital health interventions. This module focuses on key data considerations for digital health including data management, data visualisation and methods for evaluating digital health interventions. The key focus is on experimental and quasi-experimental design approaches that can be applied to evaluating digital health interventions and key considerations for the economic evaluation of digital health interventions.

Sep 14th 2026
4 Weeks
Health Healthcare Data Management
Details
Data Modeling and Applications (Coursera) Coursera
Illinois Tech

Data Modeling and Applications (Coursera)

CS: Software Engineering

This course introduces the student to the use of a database management system to provide the software and database necessary to upgrade a DBMS system. Database structures, applications, network, relational and hierarchical data models, applicate programs development, query systems, file security, and the role of the database administrator will be studied. A course fee may apply.

Sep 28th 2026
5-12 Weeks
SQL Data Modeling Database Management
Details
Introduction to Structured Query Language (SQL) (Coursera) Coursera
University of Michigan

Introduction to Structured Query Language (SQL) (Coursera)

CS: Software Engineering CS: Programming

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Sep 14th 2026
4 Weeks
SQL PHP MySQL
Details
Tools for Exploratory Data Analysis in Business (Coursera) Coursera
University of Illinois at Urbana-Champaign

Tools for Exploratory Data Analysis in Business (Coursera)

Statistics & Data Analysis Data Science

This course introduces several tools for processing business data to obtain actionable insight. The most important tool is the mind of the data analyst. Accordingly, in this course, you will explore what it means to have an analytic mindset. You will also practice identifying business problems that can be answered using data analytics. You will then be introduced to various software platforms to extract, transform, and load (ETL) data into tools for conducting exploratory data analytics (EDA). Specifically, you will practice using PowerBI, Alteryx, and RStudio to for conducting the ETL and EDA processes.

Sep 14th 2026
4 Weeks
Business Data Analysis Exploratory Data Analysis
Details
Health Informatics for Healthcare Professionals (Coursera) Coursera
Northeastern University

Health Informatics for Healthcare Professionals (Coursera)

Health & Society CS: Information & Technology

This course is best suited for individuals currently in the healthcare sector, as a provider, payer, or administrator. Individuals pursuing a career change to the healthcare sector may also be interested in this course. In this course, you will have an opportunity to explore concepts and topics related to the design and management of health information systems.

Sep 28th 2026
4 Weeks
Healthcare Data Management Digital Transformation
Details
DataOps Methodology (Coursera) Coursera
IBM

DataOps Methodology (Coursera)

Statistics & Data Analysis Data Science

DataOps is defined by Gartner as "a collaborative data management practice focused on improving the communication, integration and automation of data flows between data managers and consumers across an organization. Much like DevOps, DataOps is not a rigid dogma, but a principles-based practice influencing how data can be provided and updated to meet the need of the organization’s data consumers.”

Sep 14th 2026
5-12 Weeks
Data Management KPIs Key Performance Indicators
Details
Integración y preparación de datos (Coursera) Coursera
Universidad de los Andes

Integración y preparación de datos (Coursera)

Statistics & Data Analysis Data Science

El manejo de datos que permita generar conocimiento útil para una organización es cada vez más importante en los trabajos de alta demanda al día de hoy. Es así como este curso presenta al estudiante una metodología para el desarrollo de proyectos basados en datos, en especial de ciencia de datos. Hace énfasis en los procesos de exploración, transformación, integración de fuentes de datos estructuradas y no estructuradas con el fin de mejorar la eficiencia y calidad en los resultados de análisis posteriores como los basados en modelos analíticos.

Sep 14th 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.

Sep 28th 2026
5-12 Weeks
Programming Mobile Interface
Details
Managing Big Data in Clusters and Cloud Storage (Coursera) Coursera
Cloudera

Managing Big Data in Clusters and Cloud Storage (Coursera)

Statistics & Data Analysis Data Science

In this course, you'll learn how to manage big datasets, how to load them into clusters and cloud storage, and how to apply structure to the data so that you can run queries on it using distributed SQL engines like Apache Hive and Apache Impala. You’ll learn how to choose the right data types, storage systems, and file formats based on which tools you’ll use and what performance you need.

Sep 14th 2026
5-12 Weeks
SQL Big Data Data Management
Details
Salesforce Basics (Coursera) Coursera
University of California, Irvine

Salesforce Basics (Coursera)

Business

In this course, you will learn about what the world’s number one Customer Relationship Manager (CRM) system has to offer. You will begin this course by understanding the components that Salesforce leverages to make it an optimal system. You will learn about the basics in Lightning for Sales, Community Cloud and Marketing, and understanding how to secure your Salesforce Organization and Manage Permissions. These tools will serve as building blocks to implementing Salesforce into any organization. The course includes in-depth readings and practical application activities within Salesforce's Trailhead education platform, peer discussion opportunities, demonstration videos, and peer review assignments.

Sep 14th 2026
3 Weeks
Business Data Management Cloud Computing
Details