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

From Excel to Power BI (Coursera) Coursera
Knowledge Accelerators

From Excel to Power BI (Coursera)

CS: Information & Technology

Are you using Excel to manage, analyze, and visualize your data? Would you like to do more? Perhaps you've considered Power BI as an alternative, but have been intimidated by the idea of working in an advanced environment. The fact is, many of the same tools and mechanisms exist across both these Microsoft products. This means Excel users are actually uniquely positioned to transition to data modeling and visualization in Power BI! Using methods that will feel familiar, you can learn to use Power BI to make data-driven business decisions using large volumes of data.

Aug 10th 2026
1 Week
Excel Data Analysis Microsoft Excel
Details
Making the Case for Robotic Process Automation (Coursera) Coursera
Association of International Certified Professional Accountants - AICPA

Making the Case for Robotic Process Automation (Coursera)

CS: Information & Technology

Robotic Process Automation (RPA) is reshaping the accounting and finance profession. 40% of transactional accounting work is expected to be automated by 2020 and predicted to touch 230 million knowledge workers, 9% of the global workforce, according to McKinsey Research. Driven by the need to stay competitive, decrease costs and increase efficiency, RPA is quickly making a significant impact on the profession. Companies no longer think about "if" but "when" to implement RPA.

Aug 10th 2026
2 Weeks
Data Management Accounting Information Technology
Details
Everyday Excel, Part 3 (Projects) (Coursera) Coursera
University of Colorado Boulder

Everyday Excel, Part 3 (Projects) (Coursera)

Computer Science

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, [Parts 1](https://www.mooc-list.com/course/everyday-excel-part-1-coursera) and [Parts 2](https://www.mooc-list.com/course/everyday-excel-part-2-coursera)". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways). Each learner must complete two easy projects (chosen from four), two intermediate projects (chosen from 4), and three main (more difficult) projects (chosen from 7).

Jul 27th 2026
5-12 Weeks
Computing Algorithms Spreadsheets
Details
Clinical Trials Data Management and Quality Assurance (Coursera) Coursera
Johns Hopkins University

Clinical Trials Data Management and Quality Assurance (Coursera)

Health & Society

In this course, you’ll learn to collect and care for the data gathered during your trial and how to prevent mistakes and errors through quality assurance practices. Clinical trials generate an enormous amount of data, so you and your team must plan carefully by choosing the right collection instruments, systems, and measures to protect the integrity of your trial data. You’ll learn how to assemble, clean, and de-identify your datasets.

Jul 27th 2026
4 Weeks
Data Management Clinical Trials Statistical Analysis
Details
Data intelligence for businesses and managers (Coursera) Coursera
Institut Mines-Telecom

Data intelligence for businesses and managers (Coursera)

Statistics & Data Analysis Data Science

With the proliferation of connected objects (computers, tablets, watches, etc.), huge masses of data are generated every second. This Big Data has led to the emergence of a data economy, where data is the main source of competitive advantage for companies. In this sense, data and its processing tools have become a strategic priority for companies, and the main gas pedal of their digital transformation.

Aug 10th 2026
5-12 Weeks
Artificial Intelligence Data Management Business Strategy
Details
CompTIA a+ Network (Coursera) Coursera
CompTIA

CompTIA a+ Network (Coursera)

Security & Networking

Explore the dynamic world of network systems with the CompTIA a+ Network course. This complete networking course is explicitly designed for beginners and will equip you with foundational knowledge and hands-on skills in network installation, network support and application support. Today, network technicians are in-demand and job opportunities are plenty.

Aug 3rd 2026
5-12 Weeks
Network Scripting Data Management
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
The ABC's of GDPR: Protecting Privacy in an Online World (Coursera) Coursera
Knowledge Accelerators

The ABC's of GDPR: Protecting Privacy in an Online World (Coursera)

Business

This course is aimed at business professionals, web designers, and other interested professionals who collect, process, use, or otherwise encounter personal data subject to the European Union's General Data Protection Regulation. By the end of this course, learners will be familiar with roles involved in assuring compliance with GDPR standards, the rights of GDPR data subjects, responsibilities of organizations regarding GDPR and the consequences for failure to comply.

Aug 10th 2026
1 Week
Data Management Privacy Data Privacy
Details
Security for Artificial Intelligence Software and Services (Coursera) Coursera
Board Infinity

Security for Artificial Intelligence Software and Services (Coursera)

Data Science

The "Security Basics for Artificial Intelligence Software and Services" course provides an in-depth exploration of security measures and best practices in the context of AI. Spanning two comprehensive modules, the course begins with an introduction to the fundamentals of AI security, including ethical considerations and common threats. It then progresses to practical strategies for implementing robust security in AI development, such as secure coding, vulnerability assessment, and adherence to compliance standards.

Aug 3rd 2026
2 Weeks
Artificial Intelligence Security Encryption
Details