I'm a data enthusiast specializing in Power BI, SQL, and Excel. With a knack for transforming raw data into actionable insights, I thrive on leveraging technology to drive informed decisions and business growth.
The "Gallons By Territory" report for NOCO focuses on analyzing the distribution of fuel across various territories within the company's operational scope. It provides detailed insights into the volume of fuel consumed in each territory, allowing stakeholders to assess consumption patterns and trends effectively. By examining the gallons of fuel used per territory, the report aids in optimizing fuel allocation strategies and identifying potential areas for improvement in fuel management practices. This information empowers NOCO to make data-driven decisions aimed at enhancing operational efficiency, reducing costs, and ensuring optimal utilization of resources across territories. Ultimately, the report plays a vital role in supporting NOCO's efforts to manage its fuel resources effectively and drive sustainable business growth
Roles and Responsibilities
Creating dashboards by connecting to the SQL Server, flat files in Power BI. Extensively used DAX to achieve different functionalities within the visuals. Publish reports in Power BI Report server environment. Controlling the access for users by implementing role level security and managing the admin activities of report server. Involved in fixing the change requests for the application developed. Creating Staging Database for temporary Processing of data, consolidating data and Loading database using Integration Services. Developed Stored Procedures and views. Used Control flow tasks like for loop container, execute SQL task and data flow task, extensively used derived column, data conversion and aggregate. As per the requirements, rendering the reports in the form of Excel and .csv formats for each module with credentials. Created transformations and mappings using data flow tasks. Also, created event handlers for the package using Event Handler Tab.
Technologies: Power Bi
Industry: Oil and Gas
Operations Dashboard
September-2023 to December-2023
Description
Designed and developed an Operations Dashboard for NOCO, offering insights into fuel delivery operations. Tracked deliveries, Point of Deliveries (PODs), and key metrics for real-time monitoring. Incorporated interactive visualizations and KPIs for analyzing delivery performance and driver efficiency. Implemented year-on-year comparisons to identify trends and areas for improvement. Contributed to enhanced delivery processes and customer service through data-driven decision-making.
Roles and Responsibilities
Developed complex DAX logic for the report to achieve various functionalities within Power BI visuals. Implemented efficient data processing by migrating complex logic from Power BI Desktop to SQL Server. Created Common Table Expressions (CTEs) and temporary tables in SQL for optimal data manipulation and storage. Designed and developed stored procedures in SQL Server to encapsulate data processing logic. Scheduled SQL jobs to automate the execution of data processing tasks. Ensured data security and access control by implementing role-level security in Power BI. Managed administrative activities for the Power BI Report Server environment. Resolved change requests and addressed issues related to the application development.