About

Data Analysis

Business Sudoku Quick – What is the definitive correct answer to this particular Soduku puzzle? It’s an impossible question, right? There are multiple valid solutions to this problem. If someone insists there is only one right answer, you tell them to fill in more of the squares. This Soduku puzzle offers an analogy for your business use of data analysis techniques. Let me explain. As a business manager, you know there is an adjustment that needs to be made. You have a flood of data to choose from, but lack the tools to harness that data for decision-making. You know the answer is out there, but it is buried or out of reach. You need to fill in those missing squares. Squares that represent some aspect of how your business is performing.

Tuesday, March 18, 2025 | 3 minutes Read

Data Reporting

Data Reporting Epiphany It’s unmistakable when it happens. That “Aha” moment when a business partner sees for the first time a data reporting tool we have created for them. It is so satisfying to help others gain clarity and confidence in their decision-making process. When those moments occur, we know we’ve helped you boost the return on your data investment. Those moments are the culmination of a process that starts by interviewing you to understand the challenge. The process for us is part science and art. The science/technical parts are pretty evident. This does involve computers after all. The artistic aspect is:

Tuesday, March 18, 2025 | 2 minutes Read

Data Wrangler

Organizations today have data spread over multiple locations and formats. A common example is a Salesforce-type CRM application in the cloud with an inventory system on-premises as an Oracle database. You chose these applications because they are the best in their class. But from a business-planning standpoint, you now have isolated silos of data. You want to be able to leverage cross-system views of this data. You need to somehow corral it into a common space. In cowboy-technical terms, you need the help of a data wrangler.

Tuesday, March 18, 2025 | 4 minutes Read

Database Administration

Do you ever skip the vegetables and go straight to dessert? Think of proper database administration as eating your vegetables, while the reporting and analyses are your desserts. If you ignore the proactive administration details for too long you risk data loss and compromised business health. SQL Server Database Administration Features SQL Server offers a range of new capabilities to protect your business from data loss, downtime, and security breaches. We can help identify server-related performance issues and assist your in-house application developers with database design and SQL programming tasks.

Tuesday, March 18, 2025 | 3 minutes Read

Documentation and Training

Project documentation is the step most often neglected in IT initiatives. Providing well organized and useful documentation is a source of pride for us. One of the best compliments we’ve received concerns a customer from 20 years ago. He recalled the depth and usefulness of documentation that we provided on his projects. Documentation Mindset Documentation is a business continuity and trust issue for us. What do we mean by this?

Tuesday, March 18, 2025 | 2 minutes Read

Microsoft Database Consultant

Mission Statement My name is Jonathan Bartleson and since 1995 I have been a Microsoft database consultant helping other companies in Northwest Georgia. Our first customer was a children’s healthcare organization that was in need of a medical records tool. This project would begin a 20-year niche for our company in behavioral healthcare. It led to our authoring an electronic medical records tool that was used by over 60 therapeutic foster care homes in 5 Southern states. The product we created used Microsoft Access and SQL Server to record and report on children in care.

Tuesday, March 18, 2025 | 2 minutes Read

SQL Server Integration Services

official site SQL Server Integration Services Learning Logs for Tool Trade Data via the Census API and SSIS As taken from the Microsoft web-page for SQL Server Integration Services: Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Tuesday, March 18, 2025 | 1 minute Read

SQL Server Reporting Services

official site SQL Server Reporting Server SQL Server Reporting Services

Tuesday, March 18, 2025 | 1 minute Read