Versha A

Power Bi Developer

Freelancer.com • Freelance

Apr 2024 - Present • 2 yrs 1 mo

* Designed and developed highly interactive Power BI dashboards to track key business KPIs, enabling stakeholders to monitor performance and make data-driven decisions effectively. * Gathered business requirements from stakeholders and translated them into meaningful dashboard designs with a strong focus on usability, clarity, and actionable insights. * Transformed raw and unstructured data into meaningful insights using Power Query by implementing robust ETL (Extract, Transform, Load) processes. * Cleaned, reshaped, and standardized large datasets from multiple sources to ensure data consistency, accuracy, and reliability across reports. * Built optimized and scalable data models using star schema design, ensuring efficient data relationships and improved report performance. * Established proper relationships between tables, including one-to-many and many-to-one relationships, to ensure accurate data representation. * Created advanced DAX measures and calculated columns to support dynamic and complex reporting requirements. * Implemented time intelligence functions in DAX to analyze trends such as year-over-year growth, month-to-date performance, and rolling averages. * Improved dashboard and report performance by optimizing DAX queries, removing redundant calculations, and reducing data model size. * Applied best practices in data modeling and report design to ensure faster loading times and a seamless user experience. * Integrated multiple data sources such as SQL databases, Excel files, APIs, and cloud platforms into Power BI for unified reporting. * Developed automated data refresh processes to ensure real-time or near real-time reporting capabilities. * Automated reporting workflows, significantly reducing manual effort and improving operational efficiency across teams. * Published reports to Power BI Service and managed