Канал: Foresight BI

How to use Power BI without Work/School Email (2024 Update)

How to use Power BI without Work/School Email (2024 Update)

Power BI Developer Internship - How to approach and deliver power bi reporting requirements

Power BI Developer Internship - How to approach and deliver power bi reporting requirements

40. Data Cleaning Example 6

40. Data Cleaning Example 6

34. Introduction to Data Cleaning

34. Introduction to Data Cleaning

35. Data Cleaning Example 1

35. Data Cleaning Example 1

39. Data Cleaning Example 5

39. Data Cleaning Example 5

37. Data Cleaning Example 3

37. Data Cleaning Example 3

38. Data Cleaning Example 4

38. Data Cleaning Example 4

32. Dealing with Cell Errors in Power Query

32. Dealing with Cell Errors in Power Query

36. Data Cleaning Example 2

36. Data Cleaning Example 2

31. Removing Duplicate Records

31. Removing Duplicate Records

25. Adding Conditional Columns (1)

25. Adding Conditional Columns (1)

33. Checking for Cell Errors reasons in Power Query

33. Checking for Cell Errors reasons in Power Query

23. Adding new Columns from a Text Column

23. Adding new Columns from a Text Column

21. Understanding Group BY

21. Understanding Group BY

26. Adding Conditional Columns (2)

26. Adding Conditional Columns (2)

24. Adding new Columns from Numbers and Date Columns

24. Adding new Columns from Numbers and Date Columns

22. Adding Duplicate and Index Columns

22. Adding Duplicate and Index Columns

29. Adding Columns From Examples

29. Adding Columns From Examples

30. Other common Column Transformations

30. Other common Column Transformations

27. Adding Custom Columns (1)

27. Adding Custom Columns (1)

28. Adding Custom Columns 2

28. Adding Custom Columns 2

19. Unpivoting Columns without Header Rows

19. Unpivoting Columns without Header Rows

17. Understanding Unpivot Columns

17. Understanding Unpivot Columns

20. Understanding Pivot Columns

20. Understanding Pivot Columns

12. Understanding Join Kinds

12. Understanding Join Kinds

15. Introduction to Transposing Data

15. Introduction to Transposing Data

14. What you must know about Merge Queries

14. What you must know about Merge Queries

13. Using the different Join Kinds in Power Query

13. Using the different Join Kinds in Power Query

18. Unpivoting Columns when there are null values

18. Unpivoting Columns when there are null values

16. Transposing Data when there is a Header Row

16. Transposing Data when there is a Header Row

1. Getting Data into Power Query

1. Getting Data into Power Query

2. Understanding how Power Query works

2. Understanding how Power Query works

8. Understanding Append Queries

8. Understanding Append Queries

10. Understanding Merge Queries

10. Understanding Merge Queries

5. Previewing Column Statistical Summaries with Column Profile

9. What you must know about Append Queries

9. What you must know about Append Queries

0. Introduction to Data Prep

0. Introduction to Data Prep

6. Setting Data Preview checks for entire dataset

6. Setting Data Preview checks for entire dataset

11. Using multiple columns as keys for Merging Queries

11. Using multiple columns as keys for Merging Queries

4. Previewing Unique and Distinct with Column Distribution

4. Previewing Unique and Distinct with Column Distribution

7. Introduction to Combining Data Queries

7. Introduction to Combining Data Queries

3. Previewing empty and error values with Column Quality

3. Previewing empty and error values with Column Quality

SQL Server Database Quick Step-by-Step Setup Guide

SQL Server Database Quick Step-by-Step Setup Guide

How to create Power BI Charts after the new UI update

How to create Power BI Charts after the new UI update

Power BI Developer Internship - Data Modeling with Target Data

Power BI Developer Internship - Data Modeling with Target Data

Repetition is the key to learning and mastery!

Repetition is the key to learning and mastery!

Power BI Case Study with Ahmed Oyelowo - E-Learning Report Guide

Power BI Case Study with Ahmed Oyelowo - E-Learning Report Guide

32 Prepare data for reporting (Add Day of Week)

32 Prepare data for reporting (Add Day of Week)

