Power BI, Power Query, Power Apps, Power Pivot

For 20+ years NFI, an Atlanta, Georgia IT consulting firm, has developed software. Modern tools such as Microsoft’s Power BI, Power Pivot, Power Query and Power Apps permit us to build extraordinarily powerful solutions fast with an elegant simplicity you’ll love.
Here is how we use them for you:

  1. Power Query is an ETL tool. ETL stands for Extract, Transform and Load. Essentially, it allows us to connect to seemingly any data source, pull data from it, manipulate it to some extent and then load it into another application. In fact, we can connect to many sources even for a single application. Connect to examples include the web, Excel, Access, SQL Server, IBM DB2, Oracle, PostgreSQL, IBM Informix, SharePoint, Text/CSV, XML, JSON, etc.
  2. Power Pivot is an add-in to various new versions of MS Excel (Excel 2010, 2013 and 2016). This tool allows us to quickly aggregate millions of rows of data in ways that are far easier than older manual methods. And as the name implies, pivot data so that columns become rows and vice-versa.
  3. Power BI stands for Power Business Intelligence. It’s a dashboarding tool that’s comparable to Tableau. Power BI includes Power Query and it builds upon the data aggregation and calculation features of Power Pivot and more. It uses Power Query to connect to a vast array of data sources and has a wide-variety of charts (a la Excel), mapping and more.
  4. Power Apps is a fairly easy way to build simple internet based applications, primarily for internal usage. The apps are mobile, tablet, iPad, laptop and desktop friendly!

So does this suite of Microsoft tools replace Excel, Access, SQL Server and Oracle? No. For most Users, Excel can still do calculations far faster and easier. MS Access can still handle many tables of data easier than Excel and SQL Server, Oracle, etc. is still where one would go to build a database that will be far more powerful than MS Access. But Power BI, Power Pivot, Power Query and Power Apps work in conjunction with these other tools.

A great thing about working with NFI is we work with the software applications you already have in-house. And if you don’t have tools to do what you need, we’ll learn more about your objectives and guide you through the process of getting you the tools you need.

If you have any questions, we’d love to talk. We’re easy to reach. We don’t outsource, but do all our work here out of Atlanta. This doesn’t guarantee the security of your important data, but it helps. It also means we’re very responsive and that we’re probably in or almost in the same time zone as you are. We have great reviews and have been in business over 20 years. We’re far more affordable than the big consulting firms such as EY, PWC, IBM and others. Call us at 770-850-1640 today so we can help you start addressing your important problems now.

NFI is an Atlanta database and business intelligence management consulting company established in 1998. Our software consulting includes custom software, data migration, data integration and database services. We work with software such as Power Apps, Power BI, MS Access 2016, MS Access 2013, MS Excel, Tableau, QlikView, Oracle and SQL Server.

If you have questions about your database, need help with validating data, reporting, importing, exporting or doing anything else with your data, call 770-850-1640 to speak to one of our very knowledgeable, very nice and helpful experts. With quality, security and more in mind, we do no offshoring. Made in America.  Great reviews.

Harness your data with NFI.

Call 24x7


E-Mail 24x7


Our Newsletter


© Copyright 2021 - NFI Atlanta, Georgia - All Rights Reserved - Site by