Richard Rokat

ABC Retail Store Financial management dashboard:
This Excel-based project is a comprehensive financial management tool designed for ABC Retail Store, a small retail business. It provides a clear and organized way to track financial transactions, generate key financial statements, and analyze the business's financial health. The dashboard includes the following components:
List of Transactions: A detailed record of all financial transactions during the first month of operations, including investments, inventory purchases, sales, expenses, and cash flows.
T-Accounts: A visual representation of the ledger accounts, showing debits, credits, and balances for each account, such as Cash, Inventory, Accounts Payable, and Owner's Equity.
Trial Balance: A summary of all ledger accounts, ensuring that total debits equal total credits, which is essential for accurate financial reporting.
Income Statement: A financial statement that calculates the store's Gross Profit, Total Expenses, and Net Income (Loss) for the month, providing insights into profitability.
Balance Sheet: A snapshot of the store's financial position, detailing Assets, Liabilities, and Equity at the end of the month.
Key Features:
Automated Calculations: Formulas are used to automatically update financial statements based on transaction data, reducing manual errors.
Real-Time Updates: Changes in the List of Transactions or T-Accounts are reflected in the Trial Balance, Income Statement, and Balance Sheet.
User-Friendly Interface: The dashboard is designed to be intuitive, making it easy for business owners or accountants to track financial performance.

• ABC Store Financial Management

Simple Actual vs Target Chart

• Actual vs Target Chart

Product Performance Dashboard
Introduction
In this project, I developed a comprehensive Performance Dashboard using Excel to analyze and visualize sales and profit data across different countries, products, and time periods. The dashboard provides actionable insights through interactive pivot tables, charts, and slicers, making it a powerful tool for decision-making.Background on Dashboard
The dashboard was designed to streamline the analysis of sales performance, focusing on key metrics such as profit, units sold, and revenue. It was created to help stakeholders quickly identify trends, compare performance across regions, and make data-driven decisions.Overview of Data
The dataset includes detailed sales information for various cookie products across multiple countries, including India, the United Kingdom, the United States, Malaysia, and the Philippines. The data is organized by month, product type, and country, providing a granular view of performance.Creating the DashboardTable Creation: The data was structured into a table format to ensure easy manipulation and analysis.Pivot Tables: Three pivot tables were created to summarize profit by month, units sold each month, and profit by country and product. These pivot tables serve as the foundation for the dashboard's visualizations.Pivot Table 1: Focused on monthly profit trends, highlighting peak performance periods.Pivot Table 2: Analyzed units sold each month, providing insights into sales volume fluctuations.Pivot Table 3: Examined profit by country and product, identifying top-performing regions and products.Design and CustomizationAligning Objects: All charts and tables were aligned for a clean and professional look.Chart Dimensions: The height and width of charts were adjusted to ensure consistency and readability.Timeline & Slicers: A timeline and slicers were added to allow users to filter data by specific time periods, countries, or products.Connecting Slicers: Slicers were connected to all pivot charts, enabling seamless filtering across the dashboard.Interactive Features
The slicers allow users to dynamically filter data, providing real-time insights into specific regions, products, or time frames. This interactivity enhances the dashboard's usability and makes it a versatile tool for analysis.Adding New Data
The dashboard was designed to accommodate new data seamlessly. By refreshing the pivot tables, the dashboard updates automatically, ensuring it remains relevant and up-to-date.Final TouchesAdjusting the View: The dashboard was customized to look less like a traditional Excel sheet, with a focus on aesthetics and user experience.Customizing the Theme: A cohesive theme was applied to ensure visual consistency across all elements.Sharing the Dashboard: The final dashboard was prepared for sharing, making it accessible to stakeholders for collaborative decision-making.

• Interactive Performance Dashboard

Creating and Deploying an ERC-20 Token:
This project involves the creation and deployment of a custom ERC-20 token on the Ethereum blockchain (or any EVM-compatible blockchain). The token, named QuickNode Coin (QNC), is designed to demonstrate my proficiency in smart contract development, blockchain technology, and the ERC-20 token standard.
Tools and Technologies Used:
Programming Language: Solidity (v0.8.17)Development Environment: Remix IDE
Blockchain Network: Ethereum
Testing Tools: Etherscan
Version Control: Git and GitHub for code managementDeployment Tools: MetaMask
Steps to Create and Deploy the Token:
1. Smart Contract Development:
o Writing the ERC-20 token contract in Solidity.
o Testing the contract locally using a development environment on Remix.
2. Testing:
o Writing unit tests to verify the functionality of the token, including transfers, approvals, and edge cases.
o Using Etherscan for testing.
3. Deployment:
o Deploying the contract to a testnet Goerli using Remix.
o Verifying the contract on a blockchain explorer Etherscan
4. Interacting with the Token:
o Using MetaMask to interact with the deployed token.
o Performed transfers, approvals, and allowance checks to ensure the token works as expected.
5. Documentation:
o Clear documentation, including deployment instructions, contract details, and usage examples.

• Creating and Deploying an ERC-20 Token