Lead Consultant_Power BI & SQL_Bangalore location_Immediate joiners

Job Description

Role & responsibilities Create interactive and visually appealing dashboards and reports using Power BI. Design and implement Data Models utilizing Dax for calculations and analysis Connect to various Data Sources, clean, and transform data for use in Power BI reports and Dashboards. Analyze datasets to uncover trends, insights and key performance indicators Troubleshoot and optimize Power BI Solutions, ensuring Data Accuracy and integrity Preferred candidate profile Proficiency in Power BI: Strong knowledge of Power BI Desktop and Power BI Service. Data Modelling: Experience in creating complex data models, including relationships, hierarchies, and calculated tables and columns. DAX (Data Analysis Expressions): Ability to write complex DAX formulas for data manipulation and analysis. Power Query: Expertise in using Power Query for data extraction, transformation, and loading. SQL: Proficiency in SQL for querying databases. Data Visualization: Skills in creating visually appealing and informative reports and dashboards. Model Optimization: Expertise in optimizing data models for performance, including techniques like reducing data size, efficient use of DAX. Integration: Knowledge of integrating Power BI with other tools and platforms (e.g., Power Apps, SharePoint). Security and Compliance: - Understanding of security best practices and compliance requirements - Row-Level Security (RLS): Experience in implementing RLS to restrict data access for specific users. - Object-Level Security (OLS): Experience in implementing OLS to control access to specific objects within the data model. Good To Have: Advanced Excel : Proficiency in advanced Excel functions and features. VBA (Visual Basic for Applications) : Ability to write and understand VBA code for automation and advanced Excel functionalities. Power Platform Tools : Experience with other Power Platform tools like Power Apps and Power Automate. O365 Platform Tools : Familiarity with Office 365 tools and their integration with Power BI. Project Management Tools : Experience with project management tools like Microsoft Project