Showing posts with label 1Tap. Show all posts

Tuesday, July 1, 2025

MS Fabric Demo Sandbox : Contoso Energy

Contoso Energy and Microsoft Fabric Demo Sandbox Options

No "Contoso Energy" dataset exists for Microsoft Fabric, but the Contoso retail dataset is widely used for training. Below are options for demo data and sandboxes for personal learning, formatted for Blogger with relevant Microsoft links.

Contoso Demo Data

Overview: The Contoso dataset, focused on retail, supports Fabric’s lakehouse and BI workloads with SQL, CSV, or Delta formats.

Access: Download from the Microsoft Download Center or use the Contoso Data Generator for custom datasets.

Energy Data: No energy-specific dataset; source public energy data (e.g., Kaggle) for custom scenarios.

Fabric Sandbox for Personal Use

Trial Capacity: 60-day free trial (64 capacity units) at app.fabric.microsoft.com. Ideal for testing Contoso or custom datasets.

Sandbox: Trial acts as a sandbox for building lakehouses and reports. Convert to a Power Platform sandbox via Power Platform Admin Center for advanced needs.

Training: Free Fabric Analyst in a Day workshop on Microsoft Learn uses Contoso data for hands-on practice.

Energy-Specific Alternatives

Custom Datasets: Import energy data (CSV/Parquet) into Fabric trial for analytics practice.

Azure Sandbox: Use Azure’s free sandbox for data integration with Fabric at Azure Free Account, but monitor costs.

Community Samples: Check Microsoft Fabric Samples on GitHub for adaptable scenarios.

Recommendations

Start with Fabric’s trial for Contoso-based practice.

Use Microsoft Learn’s Fabric modules.

Import energy datasets for relevant training.

Monitor costs if using Azure services!

New for June 2025!

