arrow_back
Introduction Power BI 2024
0001 Introduction to this years video
0002 How to Use Discussion
0003Why Power Bi Merge with This year
0005 What is Power BI
0007 Recap of last year
0009 Power BI Ecosystem
Power BI Installation
021 Create User
023 Login for First Time
030 - Power BI License
031 Install Power BI
033 Open Power Bi Desktop
Source Data
Where Is the Data
Retail Data for Self Learning
Sales Data Used in Video
Pivot Data
EndtoEnd- Base PBIX File
Product Vs Division
Theme File- Org Theme1
Working With Power BI Desktop
101 Where is data and Overview
103 Load data Create Relationship
105 Missing Join - BI-Diretional join
107 Save Power BI
151 divide vs Multiply
153 Calculated COlumns
155 Measure Pre video
155 Create Measure
Power BI Visualization
201 Theme
205 Table Visual
210 Matrix - Refer next video for Layouts
212 Matrix Visual New Layouts
215 Bar Visual
220 Stacked
225 Stacked with Measures
227 Visual 100 Per Stacked Bar
230 pie visual
235 Tree Map
240 Line visual
245 area
250 Funnel
255 Map
260 Card Visual
265 Multi Row Card
270 filters
275 Slicer
280 Button Slicer
285 Sync slicer
290 Combo Visual
Learn DAX
300 What is DAX
302 What is Context
303 Row vs Filter Context
305 Introduction to DAX Query View
308 Working with DAX Query
310 Clean file before DAX
312 If and Switch
315 Expression Function
320 Calculate and Filter
325 All And Allselected final
330 Remove filters
335 AllExcept
340 Calculate Filter with and without
345 Earlier
350 Search Reviewed
355 Find
360 ContainsString
365 ContainsStringExact
370 Left Right Mid
374 Selectcolumns
376 Summarize
378 Union
380 Intersect
382 Except
384 Values and Distinct
386 GroupBy Vs Summarize
388 GenerateSeries
390 0 CrossJoin and Generate
390 1 Avg of Sum
390 2 DistinctCount With Summarize
390 3 Percent of Total and SubTotal
391 1 RankX
391 2 TopN
392 Isfiltered and hasonevalue
Power BI DAX Calendar
401 Need of calendar Table
403 Calendar Auto
405 Create Calendar
410 Basic Calendar Columns and Sort Column
415 Add Month, Qtr, and Year Start and End Date
425 Add Week Start Date and Week End Date
430 Add Calendar FY Year
Time Intelligence
501 What is TI
503 6 Points of TI
505 TI Setup - show 6 rules
510 Understand TD
512 MTD- Datesmtd Totatalmtd
514 QTD -Datesqtd and Totalqtd
516 YTD- Datesytd and Totalytd
520 Previous Month and LMTD
530 WTD and WOW
540 Trailing Period- Day, Month , Year
Advance DAX
605 Offset and IsInScope
608 Window and Datesinperiod
612 Index
615 Rank
618 RowNumber
620 Visual Calculation Intro
622 Visual Calc RunningSum
624 Visual Calc CollapseAll
626 Visual Calc MovingAverage
628 Visual Calc Previous Next
630 Visual Calc First and Last
632 Visual Cal Range
634 Visual Cal Expand Expandall
636 Visual Cal Collpase and Collpaseall
638 Visual Cal How to Use reset
640 Visual Cal Templates
600 Introduction to Window Functions
641 Visual Calculation More Calculations
642 Visual Calculation using Index
643 Visual Calculation using Offset
644 Visual Calculation using Rank
645 Visual Calculation using RowNumber and Experiment with Window
646 Visual Calculation using RankX
Power BI Advance Features and Visuals
655 Conditional Formatting
658 Interactions
661 Bookmarks
664 Calculation Groups
667 Field Parameters
670- Drill Through
673 Tooltip Page
680 AI Visuals
682 Custom Visual Text Filter
684 Custom Visual Play Axis
687 New Card Visual
Power Query
705 Power Query Overview
725 Un Pivot Data
728 Pivot Data
730 Remove Rows Blank and Duplicate
732 Fill Up Fill Down
734 Replace Value
736 Transpose Data
740 Merge Queries
745 Append Queries
755 Create Column in Power Query
758 Group By
760 String Operation Power Query
762 Double Unpivot
764 Cross Join in Power Query
775 What is M Language
777 What is M Custom Functions
779 Basics Of M
781 Power Query Create Custom Function
783 Power Query List Functions
785 Power Query Text Functions
787 Power Query Date Functions and Date Table
Use Cases
801 Create a 12-Month Trend with Single Slicer Selection on connected Date table
811 Power Query: Create Dimensions and Fact from Single Table
821 Power Query Append: Excel Sheets into one Table
831 Power Query: Sort Comma Separated String
841 Power Query: Split Text and Distinct
Power BI Service
905 Clean up file
910 Power Bi Service Overview
915 Publish Report
920 Power BI Desktop Report Live Connection
925 Power Bi Service Edit Report
930 End to End Service Dashboard
935 End to End Service Refresh Data
940 create Report in Service
945 create dataflow
950 create App
955 Analyze in excel
960 Analyze in PPT
Interview Questions
0001 Introduction to Interview Questions
0002 How to Introduce Yourself
0003 What Organizations are looking for
Q01 What is Power BI?
Q02 What are components of Power BI?
Q03 What is Power BI Desktop?
Q04 Why do we need Power BI Desktop?
Q05 What is Power Query?
Q06 What is DAX?
Q07 What is the difference between a Calculated Column and a measure?
Q08 What is the difference between Import, Direct Query, and Live mode?
Q09 What are the different types of visuals used in Power BI?
Q10 How to do a multi-column sort on a visual in Power BI?
Q11 What is conditional formatting in Power BI?
Q12 What are the three format styles in Power BI conditional formatting?
Q13 Under what circumstances does conditional formatting become unavailable or when will you not see the conditional formatting icon (Fx icon) in Power BI?
Q14 What is Interactions in Power BI?
Q15 What is Field Parameters in Power BI? Or How to create a dynamic Axis using a slicer?
Q16 Before the introduction of field parameters, what were the methods used to achieve dynamic dimensions, axes, or rows in Power BI?
Q17 What is bookmarks in power bi?
Q18 How can we maintain/pass slicer values across bookmarks?
Q19 What is the difference between sumx and sum in power bi?
Q20 What is the difference between calculate and calculatetable in DAX/Power BI?
Q21 What is the difference between Summarize and SummarizeColumns?
Q22 What is the difference between all and allselected in power bi?
Q23 What is the difference between filtering data in CALCULATE with and without FILTER Expression?
Q24 Rankx- By default, would the rank be in ascending or descending order?
Q25 If in the above visual, I add a column- city id, which also same granularity as a city, and from the same table, will I get the same ranks?
Q26 What is the difference between skip and dense in Rank?
Q27 Provide a measure that will display the top 10 states by gross sales
Q28 What are the common scenarios in which the Grand Total does not equal the sum of rows in both countable and summable measures?
Q29 Why Date table is very important in Power BI?
Q30 What are some best practices related to Time Intelligence or Date Tables?
Q31 What do mean by MTD, QTD, and YTD?
Q32 Which functions can I use to obtain MTD, QTD, and YTD results in Power BI? Alternatively, could you provide the formulas for calculating MTD, QTD, and YTD?
Q 33 When there is no filter, for which specific month will the DATESMTD display its value?
Q34 What value Dateadd([Date], -1, Year) will show for first date?
Q35 Then how can I get the date year before?
Q36 Are they same CALCULATE([Net], DATESMTD(dateadd(‘Date’[Date],-1,Month))) or CALCULATE([Net], Previousmonth(‘Date’[Date])) ?
Q37 How can I display a trend for the last 12 months, when one month is selected?
Q38 I have the Month Year in the format MMM-YYYY, but when I use it in a visual, the sorting is not correct. What steps should I take to achieve the correct sort order in Power BI?
Q39 What type of schema is preferred for Power BI modeling?
Q40 In what scenarios can I use the RELATED function? Alternatively, if I am unable to use the RELATED function while creating a column from another related table, what might be the reason?
Q41 What is the difference between RELATED and RELATEDTABLE?
Q42 What is the difference between search and find?
Q43 What does FIRSTNONBLANKVALUE function do?
Q44 Give examples of Power BI/DAX functions that are very similar to SQL window functions.
Q45 What are the differences between DAX functions Rank and Rankx?
Q46 What is the difference between GENERATE and CROSSJOIN
Q47 What is the difference between the CALENDAR and CALENDARAUTO?
Q48 What is the best way to find min values 5 columns or measures for a given table row or visual row?
Q49 How can we repeat the value of a measure or column?
Q50 How can we generate a series of odd numbers or even numbers?
Q51 Provide a measure that gives the Running/cumulative total using the date table.
Q52 How to get Top/bottom performer?
Q53 How to add a unique sequence number field in Power BI visual?
Q54 How to append two tables in DAX?
Q56 Way to check duplicates in the table?
Q57 What are the different types of joins that Power BI supports?
Q58: What is SCD?
Q59 What is the Role-playing dimension?
Question 60: What is the Conformed dimension?
Question 61: How to Solve “Many to Many” relationship between facts?
Question 62: How do I calculate the unique combinations of two columns in Power BI?
Question 63: I have a visual Brand on the category Axis and net measure on the value axis. I would like to add the city column on the tooltip, but there are multiple cities, how can I show all city values on the tooltip?
Question 64: How do I sort a column of matrix visual in Power BI using a “Month Year” field in descending order? I am using a “month year” field on the column of the matrix visual. How can I sort it in descending order?
Question 65: Is there a way to set a date slicer to always show today’s date, or a month slicer to always show the current month in Power BI?
Live Class
Doubt Clearing Class