SEEKING WORK | Alberta, Canada | Remote Services: - Web Development with Django or Flask. - ETL, Data cleaning, data Analysis and Reports with Python, MS Power BI, Power Query. - Database design, and maintenance: MS SQL Server, Postgresql, etc. - Data migration, CRM/ERP training and implementation. Linkedin: https://www.linkedin.com/in/eduardo-vieira-silva/

They're sunsetting Quickbooks Commerce, though: https://commerce.intuit.com/register

I was surprised that their plan with TradeGecko for an ecommerce platform didn't go anywhere, it seems. https://www.tradegecko.com

Last November I did an impulse buy for a Breville coffee machine on a site. It was one of those "countdown" super sales. One hour later after the purchase I contacted the seller and he refunded me the paypal... fortunately. But the site definitely looked scammy. I notified Paypal and Shopify. It's so easy nowadays to create nice looking sites in a platform like Shopify that will give a veneer of legitimacy. Anyway, that scammy site is gone. I wonder how many fell for this one. I should have checked how soon the site was taken down.

The site doesn't even use Shopify, some chinese ecom cms, shopify would shut down the site

Location: Alberta, Canada

Remote: Yes

Willing to relocate: No

Technologies: Python, RDBMS, Pandas, Power BI, Javascript, Flask, PowerApps

Résumé/CV: https://www.dropbox.com/s/58nfq4vwtp6e5j9/Resume%20Eduardo%2...

Email:

I think XLwings (https://www.xlwings.org) can do some of that.

This looks awesome! Thank you.

Agreed. I got enthused about the Power Platform, with Power BI and Power Apps, mostly. With Power BI, you get a mix of Power Query M the DAX formula language, and then comes the power automate (flow) and power apps where you use this formula language that's still different. Too much to learn. I'm not even sure if the power automate formula language is the same as the one used in power apps. Confusing.

Power Bi is nice, but expensive.

You need a costly instance as soon as you go more advanced.

My firm is all-in Microsoft and I have to say it's not working. Power BI licenses are limited, Azure cloud cost are through the roof, anything you'd have run on a proper workstation in the old days is retired 'since we have cloud' (as are tools like SAS, MATLAB and other end user modelling languages). As a non-developer but technically inclined person I've tried to find courses in non-obvious MS-software but couldn't find anything worthwhile. The pushback I receive for suggesting R or Python for modellong, stitching and automation is intense even though all juniors learn these tools in university. Microsoft lock-in is just crippling.

Agreed. Power BI seems cheaper than Tableau or other options, but you end up having to get licenses for everyone just to let them view content.

I gave it a try and used a simple Excel file (with tables) to create a PowerApp. Customization wasn't too painful. However when more than one person needed to use it, it was locked because the Excel data source could not be accessed by more than one user at the same time :-(. I should have used Sharepoint lists instead. So, the simple thing of working with familiar apps like Excel and creating a form entry on top of it was disappointing.

True. Years ago, some FoxPro developers tried to translate their experience in building apps with FoxPro to python. Check the Dabo project. It appears to be dead, though. https://github.com/dabodev/dabo

I remember years ago a Python project called Dabo, which was inspired by the FoxPro architecture or approach of building software. I could create desktop and web apps from the same code base, if I recall. Code still available on Github. https://github.com/dabodev/dabo