It contains all my Power BI exercises work. **Exercise 4 contains below calculations: Here is a brief overview of the workflow for the task: **
- Review the data (fact_sales_Iphone14 and fact_sales_Iphone15).
- Metrics to compare - iPhone 14 sales and iPhone 15 sales.
- Calculate the variance (absolute difference value) between the iPhone 15 sales and iPhone 14 sales for the identified metrics. ABS([Iphone 15 Sales]-[Iphone 14 Sales]).
- Calculate the variance (in percentage) between the iPhone 15 sales and iPhone 14 sales for the identified metrics. [([Iphone 15 Sales]-[Iphone 14 Sales])/[Iphone 14 Sales].
- Provide a complete report of the difference in numbers between the iPhone 15 sales and iPhone 14 sales data across the top 10 countries.
Exercise 5 contains below tasks :
Objective: This assignment aims to enhance practical skills in using Power Query within Power BI for various data transformation tasks. You will work with bank dataset containing inconsistencies and errors. Your task is to identify these issues and use Power Query to rectify them, ensuring the data is clean, accurate, and well-structured for analysis.
Task assignment contains total 8 tasks.
**Exercise 6 Contains total 2 tasks **
Objective : This assignment aims to enhance practical skills in using DAX within Power BI to create measures and calculated columns using CALCULATE (), ALL (), ALLEXCEPT () DAX functions. You will work with sales dataset containing data on clothing and accessories.