Mahendra Kande

Data Analyst with 4+ years of IT experience in Microsoft Business Intelligence tools like

Power BI and SQL Server.

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.

• B.Sc. computer science