ABOUT US
We would like to introduce our self as a Service Provider for Microsoft Office – Microsoft Office Excel and Microsoft Office Access.
Worked/Working as "Data/Reporting Analyst (Microsoft Excel Expert) with "Top Canadian Banks (As Independent Contractor), please see our Public Profile on "linkedin" (https://ca.linkedin.com/pub/anand-chokshi/6b/ab7/88).
Our qualifications in the same are as under:
(1) Microsoft Certified Excel Specialist (2007);
(2) Microsoft Certified Excel Expert (2007);
(3) Microsoft Certified Access Specialist 2010 (with 100% result);
(4) Microsoft Certified Access Specialist 2007;
Our specialization in "Microsoft Excel" include following :
1. Advanced User of Pivot Table (Million/Billion Rows of Data);
2. Advanced Pivot Charts/Graphs/Data Visualization, Metrics, KPI, KRI, Operational Dashboard, Hierarchy;
3. Macros/VBA programing in Excel;
4. Advanced & Complex Formulas (including vlookup, What-If-Analysis, Scenario Manager ect.);
5. Data Modelling, Data Mining and Analysis in Excel;
6. Integrating Excel with SQL for creating queries ;
7. Can create complete “Self-Serve Power Business Intelligence” in Excel for Getting the Data (Through Power Query), Transforming the Data (Through Power Pivot), Create Reports & Visualization (Through Power View & Power Map) & Share with End User on SharePoint in Excel 2013;
8. Can Convert Million/Billions Rows of Big Data into easily understandable Reports, Charts/Graphs, Metrics, “LIVE Operational Dashboard” for easy Business Decision making process for executives;
9. ENTERPRISE DATABASES: Can create advanced SQL queries in Excel through Microsoft Queries/Power Queries to bring External Data from Enterprise Databases like Microsoft SQL Server, ORACLE, IBM DB2, MySQL, Sybase, Teradata, Microsoft Analysis Services Cubes, Salesforce objects, Hadoop files etc;
10. DATA MINING : Can Run “Excel Data Mining” Add-on for Forecasting, Using Prediction Calculator, Analyze Key Influencer, Scenario Analysis, Highlighting Exception, Detecting categories, ect;
11. Can use Microsoft Excel as “Relational Database” (by using Microsoft Query/TSQL) - to extract data from multiple of DATA sources like SQL Server, Access Database, Text/Excel File/Others by writing queries in SQL (Structured Query Language);
Worked/Working as "Data/Reporting Analyst (Microsoft Excel Expert) with "Top Canadian Banks (As Independent Contractor), please see our Public Profile on "linkedin" (https://ca.linkedin.com/pub/anand-chokshi/6b/ab7/88).
Our qualifications in the same are as under:
(1) Microsoft Certified Excel Specialist (2007);
(2) Microsoft Certified Excel Expert (2007);
(3) Microsoft Certified Access Specialist 2010 (with 100% result);
(4) Microsoft Certified Access Specialist 2007;
Our specialization in "Microsoft Excel" include following :
1. Advanced User of Pivot Table (Million/Billion Rows of Data);
2. Advanced Pivot Charts/Graphs/Data Visualization, Metrics, KPI, KRI, Operational Dashboard, Hierarchy;
3. Macros/VBA programing in Excel;
4. Advanced & Complex Formulas (including vlookup, What-If-Analysis, Scenario Manager ect.);
5. Data Modelling, Data Mining and Analysis in Excel;
6. Integrating Excel with SQL for creating queries ;
7. Can create complete “Self-Serve Power Business Intelligence” in Excel for Getting the Data (Through Power Query), Transforming the Data (Through Power Pivot), Create Reports & Visualization (Through Power View & Power Map) & Share with End User on SharePoint in Excel 2013;
8. Can Convert Million/Billions Rows of Big Data into easily understandable Reports, Charts/Graphs, Metrics, “LIVE Operational Dashboard” for easy Business Decision making process for executives;
9. ENTERPRISE DATABASES: Can create advanced SQL queries in Excel through Microsoft Queries/Power Queries to bring External Data from Enterprise Databases like Microsoft SQL Server, ORACLE, IBM DB2, MySQL, Sybase, Teradata, Microsoft Analysis Services Cubes, Salesforce objects, Hadoop files etc;
10. DATA MINING : Can Run “Excel Data Mining” Add-on for Forecasting, Using Prediction Calculator, Analyze Key Influencer, Scenario Analysis, Highlighting Exception, Detecting categories, ect;
11. Can use Microsoft Excel as “Relational Database” (by using Microsoft Query/TSQL) - to extract data from multiple of DATA sources like SQL Server, Access Database, Text/Excel File/Others by writing queries in SQL (Structured Query Language);