Data Analysis Training

Zoom Class Joining Link

Download the Power BI course agenda

Data as the most strategic business asset

Data Story Telling and Categories of Data Analytics

Roles in Data

Tasks of data analyst

Connecting to Data Sources (Flat files)

Evaluate and Transform Column Data Types

Applying User Friendly naming conventions to columns and queries

Week 1 assignment

Combine Queries

Identifying and Creating appropriate Keys for Joins

Configure data loading

Prepare Data Reading from Microsoft Learn

Configure the Report Page

Adding Visualization items to Reports

Format and configure visuals

Week 2 Assignment

Download Day 10 PBIX

Choosing appropriate visualization types

Apply Sorting

Apply Slicing & Filtering

Read Data Modeling Modeling from Microsoft Learn

Designing a data model that uses star schema

Visualizing reports from Normalized data models

Define a relationship’s cardinality & cross filter direction

Week 3 Assignment

Select a Storage Mode

Resolve Data import errors

Shape & Transform Tables 2

Choose between continuous and categorical axes

Format & Configure Visuals 2

Week 6 Assignment

Mid Term Assignment

Apply and customize a theme

Use Grouping & Binning

Use AI visuals

Use the Forecast feature

Create reference lines

Edit and configure interactions between visuals

Create bookmarks

Create custom tool tips

Configure navigation

Configure Sync Slicers

Week 5 Assignment

Introduction to DAX

Create common date table

Create Calculated Tables/Columns

Create hierarchies

Implement role level security roles

Create basic measures

Relace implicit measures with explicit measures

Use CALCULATE to manipulate filters

Configure subscriptions and data alerts

Week 7 Class Files

Configure and update a workspace

Assign workspace roles

Publish, import or update assets in a workspace

Configure row level security membership

Provide access to datasets

Identify when a gateway is required

Introduction to Transact SQL

Understanding basic concept of RDBMS

Using a query to write and execute queries

Write SELECT statement for data retrieval

Understanding basic SQL Data Types and Usages

Understanding SQL Nulls

Writing queries with Scalar functions

Using aggregate functions

Using GROUP BY to combine data into groups based on common column value

Filtering groups with HAVING

Sorting Query Results with ORDER BY

Using TOP clause to limit returned rows

Using WHERE clause to filter returned rows

Using DISTINCT to eliminate duplicate rows from results

Querying multiple tables with JOINS operations

Understanding INNER JOIN, OUTER JOINS and CROSS JOIN

Writing Subqueries with SELECT statement

Inserting data into an existing table

Modifying data with UPDATE statement

Deleting data with DELETE statement

Appending data with UNION

Power BI Developer Career Talk

Sample Power BI Developer CVs