Microsoft Power BI | Tableau | Data Visualization

DAX Functions Part-2 DAX Part-1: https://t.me/PowerBI_analyst/150 ### Table Manipulation Functions These functions perform operations on tables. Examples include: - ADDCOLUMNS: Adds calculated columns to a table.

  NewTable = ADDCOLUMNS(Sales, "DiscountedAmount", Sales[Amount] * 0.9)
  

- SUMMARIZE: Creates a summary table.

  SummaryTable = SUMMARIZE(Sales, Sales[ProductID], "TotalSales", SUM(Sales[Amount]))
  

### Text Functions Text functions perform operations on text strings. Examples include: - CONCATENATE: Joins two text strings into one.

  FullName = CONCATENATE(Employees[FirstName], Employees[LastName])
  

- LEFT: Returns the specified number of characters from the start of a text string.

  LeftPart = LEFT(Product[ProductName], 5)
  

- UPPER: Converts a text string to all uppercase letters.

  UpperCaseName = UPPER(Product[ProductName])
  

### Time Intelligence Functions Time intelligence functions work with time periods to create calculations over those periods. Examples include: - TOTALYTD: Calculates the year-to-date value of an expression.

  TotalSalesYTD = TOTALYTD(SUM(Sales[Amount]), Sales[OrderDate])
  

- SAMEPERIODLASTYEAR: Returns a table that contains a column of dates shifted one year back.

  LastYearSales = CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Sales[OrderDate]))
  

- DATESINPERIOD: Returns a table that contains a column of dates shifted by a specified interval.

  SalesLast30Days = CALCULATE(SUM(Sales[Amount]), DATESINPERIOD(Sales[OrderDate], LASTDATE(Sales[OrderDate]), -30, DAY))
  

Each of these functions serves a distinct purpose in data analysis within Power BI, enabling you to manipulate and analyze data in a variety of ways.

HOW TO LEARN POWER BI IN 2024 👇👇 🔺Get Familiar with Basics: Start by understanding the basics of Power BI, such as data sources, data modeling, and visualization concepts. 🔺Install Power BI Desktop: Download and install Power BI Desktop, the free version of Power BI, to begin creating reports and dashboards on your local machine. 🔺Explore Sample Data: Use sample datasets provided by Power BI to practice creating visualizations and getting comfortable with the interface. 🔺Learn Data Loading: Understand how to import data into Power BI from various sources, including Excel, databases, and online services. 🔺Data Transformation: Learn the process of cleaning and transforming data using Power Query to ensure it's suitable for analysis. 🔺Data Modeling: Grasp the fundamentals of data modeling, including relationships between tables, creating calculated columns, and measures. 🔺Create Visualizations: Practice creating different types of visualizations like charts, tables, and maps to represent your data effectively. 🔺Master DAX (Data Analysis Expressions): DAX is the formula language used in Power BI. Learn how to create calculated columns, measures, and calculated tables using DAX. 🔺Build Dashboards: Combine visualizations into interactive dashboards to convey insights effectively. Understand how to use filters and slicers. 🔺Publish to Power BI Service: Explore Power BI Service, where you can publish your reports and share them with others. Learn about collaboration features. 🔺Explore Advanced Features: Dive into advanced features like Power BI Apps, Power Automate integration, and Power BI Embedded for more sophisticated applications. 🔺Stay Updated: As Power BI is regularly updated, stay informed about new features and improvements. Join online communities or forums to connect with other Power BI users and learn from their experiences. 👀🧠Remember, consistent practice and real-world projects will enhance your skills. Utilize online resources, tutorials, and documentation provided by Microsoft to deepen your understanding.

🚀🚀BIG NEWS: Crypto Pros Predict 50x Potential for $BCCOIN! Why Invest in $BCCOIN? ✨World’s First Limitless Crypto Credit Card: No fees, limitless spending, and real crypto integration. ✨ Imminent Tier 1 Exchange Listings: Major listings soon, increasing visibility and demand. ✨ Explosive Growth Potential: Experts predict 50x returns in the next two weeks. ✨ $200M Joint Venture: Strong institutional interest and major partnerships on the horizon. ✨Last Call Before Big Launch: Major launch on WorldPress coming soon. Act now! How to Invest: 🔗Buy & Stake Now 🔗Buy in CEX 🔗Buy in DEX Join Our Community: Telegram Channel Audit Reports: - CertiK Audit - Hacken Audit Don't miss this revolutionary opportunity! 🚀💰

