Allegient Blog

9 Power Query Tips and Tricks for Beginners

Posted by Brittany Poore | July 30, 2015

In the Microsoft BI world, the term “power” is used in every way possible and one of their newer Excel add-ins is no exception.  Power Query is a Microsoft product that allows non-technical users to query and transform source data.  This includes renaming columns, filtering values, adding calculated columns, changing data types, and many other transformations.  Power Query is a free add-in for Excel 2013 and when used with Power Pivot and Power View, users can build an end-to-end self-service BI solution in a short amount of time and with little-to-no true development experience.  In addition, Microsoft recently announced that Power Query will be a supported data source in SQL Server 2016, which suggests it’s here to stay.  If you’re just getting started with Power Query, below I offer a few tips and tricks to get you started:

Read More

How To Display A Hidden Web Resource In CRM 2015 Without Changing Size

Posted by Daryl LaBar | July 27, 2015

I was recently adding JavaScript to display an iFrame when the fields required by the web resource had been populated on the form. I noticed that the width of the iFrame was getting squished when it was being displayed:

Read More

Allegient Core Value: Servant’s Heart, All In Culture

Posted by Brent Balek | July 23, 2015

My name is Brent Balek and I am a senior at Indiana University. I am currently working towards a degree in Marketing and Management and I am also an attackman on the IU Men’s Lacrosse Team. This summer I was fortunate enough to hear about an internship opportunity with Allegient. I didn’t know much about the company, or IT consulting, but after doing some research online and two rounds of interviews I learned a great deal about Allegient’s services as well as the Allegient culture.

Read More

The Case For Usability Testing: Too Little, Too Late

Posted by Matt Meagher | July 20, 2015

Blog Co-Authored by Matt Meagher and Caleb Gove

Usability testing is the evaluation of a user interface design by testing with real users. Usability testing looks for opportunities to improve the design and learn more about the user experience. They reveal problems, how well if at all the overall design works, and that the design goals are met. A lot can be gained from usability testing, but when should usability tests be conducted? At the end of a project? Usability tests conducted at the end of project do little to benefit the final product.

Read More

Tools for Creating a Fast, Data-centric Web App: ASP.NET, MVC 5 & More

Posted by Jeremiah Theurer | July 16, 2015

Recently, I was tasked with building a custom web application for a client.  The application's main goal is to read, write, and validate database entries corresponding to configurations for the client's home grown business intelligence solution.  At the customer's request, the application was to be built using ASP.NET MVC 5 and Entity Framework 6.

Read More

What is ECMAScript 6, And Why Do I Care?

Posted by Brandon Knight | July 1, 2015

What is ECMAScript 6? ECMAScript is the official name for the language colloquially known as JavaScript. ECMAScript 6 or ES6 for short is a significant update to the language, which otherwise has not been updated since ECMAScript 5 (ES5) in 2009. After a long wait, ECMAScript 6 became a standard in June 2015.

Read More

How Allegient Has Defied My Expectations

Posted by Carter Grove | July 1, 2015

"You learn something new every day" is far more than a cliché at Allegient. It’s really more of a mission statement. I came into this internship experience focused on the value that I could bring to the company, but so far Allegient has been far more concerned with the opportunities for learning and growth that they can offer me. Over the past week, the other interns and I had the opportunity to begin Allegient’s two week long grad training program alongside the new college hires.

Read More

It's About Time: Standardization with ISO 8601

Posted by Kyle Pierce | June 26, 2015

The leap second being added on June 30, 2015 and some recent work on a legacy application got me to thinking... It's about time that web programmers join the Internet Age regarding time itself.  That may seem to be an oxymoron on its face, but a brief history lesson will illustrate what I mean.

Read More

The Life of an Allegient Intern, Part Two

Posted by Andrew Schmidt | June 25, 2015

Here I am six weeks into my internship at Allegient,  at the time of this blog over halfway done with it.  Like two weeks ago when I wrote my last post, I’m still questioning how all of this is possible. Has it really been a month and a half since my first day on the job?

Yet, at the same time, all the things I have experienced and all the things I have done seem like way too much to have occurred in just 40 days. This internship has changed me, delivering growth through the real-world experiences. I’ve learned so much, from exposure to new programming methods and techniques to simply observing how the software industry really operates. Overall, the work I have been doing so far has been great at giving me an idea what my future career has in store for me.

Read More

Evolution of Dynamics CRM on a Budget

Posted by Kelli Ellis | June 24, 2015

I’m reminded nearly every day as I get up to go to work how glad I am that I decided to become a Business Analyst. My career started late in life – after raising my kids. I went to college when they did (just not where they did!).  One benefit of beginning late like this is that you know who you are, you know what you do well, and what you do not. Selecting this career was a satisfying connection with what I do well and what I enjoy doing. And yet as I graduated, even after a couple of internships behind me, I had no idea it would be as satisfying as it is. To me, there is nothing like walking into a company, assessing/analyzing its needs, and providing a business solution that improves their bottom line.

Coming to work for Allegient has turned out to be the best career choice for me. They see my passion, they understand my abilities, and they know very well how to connect the right people to the right job.  It’s a win-win – for Allegient, for the client, and for me – the Consultant.  One of those good connections is with the project I describe next:

Read More