JD-Data Visualization PBI skills:Overall Experience : Data and Data visualization 8 to 10 years minimum with 5 years minimum in Power BIDatabase Key Skills :Handson experience with T-SQL code for creating Stored Procedure, functions, and handling data validations.Performance Monitoring using execution plans and Index tuning Designed and Developed Database Objects like Tables, Stored Procedures, user defined data types and functions for theproject.Developed, tested, and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.Sound Knowledge of Data Modeling, with exposure to Dimensions, FACTS and DWH and ability to understand the DATA Model to be build for Power BI Data VisualizationStrong IT experience in Database Design, Development, and business intelligence of Microsoft SQL Server 2016/2012Experience in working with Data Models, relationship management.Creating virtual / physical relationships and indexes on requirement basis and sound exposure to ER and cardinality in Data Model and DWHCreate and document design documents.Provide mapping from requirements to test case execution to show test coverage and results.Exposure to SQL query Execution Plan and SQL Profiler for performance tuning of Data.Data Visualization PBI skills:Handson experience with Power BI desktop Dashboard and Report development with sound formatting and navigation SkillsStrong aptitude for Power BI architecture and its integration with embedded application and Security features along with deep exposure to Power BI Pro and Premium capabilities and AppsExpertise in DAX (Data Analysis Expressions) for creating custom calculations in Power BI is crucial. Work with Query Editor and troubleshooting DAX formulae for performance optimization.Responsible for developing visual reports, KPI scorecards, and dashboards using Power BI desktopShould have analytical thinking for translating data into informative reports and visualsSound knowledge in Power BI report development and administration.Sound knowledge DAX and Role based security along with integration using Power Automate for workflows.Should have analytical thinking for translating data into informative reports and visualsTroubleshoot data-related issues, maintain the Power BI infrastructure, and use the latest Power BI features, updates, and best practices.Exposure to Power BI gateway, content pack, advance and recent features of Power BI embedding using REST APIWork with Multiple Data sources and knowledge of selection of import, Live connection, and direct query data importingDesign & develop reports with corresponding dashboards to monitor the performance and effectiveness of finance / investment systems and to provide actionable insights for business users.Exposure to Power BI Pro and Premium capacity features.Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.Additional Skills:Ability to showcase good communication with Client and stakeholder.Sound Understanding of requirement and showcase ability to work and self-explore on new topics and implement.
