Data Analyst with 4+ years of IT experience in Microsoft Business Intelligence tools like
Power BI and SQL Server.
- Expertise in Data Profiling, Data Analysis and developing various reports and dashboards and publishing them using with Power BI Tool.
- Good experience in all phases of report development like requirements gathering, design,
development, testing and support.
- Good knowledge in Data Warehousing concepts.
- Involved in importing data from various data sources like Azure SQL Server, SQL Server,
Oracle, SharePoint, Snowflake, Excel files into Power BI.
- Worked with various connectivity modes like Import, Direct Query and Live connection.
- Expertise in working with various kinds of data massaging activities like Split columns,
Conditional columns creations, data formatting, data type conversions, categorizing columns etc.
- Having good experience in using Power Query Editor, Power Pivot and Power View for creating the effective reports and dashboards in Power BI.
- Involved in Grouping operations, Merge Queries, Append Queries for improving performance of the reports.
- Good knowledge in data warehousing concepts like star schema and snowflake schema.
- Expertise in developing various data models by building the relationships among the tables imported from multiple sources for effective data visualization.
- Experience on enabling various types of filters like visual level, page level and report level filters for the reports.
- Used DAX expressions like Logical, Aggregate, and Time Intelligence & Date Functions to create business calculations according to the given specifications.
- Worked on visual interactions using Edit Interactions, Bookmarks, Slicers and maintained
Zed order using Selection pane.
- Worked on multiple Custom Visualizations like Sunburst chart, Tachometer, 3D Donut chart etc.
- Expertise in using Row Level Security (RLS) for the reports to provide data security.
- Good experience in publishing reports, workspace management, Dataflows, Apps creation,
Gateway configuration, scheduling the report refresh and Access management in Power BI
Service.
- Good experience in writing SQL Queries to pull the data.
