Advanced Sql And Power Bi For Data Analyst And Bi Developer

Expert level practical knowledge in Analytics and BI Development with SQL Server and Power BI DAX Power Query, Visual

What you'll learn

What is Analytics

Expert Level knowledge of SQL Server

Expert Level knowledge of Power BI

Project

Requirements

No programming knowledge require to learn this course. You can learn everythig without any technical knowledge

Description

Are you ready to take your Microsoft Power BI skills to the next level? Do you want to become proficient in BI Development reporting and harness the power of Power BI for Reporting and Dashboard Design? This course is designed to make you an expert in advanced Power BI techniques, Data Transformation, Reporting, Dashboard Designing, Data Modeling,  Power Query and Dax (Data Analysis Expressions)**Advanced Power BI Skills:** This course will empower you with Power BI skills, including data analysis, complex data analytics expression (Dax), Power Pivot, Power Query and data visualization. You'll learn how to tackle complex tasks with ease. - **BI Reporting Excellence:** We'll delve into the world of BI reporting, teaching you how to create, manage, and present data effectively for informed decision-making. You'll gain the knowledge and practical skills needed for efficient data reporting and analysis. Certainly! "Power of Power BI" is a concise and intriguing title that suggests the potency and impact of using Microsoft Power BI for business intelligence and data analysis. If you'd like to add a subtitle to provide more context or details, here are a few options:"Unleashing Business Intelligence with the Power of Power BI""Harnessing Data Insights: The Power of Power BI in Action""Transforming Raw Data into Strategic Wisdom with the Power of Power BI""Data Empowerment: Mastering the Power of Power BI for Dynamic Analysis""Visualizing Success: The Power of Power BI in Modern Analytics""Empowering Decision-Making: A Guide to the Strategic Use of Power BI""Driving Business Excellence: The Unmatched Power of Power BI""From Data to Dashboards: Unveiling the Power Behind Power BI""Elevate Your Insights: Exploring the Untapped Power of Power BI""Maximizing Business Impact: Uncovering the Potential of Power BI"

Overview

Section 1: Introduction

Lecture 1 Introduction of Analyst

Lecture 2 SQL Server Installation

Lecture 3 Power BI Installation

Lecture 4 SQL Introduction and SQL Query writing

Lecture 5 Power BI Introduction, Import Data and Visualization

Section 2: SQL Server Object and Component

Lecture 6 SQL Server Interface

Lecture 7 Comment SQL Server Query

Lecture 8 Server and Database

Lecture 9 SQL Table, Record, Field

Section 3: SQL Table

Lecture 10 Create Table

Lecture 11 Create Table without Create Statement

Lecture 12 Delete Table

Lecture 13 Alter Table

Section 4: Data Insert, Import and Export

Lecture 14 Insert Data with Graphical User Interface

Lecture 15 Insert Data into Table

Lecture 16 Bulk Insert Data into Table

Lecture 17 Import Data into Table

Lecture 18 Export Data from Table

Section 5: Delete ,Truncate and Drop

Lecture 19 Define Delete, Truncate and Drop

Lecture 20 Delete Data on Condition

Lecture 21 Delete Entire Data from Table

Lecture 22 Drop Entire Table

Section 6: Update Data

Lecture 23 Update Entire Field Data in Table

Lecture 24 Update Data on Condition

Section 7: Select Statement to View Data (Where Clause)

Lecture 25 View Data

Lecture 26 View Distinct Data

Lecture 27 View Filtered Data

Section 8: Filter Data with Where Clause (And, Or, IN, Between, LIKE, TOP Operators)

Lecture 28 View Filtered Data with AND Operator

Lecture 29 View Filtered Data with OR Operator

Lecture 30 View Filtered Data with IN Operator

Lecture 31 View Filtered Data with BETWEEN Operator

Lecture 32 View Filtered Data with LIKE Operator

Lecture 33 SQL Top Clouse

Lecture 34 View Top Data with Live Scenario

Lecture 35 View Bottom Data with Live Scenario

Section 9: SQL Order By to Sort Data

Lecture 36 Sort Data in Ascending or Descending Orders

Lecture 37 Sort Data In Ascending Orders

Lecture 38 Sort Data in Descending Orders

Section 10: Group By and Having

Lecture 39 Extract Distinct Data

Lecture 40 Aggregate Data with Group By

Lecture 41 Apply Condition with Having Clause

Section 11: SQL Sub Query

Lecture 42 Extract Data of Max Value

Lecture 43 Extract Data of Min Value

Lecture 44 Extract Data more than Average Value

Lecture 45 Extract Product Name of 3rd Highest Sales

Lecture 46 Extract Name of 3rd Smallest Salary

Section 12: SQL Joins

Lecture 47 Introduction of Join

Lecture 48 Inner Join

Lecture 49 Left Join

Lecture 50 Right Join

Lecture 51 Full Join

Lecture 52 Cross Join

