Microsoft Power Bi Handwritten Notes Beginner To Advanced

Page 1 of 60 POWER BI Draft on Understanding PowerBI Follow Raushan Kumar on LinkedInPage 2 of 60 POWER-BI INDEX 1. BUSINESS INTELLIGENCE (BI) CONCEPTS 1.1 INTRODUCTION TO BUSINESS INTELLIGENCE 1.2 RELATION BETWEEN BUSINESS INTELLIGENCE AND DATA WAREHOUSE 1.3 RELATION BETWEEN BUSINESS INTELLIGENCE AND DATA WAREHOUSE (CONT.) 1.4 BI TOOLS 2. MICROSOFT POWER BI (MSPBI) INTRODUCTION 2.1 POWER BI INTRODUCTION AND OVERVIEW 2.2 POWER BI ARCHITECTURE 2.3 INTRODUCTION TO POWER BI DESKTOP 2.4 WHY TO CHOOSE POWER BI OVER EXCEL 3. INTRODUCTION AND GETTING STARTED 3.1 HOW TO GET POWER BI DESKTOP? 3.2 POWER BI DESKTOP INTERFACE 3.3 CHANGE DEFAULT SETTINGS 4. CONNECT TO VARIOUS DATA SOURCES 4.1 CONNECT TO CSV/TEXT/EXCEL FILES 4.2 CONNECT TO CSV/TEXT/EXCEL FILES (CONT.) 4.3 CONNECT TO CSV/TEXT/EXCEL FILES (CONT.) 4.4 CONNECT TO SQL SERVER 4.5 CONNECT TO SQL SERVER (CONT.) 4.6 CONNECT TO A WEB PAGE 4.7 CONNECT TO A WEB PAGE (CONT.) 4.8 ENTER DATA DIRECTLY 4.9 CONNECT TO DIRECT SQL QUERY 5. POWER QUERY FOR DATA TRANSFORMATION 5.1 POWER QUERY 5.2 HOW TO OPEN POWER QUERY EDITOR? 5.3 POWER QUERY EDITOR INTERFACE 5.4 POWER QUERY EDITOR INTERFACE (CONT.) 5.5 DATA TYPES 5.6 TRANSFORMATION PROCEDURE 5.7 MERGE & APPEND QUERIESPage 3 of 60 5.8