We are maintaining the Data warehouse for a gaming company. We are extracting data from different data sources and applying business logics and BI Intelligence to prepare reports and dashboards for the business perusal.Roles & Responsibilities:• Connecting to data sources, importing data and transforming data for Business Intelligence.• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.• As per the… Show more We are maintaining the Data warehouse for a gaming company. We are extracting data from different data sources and applying business logics and BI Intelligence to prepare reports and dashboards for the business perusal.Roles & Responsibilities:• Connecting to data sources, importing data and transforming data for Business Intelligence.• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.• As per the Client requirements, rendering the reports in the form of.PDF,.CSV and Excel formats.• Knowledge and experience in prototyping, designing, and requirement analysis.• Developed visual reports, dashboards and KPI scorecards using Power BI desktop.• Worked on Import and Direct Query data connection modes in Power Bi and Created Relationships between the two different data sources by using Joins.• Able to implement Row level security on data and have an understanding of application security layer models in Power BI• Created using advance level calculations on the data set and Responsible for design methodology and project documentation.• Worked on all types of transformations that are available in Power bi query editor.• Scheduled Automatic refresh and scheduling refresh in power bi service.• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Show less

Whole Foods Market is the world's largest natural foods grocery chain. Founded in 1980, it pioneered the supermarket concept in natural and organic foods retailing. The company operates some 500 stores throughout the US, Canada, and the UK, and focuses on organic perishable and prepared products. It sells private-label items through its 365 Organic Everyday Value and Allegro Coffee lines, among others, and offers a variety of non-GMO, vegan, and gluten-free foods. Whole Foods was acquired by… Show more Whole Foods Market is the world's largest natural foods grocery chain. Founded in 1980, it pioneered the supermarket concept in natural and organic foods retailing. The company operates some 500 stores throughout the US, Canada, and the UK, and focuses on organic perishable and prepared products. It sells private-label items through its 365 Organic Everyday Value and Allegro Coffee lines, among others, and offers a variety of non-GMO, vegan, and gluten-free foods. Whole Foods was acquired by Amazon.com for $13.7 billion in 2017.Roles & Responsibilities:• Created various measures, columns to extract and analyze the data as per the Client Requirements to compare the Revenues, Transactions and Returns.• Performed Appending to get the complete data from various sources.• Used DAX Functions to get MOM Growth, MOM Growth%.• Getting the Top Growing Products, Top Performing Customers by Country.• Getting the Anchor Dates and Date wise Moving Total Sales, Running Total Sales.• Created various Visualizations, Dashboards with Slicers to Add the Required Interactivity.• Used Various Shapes, Images to Create and add the Interactivity between Multiple Pages.• Performed the Unit Testing to Validate the Reports.• Published that Reports into Power BI Service and Schedule the Data Sets, Data Flows with the help of Gateways at the Power BI Service.• Created Apps and publishing Datasets, Reports, Dashboards through Apps.• Added the Row-level security (RLS) at Power BI Desktop Level and Power BI Service level Show less