“There’s nothing inherently wrong with spreadsheets; they’re excellent tools for many different jobs. But data visualization and data communication is not one of them.” – Bernard Marr
We couldn’t agree more with what Bernard is saying in his article, “Why You Must STOP Reporting Data in Excel!” Excel is everywhere and it has proven to be a valuable resource to every company across the globe. The problem is that many companies are using spreadsheets as their main line of communication internally. Excel is great at displaying all of the raw data you could possibly dream of, just ask any Data Analyst, who eats, sleeps and dreams of never-ending spreadsheets. Bernard gets right to the point and lays out the top 4 reasons that spreadsheets are not the right fit for visualizing data and communication within an organization.
Most people don’t like them.
Bernard makes a great point, unless you work with Excel frequently like a data analyst, it has the reputation of being intimidating. Employees will be reluctant to use it, let alone even think about analyzing data from it. If employees are not clerking in Excel all day, they are most likely going to give Excel the cold shoulder when it comes to communicating data.
Important data is hidden.
I think it is safe to agree with Bernard on this. Spreadsheets are not the best visualization tool out there. Most spreadsheets today are full of endless numbers. If users can’t look at the data and quickly decipher valuable vs. non-valuable, that is a problem. There are better visualization tools that paint a clearer picture and allow for effective communication.
Loss of historical data.
Users in Excel are constantly updating the facts and data as necessary. The downfall to that is it essentially erases all historical data. Without historical data there is no clear way to see the trends and patterns. It takes away the ability to make predictions for the future.
It’s difficult to share.
Spreadsheets are not ideal for collaborative data sharing because they allow the risk of having data deleted or changed. The way that data is shared today is by emailing updated spreadsheets. This data is considered stale or dead, it lacks the key component of remaining “live” or in real-time. This way of sharing is not only time consuming but eliminates the opportunity for users to collaborate while never losing connection to the most updated information available.
The great news is, there’s an easy answer to all of the common frustrations of spreadsheets…
PowerOLAP is an example of a product developed with a solution that addresses all of these problems. It allows for real-time collaboration between users, while always remaining “live”. It has the ability to store historical data which allows for accurate analytical predictions to be reported. Take a deeper look into PowerOLAP and see how it can take your organization to the next level.
To read the entire article by Bernard Marr, click here.
Dennis McCafferty of CIO Insight recently wrote an article that addresses 11 of the top practices of Business Intelligence. With Business Intelligence controlling such key factors in today’s companies such as, analytics, business performance management, text mining and predictive analytics, it is crucially important to understand it. Let’s take a look into CIO Insight’s 11 best practices and see if you are already taking advantage of these.
- Bigger Isn’t Always Better: Just because a solution can gather a large amount of data doesn’t mean that they are helping you get the most out of the data. McCafferty thinks that trustworthiness and immediacy are the key elements.
- Deliverable Value Over TCO: When your BI solution can deliver specific ROI, you will gain higher buy-in no matter the initial total cost of ownership.
- Take Stock of Current Resources: Taking advantage and leveraging the IT that your company already owns to support your BI solution is a top practice. You can then utilize that spending on something else that will make a larger impact.
- File-Formatting Resources: Since Business Intelligence uses more than 300 file formats, it is important that you are prepared and ready to use any one of them.
- Create BI Policies for Deployment: It is important to have BI policies in place such as how the data is collected, processed and stored. This will ensure higher level of relevance and accessibility.
- Go Team, Involve Business Leaders From the Outset: You need to remain on the same page as all of the different leaders and work as a big team to keep IT on the right path.
- The Only Constant? Change: Every thing is constantly changing and evolving so this will continue to test your BI deployment at all times.
- Limit Initial User Participation: It is better to start out slow and steady when introducing initial users. If not, it can lead to confusion, errors and confusion which will impact BI’s final impact.
- Define the Project’s Scope: A BI implementation should be taken in stages and a company must know how many users and functions will be needed over time.
- Training Day: In order for your BI project to be a success, you must take the right approach to training employees and make sure that they are properly educated and feel comfortable using the new solution.
- Support Self Service: The goal of BI is to pass along the project to the appropriate department. In order to do this you must support the training plans and keep this practice as a priority at all times.
Click here to read the original article.
The days of paper charting medical records are long gone. Michael Morrison gives a good look into why Big Data is vital to the Healthcare industry in his post, “Big Data Remains Hot in Health Care.”
Medical firms did not have much choice in adapting to these changes after the Health Information Technology for Economic and Clinical Health Act in the US in 2009 took effect, this was one of the largest efforts ever in improving patient care, ensuring proficient operations, and closing the gap of medical error. The result has been phenomenal and continues to progress.
With the ability of the medical industry to continuously run analytics, they gain critical information from high volumes of medical records and data. Morrison mentions that with advancements in patient data analytics, it is becoming the most important aspect of implementing medical analysis, which allows for patient care to be personalized. Many common road blocks that are normal in the course of patient care and health management can be corrected with the use of Big Data tools.
The National Cancer Institute has created a Big Data project that has, through Big Data research, improved cancer treatments. They are now able to learn a lot about the patient’s responses to different medications and choose the best treatment course for a specific patient. The implementation of data solutions across the entire medical industry benefits everyone involved from the provider to the patient. The next time you make a visit to your local doctor’s office or hospital, take a look around and notice how much we rely on the ongoing advances of technology. Where would be now without all of it; how much safer has it made our treatment as well as our loved ones?
Click here to read entire article.
As I think most of us would agree, Big Data has made big leaps in providing the business world with a large advantage. Luc Burgelman does a great job of identifying the three hurdles that he believes are holding businesses back from reaping the most benefit from their Big Data, in his article.
The first hurdle Burgelman refers to is the ability to evolve. He brings up a great point, companies are looking for different things than they were just two years ago. They need to take technology further than before to accomplish what they need as a final result. Also, companies need to be able to engage different/more departments in the analytical process. It is no longer just about the IT team. Other departments have valuable assets to add to the equation of data anaylsis, and we have to be open to sharing the data across the departments and company, taking a more well-rounded approach to tackling large analytical processes. Which leads smoothly into Burgelman’s second point…
Not only is it important to be involving more of the company’s departments, but we need to make sure that the C-level Executives are equally “on-board.” Let’s face it, without their their final “blessing,” no data technology plan will hit the ground running and be successful. Executives need to be equally passionate about the technology and understand the great benefit and ROI of the analytics behind the data.
The third hurdle that Burgelman talks about is changing the mindset of not only the C-level executives but of all who work directly with the data such as the data users and data scientists. Big Data and the technology behind it is a game changer and offers greater benefits to customers, which returns in greater customer loyalty and greater sale margins. Companies need to be able to change and progress with the latest technologies and analysis software to be able to change the way people and businesses make their decisions and interact with their data. So what do you think, are these hurdles something that we can get over and allow businesses to run faster.
Want to read the full article? Click Here.
One thing is certain, if you want to run a successful business, you need to hire the right people to help you get there. Who is in charge of recruiting and hiring your team members? “DING, DING, DING!” you guessed it, Human Resources. Human Resources is beginning to pull ahead in the Business Analytics world. In a “Big Data” world, HR can use “People Data” to their advantage and help businesses develop strategy when it comes to hiring the best candidates. As David Klobucher writes in his article, “Data-driven confidence will help HR professionals identify behaviors and interview styles that attract better employees, as well as qualities that make effective workers – and lead to faster promotions.”
I agree with Klobucher, this is a great time to be in HR. There are big opportunities that may be presented to anyone working in HR. Executives within businesses are looking to their Human Resources department to help build the strategy to success. Of course this all depends on if HR professionals “welcome” the technology with warm arms. As stated in the article, many individuals working with Human Resources are not completely comfortable using data just yet. In today’s world, Big Data surrounds all of us, but for HR, this can lead to big success from analyzing data of past successes and past failures.
In some HR departments, to take on this scope of technology could be intimidating, however like one of my favorite sayings goes, “I never said it would be easy, I only said it would be worth it.”
Read original article here.