19 Creating Visuals on Power BI Desktop

19 Creating Visuals on Power BI Desktop

62 Wrap up

62 Wrap up

48 Basic Matrix Table Formatting

48 Basic Matrix Table Formatting

28 Using Tool Tips

28 Using Tool Tips

18 Intro to Reporting in Power BI Desktop

18 Intro to Reporting in Power BI Desktop

33 Working with Shapes

33 Working with Shapes

49 Using Maps in power bi

49 Using Maps in power bi

29 Small Multiples in Power BI Desktop

29 Small Multiples in Power BI Desktop

16 Intro to Data Analysis and Visualization

16 Intro to Data Analysis and Visualization

34 Working with Text Boxes

34 Working with Text Boxes

58 Implement Bookmarks

58 Implement Bookmarks

27 Intro to Small Multiples

27 Intro to Small Multiples

7 Configuring Report Page Part 1

7 Configuring Report Page Part 1

30 Enable Drill Down in Power BI

30 Enable Drill Down in Power BI

59 Using Q and A

59 Using Q and A

17 Categorizing Data for Visualization

17 Categorizing Data for Visualization

23 Creating additional visuals

23 Creating additional visuals

8 Change Canvas Background and Wall Paper

8 Change Canvas Background and Wall Paper

60 Design Mobile View and prepare to publish

60 Design Mobile View and prepare to publish

20 Intro to chart formatting

20 Intro to chart formatting

6 Understanding Power BI Desktop User Interface

6 Understanding Power BI Desktop User Interface

14 Refreshing Data and Revisiting Power Query

14 Refreshing Data and Revisiting Power Query

36 Visualizing Rank Changes with Ribbon Chart

36 Visualizing Rank Changes with Ribbon Chart

11 Importing Our Data Into Power Query

11 Importing Our Data Into Power Query

54 Use Decomposition Tree

54 Use Decomposition Tree

15 Reusing your M Queries

15 Reusing your M Queries

26 Power BI X axis Y axis and Legends example

26 Power BI X axis Y axis and Legends example

39 ReUsing Charts and Editing Conditional Formatting

39 ReUsing Charts and Editing Conditional Formatting

37 Sort Chart in PowerBI

37 Sort Chart in PowerBI

21 Common Formatting Options

21 Common Formatting Options

38 Apply Gradient Conditional Formatting

38 Apply Gradient Conditional Formatting

41 Using Slicers in power bi

41 Using Slicers in power bi

61 Export to pdf and publish to web

61 Export to pdf and publish to web

35 Display trends with line charts

35 Display trends with line charts

55 Use AI to drill decomposition tree

55 Use AI to drill decomposition tree

1 Introduction to Power BI Tutorial - Intro

1 Introduction to Power BI Tutorial - Intro

22 Changing Visuals

22 Changing Visuals

12 understanding how power query works

12 understanding how power query works

24 Intro to Visuals Field Buckets

24 Intro to Visuals Field Buckets

25 Understanding the Axes and Legend

25 Understanding the Axes and Legend

47 Apply Conditional Formatting on Matrix

47 Apply Conditional Formatting on Matrix

10 Intro to Getting Data Into Power BI

10 Intro to Getting Data Into Power BI

31 Introduction to Power BI Reporting

31 Introduction to Power BI Reporting

5 Typical Power BI Flow

5 Typical Power BI Flow

52 Customize Drill through header text

52 Customize Drill through header text

4 Download and Install Power BI Desktop

4 Download and Install Power BI Desktop

57 Intro to Bookmarks and Selections

57 Intro to Bookmarks and Selections

42 Synchronize Slicers in power bi

42 Synchronize Slicers in power bi

44 Create Top N in power bi

44 Create Top N in power bi

29 Small Multiples in Power BI Desktop

29 Small Multiples in Power BI Desktop

50 Report Page Tooltip

50 Report Page Tooltip

45 Bottom N Report

45 Bottom N Report

46 Using Tables and Matrix Table

46 Using Tables and Matrix Table

2 Power BI Prerequisite

2 Power BI Prerequisite

56 Key Influencer Visual

