Another year is quickly coming to a close. Unfortunately, 2021 did not turn out to be the year of “putting the pandemic behind us” that we hoped for. Despite that, we hope you saw this year as a turning point and are starting to see a trend toward better times ahead. As you look toRead more
In 2005 Microsoft introduced the synonym functionality for SQL Server. While Synonyms are not something SQL developers are likely to use on a daily basis, they are very powerful and useful, despite being relatively simple. They are essentially a placeholder that can be used as a static value in a SQL statement that points towards another object. While staticRead more
When it comes to data access, I like to keep it simple. I prefer the database be exclusively responsible for database actions using stored procedures to execute queries and updates. I also like to avoid mapping lots of parameters in stored procedures. At other times, there’s a need for a way to send a listRead more
FIMC Explores Data Storage Solutions In our introductory post on the happenings at Foam Injection Mold Company (FIMC), we described three major technology solutions that Superior Consulting Services implemented to help them modernize and streamline their operations. One of these tech solutions is a timekeeping application that interfaces with their payroll system that was migratedRead more
Welcome back! This is part 2 of our Dashboard In a Blog (or Two) series. If you missed part 1, click here [CD1] to catch up and then come back here to continue with part 1. Go ahead and open up Power BI and the file you saved in part 1. When it opens, you willRead more
If you’ve been watching the Power BI space for some time, I’m sure you’ve seen many offers to go to a seminar or watch a webinar to show you how easy it is to build a “Dashboard in a Day” or even a “Dashboard in an Hour” with Power BI. I’ve seen many of theseRead more
Power BI Query Editor Value and Table Columns Data stored as part of a transactional data processing system, for example a database to information on package deliveries, is often difficult to work with when it comes time to explore that data or create reports. This is because of a process called normalization. Data Normalization WhenRead more
One of the most intriguing features added in April 2017 is the Column From Examples functionality. You can use this feature to have Power BI craft a data transformation for you based examples of what you want the content of the new column to look like. Creating a Sample Model To demonstrate the Column FromRead more
Power BI is the newest business intelligence offering from Microsoft. It’s a product that a lot of people have been talking and thinking about for the past year or two, and it is gaining more and more traction every day. I like to refer to it as “The best tool that people don’t realize theyRead more
One of the exciting features recently added to Power BI is ad hoc grouping. Released at the end of October 2016 and then improved upon at the end of November 2016, ad hoc grouping allows us to create one or more groups of items while visualizing data, view totals for that group as a whole,Read more
