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