56 Key Influencer Visual

43 Intro to the Filters Pane

43 Intro to the Filters Pane

13 Changing Data Types in Power Query

13 Changing Data Types in Power Query

9 Introducing the Dataset

9 Introducing the Dataset

53 Summary of reports

53 Summary of reports

51 Report Drill Through

51 Report Drill Through

40 Editing Visual Interaction

40 Editing Visual Interaction

3 Power BI and Learning Outcome

3 Power BI and Learning Outcome

How to calculate age in Power BI/Power Query with a few clicks

How to calculate age in Power BI/Power Query with a few clicks

Power BI Grouping and Binning Explained

Power BI Grouping and Binning Explained

Using DAX CONCATENATEX to list values vertically in a Card Visual

Using DAX CONCATENATEX to list values vertically in a Card Visual

58. Wrap up

58. Wrap up

57. Using AVERAGE, MIN, MAX, LARGE and SMALL

57. Using AVERAGE, MIN, MAX, LARGE and SMALL

56. Using Autosum to save time

56. Using Autosum to save time

55. Adding up with SUM function

55. Adding up with SUM function

54. How to use Functions in Excel

54. How to use Functions in Excel

53. Introduction to Excel Functions

53. Introduction to Excel Functions

52. Writing simple formulas with primitive values

52. Writing simple formulas with primitive values

51. Introduction to Excel Formulas

51. Introduction to Excel Formulas

50. Text to column using Fixed Width

50. Text to column using Fixed Width

49. Text to Columns with Delimiters

49. Text to Columns with Delimiters

48. Create Dropdown Lists

48. Create Dropdown Lists

47. Intro to Data Validation

47. Intro to Data Validation

46. Using Flash Fill

46. Using Flash Fill

45. Fill Series based on Trends

45. Fill Series based on Trends

44. Filling Series using Linear and Growth Options

44. Filling Series using Linear and Growth Options

43. Fill Series with Fill Dialog box

43. Fill Series with Fill Dialog box

42. Intro to fill series and autofill

42. Intro to fill series and autofill

41. Using Outlines to Create Expand and Collapse button for data groups

41. Using Outlines to Create Expand and Collapse button for data groups

40. Keeping worksheet areas during scrolling with Freeze Panes

40. Keeping worksheet areas during scrolling with Freeze Panes

39. Using Advanced Filtering

39. Using Advanced Filtering

38. Using Rules Based Filtering

38. Using Rules Based Filtering

37. Clearing Filters and using Search for filtering

37. Clearing Filters and using Search for filtering

36. Intro to Filtering Data

36. Intro to Filtering Data

35. Advanced Sorting Options

35. Advanced Sorting Options

34. More sorting options

34. More sorting options

33. A better way to sort

33. A better way to sort

32. How sorting works when there is a space within the data

32. How sorting works when there is a space within the data

31. Basic Data Sorting

31. Basic Data Sorting

30. Intro to Sorting

30. Intro to Sorting

29 Formatting Cells Roundup Exercise

29 Formatting Cells Roundup Exercise

28. Customize Date Formats

28. Customize Date Formats

27. Custom Formatting Numbers and Text Behavior

27. Custom Formatting Numbers and Text Behavior

26. Customize Number Formatting 1

26. Customize Number Formatting 1

25. Intro to Numbers formatting

25. Intro to Numbers formatting

24. Intro to Cell Formatting 2

24. Intro to Cell Formatting 2

23. Intro to cell formats

23. Intro to cell formats

22. Dates are numbers

22. Dates are numbers

21. Excel Data Types

21. Excel Data Types

20 Increase Cell Size, Row Height and Column Width

20 Increase Cell Size, Row Height and Column Width

19 Intro to Cells

19 Intro to Cells

Step by Step Guide for Creating Complex Power BI Bookmarks

Step by Step Guide for Creating Complex Power BI Bookmarks

10. Paste with Options

10. Paste with Options

13. Move or Copy

13. Move or Copy

9. Intro to Copying and Pasting

9. Intro to Copying and Pasting

11. Using the paste options dialog box

11. Using the paste options dialog box

