Udemyexperten

Microsoft Power BI Desktop (Urdu اردو / Hindi हिंदी)

Learn Power BI Desktop! Hands-on data analysis projects in Urdu/Hindi with a certified analyst. Master data visualization & reporting.

4.7(24)
43students
9h 44m
Certificate
Jaffar Tayyar
Jaffar TayyarFinance Analyst

Course Content

Microsoft Power BI Desktop (Urdu اردو / Hindi हिंदी) is an advanced Udemy course taught by Jaffar Tayyar. It runs 9h 44m, is taught in English, and includes a certificate of completion. Learners rate it 4.7 out of 5 from 24 reviews, with 43 students enrolled. It is a paid course, last updated December 2023.

Master Power BI Desktop in Urdu (اردو) and Hindi (हिंदी)! This comprehensive course is designed for data professionals and aspiring analysts looking to become proficient with the leading business intelligence platform. Through practical projects and real-world assignments, you'll develop essential skills to transform data into actionable insights.

Course Project: AdventureWorks Cycles Case Study

You'll step into the role of a Business Intelligence Analyst for AdventureWorks Cycles, a manufacturing company. Your mission is to create professional Power BI reports and dashboards that:

  • Track key performance indicators (KPIs)
  • Analyze regional performance
  • Explore product-level trends
  • Identify high-value customers

Our expert mentors will guide you every step of the way, providing clear explanations and valuable tips to ensure your journey from beginner to expert is successful.

Course Structure: Following the Business Intelligence Workflow

This course mirrors the critical stages of the business intelligence workflow, simulating tasks data professionals face daily:

STAGE 1: Connecting & Shaping Data with Power Query

Learn to build automated data workflows using Power Query to extract, transform, and load (ETL) data. We'll cover:

  • Data Connectors: Connect to various data sources.
  • Storage & Import Modes: Understand different data import options.
  • Query Editing Tools: Master tools for data manipulation.
  • Table Transformations: Perform essential data cleaning and shaping.
  • Connecting to a Database: Learn to connect to and retrieve data from databases.
  • Extracting Data from the Web: Retrieve data from online sources.
  • QA and Profiling Tools: Assess data quality and identify issues.
  • Text, Numerical, Date & Time Tools: Manipulate different data types.
  • Rolling Calendars: Create dynamic date ranges.
  • Index & Conditional Columns: Enhance data structure.
  • Grouping & Aggregating: Summarize data effectively.
  • Pivoting & Unpivoting: Reshape data for analysis.
  • Merging & Appending Queries: Combine data from multiple sources.

STAGE 2: Creating a Relational Data Model

Develop strong data modeling skills with best practices. We'll explore:

  • Database Normalization: Optimize data structure for efficiency.
  • Fact & Dimension Tables: Understand the core components of a data model.
  • Primary & Foreign Keys: Establish relationships between tables.
  • Star & Snowflake Schemas: Design efficient data models for analysis.
  • Active & Inactive Relationships: Manage relationships between tables.
  • Relationship Cardinality: Understand different relationship types.
  • Filter Context & Flow: Control how filters impact data.

STAGE 3: Adding Calculated Fields with DAX

Unlock the power of DAX (Data Analysis Expressions) to perform advanced data analysis. You'll learn to:

  • DAX vs. M: Understand the difference between DAX and M languages.
  • Calculated Columns & Measures: Create custom data fields.
  • Implicit, Explicit & Quick Measures: Learn different ways to define measures.
  • Measure Calculation Steps: Understand how DAX measures are calculated.
  • DAX Syntax & Operators: Master the DAX language.
  • Math & Stats Functions: Perform mathematical and statistical calculations.
  • Conditional & Logical Functions: Create complex calculations based on conditions.
  • The SWITCH Function: Implement conditional logic in DAX.
  • Text Functions: Manipulate text data.
  • Date & Time Functions: Perform date and time calculations.
  • The RELATED Function: Retrieve related data from other tables.
  • CALCULATE, FILTER & ALL: Control filter context in DAX.
  • Iterator (X) Functions: Iterate over data.
  • Time Intelligence Patterns: Analyze data over time.

STAGE 4: Visualizing Data with Reports & Dashboards

Bring your data to life with compelling Power BI visualizations. We'll cover:

  • Data Viz Best Practices: Create effective and informative visuals.
  • Dashboard Design Framework: Design user-friendly dashboards.
  • Cards & KPIs: Display key metrics.
  • Line Charts, Trend Lines & Forecasts: Visualize trends over time.
  • On-Object Formatting: Customize visual elements.
  • Table & Matrix Visuals: Present data in tabular format.
  • Conditional Formatting: Highlight important data points.
  • Top N Filtering: Display top performers.
  • Map Visuals: Visualize data geographically
$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0(458)
43m
beginner
skillshare
5.0(76)
3h 51m
beginner
skillshare
5.0(179)
5h 59m
beginner
skillshare
5.0(308)
1h 35m
beginner
skillshare
5.0(234)
1h 36m
all
skillshare