Course Duration & Payment Details

Day: Sundays only
Timing: 02:00 to 05:00pm
Duration: 18 hours
Starting from: Sunday, 04 April 2021
Last date of registration: Wednesday, 31 March 2021

Actual Fee: 18,000/-  | Early bird discount: 9,000/-
How to Pay: Online Payment
Bank: Habib Bank Limited (26 street, Badar Commercial, DHA Karachi)
Title: Irfan
Account No: 0011557900292501 | PK02HABB0011557900292501

Training Highlights

Theory Time:

• What is a data warehouse
• Concept of ETL
• Data warehouse Characteristics
• Data warehouse Schema
• The Star Schema

Getting started

• What is BI?
• What are Self Service BI and the steps involved?
• Overview of Power BI
• Different products of Power BI
• Power BI licensing and features
• Power BI pros and cons
• Other self-service BI tools and comparison

Power BI desktop – data extraction

• Exploring different data sources and connectors
• Data extraction from the Web
• Data extraction from Access Database
• Data extraction from Online Services
• Data extraction from Excel Workbook

Data Visualization in Power BI Desktop

• Visualization Best Practices
• Which Chart is the Best?
• Basic Charts
• Interaction of Visuals
• Color Formatting
• Setting Sort Order
• Tooltips
• Slicers & Timeline Slicers
• Cross Filtering and Highlighting
• Visual, Page, and Report Level Filters
• Drill Down/Up
• Hierarchies
• Map Visuals
• Scatter Chart
• Line Chart
• Table and Matrix with Conditional Formatting
• Multiple levels of filters
• Using custom slicers
• Switch between web/phone layout
• Inserting shapes, images, and text boxes
• Drill Down
• Tooltip
• Hyperlink & Bookmark

Working with Custom Visuals

Power BI desktop – data transformation / Edit Queries

• What is Power Query?
• Power Query in Excel and Power BI
• Basic Transformations
• Get Data
• Different Data Sources
• Get Data from Web

Query Editor

• Base structures in Power Query
• Query Editor in Details
• Get Data from CSV Files
• Get Data from Excel
• Transformation Pane

Power Query Syntax

• Data Types in Power Query
• Transformation Steps
• Query Operations; Duplicate, and Reference
• Managing Queries in Groups

Combine Queries

• Merge, Joining queries
• Append, creating a big list
• Combine Binaries; Looping through files in a folder

Transformations

• Column Operations
• Row Operations
• Filtering
• Sorting

Table Transformations

• Group By
• Transpose
• Pivot, Unpivot

Text Transformations

• Split
• Merge (Concatenate)

More Transformations

• Date Transformations (Year, Month, Quarter)
• Extending Fiscal Date Column
• Aggregate
• Add Custom Column

Power Query Formula Language: M

• What is M? and the importance of learning M
• M Syntax
• Basic examples of M

Power BI desktop – data modeling

• Introduction to relationship view navigation
• Understanding data modeling concepts
• Creating and editing relationships
• Why is a data model more efficient?
• Relationship-based on multiple Columns
• Principles of Database Normalization
• Cardinality: Many-to-One & One-to-One
• Understanding how LEFT, RIGHT, INNER, and OUTER joins work
• Cross Filter Direction & Many-to-Many
• Understanding Active Properties
• M-Language vs DAX (Data Analysis Expressions)
• Understanding the CALENDAR Function
• Managing Active vs. Inactive Relationships

Introduction to DAX

• Introduction to DAX
• Syntax of DAX
• Understanding calculated columns and measures
• Why is a measure more efficient than a column?
• Creating calculated columns
• Measures in PowerPivot
• Implicit and explicit measures
• Understanding filter context
• Measure referencing
• Editing / Deleting measures
• Logical Operations

Artificial Intelligence (AI) Visuals

Most common and demanding DAX functions / Learning Data Analysis Expression (DAX) Functional language

Date & Time Functions – Calendar, CalendarAuto, Date, Day, Month, Year, Format, Datediff, Now, Today, Weekday, Weeknum

Filter Functions – All, AllExcept, AllSelected, Calculate, Earlier, Filter, HasOneValue, IsFiltered, Related

Math & Trig Functions – Ceiling, Divide, Round, Roundup, Sum, Sumx

Logical Functions – IF, AND, OR, Switch

Time Intelligence Expressions – MTD, QTD, YTD, SamePeriodLastYear, DateAdd, DatesBetween, Running Total

Statistical Function – Average, AverageX, Count, CountA, CountBlank, CountRows, CountX, Max, MaxX, Min, MinX, MedianX, RankX, Sumarize

Text Functions – Concatenate, Format, Left, Len, Lower, Rept, Right, Trim, Unichar, Upper, Value

• Top N Values, Top N Filter, Top Order calculations, Top 10 Customers, Dynamic

Power BI service

• Logging in and understanding navigation
• What are workspaces?
• Difference between datasets, workbooks, reports, and dashboards
• Publishing data to web

Power BI Service – Dashboards

• Pinning visuals and creating dashboards
• Alignment and configuration of visuals
• Viewing reports & dashboards
• Sharing reports & dashboards
• Row-level security

Gateways

• What is Gateway?
• Types of Gateway
• On-premises Gateway in Details
• Installation, Configuration, and considerations
• Schedule Refresh

Integration

Power BI and PowerPoint