Expertise in SQL Server Analysis Services (SSAS Tabular Model) and SQL Server Reporting Services(Power BI) with good knowledge on SQL Server Managements Studio(SSMS)
Hands on experience in Creating Star Schema and Snow Flake Schemas. Sound Experience and understanding of SSAS, OLAP cube and Architecture.
Practical understanding of data modeling (dimensional and relational) concepts like star-schema modeling, snowflake schema modeling, and fact and dimension tables.
Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
Applied transform rules Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.
Created Custom columns and Conditional Columns in the Power BI using Power Query
Created various measures and columns in Power BI Modeling using Data Analysis Expression
Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals….etc.).
Published reports to the Power BI Online.