Advanced Sql And Power Bi For Data Analyst And Bi Developer

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


Homepage