• Understand the business problem from Clients perspective, provide an analytical approach utilising Power BI tools to resolve the issue at hand and further action
• Identify business requirements and design data models to transform raw data into meaningful insights
• Create relationships between multiple data sources and develop data models accordingly
• Provide reporting, including mapping out complex data structures, and writing DAX measures
• Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
• Develop Dashboards using Growth rate calculations (YTD, MTD and YOY etc…)
• Design, build and deploy, publish data analysis reports/dashboards for large volumes of data
• Extract data from non-database sources (XLS, CSV file), Database sources (SQL Server), Snowflake
• Advance charts, interactive visual reports and complex calculations to manipulate the data as per business need through Power BI
• Automatic refresh and scheduling refresh in Power BI service
• Dataflows, Datamarts