In my role as a Business Intelligence Analyst at Greenspring Associates, a Venture Capital Fund of Funds, from 2010 to 2014, I had the opportunity to implement an innovative process that unlocked a wealth of information through reporting and analytics. This process involved completely revamping the reporting, analytics and data collections procedures in place.
I was offered the newly created role of Business Intelligence Analyst due to my previous experience with SalesForce, a cloud-based Customer Relationship Management platform, and a reporting tool Crystal Reports. The firm was in the process of transitioning from “Out of the Box” SalesForce platform to a more customized version specifically for alternative investments space. From the
…show more content…
Additionally, the historical data back to 2007 while the firm had been operational since 2000. This information gap proved to be extremely difficult when comparing performances of underlying funds across various investment portfolios. In order to backfill the missing data, I was given permission to leverage the summer interns. Since historical data was in text format, I was rendered with only option: to have the interns manually input data into Microsoft Excel. While it wasn’t the most exciting project, I outlined clearly the downstream impact of their full commitment and by the end of their internships, we completed this massive undertaking.
With the final missing piece having been completed, the CRM platform became fully operational and final product was groundbreaking in terms of the insights it provided. In combination with the reporting software Crystal Reports, I automated several routine reports and provided ad hoc reporting. Additionally, I used both tools to automate many reports for the Investor Relations team which were previously not
From an organizational and profitability standpoint, an efficient, easy to use, and unified CRM system, captures all key and critical data from sales and marketing to commercial operations, all the while focusing on sales process, sales efficiencies, and increasing sales, all contributing to the bottom-line profitability of the organization. Data has proven that CRM platforms increase the productivity and profitability of individual departments and subsidiaries, these same platforms and characteristics will have the same ramifications on a larger scale organization, especially an organization that spans the global footprint, such as
On the above date and time I was conducting a business check of Walmart with loss prevention.
This lesson changed how I managed my results and I have worked hard over the years to ensure I use data to accurately measure the performance of my teams and to devise strategies to achieve my goals. In my role as the Operations Director at an Executive Search firm, I was tasked with managing our offshore operations. This created a unique challenge since traditional management techniques of observation were ineffective when managing a team on the other side of the planet. I discovered the intricacies of Excel to spot areas of opportunities that most managers would rely on observation. This reliance on data analysis resulted in a highly successful operation that was able to detect early risks to avoid revenue
First off, why do we need a business intelligence system for our business? Simply put, an effective
Companies are adopting business intelligence system within their organizations because by using the system reports they can gain the advantages of understanding their internal strength and weaknesses to face external competitors and challenges to increase profits and reduce cost on their everyday operations and processes.
Customer Relationship Management (CRM) is a tool that helps track, manage and supply information about customer’s interactions with an organization to help contribute to customer satisfaction that leads to customer loyalty. Additionally, CRM programs provide tools and applications designed to target their efforts on the most profitable customers, target new potential customers, and generate sales and maintain relationships with customers contributing to a greater market share.
Thinking back to the day the application to SNHU for this Data Analytics Program was submitted, it was months of weighing options before the final decision to take the plunge. There were a few reasons to why this program was chosen. Career growth was definitely the first reason for this motivation. The realization of a need to find a professional ‘me’ was the decision maker. Seeking something interesting yet challenging was the goal. Realizing that calling out anomalies and outliers, seeing trends and patterns is a personal strength, hence, the analytics path was chosen. Working with data and reviewing information has always been something of interest, moreover, and the interest was even deeper
Company’s current position and ability to compete on analytics: I had worked for a healthcare delivery organization whose mission is to enhance the quality of life through improved health, prepare future health care professionals and discover new medical knowledge through research. It is the only Academic Medical center in the region and enjoyed a monopoly for quite some time. With the passage of the Affordable Care Act, the payment model changed from Fee for Service to Bundled payments. The organization was challenged to lower the cost of providing healthcare services without compromising quality of care or research. It had to invest heavily on implementing Electronic Medical Records and systems for reporting to regulatory agencies and insurance companies. The table below highlights the differences between Analytics and Business Intelligence. Note that the organization is in the early phase of implementing BI solutions.
The new CRM integrates past data with customer-centric reports that act as decision support system and helps to understand sales trends, impact of promotions and pattern usage.
The article by Chandler (2015) “The Business Intelligence and Analytics Leader 's First 100 Days” hit a cord with me after a talk with a friend of mine who was just added to the BI team at his company. The new BI director at my friend’s company could have used this article to help him with his new role of BI director. My friend’s boss came in with prebaked ideas and thought he knew what the company needed from the BI department, but after 380 days the department is still feeling its way around in the dark.
The financial services industry is rapidly changing. Factors such as globalization, deregulation, mergers and acquisitions, competition from nonfinancial institutions, and technological innovation, have forced companies to re-think their business.
The CRM system contains positive attributes, but the implementation is risky. Despite the risks that are involved, establishing a strong team that can help the system work effectively and efficiently will improve the company’s key performance factors. Communication amongst the administration that
Business intelligence analysts are important to the business field. They are responsible for producing financial and marketing intelligence by querying data repositories and generating periodic reports. They are also to devise methods for identifying data patterns and trends in available information sources. Its certain you must acquire or already attain to be a business analyst such as critical thinking, active listening, reading comprehension, active learning, and also speaking well. They must complete certain tasks, like for example, Analyzing competitive marketing strategies, synthesizing current business intelligence, managing timely flow of the business, and also collect data from available industries reports. As of the 2014 research business analyst median wages are $40.10 an hour and their salaries are $83,410. What really drew me to this field was the chance to work with a company to ensure growth and improvement.
Adept at building innovative reports and interactive dashboards using Tableau. Publish reports in Tableau server
With information streaming in from a seemingly endless array of applications and devices, organizations face the daunting task of extracting insights from new data sources and types, including structured and unstructured sources. There’s also the challenge of the speed in which data is coming in and how quickly you need to be able to capitalize on it. In this environment, competitive advantage hinges not only on your capacity to access data quickly, but your ability to analyze and act upon this information in a timely manner.