1.1 Power BI Introduction Copy

1.2 Download Resources Copy

QUIZ: Introducing Microsoft Power BI Desktop Copy

Start Quiz 1: Which of the following sources lets users connect to a set of pre-wired connections? Copy

2.1 Connecting to csv files in Power BI Copy

2.2 Combining multiple csv files in one-go using folder connector & testing data refresh on Cloud Copy

2.3 Combining multiple sheets in one go from multiple excel files and scheduling data refresh Copy

2.4 Connecting to OneDrive via Power BI Copy

2.5 Loading data from Github to Power BI Copy

2.6 How to connect to DataVerse using Power BI Copy

2.7 Extracting data from DataVerse via Power BI Copy

3.1 Types of Storage Mode – Power BI Copy

3.2 Working with PBDIS file Copy

3.3 What is Rest API , & how to connect to Web Page to bring in data into Power BI Copy

Start Quiz 1: Which of the following sources lets users connect to a set of pre-wired connections? Copy

Start Quiz 2: Profiling Copy

QUIZ: Connecting & Shaping Data with Power BI Desktop Copy

4.1 Data Transformation using Power Query Editor Part 1 Copy

5.1 Data Profiling Copy

5.2 Merging the data sets in Power Query Editor Copy

5.3 Appending Data sets in Power BI Copy

6.0 Enable Load , Include Report Refresh , Custom column, Custom Function , Column From Examples Copy

7.1 What is Query Parameter and different types of Query Parameters Copy

7.2 Creating Index in Power Query Editor Copy

7.3 Custom Function Assignments Copy

8.1 How to Perform Group by and Fuzzy Grouping operation using Power Query Editor Copy

8.2 Case Study Converting multiple currencies into single currency Copy

8.4 Row Level Security , Dynamic Row Level & Object Level Security Copy

8.5 Incremental Data Refresh in Power BI Copy

Power Query Assignment Copy

Quiz 3: QUIZ: Cleaning, Transforming & Loading Copy

9.1 Data Modeling Introduction – Power BI Part 1 Copy

9.2 Normalization , Denormalization , Datawarehousing – Power BI Copy

10.1 Types of Relationships in Data Model and how to Implement them in Power BI Copy

10.2 Active and Inactive Relationship in Power BI Copy

11.1 Alternative to inactive relationship in Power BI – Role Playing Dimension Copy

11.2 Implementing Many to Many Relationships with a different approach in PBI Copy

11.3 Automatic Date table, Custom Date Table Creation in Power BI Copy

Quiz 4: QUIZ: Data Modeling 101 Copy

Data Modeling Assignment Copy

QUIZ: Creating Table Relationships & Data Models in Power BI Copy

12.1 Data visualization Copy

12.2 Types of Chart Copy

12.3 Line Chart Copy

12.4 Area Chart Copy

12.5 Bar & Column Chart Copy

12.6 Combo Chart Copy

12.7 Scatter plots & Bubble Chart Copy

13.1 Matrix Visual in Power BI Copy

13.2 Pie Chart & Doughnut Chart in Power BI Copy

Funnel Chart Copy

13.3 Ribbon Chart in Power BI Copy

13.4 Gauge chart in Power BI Copy

13.5 Waterfall Chart in Power BI Copy

13.6 Tree Maps In Power BI Copy

13.7 Append vs Merge Copy

13.8 Transpose , Pivoting and Unpivoting Copy

14.0 Slicer in Power BI Copy

14.1 Types of Slicer in Power BI Copy

14.2 Filter in Power BI Copy

15.0 Power BI Interview Questions Copy

16.0 Decomposition Tree , Q & A Visual Copy

17.1 Bookmark in Power BI Copy

17.3 Key Influencer Visual Copy

Start Quiz 6: QUIZ: Creating Reports & Dashboards Copy

QUIZ: Visualizing Data with Power BI Reports Copy

18.1 Introduction to DAX and Vertipaq Engine Copy

18.2 Data types and operators Copy

18.3 Types of Dax function and Count family functions Copy

18. 4 Operators and Built-in Functions Copy

18.5 Information Functions Copy

18.6 Evaluation Context in DAX Copy

18.7 Calculated Column, Calculated Table & Measure Copy

18.8 Calculate & All Copy

18.9 Calculate Table Copy

