Power Bi Developer

Data Analytics Bangalore, Karnataka, India

Profile
Contacts

Summary

Having 3.8years of professional experience in the IT Industry and I have worked on Microsoft Power Bi, SQL server, SSIS and Power Apps.
Having Experience in importing data from various sources into Power Bi like SQL Server, CSV Files, and MS Excel by using Import Direct, and Live connections.
Experience in creating Append and Merge Queries, Duplicate and Reference tables in Power Query.
Data modeling in Creating a relationship between the different tables like one to one, many to one, one to many.
DAX (Data Analysis Expression) functions to create Tables, Columns, and Measures
Expert in Data Warehouse concepts like Star Schema, Snow Flake, Dimension, and Fact Tables.
Good Knowledge of DAX expressions like filters, Aggregate and time intelligence, etc.
Creating different visualizations like Line charts, Bar charts, Treemap, Card, Multi-card, Table, Area charts, Pie charts, maps, slicers, etc.
Experience in different filters like drill down & drill through.
Creating Hierarchies and implementing Hierarchy filters in reports.
Creating bookmarks and providing actions, enabling toggle buttons and sync slicers to interact with reports.
Worked on all kinds of reports such as Yearly, Quarterly, Monthly, and Daily Knowledge on implementation of row-level security (RLS) as part of security.
Knowing of Data Source Settings, Workspaces, publishing Reports to Power BI Services, and setting up the necessary connection details and Scheduling.
Experience in writing SQL Functions like Aggregation Functions, and Date Functions.
Experience in the implementation of Common Table Expressions (CTE), implementation of Rank Functions, Stored procedures, and creating Indexes and views using SQL.