Project 1:
Client : United ParcelServices.
Role : Power Bi Developer
Environment :Power BI Desktop, Power Bi Services, DAX, SQL server and Excel.
Description:
It is commonly referred as UPS and is an American package delivery company with global operations. Headquartered in Sandy Springs, Georgia, United States it was founded in Seattle in the year 1907. It is known to deliver over 15 million packages a day to 6.1 million customers in more than 220 countries around the world. Its courier express service is one of the best in the world.
Working on procurement to pay and vendor rationalization project which helps my client to save the working capital and revenue leakage.
Roles & Responsibilities:
❖ ImporteddatafromSQLServerDBtoPowerBI forgeneratingthereport
❖ Created DAX Queries to generated computed columns in PowerBI.
❖ Generated computed tables in Power BI by usingDAX.
❖ Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
❖ Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobileapps
❖ ExploredatainaVarietyofwaysandacrossmultiplevisualizations usingPowerBI
❖ Used Power BI Gateways to keep the dashboards and reports up todate.
❖ InstalledandConfiguredEnterpriseGatewayandPersonalGatewayinPowerBiServices.
❖ DesignanddevelopofreportingdatamoduleforCredit CardMarketingAnalytics.
❖ Developed Up-selling and Cross-selling reports using DAXfunctions.
❖ Creating Row level security with power bi and integration with power bi serviceportal.
❖ Developed profit analysis reports and dashboards by products andcustomers.
❖ Worked on all types oftransformations that are available in Power bi queryeditor.
❖ Scheduled Automatic refresh and scheduling refresh in power biservice.
❖ Developed analysis reports and visualization using DAX functions like table function, aggregation function and iterationfunctions.
Project 2:
Client : WinCo Foods
Role : Power bi Developer
Environment : Power BI, SQL Server, MS Excel, DAX
Description:
WinCo Foods is one of the leading Supermarkets in America in performing business intelligence operations in different locations across the globe. In order to analyse their business moment like different product sales trends, sales profits, regional sales, top N products sales information, they need a data warehouse system. We build the data warehouse system by capturing data from different transaction systems. Once data loaded into data mart, we generate data mart reports as per business request marts
Roles & Responsibilities:
❖ Extract and Load data from multiple data sources.
❖ Creating the data modelling in Power BI desktop.
❖ Flexible in working with filters/calculated columns/measures/relationships and transformations of edit Query section.
❖ Developing User Interactive reports using various visualization Objects
.
❖ Developing Customized Bar Charts for better understanding to the user. Working on the Power Bi reports and dashboards with SQL Server.
❖ Using table/matrix/bar/card/gauge/slicers and custom visualizations.
❖ Publishing and sharing the reports by creating content pack in Power BI Service, designing and developing the application as per the user's requirements.
❖ Implementing KPI's in the Main dashboard page for High Level Business Analysis.