Save Out Excel Worksheets to CSV Files Using Visual Basic

Introduction                Ever found yourself needing to separate Excel worksheets into CSV flat files to make it easier to ingest for ETL? Well I’m going to walk you through the steps to take to get this done using Visual Basic(VBA). With the help of VBA and Macros in Excel, we can get the job done in no time. How To                Step 1: Open the Excel File you want to break apart into CSV files

Read More »

Getting Started with Reporting Services

Hello, I hope everyone is having a great day. For any beginners in SSRS I am creating this blog to show you can create a data source and a data set to be used in your reports that you’re building. Now, first you are going to need the SSRS extension installed in Visual Studio. An easy way to do this is if you are already in any type of project in Visual Studio and you’ll

Read More »

Excel Calculations: Unlock the Power of Operators!

Microsoft Excel is still one of many analytics and data tools used within corporations. Being it’s included in the Office 365 suite helps as there are no additional subscriptions or charges required in order to be used by the users. Its versatility, ease of use, and a lot of online learning materials assist Excel to continue to be a competitor in the data and analysis space. Having used Excel for decades for data and analysis,

Read More »

In-Memory Import vs Direct Query: What you need to know when loading data

Hello everyone, I hope y’all are having or will have a great day today. In this blog post I will be covering the differences between In-Memory Import and DirectQuery from its effects on the front-end (your report and DAX) as well as the effects on the back-end (Power Query Editor and loading data processes). Without further ado, let’s get into it. To start, we are going to look deeper into the difference between In-Memory Import

Read More »

SQL Saturday Jax 2024

Hey guys, a couple weeks ago all of those at Patriot Consulting spoke at the SQL Saturday event in Jacksonville, Florida. At this Star Wars themed community event, we were able to both enjoy and learn while in attendance of the presentations of others and also impart some of our knowledge upon those who attended our session. At UNF, where the event was held, each room was named after another planet. We had people like

Read More »

Single Ticks & Strings

Hello everyone, I hope you are doing well today. Have you ever been writing out a string or a print statement in python and got stuck trying to put an apostrophe in there? If so, I have the answers for you. First, I am going to address our error… single tick hell… then I am going to give you the solutions to your problems and keep you out of single tick hell. Fear not citizen!

Read More »
Subscribe to our blogs via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 3 other subscribers