18.10 Filter Function Copy

19.1 Cross Filter Copy

20.1 DataTable, GenerateSeries, & Table Functions Copy

20.2 Summarize Columns Copy

21.1 Switch Function Copy

Quiz 6: QUIZ: DAX Calculations Copy

QUIZ: Analyzing Data with DAX Calculations Copy

DAX Assignments Copy

SUMMARIZE , ROLLUP, TopN TOTALMTD & QTD, YTD functions Copy

DAX Best Practices Copy

Aggregation Function, Logical & Information Function Copy

SUM and SUMX Copy

Round Function Copy

Information Function Copy

RANKX Copy

How to install Microsoft SQL Server on Windows 10 Copy

Microsoft SQL Server – Introduction Copy

How load Excel file into SQL server Copy

Quiz 1: MS SQL Quiz Copy

Quiz 2: Date data types Copy

Database Constraints & Joins in Microsoft SQL Server Copy

Quiz 3: Databases and Queries Copy

Microsoft SQL Server Assignments Copy

Data Types , Numeric built-in Functions in SQL Server Copy

T- SQL Part 2 & 3 DML Operations & Normalization Copy

Constraints Copy

Introduction to Power BI Copy

Data Extraction Copy

Shaping and combining Data Copy

Data Modelling Copy

Data Visualization Copy

Power BI Service Copy

Power BI Solutions and Direct Connectivity Copy

Development With Power BI Copy

Introduction to Power BI Premium Copy

Power bi Assignment Copy

SQL Query Assignment Copy

Power BI Sample preview questions Copy

Power BI General Interview Question & Answers Copy

Power BI DAX Interview Question & Answers Copy

Power BI Power Pivot Interview Question & Answers Copy

Power BI Power Query Interview Question & Answers Copy

Power BI Power Map Interview Question & Answers Copy

Power BI Additional Interview Question & Answers Copy

SSIS Interview Question & Answers Copy

MySQL Interview Question & Answers Copy

Analyzing Data with Microsoft Power BI Copy

Introduction to Python Copy

Quiz : Python Basic Copy

Quiz 1 : Introduction to Programming Copy

Python Study Material Copy

Quiz 2: Why Python? Copy

Quiz 3: Using Arithmetic Operators in Python Copy

String Manipulation in Python Copy

Quiz 4: Variables Copy

Boolean Data Type in Python Copy

Quiz 6 : Numbers and Boolean Values in Python Copy

List Data Structure in Python Copy

Quiz 7: Python Strings Copy

Quiz 8 : Add Comments Copy

Quiz 9 : Indexing Elements Copy

Tuple in Python Copy

Quiz 10 : Structuring with Indentation Copy

Dictionary in Python Copy

Quiz 11 : Comparison Operators Copy

Quiz 10 : The IF Statement Copy

Sets and Conditional Programming in Python Copy

Quiz 11 : A Note on Boolean Values Copy

Conditional Flow and Control Structures Copy

Python list Copy

Quiz 12 : Lists Copy

Quiz 13 : Python Functions Copy

Quiz 13 : Functions Copy

Functions in Python Copy

Quiz 14 : Using Methods Copy

Quiz 15 : Dictionaries Copy

Numpy (Arrays, & Matrices) in Python Copy

Quiz 16 : For Loops Copy

Quiz 17 : Lists with the range() Function Copy

Introduction to Pandas in Python Copy

Quiz 18 : Importing Modules in Python Copy

Pandas Assignments Copy

Dowload Pandas Assignment Data Sets Copy

Data pre processing assignments Copy

Data exploration assignments Copy

DATASETS Copy

Pandas Quiz Copy

Numpy Quiz Copy

Python Set Copy

Python Tuples Copy

QUIZ FOR GLOBAL & LOCAL VARIABLES Copy

Python Dictionary Copy

While & For Loop Copy

Pipelining data with Azure Data Factory Copy

What you should already know Copy

ADF basic object model Copy

Preparing for your first data ingestion Copy

Configure your first simple data copy solution Copy

Data copy pipeline results Copy

Review object model and clean-up Copy

Deployment using Azure Portal Copy

Taking a look at an ADF instance Copy

ADF studio Copy

Data flow Copy

Filtering data Copy

Debugging Copy

Orchestration Copy