Data Analyst with AI + AWS + Snowflake (Batch-12)

Categories: Data Analyst
Wishlist Share
Share Course
Page Link
Share On Social Media

Course Content

Power BI – Assignment Solutions

  • Assignment 01 Solution
    32:27
  • Assignment 02 Solution
    20:43
  • Assignment 03 Solution
    09:46
  • Assignment 04 Solution
    16:06

Pre-Requisite Videos

Class 01 – Importance of Excel | Keyboard Shortcuts | Functions (PROPER, UPPER, LOWER, SUM, MIN, MAX, AVG, VLOOKUP)

Class 02 – Data Types & Formats | Freeze Panel | Data Cleaning (Duplicates, TRIM, SUBSTITUTE, Flash Fill, Text to Columns, CONCATENATE) | Text Functions (LEFT, RIGHT, LEN)

Class 03 – Filtering | Sorting | Custom Sorting | Functions (VLOOKUP, XLOOKUP, INDEX, MATCH) | Data Validation | Conditional Formatting

Class 04 – Conditional Formatting | Logical Functions (IF, AND, OR, Nested IF) | Conditional Summing & Counting (SUMIF, COUNTIF, SUMIFS, COUNTIFS) | RANK

Class 05 – Basics of Pivot Tables | Data Analysis using Pivot Tables

Class 06 – Customizing Charts (Bar & Column Charts, Line Chart, Pie & Donut Charts, Treemap & Sunburst Charts, Waterfall & Funnel Charts)

Class 07 – 365 Cafe Coffee Project

Class 08 – 365 Cafe Coffee Project

Class 09 – Power BI: Power Query (Basic, Text Tools)

Class 10 – Power Query (Data Profiling, Column Quality, Context)

Class 10 (Sir Abbas Lectures)

Class 11 – Categorical vs Time Series Analysis | Append Queries | Merge Queries | Folder Query

Class 12 – Power Query Revision

Class 13 – Power Query Revision | Advanced Editor

Class 14 – Data Modelling & Data Normalization

Class 15 – Advanced Data Modelling

Class 16 – Data Analysis Expressions (DAX) | Left | Right | LEN | Find | Substitute| Variables (VAR)

Class 17 – DATE Functions (TODAY, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATEDIFF, DATEADD, NETWORKDAYS, YEARFRAC)

Class 18 – Logical Operators | Functions | Order of Operation (Lower & Upper Bound) | IF Function | Nested IF | Multiple Conditions | Multiple Conditions & Multiple Logics | Uses of AND | SWITCH Function | MID Function | Data Categorization | Hiding Foreign Keys

Class 19 – Introduction to Measures and its Best Practices | Filter Context | Implicit VS Explicit Measures | Measures Table | Measures Tree | Handling Blanks

Class 20 – Calculate Function | Batching Similar Measures | Decision Making | Industrial Standards/Practices while Presenting Report | Contribution Analysis

Class 21 – REMOVEFILTER | % of Grand Total Analysis | % of Parent Analysis

Class 22 – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | RELATED | Time Intelligence Analysis (YoY & MoM %age Change Analysis, DATEADD ) | Error Handling (ISBLANK, IFERROR)

Class 23 – Discussion (Dashboard | Images | Elements | Shapes | Color Palette | Formatting | UI UX | Card Visual | Corporate Standards | Line Chart (Trend Line, Reference Line: Comparison Analysis) | Bar Chart | Column Chart | Difference between Clustered and Stacked Charts)

Class 24 – KPI Card | Donut Chart | Pie Chart | Filters (Visual, Page & Report Level) | Basic Filter | Advanced Filters | TOPN Filter

Class 25 – Table and Matrix | Conditional Formatting | Area Chart

Class 26 – Guage Chart (Filtering, Monthly Filter, Industry Standards)

Class 27 – Drilling (Up, Down, Through) | Bookmarks | Page Navigation | Custom Tooltips

Class 28 – Power BI Service

Project: 365 Media Feathers

Project: 365 Granny’s Cafe