If you're looking to build a career in Data Analytics but feel unsure about where to start, this post is for you. It's important to know that you don't need to spend money on expensive courses to succeed in this field. Many posts you see on LinkedIn promoting paid courses are often shared by individuals who are either trying to sell their own products or are being compensated to endorse these courses. Through this post, I will share with you everything you need to start your data journey absolutely free. 🔗 Source Hope it helps :)

Power BI DAX Functions PART-1 ### Aggregation Functions Aggregation functions perform calculations on a set of values and return a single value. Common aggregation functions include: - SUM: Adds all the numbers in a column.

  TotalSales = SUM(Sales[Amount])
  

- AVERAGE: Calculates the average of numbers in a column.

  AverageSales = AVERAGE(Sales[Amount])
  

- MIN: Finds the minimum value in a column.

  MinSales = MIN(Sales[Amount])
  

- MAX: Finds the maximum value in a column.

  MaxSales = MAX(Sales[Amount])
  

### Date and Time Functions Date and time functions are used to manipulate dates and times. Examples include: - DATE: Returns a date in datetime format.

  DateValue = DATE(2023, 12, 31)
  

- TODAY: Returns the current date.

  CurrentDate = TODAY()
  

- YEAR: Returns the year from a date.

  YearValue = YEAR(Sales[OrderDate])
  

- DATEDIFF: Returns the difference between two dates.

  DateDifference = DATEDIFF(Sales[OrderDate], Sales[ShipDate], DAY)
  

### Filter Functions Filter functions allow you to manipulate data based on criteria. Examples include: - FILTER: Returns a table that represents a subset of another table.

  FilteredTable = FILTER(Sales, Sales[Amount] > 1000)
  

- ALL: Removes all filters from a column or table.

  AllSales = CALCULATE(SUM(Sales[Amount]), ALL(Sales))
  

- RELATED: Returns a related value from another table.

  RelatedValue = RELATED(Product[ProductName])
  

### Information Functions Information functions return information about the data type, value, or reference. Examples include: - ISBLANK: Checks if a value is blank.

  IsBlankCheck = ISBLANK(Sales[Amount])
  

- ISNUMBER: Checks if a value is a number.

  IsNumberCheck = ISNUMBER(Sales[Amount])
  

- ISERROR: Checks if a value is an error.

  IsErrorCheck = ISERROR(Sales[Amount] / Sales[Quantity])
  

### Logical Functions Logical functions return information based on logical tests. Examples include: - IF: Returns one value if a condition is true and another if false.

  Discount = IF(Sales[Amount] > 1000, 0.1, 0.05)
  

- AND: Checks if all arguments are true.

  AndCheck = AND(Sales[Amount] > 1000, Sales[Quantity] > 10)
  

- OR: Checks if any argument is true.

  OrCheck = OR(Sales[Amount] > 1000, Sales[Quantity] > 10)
  

### Math and Trig Functions These functions perform mathematical calculations. Examples include: - ABS: Returns the absolute value.

  AbsoluteValue = ABS(Sales[Amount])
  

- ROUND: Rounds a number to the specified number of digits.

  RoundedValue = ROUND(Sales[Amount], 2)
  

- POWER: Returns the result of a number raised to a power.

  PowerValue = POWER(Sales[Amount], 2)
  

### Parent and Child Functions Parent and child functions help in hierarchical data representation. Examples include: - PATH: Returns a delimited text string with the identifiers of all parents to the current identifier.

  Path = PATH(Employees[EmployeeID], Employees[ManagerID])
  

- PATHITEM: Returns the item at the specified position from a PATH result.

  PathItem = PATHITEM(Path, 2)
  

### Relationship Functions These functions work with relationships between tables. Examples include: - RELATED: Returns a related value from another table.

  RelatedValue = RELATED(Product[ProductName])
  

- RELATEDTABLE: Returns a table related to the current table.

  RelatedTable = RELATEDTABLE(Sales)

I have curated the best interview resources to crack Power BI Interviews 👇👇 https://topmate.io/analyst/866125 Hope you'll like it Like this post if you need more resources like this 👍❤️

📘 Free Power BI Course by Microsoft https://learn.microsoft.com/en-us/power-bi/

Added one amazing book called data visualisation made easy with these resources. Give me it a read whenever you get time ❤️