The [Digital Twin Builder (preview) tutorial introduction](https://learn.microsoft.com/en-us/fabric/real-time-intelligence/digital-twin-builder/tutorial-0-introduction) in Microsoft Fabric provides a hands-on guide to creating operational analytics scenarios using digital twins. It introduces a low-code/no-code tool that allows users to model and contextualize data from various sources—like sensors and control systems—within Microsoft Fabric’s unified analytics platform.

The tutorial centers on a fictional company, Contoso Energy, which uses the tool to improve efficiency, reduce energy consumption, and enhance product quality across its distillation sites. Users are guided through building a scenario ontology and visualizing insights with Power BI.

**Key prerequisites** include:

- A Microsoft Fabric-enabled workspace

- Digital Twin Builder (preview) enabled in the tenant settings

- Power BI Desktop installed (not just the web version)

This feature is currently in preview and is designed to help organizations drive operational improvements such as reducing waste, improving yield, and achieving sustainability goals. Let me know if you’d like a breakdown of the tutorial steps or help setting up a test scenario.

Add ‘Open Bash Here’ into Visual Studio

With the rise of cross-platform development, the need for Linux tools like bash has become more prevalent, even in Windows environments. Developers often need to run bash scripts for tasks such as deploying services to Azure or managing containers. An integrated bash prompt in Visual Studio, opening directly at a file’s location, can significantly streamline this process. Here we create a script amd config.VS to run it

Why

In a mixed development environment where Windows and Linux tools are both essential, there’s a challenge: Windows uses a different file path structure compared to Linux. When developing on Windows with Visual Studio but needing to run Linux-based tools (like bash scripts), there’s a disconnect — the paths don’t translate automatically between systems. This is where a Linux script comes into play.

Creating the script

To bridge this gap, we created a Linux script that performs path translation. It takes a Windows file path as input, converts it into a Linux-friendly path, and then opens a bash shell at that location.

vi ~/.open-wsl-bash.sh

#!/bin/bash

win_path=$1

# Replace single backslashes with double backslashes

win_path=${win_path//\\//\\\\}

# Translate the Windows path to WSL path

wsl_path=$(wslpath -u "$win_path")

# Navigate to the directory and open bash

cd "$wsl_path" && exec bash

Script Breakdown

#!/bin/bash: Shebang line to indicate the script uses bash.

win_path=$1: Assigns the first argument passed to the script to win_path.

win_path=${win_path//\\//\\\\}: Doubles the backslashes to escape them properly for bash.

wsl_path=$(wslpath -u "$win_path"): Uses wslpath to convert the Windows path to a WSL path.

cd "$wsl_path" && exec bash: Changes to the directory and opens a new bash shell.

This script is an essential piece of the puzzle for a seamless development experience across Windows and WSL environments.

Adding the External Command in Visual Studio

Find the path to wt.exe.

Navigate to Tools > External Tools.

Click “Add” and configure:

Title: Open Bash Here

Command: Path to your wt.exe.

Arguments: --profile "Ubuntu-20.04" -- bash -c "bash ~/.open-wsl-bash.sh '$(ItemDir)'"

Initial directory: $(ItemDir)

Visual Studio: Adding external command

“Ubuntu-20.04” is the name of my Linux Windows Terminal profile. Change it to your Linux profile name.

Conclusion

With this setup, you’ll have a seamless “Open Bash Here” command in Visual Studio that improves the development workflow by providing quick access to a Linux bash environment at the location of your current file.

Monday, November 2, 2020

Compare Android Receipt Tracking Apps: Best & Worst Scan + OCR Receipt Apps for Small Business

Finding the Best and Worst Android Receipt Management Apps with a focus on Scan, OCR & small business functionality,.

Summary

The following review focuses on finding a stable and affordable receipt tracking app that includes the following functionality either in the app directly or via the browser. Scan & OCR functions must reside in native app while reporting & settings may exist in browser. This is a summary review focusing on OCR accuracy, ease of use & functionality that can satisfy tax related use cases for small business/sole-proprietor.

Requirements

1. Ability to scan a receipt via phone camera

2. OCR Capability for scanned receipts

3. OCR accuracy is > 90%

4. OCR picks up minimally following fields:

a. Pricve

b. Date of transaction

c. Merchant / Store Name

d. Category – Filled 90% with accuracy at or above 50%

5. Scan & OCR will involve at most 2 user events: Camera Click & Button Click.

6. Pricing either :

a. Subscription of < 5$ per month for 1-2 user or

b. 100$ one time for life of product

7. Ability to create simple report &/or export including:

a. Transaction detail

b. Transaction Summary

8. Reports shall allow user to filter by Start / End Date

9. Export Report to csv

Optional / Nice To haves:

1. Ability to identify / resolve / merge duplicates

2. Ability to scan a receipt via email

3. Search feature allowing to find tx by merchant, amount and/or category

4. Customer service with chat capability or email response

5. Ability to import from another expense platform, E.g: Import from Expensify.

The following apps were downloaded & tested on Android 10 Kernel Version 4.9.193 on LG V40 model V405TA30b :

Test Case:

1. Create Account

2. Create 3 receipts: Scan & OCR, see #6 below

3. Verify fields populated by OCR:

Date

Merchant

Amount

Test Results

Apps failed due to 1 or more of the following conditions, noted by the leading symbol below : , denoted with leading in

1 - OCR in-accurate or non-existent

2 - pricing exceeds 5$ per month or $120 per year

BEST of the BEST

1tap receipts Tax Calculator & Receipt Scanner

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 100% Accurate!

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- $2.08 per MONTH! Billed annually!

Pricing Details:

More Info: support@1tap.zendesk.com

6. Ease of Use: - High

7. Pros: - Very accurate & fast, simple UI, great fit for small business who wants no frills & hughly accureate OCR receipt scanning

8. Cons: basic reporting, limited filtering, did not see a way to search for a receipt. Not

Receipt Scanner: smart receipts & expense tracker

Test Results Notes:

1. Create Account - Easy, Email.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 100% Accurate!

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- $3/ month paid yearly !

Pricing Details:

More Info: contact@easy-expense.com

6. Ease of Use: - High

7. Pros: - Very accurate & fast, Clean & simple UI, great summary dashboard. Info on importing: Break expensed into Biz/personal

8. Cons: limited browser, in work.

BEST

Zoho Expense - Expense Reporting and Approval

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 0% Accurate!

http://prntscr.com/vcbpqa

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- 5$ per mos

6. Ease of Use: - High

7. Pros: - OCR was fast, however category not filled in, Many features for mid sized business.

8. Cons: OCR

Foreceipt - Receipt Scanner Expense Tracker Cloud

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 0%

4. How many events to create a receipt?

- 2

5. What is the pricing amount & model for app?

- 3.99$ per mos (220 scans only)

6. Ease of Use: - High

7. Pros: - OCR was fast, however category not filled in, Many features for mid sized business.

8. Cons: OCR & pricing is only 200 scans per month

Wave Invoicing

Test Results Notes:

1. Create Account - Easy, Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: <1 hr

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 0% Accurate!

4. How many events to create a receipt?

- 1 !

5. What is the pricing amount & model for app?

- 35$ per mos

https://www.waveapps.com/pricing

6. Ease of Use: - High

7. Pros: - OCR was fast, however category not filled in, Great features for mid sized business.

8. Cons: Category OCR and price!

Expensify - Expense Reports

1. Create Account - Easy, Email or Google OAuth.

2. Create 3 receipts: Scan & OCR. - 1 step; process time: Slow > 2 hours

3. Verify fields populated by OCR: (% of 3 receipts)

Date - 100%

Merchant - 100%

Amount - 100%

Category - 50%

4. How many events to create a receipt?

http://prntscr.com/vcbumb

- 1 !

5. What is the pricing amount & model for app?

- 4.99$ per mos

https://www.expensify.com/pricingw

6. Ease of Use: - High

7. Pros: - OCR was slow, but accurate. Most fields filled in, duplicates management. Great features for mid sized business.

8. Cons: OCR is slow, Fees & overcharging, customer service.

WORST: Worst / Not applicable

Fyle: Receipt Scanner & Expense Reports

fail reason: 1

fail reason: 2

fail reason: 2

fail reason: 2

fail reason: 2

Veryfi - expenses, receipts & projects

fail reason: 2

Foreceipt - Receipt Scanner Expense Tracker Cloud

fail reason: 1

Smart Receipts

fail reason: 1

Receipt Bank

fail reason: 1

QuickBooks Online Accounting, Invoicing & Expenses

fail reason: 2

Free Expense Tracker & Budget Planner - Bookipi

fail reason: 1

MrReceipt - your receipts in one place

fail reason: 1

Receipt Box

fail reason: 1

Smart Receipts

fail reason: 1

Easy Receipt Log

fail reason: 1

Import Export Links:

Expensify

https://community.expensify.com/discussion/3531/how-do-i-export-download-actual-images-of-receipts-for-document-support-storage

https://community.expensify.com/discussion/6029/is-there-a-way-to-create-a-multi-line-report

https://www.expensify.com/csvExport

Easy Expense:

https://easy-expense.com/guides/

1Tap

https://support.1tap.io/hc/en-us/articles/115000224429-How-do-I-export-my-data-

https://support.1tap.io/hc/en-us/articles/115001072209-How-to-add-a-note-to-a-receipt-an-invoice-

Test Results Details & Figures:

1Tap:

Browser/Admin UI:

https://my.1tap.io/my-expenses/overview/2020

Report Request

Report Output

OCR Results:

Easy-Expense:

Browser/Admin UI:

https://app.easy-expense.com/

OCR Results:

Dashboard

Export:

Easy Expense Import

Expensify:

Expensify Export

Sample Script

https://community.expensify.com/discussion/6029/is-there-a-way-to-create-a-multi-line-report

Export Formats