Главная
Study mode:
on
1
) Intro & Overview
2
) Look at data for project
3
) Look at New Power BI file and tour of Power BI user interface
4
) Power Query to import two tables from one Excel file
5
) Import and append data from multiple Excel files
6
) Why the From Folder Power Query option when you have Excel files is more complicated than when you have Text files
7
) Power Query Excel.Workbook function to get Objects from an Excel file, using a Custom Column
8
) Append all tables from Excel files
9
) Using Locale Data Type feature to match imported dates with Regional Settings on Computer. Allows any country to use any other country’s dates and number settings
10
) Close & Apply Fact Table to Data Model and watch Relationships that are automatically created
11
) Create Date or Calendar Table using DAX Table functions. CALENDAR function. Also see DATE, YEAR, MIN and MAX functions
12
) Definition of Date Table
13
) Mark Date Table as a Date Table
14
) Create DAX Calculated Columns in the Date Table for Month, Month Number and Year
15
) Row Context in a Calculated Column
16
) FORMAT function to create Month Name
17
) Sort BY Column feature to get Month Names to sort correctly
18
) Create Relationship for Date field
19
) Create Date Table with GENERATE and ROW functions. See variables and fiscal period formulas in this DAX Table Function. Amazing formula!!!!
20
) Create Total Sales Measure in Data View (Table View) using the SUMX & RELATED functions
21
) Measure Icons in Power BI and Power Pivot
22
) Create Measures in Report View on a Test Measure Page
23
) Matrix Visualization is VERY similar to a PivotTable!
24
) First look at the Format area and the Paint Roller option
25
) Move Totals from Top to Bottom
26
) Total Units Measure
27
) Frequency Measure with COUNTROWS function
28
) EOMONTH function in DAX Calculated Column in Date Table
29
) Why we need EOMONTH function for accurate average monthly sales formula
30
) Average Monthly Sales Measure with AVERAGEX, VALUES function
31
) YOY % Change DAX Measure using Variables, CALCULATE, SAMEPERIODLASTYEAR, IF and HASONEVALUES DAX functions
32
) Introduction to ALL and ALLEXCEPT DAX functions
33
) % of Sales Grand Total Measure using CALCULATE, DIVIDE and ALL DAX functions.
34
) Why ALL on Fact Table removes all filters in the Data Model
35
) % of Year Sales Measure using CALCULATE, DIVIDE and ALLEXCEPT, IF and HASONEVALUE DAX functions
36
) Hide fields in tables from the Report View
37
) What Relationships do
38
) Visualizations in Power BI
39
) Create Year Month Total Sales Matrix and Line Chart
40
) Turn off concatenated
41
) Measures in Tooltips
42
) Edit Visualization Title, especially when you use Tooltips
43
) Amazing Filter Pane in Power BI!
44
) Edit Interactions between visualizations for Matrix and Line Chart
45
) Drill Up, Drill Down, and move to a new Level
46
) What Line Charts do
47
) What is a Dashboard? Define Dashboard and what a Dashboard is in Online Power BI
48
) Create Year Metric “Dashboard” on a Page in a Power BI Desktop Report file
49
) What Tables or Matrix visuals do that is different than a chart or other visuals
50
) What Column and Bar Charts do = Compare differences across categories.
51
) Difference between the Clustered Column/Bar and the Stacked Column/Bar
52
) Moving Visualizations
53
) Add Data Labels
54
) Edit Interactions between visualizations for Matrix and Column or Bar Chart: Filtered, Highlight or No Filter
55
) Publish Power BI Report to Power BI Online
56
) Hide Measure Page
57
) What is a Workspace?
58
) Open Power BI Online
59
) Tour of Power BI Online
60
) Sharing reports and dashboards with Power BI Online
61
) Build a new Workspace
62
) Create a report from a dataset
63
) One Source of Truth Data Sets for Excel PivotTable
64
) Creating Dashboards in Power BI Online, including sharing a dashboard
65
) Add new Excel and update
66
) Summary
67
) What’s in next video
Description:
Dive into an extensive video tutorial on Power BI Desktop, focusing on data analysis techniques, DAX formulas, relationships, data modeling, and visualizations. Learn to import and manipulate data using Power Query, create date tables with DAX functions, and develop measures for sales analysis. Explore various visualizations, including matrices, line charts, and column charts, while understanding their specific uses. Master the creation of relationships, calculated columns, and the implementation of DAX functions like CALCULATE, SAMEPERIODLASTYEAR, and ALLEXCEPT. Discover how to publish reports to Power BI Online, create workspaces, and share dashboards. This comprehensive guide covers everything from basic Power BI interface navigation to advanced data modeling techniques, providing a solid foundation for Excel data analysis enthusiasts looking to expand their skillset.

Excel Data Analysis - Power BI Desktop, DAX Formulas, Relationships, Data Modeling & Visuals

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Business Intelligence #Microsoft Power BI #DAX (Data Analysis Expressions)
0:00 / 0:00
1 of 67

) Intro & Overview