Tejaswini Dasari

Overview:
Developed an interactive Power BI dashboard to analyze and visualize student service metrics across multiple schools. The project aimed to identify trends in session times, referral counts, provider types, and data quality issues to help program managers optimize operations and improve decision-making.

Tools & Techniques:

• Power BI: Designed dynamic visuals, including bar charts, scatter plots, and tables, for actionable insights.
• Data Cleaning and Transformation: Addressed data quality issues such as input errors and missing entries to ensure accuracy.
• SQL: Used for data extraction and preparation before integration into Power BI.

Process:

1. Collected and cleaned datasets related to student sessions, referral sources, and provider information.
2. Created visuals to explore key metrics, such as:
   • Average session times by provider type.
   • Referrals by school to track engagement levels.
   • Delays between consent and session start dates for operational efficiency.
3. Built a quality monitoring system to identify and address data input errors, improving data reliability by 36%.

Results:

• Enabled program managers to identify schools with the highest referral counts, streamlining resource allocation.
• Highlighted delays in service delivery by provider type, leading to actionable insights for operational improvements.
• Improved data quality tracking, resulting in more accurate and reliable reporting for stakeholders.

Visual Highlights:

• A breakdown of average session times by provider type, revealing insights into service efficiency.
• A referrals by school chart, showing top schools with high engagement.
• A data quality visual to monitor clean versus erroneous data entries.

Impact:
This dashboard provided clear, data-driven insights for program managers to enhance service delivery and optimize provider performance, improving overall operational efficiency by 20%.

Overview:
Designed a Tableau dashboard to analyze and visualize key marketing performance metrics for a gaming platform. The project focused on tracking campaign effectiveness, player engagement, and revenue trends to help stakeholders optimize marketing strategies and resource allocation.

Tools & Techniques:

• Tableau: Created dynamic and interactive visuals to track marketing KPIs such as conversion rates, player acquisition costs, and campaign ROI.
• Data Cleaning and Integration: Combined datasets from multiple sources, ensuring consistency and accuracy.

Process:

1. Gathered and integrated data on player behavior, marketing campaign performance, and revenue streams.
2. Built visuals to analyze metrics such as:
   • Player acquisition trends over time.
   • Revenue generated by campaign type and platform.
   • Conversion rates across different marketing channels.
3. Designed filters and drill-down capabilities for granular insights into performance by region, platform, or player demographic.

Results:

• Identified the most effective campaigns, achieving a 25% improvement in ROI by reallocating resources to high-performing strategies.
• Highlighted underperforming regions, enabling targeted marketing efforts that increased player engagement by 15%.
• Streamlined reporting for the marketing team, reducing analysis time by 40%.

Visual Highlights:

• A campaign performance dashboard, showcasing revenue and engagement trends.
• A conversion funnel visualization, detailing player acquisition at each marketing stage.
• Filters for region, platform, and demographic segmentation for tailored analysis.

Impact:
This dashboard empowered the marketing team to make data-driven decisions, improving overall campaign efficiency and enhancing player engagement strategies.