Complete Power BI DAX Training | All Important Dax One Must Know

This Course is Nearly 9.5 Hrs and Includes Everything Which as Business Analyst/Data Analyst Must Know

The Course Published For Free So that Everyone can Learn ,This Course is Based on Real Projects Involve at Company Level

This Course will help anyone who wants to make their Career in Analytics Domain

Data Source : All Excel File /Data Sets will be Published Soon!!!

Exploring Visual Datasheet Link & Project 1 : https://docs.google.com/spreadsheets/...

Data Modeling DataSheet Link : https://docs.google.com/spreadsheets/...

Excel Practice : https://docs.google.com/spreadsheets/...

https://docs.google.com/spreadsheets/...

Survey Uncleaned Data : https://docs.google.com/spreadsheets/...

Survey Clean Data : https://docs.google.com/spreadsheets/...

Survey Dim & Fact Data : https://docs.google.com/spreadsheets/...

IT Spend Data : https://docs.google.com/spreadsheets/...

Checkout The Website : www.finkaro.com
Checkout The Courses : https://finkaro.com/course/
Checkout The Services : https://finkaro.com/service/
Read Company Blogs : https://finkaro.com/blog/

Social Media
Twitter :   / ksfd67  
Linkdein :   / mohd-kasfur-dhuniyan-b1085aba  
Instagram :   / finkarodotcom  
Telegram : https://t.me/finkaro

The Course Content
Module No. Practical Training Hrs
01 Introduction of Power BI and Installation
• Introduction of Power BI
• Data is the New Oil How
• What is Power BI and Its Importance and Peers Trend
• Parts of Power BI
• Flow Work of Power BI
• Advantages of Power BI
• Installation of Power BI

02 User Interface of Power BI
• How Does it Look Like
• Power BI Desktop Interface
• Ribbon,Pages,Report View,Data View,Relationship View,Visulisation,Fields Pane,Advanced Filter
03 Process To Create Dashboards
• How To Import Data and Types of Data
• Types of Loading Trnsform/Load ?

04 Exploring The Visuals and When To Use
• Area Chart,What is it ? And When to Use ?
• Line Chart,What is It ? And When To Use ?
• Bar Chart,What is It ? And When To Use ?
• Column Chart,What is it ? And When To Use ?
• Combo Line and Column Chart,What is it ? And When To Use?
• Pie Chart,What is It ? And When To Use?
• Doughnut Charts,What is it ? And When To Use?
• Gauge Chart,What is it ? And When To Use ?
• Funnel Chart,What is it ? And When To Use ?
• Scatter Chart,What is it ? And When To Use ?
• Bubble Chart,What is it ? And When To Use?
• Waterfall Chart,What is it ? And when to use ?
• Maps,and How To Plot ?
• Slicers Chart,What is It ? And When To Use ?
• Tree Map,What is It ? And When To Use ?
• Tables,What is it ? And When To Use ?
• Matrix Table,What is it? And When To Use ?

05 Types of Business and Data Understanding

06 Preparation of Dashboard: Project 1

07 Advanced Features of Power BI
• Drill Through
• BookMark
• Tool Tip
• Syncing
• Parameters Field
• Dynamic Header
• Animated Chart
• Conditional Formatting

08 Power Query
• User Interface of Power Query
• Text Function
• Merge Function
• Split and Trim
• Upper,Lower and Proper
• Add Suffix & Prifix
• Left,Right and Mid
• Extract the Text Using Delimiter
• Date Function
• Year,Quarter,Month and Day
• Difference Between Dates ,Earliest and Latest
• Name of the Day and Month
• Day of the Week/Month/Year
• Extract Date ,Time and Year
• Calculate Age
• Number Function
• Add,Subtract and Multiply
• Percentage,Rounding of Number
• Even and Odd
• Append Function
• Append Multiple Excel Files
• Append Multiple Tables
• Append Multiple Excel with Different Column
• Merge Files
• Column in Power BI
• Spliting Text into Column
• Merging Text into Column
• Conditional Column

09 Dimension and Fact Table
• What is Data Wharehouse and Design of Data Wharehouse
• What is Dimension Table and Example
• What is Fact Table and Examples

10 Data Modelling
• What is Data Modelling?
• What is Star Schema
• Types of Relationship
• How To Create Relationship
11 Survey Dashboard Project 2

12 • Excel Function For Complex Project

13 What is Dax and How To Write

14 IT Spend Analysis: Project No 3

After Completing This Course one can Apply for the Job/Freelancing etc

#powerbi #dataanalysis #businessanalyst