skip to Main Content
Our Vision
1) We want to be a niche player who assist “small businesses” in reviewing overall, geographic, department , team, or individual employee’s performance against metrics, such as budget, targets, prior time period, etc. We will provide such information to our clients through interactive and graphical dashboards which will be developed by using one or more of these tools power query, power pivot, power bi, and Microsoft SQL server in Cloud/Azure.
2) We also want to provide a self learning platforms for students and professionals who work with data and want to present meaningful information to management in form of interactive and graphical dashboards, which will assist management in reviewing performance against metrics and decision making. These self learning platforms will provide online learning resources such as videos and sample data to create interactive graphical dashboards.
Gaurav Saneja

Gaurav Saneja

I am a 2008 MBA graduate from University of Arizona’s Eller College of Management. I have been working in Finance for over 7 years.  Over this time, I have extensively used Excel at work and realized that most of my tasks are recurring/repetitive in nature. I could be building models, reports or dashboards to analyze data for the first time and then would often update these tools with new data. I got introduced to Microsoft Excel’s Power Query feature about 1 and a half year ago and it has made me so much more efficient at work. Microsoft has put it best that Power Query is self-service business intelligence (BI) for Excel.

Power Query has helped me automate the processes of getting and combining data from multiple sources, filtering, cleaning and shaping data to my needs, adding columns with lookups and calculations, and analyzing data by loading it into an Excel worksheet, Pivot table/Power Pivot, Pivot Charts/Power Pivot Charts.

Microsoft Power BI Desktop uses Power Query to get, filter, clean or shape data, add columns with lookups and calculations, and load data. I highly recommend using Microsoft Power BI after you get a working knowledge of using Power Query in Excel.

Below is a list of tasks that I do in Excel’s Power Query:

Forecasting revenue and expenses, generating dashboards and management reports with dynamic graphs/charts and financial commentary, building advanced models, budgets and operating plans, and reviewing and analyzing financial data, performance metrics, risks and opportunities, variances from targets/budget, prior month/quarter/year, and progress on key projects. So, almost everything!!

Masters of Business Administration, Eller College of Management, University of Arizona

I’m here to answer any questions you might have about our products and services. Feel free to contact me using any of the following methods:

Email: email@email.com
Phone: (800) 555-5555 x35
Twitter: @Envato

Saurabh Saneja

Saurabh Saneja

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin pulvinar nisl enim, eget dignissim felis posuere in. Ut suscipit et mi facilisis posuere. Nulla iaculis placerat dui in rutrum. Nulla commodo eros metus. Sed tincidunt augue ipsum, et sodales odio egestas a. Fusce id pulvinar sem. Maecenas vitae facilisis nulla. Morbi semper lobortis eros ut sagittis.

Bachelors of Business Administration, Loyola University
Masters of Accountancy, University of Nevada

I’m here to answer any questions you might have about our products and services. Feel free to contact me using any of the following methods:

Email: email@email.com
Phone: (800) 555-5555 x35
Twitter: @Envato

Back To Top