Coursera

Database Design and Operational Business Intelligence (Coursera)

Offered by Edureka,
Database Design and Operational Business Intelligence (Coursera)

Welcome to the course on Database Design and Operational Business Intelligence. This course is strategically crafted to empower you with the skills needed to design a robust database and efficiently manage intricate datasets. Throughout this course, you will acquire the expertise to develop well-formatted databases 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.

Throughout this course, you'll delve into how Power BI and MS SQL Server are applied within specific industries. By the end of this course, you will be able to:

  1. Compose different data models by re-structuring the data
  2. Interpreting Data models
  3. Create dashboards and Publish them on Service
  4. Demonstrate machine learning and advanced features in Power BI Service
  5. Analyze the scorecard and results from the binary prediction model
  6. Implement best practices for visualization

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.

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 Database Design and Operational Business Intelligence. 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.

Functions and Views
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
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

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. 

Aug 17th 2026
4 Weeks
Excel Data Analysis Microsoft Excel
Details
Introducción a Power BI para los negocios (edX) EdX
Universitat Politècnica de València,UPValenciaX

Introducción a Power BI para los negocios (edX)

Statistics & Data Analysis Computer Science

Te presentamos los componentes de Power BI, te mostramos la herramienta gratuita Power BI Desktop y te enseñamos a usarla para cargar y tratar datos de diversas fuentes, relacionar los datos importados e incorporar medidas para extraer la información importante y manejar las visualizaciones gráficas más habituales y utilizar los filtros para presentarla de la mejor manera posible.

Self Paced
Self-Paced
Power BI Visualización de Datos Negocios
Details
Data Storytelling with Power BI (Coursera) Coursera
Edureka

Data Storytelling with Power BI (Coursera)

CS: Information & Technology

Welcome to the Data Storytelling with Power BI course, where you'll embark on a journey to acquire practical expertise in data transformation and visualization. Leverage the potential of Power BI to craft narratives through structured data, leading to the discovery of more profound insights. Throughout this course, you'll explore the industry-specific applications of Power BI and delve into its various features and functionalities.

Aug 17th 2026
5-12 Weeks
Data Management Data Visualization Power BI
Details
Insights of Power BI (Coursera) Coursera
Fractal Analytics

Insights of Power BI (Coursera)

Statistics & Data Analysis Data Science

Today's business world is becoming increasingly data-driven. Small and large businesses use data to make decisions about sales, hiring, goals, and all areas they have data for. While most businesses have access to data of one type or another, it can be intimidating for an average business user to understand the data without a background in data analytics.

Aug 17th 2026
4 Weeks
Data Analysis Data Visualization Power BI
Details
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
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.

Aug 10th 2026
4 Weeks
Databases SQL Descriptive Statistics
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.

Aug 17th 2026
4 Weeks
SQL PHP MySQL
Details
Data Connection and Functionalities in Power BI (Coursera) Coursera
Edureka

Data Connection and Functionalities in Power BI (Coursera)

CS: Information & Technology

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.

Aug 10th 2026
4 Weeks
Data Management Microsoft SQL Server Power BI
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.

Aug 17th 2026
4 Weeks
Business Data Analysis Exploratory Data Analysis
Details