You walk in the door in a Microsoft shop what do you install or get access to? I'll start it: Power BI VScode (for Pandas and mucking around in python) SSMS (yea I know I could use VSCode extension but best to use the tools/lingo of your testers and DBAs) Notepad++ Figma (for mockups although if data is simple I'd just mock data and PowerBI it) Clover (windows explorer upgrade - I like it for folder only view) Test Environment access for all your business platforms (i.e. talk to testers first) Later on power automate if they'll give me a license submitted by /u/ComfortAndSpeed [visit reddit ..read more

We are in the process of selecting a BI tool to offer analytics services to various clients. We've ruled out Tableau due to its high costs, and Power BI isn't an option because it lacks support for Macs. We're seeking an affordable or open-source solution with the following features: Basic to intermediate visualization capabilities, with the potential to embed Python-related visualizations (for those clients that want some very specific visualization) Ability to connect to a wide variety of data sources. Capability to create both internal (private, with user access controls) and external (pu ..read more

As I approach my one-year mark in my current role, I'm seeking advice and insights. I'm fortunate to have early access to Copilot at my workplace and want to create an impactful presentation on its capabilities. Any tips or suggestions would be greatly appreciated! submitted by /u/Proper-Ad98 [visit reddit] [comments ..read more

The company I work for uses a software application called Business Alerts. BA periodically (on a custom schedule) reads our ERP database through a SQL query and then sends emails based on the conditions it finds. There are two types of alerts: Query: Sends email based on a SQL query. For example, send an email to all sales reps with a list of late sales orders for their territories. A sales order will show up on the email every day until it is no longer late. Monitor: Takes a snapshot of the database and, when it runs, compares the new snapshot to the old snapshot and sends emails based on t ..read more

I often hear that PBI and Tableau have some of the best BI communities out there, but what makes them the best? Is it active community members who post content? Users who are always online to answer questions? User meets-ups to share ideas? Inspiration for dashboard and architecture designs? Something else altogether? submitted by /u/Solid_Relationship70 [visit reddit] [comments ..read more

Hey Folks! I was just wondering, a lot of RevOps has to do with understand data and derive insights from multiple sources to make revenue impacting decisions...and one of the best ways to do this is to know how to use SQL to join across business datasources. I am looking to create a course specifically for RevOps related data use-cases using SQL. Was wondering if someone here would find this helpful? I'd love to chat. Some of the broad topics I'm covering include: How to find out funnel conversion rates by combining data across GA, HubSpot, Salesforce & Stripe. Creating a pipeline inspec ..read more

We have a sass application that we would like to bring business analysis functions into. Our requirements are simple: 1) Import data from sql server into an analysis server and build all the models. 2) Have the ability to query the analysis server by a tenant, using a claim from the JWT for example. 3) The ability to report on the models on the front end using react integrated into the app. We tried Azure analysis service but it’s a bit of a mess because of the tenant requirements. Also found flexmonster this could work well and we’re evaluating it now. Anyone having any luck integrating a bu ..read more

Hi, I'm working with an agency team that needs to collect and consolidate data from spreadsheets. Note that each spreadsheet originates from a different client. They may have the same information, but they're never going to be consistent. Plus, we have to stick to file uploads since a direct API integration is not realistic. Ideally, we would upload the files into an app which we could program to rename, reformat, and reorder the columns. Once the data is transformed, it would get written to a table in our data warehouse. Bonus point if we could also have the ability to overwrite or delete da ..read more

Joined an e-commerce startup as business analyst to build the team and lead it, how do I start, I only have 2 YOE? I've joined a profitable cross border e-commerce startup with less than 20 employees as a business analyst and they're growing fast. Building the power bi reports will be my first task; the CEO completely supports me and doesn't micromanage. I never used power bi before. I'll go on to build the analytics team as we grow. I only have 2 Yoe as a BA in a startup, where I worked with python, SQL, ETL, tableau, and google analytics. This is my opportunity to learn a lot, apply it and ..read more

Hi guys, could you share the biggest challenge you faced during your first business? How did you overcome it? submitted by /u/ciaerha_73 [visit reddit] [comments ..read more