Blog

Quick & Powerful High-Level Description of Excel Ribbon

Excel is a powerful tool used worldwide for data analysis, visualization, and organization. One of the key features that makes Excel user-friendly is its Ribbon interface, which organizes commands into tabs for easy access. In this blog, I will provide a quick high-level description of the Excel Ribbon for beginners. As of the date the blog was published, Figure 1.1, displays the Ribbon tabs and a description of commands that are available within each Ribbon

Admira Meskic July 5, 2024 No Comments

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

Dale Levesque June 7, 2024 No Comments

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

Bailey McDonald June 6, 2024 No Comments

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,

Admira Meskic June 3, 2024 No Comments

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

Bailey McDonald May 30, 2024 No Comments

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

Bailey McDonald May 16, 2024 No Comments