Prathyusha Rudraraju

• Designed and developed interactive Power BI dashboards to visualize KPIs and trends for business decision-making.
• Created data models (Star & Snowflake schema) with relationships, hierarchies, and calculated fields.
• Developed DAX measures for complex business calculations and time-based analytics.
• Used Power Query (M Language) for data transformation, cleansing, and ETL processes.
• Integrated Power BI with SQL Server, Azure SQL, SharePoint, Excel, and APIs for seamless data access.
• Implemented Row-Level Security (RLS) for role-based access control across departments.
• Optimized performance through query folding, aggregations, and incremental refresh.
• Published reports to Power BI Service, scheduled data refresh, and managed workspace permissions.
• Collaborated with stakeholders to gather requirements and translate them into actionable reports.
• Improved overall efficiency by automating manual reporting tasks through the development of dynamic BI tools.
• Improved data gathering, analysis, and visualization procedures with strategic optimizations.

Roles & Responsibilities:

• Assisted in dashboard creation for HR analytics, inventory management, and marketing campaigns.
• Wrote SQL scripts for data extraction, cleansing, and transformation.
• Designed interactive charts, slicers, and filters for user-driven analysis.
• Maintained documentation for datasets, models, and queries.
• Worked with the senior BI team to ensure data accuracy and consistency.

Real-Time Project: Sales & Revenue Performance Dashboard

• Created an interactive dashboard that visualized monthly revenue, top-performing products, and regional sales using SQL Server as the backend.
• Reduced manual report preparation time by 70% through automation.