• Cleaning the data in the power Query editor and load into the desktop to perform the visualisation.
• Develop dashboards and reports using Power BI to provide insights and
recommendations to stakeholders.
• Connecting Power BI with Database and Developing dashboard using DAX
Queries like YTD, QTD, MTD and Calculate etc.
• Comparison with previous day / Previous month and identify the growth day by day / month on month
• Using Variables writing the DAX Queries. Variables can improve performance,
reliability, readability, and reduce complexity.
• SQL Development – Writing Queries to develop reports on Business requirement.