Data Connection and Functionalities in Power BI

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

Instructor: Edureka

What you'll learn

Working with MS SQL Server and data connectivity with Power BI to visualize datasets.

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

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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.

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.

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 videosTotal 117 minutes

Course Introduction5 minutesPreview module
What is SQL?4 minutes
Introduction to Microsoft SQL Server3 minutes
Installation of MS SQL Server 2 minutes
SQL Server Interface - Object Explorer6 minutes
SQL Server Interface - Basic Scripts5 minutes
Data Modeling - ER Diagram Components3 minutes
Data Modeling - ER Diagram Entities3 minutes
Cardinality in ER Diagrams2 minutes
Degrees of Relationships3 minutes
ER Modeling Session - Building Tables4 minutes
ER Modeling Session - Creating Diagrams3 minutes
Operation on Keys3 minutes
Normalization3 minutes
Types of Normalization - 1NF2 minutes
Types of Normalization - 2NF1 minute
Types of Normalization - 3NF2 minutes
Types of Normalization - 4NF2 minutes
Types of Normalization - 5NF4 minutes
DDL Commands4 minutes
DQL Commands4 minutes
DML Commands2 minutes
DCL Commands5 minutes
TCL Commands3 minutes
MERGE Statement4 minutes
ALTER Statement2 minutes
Implementing Joins 5 minutes
Implementing Joins - Right, Full and Cross Joins2 minutes
Implementing Restaurant Database - Creating Database4 minutes
Implementing Restaurant Database - Commands4 minutes
Implementing Restaurant Database - Transactions3 minutes
Summary of MS SQL Server1 minute

7 readingsTotal 175 minutes

Welcome to Data Connection and Functionalities in Power BI10 minutes
MS SQL Server User Guide40 minutes
How to use Discussion Forums?10 minutes
MS SQL Server Editions40 minutes
Release notes for SQL Server Management Studio (SSMS)30 minutes
Normalization20 minutes
SQL Joins25 minutes

11 assignmentsTotal 55 minutes

Knowledge Check: SQL Server5 minutes
Knowledge Check: ER Diagrams5 minutes
Knowledge Check: Normalization5 minutes
Knowledge Check: SQL Commands 5 minutes
Knowledge Check: Practice Session5 minutes
Knowledge Check: Introduction to MS SQL Server20 minutes
Practice Quiz: Basics of SQL Server2 minutes
Practice Quiz: ER Modeling2 minutes
Practice Quiz: Data Normalization2 minutes
Practice Quiz: SQL2 minutes
Practice Quiz: SQL Queries and Commands2 minutes

1 discussion promptTotal 10 minutes

Introduce Yourself10 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 videosTotal 63 minutes

What is T-SQL?3 minutesPreview module
Aggregate Functions 2 minutes
Convenient Aggregate Functions – AVG() and MAX()2 minutes
Convenient Aggregate Functions – MIN() and SUM()2 minutes
Convenient Aggregate Functions – COUNT() and COUNT_BIG()2 minutes
Statistical Aggregate Functions3 minutes
User Defined Aggregate Functions1 minute
Querying using Built-in Functions5 minutes
Composing T-SQL4 minutes
Introduction to Sub - Queries4 minutes
SQL Server Views - Describing Views2 minutes
SQL Server Views Operations2 minutes
Case Expressions2 minutes
Stored Procedures2 minutes
Operating Views10 minutes
Implementing Stored Procedures4 minutes
Executing Stored Procedures2 minutes
Summary of Working with Advanced SQL2 minutes

6 readingsTotal 200 minutes

ODBC Scalar Functions20 minutes
T-SQL 25 minutes
SQL Functions40 minutes
Database Functions45 minutes
Understanding concurrency control25 minutes
Views45 minutes

7 assignmentsTotal 44 minutes

Knowledge Check: Built-in Functions and T-SQL5 minutes
Knowledge Check: T-SQL and Functions5 minutes
Knowledge Check: Views and Queries in SQL5 minutes
Knowledge Check: Practice Session on Views and Queries5 minutes
Knowledge Check: Working with Advanced SQL20 minutes
Practice Quiz: SQL Functions2 minutes
Practice Quiz: Queries and Views2 minutes

1 discussion promptTotal 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 videosTotal 75 minutes

Installation of Power BI Desktop and Service5 minutesPreview module
Problem Description4 minutes
Inserting Data2 minutes
Applying Data Records0 minutes
Adjusting the data6 minutes
Performing Basic Operations4 minutes
Connecting with Power BI8 minutes
Visualizing the Data7 minutes
Creating Reports 7 minutes
Formatting Dashboards7 minutes
Gateway2 minutes
Installing Gateway1 minute
M - Functions 7 minutes
Deep Dive in M - Functions5 minutes
Summary: Data Connectivity with Power BI4 minutes

8 readingsTotal 215 minutes

Requirements for Installing Power BI Desktop10 minutes
Power BI Licenses10 minutes
Building Block of Power BI10 minutes
Basics of Power BI30 minutes
Power BI Tutorial70 minutes
Problem Statement20 minutes
Date and Time Features40 minutes
Overview of Power BI Service25 minutes

5 assignmentsTotal 25 minutes

Knowledge Check: Data Connection with Power BI5 minutes
Knowledge Check: M - functions5 minutes
Knowledge Check: Data Connectivity with Power BI10 minutes
Practice Quiz: Introduction to Power BI3 minutes
Practice Quiz: Connecting with Power BI2 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.