Power BI Essentials

✅ Why is Data Analytics Important?

✅ Why is the conventional Data Analysis Process inefficient?

✅ What is Business Intelligence?

✅ Steps & concepts involved in Business Intelligence

✅ Other BI Tools in the Market

✅ What is Self-Service BI?

✅ Power BI (Desktop Vs Mobile Vs Service)

✅ Licenses (Free Vs Pro Vs Premium)

✅ What makes Power BI different from other BI Tools?

✅ Frequent Updates and Changes

✅ BI Steps in Power BI

✅ Languages Involved in Power BI (Power Query, DAX, R)

✅ Setting up Office 365 Enterprise E3 trial account

✅ Signing up for Power BI

✅ Upgrading to Power BI PRO

✅ Downloading Power BI Desktop

✅ Understanding Power BI Navigation

✅ Exploring Different Data Sources in Power BI

✅ Getting Data from the Web

✅ Getting Data from Azure SQL Database

✅ Getting Data from Azure SQL Database using SQL statement

✅ Getting Data from Access File

✅ Getting Data from Excel

✅ Navigating Query Editor

✅ What is Query?

✅ What is Data Transformation?

✅ Removing empty rows

✅ Removing irrelevant Columns

✅ Renaming Columns

✅ Changing Data Types

✅ Duplicating Columns

✅ Splitting Columns

✅ Merging Columns

✅ Correcting Spelling Mistakes

✅ Changing cases

Trimming & Cleaning

✅ Exploring Applied Steps

✅ Introducing the idea of repeatable workflows

✅ Updating Applied Steps

✅ Deleting Applied Steps

✅ Renaming Applied Steps

✅ Understanding the Code behind every step

✅ Automating Data Transformation process via repeatable workflows

✅ Exploring Advanced Editor

✅ Loading and Applying Data

✅ Understand Navigation of Relationship view

✅ What is Data Model?

✅ What is a unique Identifier?

✅ Creating a new relationship

✅ Editing a relationship

✅ Updating a relationship

✅ Understanding Cardinality

✅ Understanding Cross Filter Direction

✅ Why is Data Model more efficient than a Flattened Data Set?