Lecture 53 Self Join

Section 13: SQL Union

Lecture 54 Union

Lecture 55 Union ALL

Lecture 56 Intersect

Lecture 57 Except

Section 14: SQL Case Statement

Lecture 58 Create a Conditional Field

Section 15: Common Table Expression (CTE)

Lecture 59 Row_Number

Lecture 60 Rank Function

Lecture 61 Dense_Rank Function

Lecture 62 Extract Product Name of 3rd Largest Sales

Lecture 63 Extract Product Name of 3rd Smallest Sales

Lecture 64 Extract Each Category Two Max Value Data

Lecture 65 Extract Each Category Two Min Value Data

Section 16: Power BI Introduction

Lecture 66 Introduction of Power BI

Lecture 67 ETL (Extract Transformation and Load)

Lecture 68 Dimension Table and Fact Table

Lecture 69 Star Schema vs Snowflake Schema

Section 17: Power Query

Lecture 70 Power Query Introduction

Lecture 71 Data Extraction Using Import and Direct Query Mode

Lecture 72 Manage Parameters

Lecture 73 Dynamic Calendar Table Using Parameters

Lecture 74 Join and Append

Lecture 75 Index Number and Group by

Lecture 76 Manage (Delete, Duplicate and Reference) Option

Lecture 77 Conditional Column

Lecture 78 Custom Column

Lecture 79 Choose Columns and Remove Columns

Section 18: Filters in Power BI

Lecture 80 Visual Level, Page Level, Report Level and Drill Through Filters

Section 19: Slicers in Power BI

Lecture 81 Basic of Slicer

Lecture 82 Sync Slicer

Lecture 83 Edit Interactions

Section 20: Tooltips in Power BI

Lecture 84 Basic of Tooltip

Lecture 85 Report Tooltip

Section 21: Selection Pane and Bookmark in Power BI

Lecture 86 Selection Pane

Lecture 87 Create a Report with Use of Bookmark

Section 22: Reference Line

Lecture 88 Reference Line for Minimum, Average and Maximum Value

Section 23: Conditional Formatting

Lecture 89 Conditional Formatting

Section 24: Data Modeling

Lecture 90 One to One Relationship

Lecture 91 Modeling in Power BI

Section 25: DAX (Data Analysis Expression) Calculated Table

Lecture 92 DAX (UNION, INTERSECT, EXCEPT)

Lecture 93 DAX (ALL, ALLSELECTED, ALLEXCEPT)

Lecture 94 DAX (CALCULATETABLE, FILTER)

Lecture 95 DAX (TOPN)

Section 26: DAX (Data Analysis Expression) for Calculated Column

Lecture 96 Calculate Incentive with IF

Lecture 97 Calculate Incentive with Switch

Section 27: DAX (Data Analysis Expression) for Measure Calculation

Lecture 98 What is Measure (Implicit and Explicit)

Lecture 99 Filter Dax to Create a Table

Lecture 100 Sumx vs Calculate with Live Report Design

Lecture 101 Countx vs Calculate with Live Report Design

Lecture 102 Averagex vs Calculate with Live Report Design

Lecture 103 Minx vs Calculate with Live Report Design

Lecture 104 Maxx vs Calculate with Live Report Design

Lecture 105 Rankx to Calculate Rank with Dynamic Report

Lecture 106 DAX for Date Dimension Table

Lecture 107 Design Report to Compare Current Day Vs Previous Day Sales

Lecture 108 Design Report to Compare Current Week Vs Previous Week Sales

Lecture 109 Design Report to Compare Current Month Vs Previous Month Sales

Lecture 110 Design Report to Compare Current Quarter Vs Previous Quarter Sales

Lecture 111 Design Report to Compare Current Year Vs Previous Year Sales

Lecture 112 Design Report to Compare Current Week Vs Previous Week Sales

Lecture 113 Current Year MTD Vs Last Year MTD

Lecture 114 Current Year QTD Vs Last Year QTD

Lecture 115 Current Year YTD Vs Last Year YTD

Lecture 116 Design Report to Calculate TOPN and BottomN Sales

Section 28: Charts for Visualization

Lecture 117 Card Vs Multi Row Card

Lecture 118 Table Vs Matrix

Lecture 119 Stacked Bar Vs Stacked Column Chart

Lecture 120 Clustered Bar Vs Clustered Column Chart

Lecture 121 100% Stacked Bar Vs 100% Stacked Column Chart

Lecture 122 Line Chart Vs Area Chart

Lecture 123 KPI Visual

Lecture 124 Pie Chart Vs Donut Chart

Lecture 125 Map Vs Filled Map

Lecture 126 Gauge Vs Funnel Chart

Section 29: Row Level Security (RLS)

Lecture 127 Restrict Report Access

Section 30: Project

Lecture 128 Project Overview

Who wants to looking career in Data Analytics, Reporting Analytics, Business Analyst, BI Developer