Strong Excel and dashboarding skills, with extensive experience in the following:
✓ Excel Spreadsheet Formulas, Charts and Pivot Tables
✓ VBA for Macros, User-Forms, reporting and database interaction
✓ Reports & Dashboard Design with Excel, PowerPivot and Power BI
✓ Advanced DAX formulas for PowerPivot / Power BI Data Models / SSAS Tabular
✓ Advanced data mashup using Power Query 'M' formula language
✓ Database design and implementation with MS Access with strong SQL background
*** 4 yrs Experience as an Excel / PowerPivot / Power BI Data Analyst. Major accomplishments include:
2020欧洲杯体育投注平台 - Automation of data analysis periodic reports...
I'm a software engineer specialized in T-SQL development, database design, and stored procedure optimization.
Over the last 18 years, I have developed a wide range of software applications by using Microsoft Technology such as ASP.Net, VB.Net, C#.Net, VBA (Access and Excel macro programming), VB 6.0, MS SQL Server from version 2000 to 2016.
14+ year’s solid MS SQL and .NET development experience in complex environments/projects
8+ years of experience with Microsoft Structured Query Language (MSSQL) Server 2008+, SQL Server Reporting Service (SSRS), SSIS and SSAS
4+ years of experience with developing, designing,...
I design and develop databases, present data with stunning visualisations to easily get the big picture, and perform deep dive analysis to make key decisions.
I am an US MSIT+MBA Dual Degree Graduate with 12 years of work experience in Business Intelligence, Data Science, Business Analysis, Systems Implementation and Web Development
Fluent in English and expert in understanding your business requirements and identifying root cause of problems. Thus, I plan and execute the best course of action for your needs
2020欧洲杯体育投注平台 I make business recommendations to improve productivity or return on investment, due to my experience in various industries and...
2020欧洲杯体育投注平台 Financial analyst and advanced Microsoft Excel user. I have worked in finance for 10+ years in multiple industries including: employee benefits, investment banking, engineering, real estate and utilities. I have worked on creating dynamic dashboards (using both Excel and Power BI), pivot tables, advanced formulas (vlookup, embedded if statements, and etc.), and VBA Macros. I am also experienced in the use of other Microsoft Office applications including: Word, Power Point, Outlook, and OneNote.
A Microsoft Certified Solution Expert in Dynamics CRM with 10 years of experience in Microsoft Dynamics CRM implementations and extension in different business sectors like Manufacturing, Banking, Insurance.
My aim is to provide the best solution to my customer to fulfill their business requirement.
- Microsoft Dynamics CRM 365 CE
- Microsoft Dynamics CRM 2016
- Microsoft Dynamics CRM 2015
- Microsoft Dynamics CRM 2013
- Microsoft Dynamics CRM 2011
- Microsoft Dynamics CRM 4.0
- MCSE: Business Applications - Certified 2019
- MCSA: Dynamics 365 - Certified 2019
2020欧洲杯体育投注平台 - Exam 715: Microsoft...
Only the best Excel & Google solutions for your business!
Ph.D. in Mathematics and 10+ years of work in Excel and VBA development in IT & Programming, Database Development, Finance & Management.
Excel, VBA, Microsoft Power BI Data Visualization, Google Spreadsheet, Access, PowerPoint, Statistics.
Areas of expertise:
- Data Analysis: Sales databases in Excel, Power BI, Google, Access, SQL. Reporting. Development and support.
- Data Modeling: Big Data, Pivot & Power Pivot Tables & Charts, Power Queries, VBA.
- Data Visualization. Creating interactive dashboards, charts, user forms.
- Automation of routine processes in Excel and...
TO HELP YOU succeed in your endeavors is my end goal. Consider me your LEVERAGE to enable you to focus more on the crucial tasks in your business.
YOU can make use of my SHOPIFY and ECWID exposure to help you with your online shopping store chores.
YOU can rely on my POWERBI skills to transform your data into visuals to aid you in various business decisions.
YOU can tap on my PROJECT MANAGEMENT skills to ensure projects are successfully delivered from requirements to resolution. Trello, Evernote, Rally, Extraview are some of the useful tools I'm familiar with to monitor work items and progress.
YOU can make use of my natural...
I'm a Tableau professional and a Business Analyst
Experience in creating Dashboards with Tableau and Power BI. Creating complex reports.
Experience in preparing BRDs (Business Requirement Documents), supporting documents
containing the essential business elements, and detailed definitions
Experienced in maintaining all project tracking documents and producing status reports for the smooth delivery of the project.
Experience in facilitating Joint Requirement Planning (JRP) sessions with client and
Business User Groups, conducting Joint Application Development (JAD) sessions with IT
Database Tools : SQL Server Management...
Accomplished system & network administrator with 8 years of experience system support, managing server infrastructures
and data-centre operations. Effectively plan, install, configure and optimize the IT infrastructure
to consistently achieve high Availability and performance.
Known for having an extreme attention to detail, capable of thinking independently, exceptional analytical and problem solving
skills to identify, troubleshoot, and resolve root cause outages or performance issues.
Proven ability to create and deliver solutions tied to business growth, organizational development and systems/network
Spending too much time for raw data arrangement? Or your spreadsheets are still calculating? Or your reports are too washy?
The repeating tasks SHOULD be automated!
Do you need to transform a bunch of Excel, text or PDF files into the Application or MS Access Database with full-value interface and functionality? Or to develop the macro for MS Office - custom formula, data manipulator, complicated set of special actions? Or to create the infographics report or dashboard? Or to develop the annual report, presentation or a schedule set? Or to build an arbitrarily complex data structure, to organize all the required data communications and...
Google Analytics Advanced Integration by Senior Web Analytics Manager (Google Analytics IQ and Google Partners certified) with Software Engineer background. With excellent communication and self-management skills
My goal is to support Business and Marketing Teams with clean and correct data
📌 Responsible for tracking on all phases:
✔ Gather requirements and creating documentation
✔ Communication with marketing and developer teams
✔ Tracking implementation on Web and App platforms
✔ Manual and Automated testing of tracking on different devices
✔ Ongoing support for feature requests and troubleshooting
2020欧洲杯体育投注平台 📌 Web tracking...
2020欧洲杯体育投注平台 An out-of-the-box, make-it-happen strategist in the Power BI, Microsoft SQL Server, and SSRS technical space. Diverse background in writing, business intelligence, training, technical support, customer service, database development, and customized end-to-end report development. Experience in various fields including Healthcare, Education, Financial, and Real Estate. A proven successful leader on projects for both internal and external users that promote efficiency, data integrity, and user friendliness. A polished communicator able to bridge the gap between technical and non-technical resources.
- CFA Level III Candidate.
- QuickBooks Online Advanced Certified ProAdvisor
I believe that the resources within your company can be allocated at the lowest cost and the greatest return to create value for your business.
What I can do for you:
- Work closely with you to prepare the company's Balance Sheet and P&L budget.
- Monitor and control operating expenses – analyze monthly/quarterly results, review variances to budget and last year’s performance and assist you with explanations and establishing course of action.
- Publish the monthly forecast of the Balance Sheet and P&L for your business.
2020欧洲杯体育投注平台 - Provide KPIs and their...
You've got a love-hate relationship with excel. You love the power it brings but hate the time needed to harness that power. That's where I come in. Through automation and a few tricks up my sleeve, we can erase the "hate" half of your relationship.
Whether its merging spreadsheets or creating a custom VBA application, I relish in the challenge of Excel. I'd love to partner with you today to build solutions that fit your business needs.
Microsoft Certified Professional - MCSA: BI Reporting.
Do you want to get more insights from your data? Are you looking to implement data-driven culture within your organisation? If your answer is yes, I am here to help you.
I have more than 14 years of experience in finance and data analytics. My core competencies include financial and data strategy, business intelligence, data audits, data modelling, data analysis and data visualisations.
What I can do:
- Audit your existing data systems and suggest areas for improvements.
- Implement new data strategy within your company which includes identifying the business questions you would...
I am an accountant by profession and an MS Excel & Power BI Expert with a vast experience in designing and implementing dynamic reports & innovative dashboards. Over the last 7 years, I had the opportunity to help clients across different sectors; this has given me unique insight into business operations. My core competency lies in identifying problems/bottlenecks in business and providing the most effective solutions.
My key skill areas are Business Consulting, Data Visualization, Designing Intuitive Dashboards & Interactive Financial Models using Microsoft Excel, QuickBooks, Power BI and other opensource tools.
My advanced Microsoft...
I have a BSc (Honours) degree, with majors in Computer Science and Applied Mathematics. I have had Upwork Top Rated status for more than 5 years, and I have an Upwork Job Success Score that is 100% after more than 50 jobs and 7 years full-time. I am a Certified Microsoft Professional in the field of Data Science.
I have real technical skills, such as Python, ML & Deep Learning, Power BI, Excel, Tableau, VBA, SQL, Mongo and PHP, and I am certainly not afraid of getting my hands dirty, but I also like (and am able) to operate on a higher level, to see a project or requirement through from concept to completion in the most elegant and...
I am Microsoft Certified Professional. Be free to check my detailed list of certificates in Certifications section.
My professional experience with Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central covers more than 6 years. I'm specializing on supply chain management (distribution, warehousing, manufacturing, replenishment) and retail (LS Nav, LS Hospitality, LS Forecourt from LS Retail). I also experienced in integration of Microsoft Dynamics NAV with other systems (Magento, InforWM, custom web apps etc.). Please do not hesitate to contact me to discuss your upcoming implementation project or desired modifications. I...
I'm Power BI & Excel consultant, certified as MSFT Data Scientist, with 18 years of experience in using and creating solutions needed to manage time, money and people.
I work on powerful computer / server so my work is more time efficient.
For more info please check my personal web site www_pbiexpert_com.
Contact me for:
• Power BI
• Power Pivot
• Power Query
• Power Apps
• Power Automate
• DAX language
• M language
• UiPath RPA
• Azure Machine Learning
• Office 365 (Excel, Word, Power Point, Visio, Project, Flow, ...)
With over 21 years of experience in the public and private sector, I bring a vast spectrum of experience from many platforms and technologies. I started my career doing web development for several years and migrated into data warehousing, reporting, data management, data automation, and pretty much anything you can think of that deals with data.
2020欧洲杯体育投注平台 The Microsoft SQL Server BI Stack is my wheelhouse. I specialize in architecture specific to client business goals and budget using tools like Microsoft Azure SQL, Azure Data Factory, XPlenty, SQL Server, SSIS, SSAS, SSRS, Power BI, and more. I strive to create strong partnerships with clients so...
Summary of Qualifications:
• Expert in Fishbowl Inventory Report customization
• Ten years of accumulated talent and professional experience in PHP (Laravel and Codeigniter), Java, MySQL, Oracle, MS SQL, Firebird and Jasper iReport
• Excellent in creating stored procedures, functions, view and triggers
• Skilled in hardware operating systems and network procedures
• Exceptional history with content management relational databases systems and web development and web services
• Extensive knowledge of CSS/HTML jQuery, Joomla, WordPress, etc.
2020欧洲杯体育投注平台 • Strong analytical skills and attention to...
100% job success score.
SAP Business One|SAP ByDesign|SAP ECC Application Expert with more than 15 years of experience in design, configuration, writing functional specifications. Advanced knowledge of implementations, development and system configuration through the entire life cycle, from project preparation to Go live and Support.
- Software Integration (EDI, eCommerce, POS, WMS, iOS, Microsoft Dynamics CRM, MS Office, Sharepoint, Magento, Shopify, BigCommerce, Salesforce, UPS, FedEx, TaskCentre, Hubspot, 3PL).
- Custom addons (SAP B1 SDK, DI API, UI, Server DI, B1i integration framework(B1if), C#, VB.NET, REST API)
I've been working with MS SQL for more than 17 years and my core competency lies in SQL Server performance tuning/optimization. I've helped many customers with designing and developing high performing and scalable BI systems, based on MS SQL, SSIS, SSAS and SSRS.
I also have strong skills in Microsoft Cloud and Big Data technologies, including Azure SQL, Azure Data Warehouse, Azure Data Lakes, Azure Data Factory, Event Hubs, IoT, Stream Analytics.
Lastly, I have a good understanding of predictive and statistical analysis and hands-on skills on Machine learning, R and Python
Good customer service is key for me, and no...
I am a hardworking, dedicated, passionate individual with over 17 years of corporate experience working extensively with all Microsoft Office products. I have built numerous automated Excel-based dashboards throughout my professional career where I was fortunate enough to work for two different leading financial institutions. I now operate my own Excel/Microsoft Office based business using the skills I've learned from the corporate world, and I would love to discuss the requirements of your project to see if I would be a good fit.
I enjoy automating tasks in Excel for clients using complex functions, formulas and basic VBA coding....
"Work with David was excellent. He knows his stuff!""
I've been helping businesses large and small gain insights from their data for over 20 years.
2020欧洲杯体育投注平台 I enjoy pushing technical limits, solving difficult problems, writing clean, efficient queries and building intuitive and beautiful data visualizations for my clients.
I am a qualified Chartered Accountant with over 10 years experience working with a variety of businesses big & small. I utilise the latest in technology solutions and marry this with the innovative business processes to support it.
I have extensive experience setting-up and using Xero including bank reconciling, payroll, invoicing and much more.
- Xero set-up & conversion
- Business Advisory & Improvement
- Business Analytics
I offer quick turnarounds and constant communication with the clients I work with. Get in touch today!
I have been working for the last 6 years on different Business Intelligence projects with the full Microsoft BI suite.
I have experience in all the phases of the data life cycle.
On ETL processes extracting information from very different sources (MySql, Sql Server, different file formats...), on managing DBs on SQL server, and on showing the data to final customers through several tools (Reporting Services, Power BI, Power view, Powerpivot...)
Building Analysis Services cubes are other of the tasks I have been working on (SSAS).
2020欧洲杯体育投注平台 I really enjoy BI, and I'm looking for small challenging projects.