Curriculum
- 14 Sections
- 134 Lessons
- 30 Hours
Expand all sectionsCollapse all sections
- Power Bi Instructed Led Online Course4
- Connecting to various data sources10
- 3.12.1 Connecting to csv files in Power BI
- 3.22.2 Folder connector in Power BI
- 3.32 3 How to connect to DataVerse using Power BI
- 3.43.1 Types of Storage Mode – Power BI
- 3.53.2 What is Power BI Data Source (PBDIS)
- 3.63.3 What is Rest API , & how to connect to Web Page to bring in data into Power BI
- 3.7Start Quiz 1: Which of the following sources lets users connect to a set of pre-wired connections?10 Minutes4 Questions
- 3.8Start Quiz 2: Profiling10 Minutes2 Questions
- 3.9QUIZ: Connecting & Shaping Data with Power BI Desktop12 Questions
- 3.10Getting Data from Different Sources10 Minutes10 Questions
- Power Query Editor15
- 4.14.1 Data Transformation using Power Query Editor Part 1
- 4.25.1 Power Query Editor Part 1
- 4.35.2 Data Profiling
- 4.45.3 Merging the data sets in Power Query Editor
- 4.55.4 Appending Data sets in Power BI
- 4.66.0 Enable Load , Include Report Refresh , Custom column, Custom Function , Column From Examples
- 4.77.1 What is Query Parameter and different types of Query Parameters
- 4.87.2 Creating Index in Power Query Editor
- 4.97.3 Custom Function Assignments
- 4.108.1 How to Perform Group by and Fuzzy Grouping operation using Power Query Editor
- 4.118.2 Case Study Converting multiple currencies into single currency
- 4.128.4 Row Level Security , Dynamic Row Level & Object Level Security
- 4.138.5 Incremental Data Refresh in Power BI
- 4.14Power Query Assignment
- 4.15Quiz 3: QUIZ: Cleaning, Transforming & Loading10 Minutes8 Questions
- Data Modeling10
- 5.29.1 Data Modeling Introduction – Power BI Part 1
- 5.39.2 Normalization , Denormalization , Datawarehousing – Power BI
- 5.410.1 Types of Relationships in Data Model and how to Implement them in Power BI
- 5.510.2 Active and Inactive Relationship in Power BI
- 5.611.1 Alternative to inactive relationship in Power BI – Role Playing Dimension
- 5.711.2 Implementing Many to Many Relationships with a different approach in PBI
- 5.811.3 Automatic Date table, Custom Date Table Creation in Power BI
- 5.9Quiz 4: QUIZ: Data Modeling10 Minutes9 Questions
- 5.10Data Modeling Assignment
- 5.11QUIZ: Creating Table Relationships & Data Models in Power BI11 Questions
- Data visualization21
- 6.112.1 Data visualization
- 6.212.2 Types of Chart
- 6.312.3 Line Chart
- 6.412.4 Area Chart
- 6.512.5 Bar & Column Chart
- 6.612.6 Combo Chart
- 6.712.7 Scatter plots & Bubble Chart
- 6.813.1 Matrix Visual in Power BI
- 6.913.2 Pie Chart & Doughnut Chart in Power BI
- 6.1013.3 Ribbon Chart in Power BI
- 6.1113.4 Tree Maps In Power BI
- 6.1214.0 Slicer in Power BI
- 6.1314.1 Types of Slicer in Power BI
- 6.1414.2 Filter in Power BI
- 6.1515.0 Power BI Interview Questions
- 6.1616.0 Decomposition Tree , Q & A Visual
- 6.1717.1 Bookmark in Power BI
- 6.1817.3 Key Influencer Visual
- 6.1917.4 Waterfall Chart in Power BI
- 6.20Start Quiz 6: QUIZ: Creating Reports & Dashboards10 Minutes8 Questions
- 6.21QUIZ: Visualizing Data with Power BI Reports10 Questions
- Data Analytics Expresssion (DAX)21
- 7.1Protected: 18.1 Introduction to DAX and Vertipaq Engine
- 7.2Protected: 18.2 Data types and operators
- 7.3Protected: 18.3 Types of Dax function and Count family functions
- 7.4Protected: 18. 4 Operators and Built-in Functions
- 7.5Protected: 18.5 Information Functions
- 7.6Protected: 18.6 Evaluation Context in DAX
- 7.7Protected: 18.7 Calculated Column, Calculated Table & Measure
- 7.8Protected: 18.8 Calculate & All
- 7.9Protected: 18.9 Calculate Table
- 7.10Protected: 18.10 Filter Function
- 7.11Protected: 19.1 Cross Filter
- 7.12Protected: 20.1 DataTable, GenerateSeries, & Table Functions
- 7.13Protected: 20.2 Summarize Columns
- 7.14Protected: 21.1 Switch Function
- 7.15Protected: Quiz 6: QUIZ: DAX Calculations10 Minutes10 Questions
- 7.16Protected: QUIZ: Analyzing Data with DAX Calculations15 Questions
- 7.17DAX Assignments
- 7.18Protected: SUMMARIZE , ROLLUP
- 7.19Protected: TopN TOTALMTD
- 7.20Protected: QTD, YTD functions
- 7.21Protected: DAX Best Practices
- Scalar Functions4
- Iterator Functions1
- Microsoft SQL Server7
- 10.1Protected: Microsoft SQL Server – Introduction
- 10.2Protected: Quiz 1: MS SQL Quiz10 Minutes3 Questions
- 10.3Protected: SQL Server (Data Types, Built-in Functions, & Constraints
- 10.4Protected: Quiz 2: Date data types10 Minutes5 Questions
- 10.5Protected: Database Constraints & Joins in Microsoft SQL Server
- 10.6Protected: Quiz 3: Databases and Queries10 Minutes2 Questions
- 10.7Protected: Microsoft SQL Server Assignments
- Azure Data Factory ( Videos' Will be Available by 1st Week of Aug )20
- 11.1Environment Set-up – Module Overview
- 11.2Creating Azure Free Account
- 11.3Azure Portal Overview
- 11.4Creating Azure Data Factory
- 11.5Creating Azure Storage Account
- 11.6Creating Azure Data Lake Storage Gen2
- 11.7Creating Azure SQL Database
- 11.8Useful Links & Resources
- 11.9Data Ingestion from Azure Blob – Module Overview
- 11.10Copy Activity Overview
- 11.11Environment Preparation
- 11.12Naming Standards
- 11.13Linked Services & Data Sets
- 11.14Creating ADF Pipeline
- 11.15Control Flow Activities (1) – Validation Activity
- 11.16Control Flow Activities (2) – Get Metadata, If Condition, Web Activities
- 11.17Control Flow Activities (3) – Delete Activity
- 11.18ADF Triggers Overview
- 11.19Creating Event Trigger
- 11.20Useful Links & Resources
- Power BI Study Materials11
- 12.1Introduction to Power BI
- 12.2Data Extraction
- 12.3Shaping and combining Data
- 12.4Data Modelling
- 12.5Data Visualization
- 12.6Power BI Service
- 12.7Power BI Solutions and Direct Connectivity
- 12.8Protected: Development With Power BI
- 12.9Protected: Introduction to Power BI Premium
- 12.10Protected: Power bi Assignment
- 12.11Protected: SQL Query Assignment
- Power BI Interview Question & Answers9
- 13.1Power BI Sample preview questions
- 13.2Power BI General Interview Question & Answers
- 13.3Power BI DAX Interview Question & Answers
- 13.4Power BI Power Pivot Interview Question & Answers
- 13.5Protected: Power BI Power Query Interview Question & Answers
- 13.6Protected: Power BI Power Map Interview Question & Answers
- 13.7Protected: Power BI Additional Interview Question & Answers
- 13.8Protected: SSIS Interview Question & Answers
- 13.9Protected: MySQL Interview Question & Answers
- DA-100 Certification Dumps1
- Data Analytics Using Python46
- 15.1Introduction to Python
- 15.2Protected: Quiz : Python Basic20 Questions
- 15.3Protected: Quiz 1 : Introduction to Programming10 Minutes2 Questions
- 15.4Protected: Python Study Material
- 15.5Protected: Quiz 2: Why Python?10 Minutes0 Questions
- 15.6Protected: Quiz 3: Using Arithmetic Operators in Python10 Minutes0 Questions
- 15.7String Manipulation in Python
- 15.8Quiz 4: Variables10 Minutes1 Question
- 15.9Boolean Data Type in Python
- 15.10Protected: Quiz 6 : Numbers and Boolean Values in Python10 Minutes1 Question
- 15.11Protected: List Data Structure in Python
- 15.12Protected: Quiz 7: Python Strings10 Minutes3 Questions
- 15.13Protected: Quiz 8 : Add Comments10 Minutes1 Question
- 15.14Protected: Quiz 9 : Indexing Elements10 Minutes1 Question
- 15.15Protected: Tuple in Python
- 15.16Quiz 10 : Structuring with Indentation10 Minutes1 Question
- 15.17Dictionary in Python
- 15.18Protected: Quiz 11 : Comparison Operators10 Minutes2 Questions
- 15.19Protected: Quiz 10 : The IF Statement10 Minutes1 Question
- 15.20Protected: Sets and Conditional Programming in Python
- 15.21Protected: Quiz 11 : A Note on Boolean Values10 Minutes1 Question
- 15.22Protected: Conditional Flow and Control Structures
- 15.23Protected: Python list25 Questions
- 15.24Protected: Quiz 12 : Lists10 Minutes1 Question
- 15.25Protected: Quiz 13 : Python Functions10 Minutes2 Questions
- 15.26Protected: Quiz 13 : Functions10 Minutes2 Questions
- 15.27Protected: Functions in Python
- 15.28Protected: Quiz 14 : Using Methods10 Minutes1 Question
- 15.29Protected: Quiz 15 : Dictionaries10 Minutes1 Question
- 15.30Numpy (Arrays, & Matrices) in Python
- 15.31Quiz 16 : For Loops10 Minutes1 Question
- 15.32Quiz 17 : Lists with the range() Function10 Minutes1 Question
- 15.33Protected: Introduction to Pandas in Python
- 15.34Protected: Quiz 18 : Importing Modules in Python10 Minutes2 Questions
- 15.35Protected: Pandas Assignments
- 15.36Protected: Dowload Pandas Assignment Data Sets
- 15.37Protected: Data pre processing assignments
- 15.38Protected: Data exploration assignments
- 15.39DATASETS
- 15.40Pandas Quiz10 Minutes22 Questions
- 15.41Numpy Quiz20 Questions
- 15.42Python Set25 Questions
- 15.43Python Tuples20 Questions
- 15.44QUIZ FOR GLOBAL & LOCAL VARIABLES10 Questions
- 15.45Python Dictionary19 Questions
- 15.46While & For Loop15 Questions