5. Peek into Excel Options

5. Peek into Excel Options

6. Save and Protect Workbook

6. Save and Protect Workbook

4. Understanding Excel Environment

4. Understanding Excel Environment

15. Find and Replace options

15. Find and Replace options

17. Find and replace unknown with question mark as wild card

17. Find and replace unknown with question mark as wild card

14. Intro to Find and Replace

14. Intro to Find and Replace

12. Pasting from the clip board

12. Pasting from the clip board

16. Find and Replace unknown with Asterisk as Wild Card

16. Find and Replace unknown with Asterisk as Wild Card

18. Find and Replace based on cell format

18. Find and Replace based on cell format

7. Navigate between worksheets

7. Navigate between worksheets

8. Navigate between Excel Workbooks

8. Navigate between Excel Workbooks

3. Excel Knowledge Overview

3. Excel Knowledge Overview

2. Prerequisites

2. Prerequisites

1.Introduction

1.Introduction

Use Power BI Without Work Email (Step by Step Guide)

Use Power BI Without Work Email (Step by Step Guide)

Power BI Case Study with Ahmed Oyelowo - Weird Calendars (Week Based Calendars)

Power BI Case Study with Ahmed Oyelowo - Weird Calendars (Week Based Calendars)

How to use Power BI New Formatting Pane. #powerbi #formattingpane

How to use Power BI New Formatting Pane. #powerbi #formattingpane

53.Understanding the RANKX function and technicalities

53.Understanding the RANKX function and technicalities

53.Adding a parameter table to make TopN Dynamic

53.Adding a parameter table to make TopN Dynamic

52.Calculating Top N measures with CALCULATE and TOPN function

52.Calculating Top N measures with CALCULATE and TOPN function

51.How TOPN function works

51.How TOPN function works

50.Creating Top N visuals with Filters Pane

50.Creating Top N visuals with Filters Pane

49.Expanding SAMPERIODLASTYEAR function with VALUES and DATEADD

49.Expanding SAMPERIODLASTYEAR function with VALUES and DATEADD

48.Calculating values for the same period in a previous year with SAMEPERIODLASTYEAR

48.Calculating values for the same period in a previous year with SAMEPERIODLASTYEAR

46. Expanding the DATESYTD function with FILTER, DATE and DATESBETWEEN

46. Expanding the DATESYTD function with FILTER, DATE and DATESBETWEEN

47. Using TOTALYTD to calculate Year to Date Values

47. Using TOTALYTD to calculate Year to Date Values

45.Calculating Year to Date values with CALCULATE and DATESYTD

45.Calculating Year to Date values with CALCULATE and DATESYTD

44. Expanding PREVIOUSMONTH function with VALUES and DATEADD

44. Expanding PREVIOUSMONTH function with VALUES and DATEADD

43.Expanding the PREVIOUSMONTH function 1

43.Expanding the PREVIOUSMONTH function 1

42. Calculating previous month values with PREVIOUSMONTH function

42. Calculating previous month values with PREVIOUSMONTH function

41.Setting up our table for Time Intelligence Reporting

41.Setting up our table for Time Intelligence Reporting

40.Creating and Sorting Month column with FORMAT and MONTH functions

40.Creating and Sorting Month column with FORMAT and MONTH functions

39.Using YEAR or FORMAT function to create Year Column

39.Using YEAR or FORMAT function to create Year Column

38. Using CALENDARAUTO function to generate a Date Table

38. Using CALENDARAUTO function to generate a Date Table

37. Overview of Time Intelligence in DAX

37. Overview of Time Intelligence in DAX

Append in Power Query without using Append Queries

Append in Power Query without using Append Queries

36. Activating filters between tables with CALCULATE and CROSSFILTER

36. Activating filters between tables with CALCULATE and CROSSFILTER

35.Understanding Variables

35.Understanding Variables

34.Understanding how ALL filters columns in DAX

34.Understanding how ALL filters columns in DAX

33.Using ALL function as a CALCULATE filter argument

33.Using ALL function as a CALCULATE filter argument

32. Understanding the 4 types of filtering

32. Understanding the 4 types of filtering