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:
- 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
沙巴体育足球开户 I make business recommendations to improve productivity or return on investment, due to my experience in various industries and...
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
- 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
沙巴体育足球开户 📌 Web tracking...
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.
沙巴体育足球开户 - Provide KPIs and their...
I'm an experienced data analyst. I optimize sites, apps and ads campaigns, build dashboards, improve lead generation process, optimize a conversion rate, conduct ROI analysis, make analytics reports and much other.
I working with such analytical and marketing tools as:
Google Analytics, Google Tag Manager, Google Data Studio, Google Optimize, Firebase, Facebook Analytics (Facebook Pixel), Segment.сom, Microsoft Power BI, Tealium, Mailchimp, Expertsender, Activecampaign, Yandex Metrica, Leanplum, Amplitude, Adjust, Mixpanel, Woopra, Heap, Chameleon and many other similar systems for analyzing data from websites and mobile...
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...
A flexible and performance driven BI developer with over 8 years of extensive experience in developing Business Intelligence/DWH solution, Data Analysis, Transforming business requirements into technical and report developing.
I have strong knowledge of writing complex Stored Procedures for populating data from different source systems using T-SQL and SSIS packages. Experience in creating and managing number of Multi-dimensional and tabular Model SASS cubes. Having knowledge of implementing security on both Multi-dimensional and tabular cubes. I am working on MDX from continuously from last 4 years and developed strong knowledge for...
Top rated Upwork freelancer with ~3400 hours of working and 90% Job success out of 248 Jobs.
Prashant is a salt and pepper combination of an automated business Intelligence and Data Analytics with 10+ years’ experience. He began his career in Data Analytics, cut his analytical teeth with more than 200 clients on Upwork.
Over the last 10 years, I have developed 500+ Tools for my clients with the use of VBA code in Excel, Access at major financial centers, with the main focus in designing solutions, an automation and process improvement. Roles include anything from small macros to complex VBA applications for major projects.
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...
If you need excellent Excel spreadsheet, tracker, planner, calculator, dashboard, report, scheduler, pivot table or you just want simple data entry form, I am right person for you.
Beside Excel I can offer professional service in Word and PowerPoint as well
My professionalism is based at 15 years of experience.
I work with professionalism, accuracy and integrity, enjoy a challenge and never quits until the job is done right, on time and on budget. I am hardworking, quick and detailed person with strong analytical and research skills.
I will newer look for an excuse. I will always find a way!
Printable and editable...
Service I Provide
1. Analytics Design and Implementation
a) These are the Tools I use: Google Analytics (Certified), Mixpanel, Google Tag Manager and Segment.io
b) I have set up analytics for all kind of products including SaaS, Online Stores, Consumer Apps, Marketplaces
2. Custom Dashboards -
a) I also focus on creating Mobile Friendly Business Dashboard that combines data from multiple sources. Ideal for owners and senior managers.
b) This is very essential to manage your business like a pro and align stakeholders, with daily updated custom reports.
c) Data Sources: Mixpanel, Google Analytics, Product Database, Youtube, Adwords,...
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.
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.
沙巴体育足球开户 • 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)
沙巴体育足球开户 - Database...