Curriculum
- 16 Sections
- 201 Lessons
- 30 Hours
Expand all sectionsCollapse all sections
- Power Bi Instructed Led Online Course7
- Connecting to various data sources17
- 2.02.1 Load Data from CSV in Power BI and Power BI Cloud Service
- 2.12.2 How to Connect PBI Desktop and Cloud Service to Microsoft SQL Server
- 2.22.3 How to invoke a SQL Server Stored Procedure from Power BI
- 2.32.4 Folder connector: Combining multiple sheets from multiple files in one-go
- 2.42.5 Combine Multiple csv files in one-go using folder connector in Power BI
- 2.52.7 Connecting to OneDrive via Power BI
- 2.62.8 Loading data from Github to Power BI
- 2.72.9 How to connect to DataVerse using Power BI
- 2.83.1 Types of Data Storage Modes & Import Mode in Power Bi
- 2.93.2 Types of Storage Mode – Direct Query in Power BI
- 2.103.3 Types of Storage Mode – Live Connection in Power BI
- 2.113.4 Types of Storage Mode – Dual Storage Mode in Power BI
- 2.123.5 Working with PBDIS file (Live Connection Mode)
- 2.133.6 What is Rest API , & how to connect to Web Page to bring in data into Power BI
- 2.14QUIZ: Introducing Microsoft Power BI Desktop15 Minutes7 Questions
- 2.15Start Quiz : Profiling10 Minutes2 Questions
- 2.16QUIZ: Connecting & Shaping Data with Power BI Desktop15 Minutes12 Questions
- Power Query Editor21
- 3.14.1 Data Transformation using Power Query Editor
- 3.25.1 Data Profiling
- 3.35.2 Transpose , Pivoting and Unpivoting
- 3.45.3 How to append datasets in Power Query
- 3.55.4 How to merge datasets in Power Query
- 3.65.5 Creating Index in Power Query Editor
- 3.76.0 Enable Load , Include Report Refresh in Power Query Editor
- 3.87.1 Query Parameter in Power Query
- 3.97.2 Custom Column Creation
- 3.107.3 Conditional Column in Power BI
- 3.117.4 Column from Examples in Power BI
- 3.127.5 Custom Function in Power BI
- 3.137.6 Custom Function Assignments
- 3.148.2 Case Study Converting multiple currencies into single currency
- 3.158.1 Group by and Fuzzy grouping in Power BI
- 3.168.3 Row Level Security , Dynamic Row Level & Object Level Security
- 3.178.4 Incremental Data Refresh in Power BI
- 3.18Parameters in Power BI
- 3.19What is a Data warehousing & Data Lake? Star Schema Snow-flake Schema
- 3.20Power Query Assignment
- 3.21Quiz 3: QUIZ: Cleaning, Transforming & Loading12 Minutes8 Questions
- Data Modeling12
- 4.19.1 Introduction to Data Modeling in Power BI
- 4.210.1 Data Modeling | Types of Relationships
- 4.310.2 Active and Inactive Relationship in Power BI
- 4.4Alternative to inactive relationship in Power BI – Role Playing Dimension
- 4.5Types of cardinalities, Active , & Inactive relationship
- 4.6Cross Filter Direction in Power BI
- 4.7Quiz 4: QUIZ: Data Modeling5 Minutes9 Questions
- 4.8Data Modeling Assignment
- 4.9QUIZ: Creating Table Relationships & Data Models in Power BI20 Minutes11 Questions
- 4.10Many to Many Relationship – Covering two Scenarios
- 4.11Many to Many relationship Assignment
- 4.12Custom Date Dimension Table creation using CALENDAR() & CALENDARAUTO() in Power BI
- Data visualization26
- 5.112.1 Data visualization
- 5.212.3 Types of Chart
- 5.312.4 Line Chart
- 5.412.5 Area Chart
- 5.512.6 Bar & Column Chart
- 5.612.7 Combo Chart
- 5.712.8 Pie & Doughnut Chart in Power BI
- 5.812.9 Scatter plots & Bubble Chart
- 5.912.10 Matrix Visual
- 5.1013.1 Custom Visual – Heat map
- 5.1113.2 Table Visual
- 5.1213.3 Slicer
- 5.1314.2 Types of Slicer in Power BI
- 5.1413.4 Tree Maps
- 5.1513.5 Ribbon Chart
- 5.1613.6 Funnel Chart
- 5.1713.7 Gauge chart
- 5.1813.8 Waterfall Chart
- 5.1913.9 Key Influencer Visual
- 5.2016.0 Decomposition Tree , Q & A Visual
- 5.2116.2 Drill Through and Cross Report Drill Through in Power BI
- 5.2217.0 Bookmark in Power BI
- 5.2317.2 Custom Tooltip in Power BI
- 5.2418.0 Power BI Interview Questions
- 5.25Start Quiz 6: QUIZ: Creating Reports & Dashboards10 Minutes8 Questions
- 5.26QUIZ: Visualizing Data with Power BI Reports10 Minutes10 Questions
- Data Analytics Expresssion (DAX)49
- 6.118.1 Introduction to DAX
- 6.218.2 Calculated Column in DAX
- 6.318.3 Calculated Measure in DAX
- 6.418.4 Data types in DAX
- 6.518.5 Value Encoding in DAX
- 6.618.6 Hash Encoding in DAX
- 6.718.7 Run length Encoding in DAX
- 6.818.8 Operators and Built-in Functions
- 6.918.9 Rounding Functions
- 6.1018.10 Information Functions
- 6.1119.1 Logical Function : Switch in DAX
- 6.1219.2 SUM and SUMX
- 6.1319.3 Average Functions in DAX
- 6.1419.4 Variables in DAX
- 6.1519.5 Evaluation Context in DAX
- 6.1619.6 CALCULATE Function in DAX
- 6.1719.7 Evaluation Order of CALCULATE
- 6.1819.8 Filter in DAX
- 6.1919.9 CALCULATETABLE function in DAX
- 6.2019.10 ALL Function in DAX
- 6.2119.11 ALLSELECTED Function in DAX
- 6.2220.0 ALLEXCEPT in DAX
- 6.2320.1 KEEPFILTER & REMOVEFILTER IN DAX
- 6.2420.2 AddColumns() in Power BI
- 6.2520.3 CROSSFILTER in DAX
- 6.2620.4 SELECTEDVALUE in DAX
- 6.2720.5 Summarize, Summarizecolumns functions in DAX & how to use DAX Studio
- 6.2820.6 DATATABLE , UNION, INTERSECT, EXCEPT, & INTERSECT IN DAX
- 6.2920.7 LOOKUPVALUE in DAX
- 6.3020.8 RELATED Function in DAX
- 6.3120.9 RELATEDTABLE in DAX
- 6.3220.10 TREATAS function in DAX
- 6.3320.11 Rankx & TopN in DAX
- 6.3421.1 Dynamic TopN in DAX
- 6.3521.2 Recap of Dynamic TopN in DAX and Disconnected table
- 6.3621.3 DataTable, GenerateSeries, & Table Functions
- 6.3721.4 Time Intelligence Functions
- 6.3821.5 Display last N months Sales Dynamically
- 6.3921.6 Rolling / Moving Average, What-if Parameter in DAX
- 6.4021.7 Capstone Project – Retail Analytics Part – 1
- 6.4121.8 Capstone Project -1 Retail Analytics
- 6.4221.9 Capstone Project – 2
- 6.4321.10 Capstone Project Retail Analytics Part 2
- 6.442.11 Creating calculation group in tabular editor
- 6.45Report Design in Power BI
- 6.46Quiz 6: QUIZ: DAX Calculations10 Minutes10 Questions
- 6.47QUIZ: Analyzing Data with DAX Calculations15 Questions
- 6.48DAX Assignments
- 6.49DAX Best Practices
- Power BI Cloud Service3
- Microsoft SQL Server25
- 9.0Installation of SQL Server
- 9.1Installation of SSMS
- 9.2Introduction to Microsoft SQL Server
- 9.3Data Types in SQL Server
- 9.4Built in functions in SQL Server
- 9.5Constraints in SQL Server
- 9.6DDL & DML Hands-on
- 9.7How to create Views in SQL Server
- 9.8SQL Server – Hands on Session Day 2
- 9.9SQL Queries – Hands on Session Day 3
- 9.10How to clone or duplicate a table in SQL Server
- 9.11What is Correlated Subquery and Plain Subquery in SQL Server
- 9.12SET Operators in SQL Server
- 9.13Joins in SQL Server
- 9.14IN Operator in SQL Server
- 9.15Exists Operator in SQL Server
- 9.16How to find and Remove Duplicate Records in SQL
- 9.17How to find the Nth Maximum Salary
- 9.18Grouping sets and rollup functions in SQL Server
- 9.19CUBE function
- 9.20How to Pivot and Unpivot the data
- 9.21Stored Procedure
- 9.22Transaction Control Statements in SQL Server
- 9.23Stored Procedure and Stored Function in SQL Server
- 9.24Common Table Expression (CTE) in SQL Server
- Power BI Interview Question & Answers9
- 10.0Power BI Sample preview questions
- 10.1Power BI General Interview Question & Answers
- 10.2Power BI DAX Interview Question & Answers
- 10.3Power BI Power Pivot Interview Question & Answers
- 10.4Power BI Power Query Interview Question & Answers
- 10.5Power BI Power Map Interview Question & Answers
- 10.6Power BI Additional Interview Question & Answers
- 10.7SSIS Interview Question & Answers
- 10.8MySQL Interview Question & Answers
- Power BI Study Materials11
- DA-100 Certification Dumps1
- Data Analytics Using Python46
- 13.0Introduction to Python
- 13.1Quiz : Python Basic20 Questions
- 13.2Quiz 1 : Introduction to Programming10 Minutes2 Questions
- 13.3Python Study Material
- 13.4Quiz 2: Why Python?10 Minutes0 Questions
- 13.5Quiz 3: Using Arithmetic Operators in Python10 Minutes0 Questions
- 13.6String Manipulation in Python
- 13.7Quiz 4: Variables10 Minutes1 Question
- 13.8Boolean Data Type in Python
- 13.9Quiz 6 : Numbers and Boolean Values in Python10 Minutes1 Question
- 13.10List Data Structure in Python
- 13.11Quiz 7: Python Strings10 Minutes3 Questions
- 13.12Quiz 8 : Add Comments10 Minutes1 Question
- 13.13Quiz 9 : Indexing Elements10 Minutes1 Question
- 13.14Tuple in Python
- 13.15Quiz 10 : Structuring with Indentation10 Minutes1 Question
- 13.16Dictionary in Python
- 13.17Quiz 11 : Comparison Operators10 Minutes2 Questions
- 13.18Quiz 10 : The IF Statement10 Minutes1 Question
- 13.19Sets and Conditional Programming in Python
- 13.20Quiz 11 : A Note on Boolean Values10 Minutes1 Question
- 13.21Conditional Flow and Control Structures
- 13.22Python list25 Questions
- 13.23Quiz 12 : Lists10 Minutes1 Question
- 13.24Quiz 13 : Python Functions10 Minutes2 Questions
- 13.25Quiz 13 : Functions10 Minutes2 Questions
- 13.26Functions in Python
- 13.27Quiz 14 : Using Methods10 Minutes1 Question
- 13.28Quiz 15 : Dictionaries10 Minutes1 Question
- 13.29Numpy (Arrays, & Matrices) in Python
- 13.30Quiz 16 : For Loops10 Minutes1 Question
- 13.31Quiz 17 : Lists with the range() Function10 Minutes1 Question
- 13.32Introduction to Pandas in Python
- 13.33Quiz 18 : Importing Modules in Python10 Minutes2 Questions
- 13.34Pandas Assignments
- 13.35Dowload Pandas Assignment Data Sets
- 13.36Data pre processing assignments
- 13.37Data exploration assignments
- 13.38DATASETS
- 13.39Pandas Quiz10 Minutes22 Questions
- 13.40Numpy Quiz20 Questions
- 13.41Python Set25 Questions
- 13.42Python Tuples20 Questions
- 13.43QUIZ FOR GLOBAL & LOCAL VARIABLES10 Questions
- 13.44Python Dictionary19 Questions
- 13.45While & For Loop15 Questions
- Azure Data Factory Introduction2
- Understanding Adf Basic Object Model5
- Azure Data Factory Deployment3
- Data Transformation4