Akash Thele

About Akash Thele

Hi, I’m Akash — Data Analyst |Databricks |Power BI | SQL | Excel | Business IntelligenceAs a passionate Data Analyst, I specialize in transforming raw data into meaningful insights and actionable business solutions. With experience spanning pharmacy support systems and enterprise-level reporting for sales, I bring a unique blend of technical proficiency and business understanding to every project. What I Do: Design Centralized Dashboards: Unified 5+ disconnected reports into one Power BI model (Live + Import) — delivering centralized insights to stakeholders for faster, smarter decisions. Advanced Data Modeling & DAX: Created dynamic slicers, KPIs and handled composite model limitations — enabling flexible, self-service analytics. Secure Reporting with RLS: Implemented Row-Level Security (RLS) on hierarchical datasets and resolved OLE DB/ODBC errors for secure access control. SQL for Analytics: Built and optimized complex queries in Azure Databricks using joins, subqueries, and window functions (RANK, DENSE_RANK) to support ad hoc and scheduled reporting. Stakeholder Collaboration: Regularly collaborate with cross-functional teams to identify performance bottlenecks and uncover business insights — especially around degrowth indicators and sales effectiveness. Advanced Excel Workflows: Use Pivot Tables, VLOOKUP, Power Query, and conditional logic to clean, transform, and analyze large datasets with precision.🧰 Tools & Technologies:Power BI: Data Modeling,Data Cleaning,Powerbi Service ETL, DAX, RLS, Gateways, Bookmarks, Filters,Drill ThroughSQL (Databricks): Joins, Subqueries, Window Functions, Data ValidationExcel: Pivot Tables, Lookups, Power Query, Power PivotAzure Databricks | ServiceNow | PowerPoint | Wireframing🧠 Functional Areas:Data Cleaning & PreparationData Visualization & KPI DesignDashboarding & ReportingBusiness Intelligence StrategyData Analysis & InterpretationI’m always eager to learn and apply new tools in this ever-evolving field of data. Let’s connect if you’re looking to collaborate or discuss how data can solve real-world business problems! Email: a••••••••@gmail.com Open to Opportunities | Let\'s Explore Possibilities

Experience

1. Data Analyst

   Cyient

   Jan 2025 — Present

   Power BI DevelopmentWorked on enhancing existing dashboards by adding interactive features such as slicers based on employees\' joining dates and implementing Row-Level Security (RLS) on hierarchical data.Performed data modeling to integrate five separate dashboards into a single unified model. Resolved various reporting errors, including OLE DB/ODBC connectivity issues.SQL (Databricks)Developed complex SQL queries involving joins, analytical functions, subqueries, and window functions (e.g, RANK) to validate data with powerbi dashboard and generate ad hoc reports from multiple tables.Advanced ExcelUtilized tools like Pivot Tables, VLOOKUP, SUMIF, and various Excel functions to extract and analyze data efficiently.Data AnalysisTransformed raw data into standardized, easy-to-understand formats to support data-driven decision-making and improve operational clarity.Stakeholders:Regularly conduct meetings with internal stakeholders to discuss business concerns such as degrowth indicators. Collaborate with cross-functional teams to understand potential root causes and validate these concerns using data-driven insights. Leverage Power BI to investigate trends, analyze key performance metrics, and provide actionable reports that support informed decision-making and strategic planning.

Education

• Prof. Ram Meghe Institute of Technology & Research

  Bachelor of Engineering - BE