Skip to main content

Home/ BI-TAGS/ Group items tagged build

Rss Feed Group items tagged

cezarovidiu

Top Mistakes to Avoid in Analytics Implementations | StatSlice Business Intelligence an... - 0 views

  • Mistake 1.  Not putting a strong interdisciplinary team together. It is impossible to put together an analytics platform without understanding the needs of the customers who will use it.  Sounds simple, right?  Who wouldn’t do that?  You’d be surprised how many analytics projects are wrapped up by IT because “they think” they know the customer needs.  Not assembling the right team is clearly the biggest mistake companies make.  Many times what is on your mind (and if you’re an IT person willing to admit it) is that you are considering converting all those favorite company reports.  Your goal should not be that.  Your goal is to create a system—human engineered with customers, financial people, IT folks, analysts, and others—that give people new and exciting ways to look at information.  It should give you new insights. New competitive information.  If you don’t get the right team put together, you’ll find someone longing for the good old days and their old dusty reports.  Or worse yet, still finding ways to generate those old dusty reports. Mistake 2.  Not having the right talent to design, build, run and update your analytics system.  It is undeniable that there is now high demand for business analytics specialists.  There are not a lot of them out there that really know what to do unless they’ve been burned a few times and have survived and then built successful BA systems.  This is reflected by the fact you see so many analytics vendors offer, or often recommend, third-party consulting and training to help the organization develop their business analytic skills.  Work hard to build a three-way partnership between the vendor, your own team, and an implementation partner.  If you develop those relationships, risk of failure goes way down.
  • Mistake 3.  Putting the wrong kind of analyst or designer on the project. This is somewhat related to Mistake 2 but with some subtle differences.  People have different skillsets so you need to make sure the person you’re considering to put on the project is the right “kind.”  For example, when you put the design together you need both drill-down and summary models.  Both have different types of users.  Does this person know how to do both?  Or, for example, inexperience in an analyst might lead to them believing vendor claims and not be able to verify them as to functionality or time to implement. Mistake 4.  Not understanding how clean the data is you are getting and the time frame to get it clean.  Profile your data to understand the quality of your source data.  This will allow you to adjust your system accordingly to compensate for some of those issues or more importantly push data fixes to your source systems.  Ensure high quality data or your risk upsetting your customers.  If you don’t have a good understanding of the quality of your data, you could easily find yourself way behind schedule even though the actual analytics and business intelligence framework you are building is coming along fine. Mistake 5.  Picking the wrong tools.  How often do organizations buy software tools that just sit on the shelve?  This often comes from management rushing into a quick decision based on a few demos they have seen.  Picking the right analytics tools requires an in-depth understanding of your requirements as well as the strengths and weaknesses of the tools you are evaluating.  The best way to achieve this understanding is by getting an unbiased implementation partner to build a proof of concept with a subset of your own data and prove out the functionality of the tools you are considering. Bottom Line.  Think things through carefully. Make sure you put the right team together.  Have a data cleansing plan.  If the hype sounds too good to be true—have someone prove it to you.
cezarovidiu

Magic Quadrant for Business Intelligence and Analytics Platforms - 0 views

  • Integration BI infrastructure: All tools in the platform use the same security, metadata, administration, portal integration, object model and query engine, and should share the same look and feel. Metadata management: Tools should leverage the same metadata, and the tools should provide a robust way to search, capture, store, reuse and publish metadata objects, such as dimensions, hierarchies, measures, performance metrics and report layout objects. Development tools: The platform should provide a set of programmatic and visual tools, coupled with a software developer's kit for creating analytic applications, integrating them into a business process, and/or embedding them in another application. Collaboration: Enables users to share and discuss information and analytic content, and/or to manage hierarchies and metrics via discussion threads, chat and annotations.
  • Information Delivery Reporting: Provides the ability to create formatted and interactive reports, with or without parameters, with highly scalable distribution and scheduling capabilities. Dashboards: Includes the ability to publish Web-based or mobile reports with intuitive interactive displays that indicate the state of a performance metric compared with a goal or target value. Increasingly, dashboards are used to disseminate real-time data from operational applications, or in conjunction with a complex-event processing engine. Ad hoc query: Enables users to ask their own questions of the data, without relying on IT to create a report. In particular, the tools must have a robust semantic layer to enable users to navigate available data sources. Microsoft Office integration: Sometimes, Microsoft Office (particularly Excel) acts as the reporting or analytics client. In these cases, it is vital that the tool provides integration with Microsoft Office, including support for document and presentation formats, formulas, data "refreshes" and pivot tables. Advanced integration includes cell locking and write-back. Search-based BI: Applies a search index to structured and unstructured data sources and maps them into a classification structure of dimensions and measures that users can easily navigate and explore using a search interface. Mobile BI: Enables organizations to deliver analytic content to mobile devices in a publishing and/or interactive mode, and takes advantage of the mobile client's location awareness.
  • Analysis Online analytical processing (OLAP): Enables users to analyze data with fast query and calculation performance, enabling a style of analysis known as "slicing and dicing." Users are able to navigate multidimensional drill paths. They also have the ability to write back values to a proprietary database for planning and "what if" modeling purposes. This capability could span a variety of data architectures (such as relational or multidimensional) and storage architectures (such as disk-based or in-memory). Interactive visualization: Gives users the ability to display numerous aspects of the data more efficiently by using interactive pictures and charts, instead of rows and columns. Predictive modeling and data mining: Enables organizations to classify categorical variables, and to estimate continuous variables using mathematical algorithms. Scorecards: These take the metrics displayed in a dashboard a step further by applying them to a strategy map that aligns key performance indicators (KPIs) with a strategic objective. Prescriptive modeling, simulation and optimization: Supports decision making by enabling organizations to select the correct value of a variable based on a set of constraints for deterministic processes, and by modeling outcomes for stochastic processes.
  • ...7 more annotations...
  • These capabilities enable organizations to build precise systems of classification and measurement to support decision making and improve performance. BI and analytic platforms enable companies to measure and improve the metrics that matter most to their businesses, such as sales, profits, costs, quality defects, safety incidents, customer satisfaction, on-time delivery and so on. BI and analytic platforms also enable organizations to classify the dimensions of their businesses — such as their customers, products and employees — with more granular precision. With these capabilities, marketers can better understand which customers are most likely to churn. HR managers can better understand which attributes to look for when recruiting top performers. Supply chain managers can better understand which inventory allocation levels will keep costs low without increasing out-of-stock incidents.
  • descriptive, diagnostic, predictive and prescriptive analytics
  • "descriptive"
  • diagnostic
  • data discovery vendors — such as QlikTech, Salient Management Company, Tableau Software and Tibco Spotfire — received more positive feedback than vendors offering OLAP cube and semantic-layer-based architectures.
  • Microsoft Excel users are often disaffected business BI users who are unable to conduct the analysis they want using enterprise, IT-centric tools. Since these users are the typical target users of data discovery tool vendors, Microsoft's aggressive plans to enhance Excel will likely pose an additional competitive threat beyond the mainstreaming and integration of data discovery features as part of the other leading, IT-centric enterprise platforms.
  • Building on the in-memory capabilities of PowerPivot in SQL Server 2012, Microsoft introduced a fully in-memory version of Microsoft Analysis Services cubes, based on the same data structure as PowerPivot, to address the needs of organizations that are turning to newer in-memory OLAP architectures over traditional, multidimensional OLAP architectures to support dynamic and interactive analysis of large datasets. Above-average performance ratings suggest that customers are happy with the in-memory improvements in SQL Server 2012 compared with SQL Server 2008 R2, which ranks below the survey average.
  •  
    "Gartner defines the business intelligence (BI) and analytics platform market as a software platform that delivers 15 capabilities across three categories: integration, information delivery and analysis."
cezarovidiu

MicroStrategy Suite | MicroStrategy - 0 views

  • Free reporting software Now enhanced for mobile intelligence Perfect solution for departments Scalable as your needs expand For Windows, Unix, Linux, Solaris, HP-UX, and AIX operating systems and any data source, including Hadoop, SAP BW, Microsoft Analysis Services, Essbase, and IBM TM1.
  • Simple development and maintenance of Mobile apps and dashboards Powerful Visual Data Discovery capabilities Packed with robust analytics Free online support and training Perpetual license to use forever Quick Start Guide brings you from download through your first report
  •  
    "Free Mobile and Business Intelligence Software MicroStrategy's award-winning business intelligence software and mobile app development platform are now available in a convenient free software suite, designed for departments to start building and using mobile apps, dashboards, and reports quickly and easily... and at no charge."
cezarovidiu

Successful Social Marketing is So Much More Than Social Media | ClickZ - 0 views

  • In the past, prospects primarily accessed information about a company by interacting directly with a salesperson.
  • As media evolved, mass ads, events, direct mail, and more recently, email, have been the primary tools for engagement.
  • Given the number of consumers posting, blogging, tweeting, liking and sharing, the question for marketers is no longer, Should I use social? It's, How do I use social to its full potential?
  • ...14 more annotations...
  • Social channels are inherently built for sharing and engagement, making them the perfect place to cultivate valuable business relationships. Integrating social into every marketing campaign you run can move you from a company-to-buyer marketing model to a peer-to-peer influence model. This not only builds trust and brand loyalty, but also positively impacts ROI.
  • It can be tempting to jump right in to all the social media sites out there and start posting away. However, before you publish that first nugget of social marketing content, you need to develop your plan.
  • goals and metrics
  • Build a team that is willing and able to dedicate adequate time to social media endeavors.
  • Many marketers fall into the trap of thinking that social media campaigns can be dealt with on an ad hoc basis, but this couldn't be further from the truth. You don't want your company's online personality to come across as erratic or disjointed, so create a policy that guides those who are participating in the social marketing effort and be sure those guidelines are enforced.
  • Once everyone is on board, encourage them to create engaging content. A good starting place is to ask your team members to answer some of the most frequently asked questions they receive on the various social channels. If everyone is a content creator, you'll never be short of ideas.
  • Word-of-mouth is incredibly powerful and the "share" button on every social media channel allows you to tap into millions of different networks. One of the best ways to interact with your audience is by giving them content they genuinely want to share with their networks. Peer recommendation is extremely valuable because people believe their friends much more readily than a company or marketer.
  • A "Refer-a-Friend" campaign promotes a compelling offer via email marketing and social networks, then grants access to special offers for both the referrers and those referred. Using these campaigns will allow you to gather important metrics, like tracking who the biggest influencers are.
  • A "Social Sweepstakes" campaign allows your entrants to spread the word on your behalf. Through the sweepstakes entry, you gain important user data like who is sharing and where they are sharing most.
  • Finally, a "Flash Deal" campaign is similar to Groupon. Flash deals offer a limited amount of deals for a specific time period through your social platforms. If you use these campaigns, be sure to let participants track the deal's progress! These campaigns are fun and viral ways to spread brand awareness and boost new customer numbers with sharing.
  • make sure your shares are measurable. Monitoring social share numbers is not only an easy way to tell what's working and what's not, but also allows you to see your ROI by showing how far your social reach is in relation to how much time and resources you've put in.
  • Google Alerts and search functions, or enterprise level software like Viral Heat or Radian6.
  • Once you hear what people are saying, you can engage them with relevant responses.
  • Social has evolved into much more than just a channel or tactic and should be an ever-present strategy in all aspects of your marketing. Ultimately, if you come up with a plan, encourage creative content, incorporate social marketing into every stage of your funnel, and measure your results, you'll start to see your social efforts move the ROI needle in the right direction.
cezarovidiu

Focus on Valuable Data - Not Big Data - to Boost Conversions and ROI | ClickZ - 0 views

  • Big Data has been all the rage. But fast data, even if it is small, can be more valuable than complicated masses of information.
  • Here's why: All the focus on "bigger is better" has overlooked the fact that most Big Data segments have not been validated with a business application or value.
  • Those kinds of analytics can help you find the right streams to access and work with, and also can help you build out robust programs that identify valuable customers.
  • ...1 more annotation...
  • 1) Your First-Party Data: The primary and most valuable data set you can access, first-party data encompasses transactional and other customer-level profile information you have on your customers. It could also include your own off-line segmentation analysis that allows you to map a customer to a customer profile around which you build your marketing programs. This can also include your analytics or other on-site tracking data, which can deliver behavioral insight to your consumers. This data can be difficult to export from its current environment due to the ad hoc nature of the data, but, if possible, look at ways to make this information accessible to your digital sites. 2) Third-Party Data: A consumer's broader Web browsing and buying history can now be accessed in session to provide you with more context on their likes and habits. Data management platforms (DMPs) and other data aggregators are accelerating this offering and, just as importantly, the availability of this type of data. This is invaluable in the context of new visitors who you know nothing about historically. 3) Real-Time Behavior: Let's not forget what our customers are telling us with each click. We get enamored with our predictive modeling to the point that we do not see the tell-tale signs as they are happening. Take the time to stop, look, and react. Your analytic tools, personalization tools, and other software-as-a-service (SaaS) platforms can help you trigger alternate site experiences based on every click you see.
cezarovidiu

Rittman Mead Consulting » Blog Archive » Using OBIEE against Transactional Sc... - 0 views

  • The best practice in business intelligence delivery is always to build a data warehouse.
  • Pure transactional reporting is problematic. There are, of course, the usual performance issues. Equally troublesome is the difficulty in distilling a physical model down to a format that is easy for business users to understand. Dimensional models are typically the way business users envision their business: simple, inclusive structures for each entity. The standard OLTP data model that takes two of the four walls in the conference room to display will never make sense to your average business user.
cezarovidiu

The Past, Present and Future of Business Intelligence. - YouTube - 0 views

shared by cezarovidiu on 13 Jan 13 - No Cached
  • Irshad Raihan interviews Don Lutter, senior BI solutions manager, on HP's products, solutions and services for Business Intelligence. Don has over 30 years of experience, building and implementing BI solutions. He talks about HP's view on where the market is headed and how HP can help customers address the challenges of Big Data and Real Time Analytics. This interview was recorded at HP Discover 2011 in Las Vegas.
cezarovidiu

Building Dynamic Actions in Oracle Application Express 4.1 - 0 views

  •  
    "select d.loc location, count(e.empno) num_employees from dept d, emp e where d.deptno = e.deptno(+) and d.deptno = :P3_DEPTNO group by d.loc"
cezarovidiu

Complex OBIEE Reports - Emulating QlikView in OBIEE - 0 views

  • So, one alternative to installing a QlikView platform is to build QlikView-style displays with QlikView-style performance directly within OBIEE.
cezarovidiu

What's in a Tag? | ClickZ - 0 views

  • The tag-management industry is growing rapidly, as tags are critical to gathering data about your customers.
  • It's the early days for tag management, but the industry is growing rapidly because it's not so much about tags, but about the bigger challenge of using digital data.
  • Where does tag management fit in the data picture? Here's an example someone shared with me recently: He had gone to an antivirus product's website, read the reviews, and bought the software. In the days that followed, however, he suddenly began to see banner ads from that same software maker whenever he visited CNN, ESPN, and other favorite websites. The software maker knew he had visited its website, but not that he already bought the product. They were retargeting him with banner ads at unnecessary cost and no purpose.
  • ...11 more annotations...
  • Tag management fixes this problem.
  • Most marketing teams struggle with the volume, velocity, and variety of digital data generated every time someone touches the brand. You need insights from the data. You need to understand cross-channel behavior and run predictive "what if" scenarios to improve the effectiveness of your media mix. Tag management can create a foundation to make it easier to use multichannel marketing analytics for these purposes.
  • But one of the big improvements introduced by tag management systems is this: non-technical marketers can do their own tag management.
  • No need to ask IT to deploy tags.
  • You can deploy just one tag, sometimes even just a single line of code, and then manage all the tags through a single user interface.
  • That's a big change from being forced to modify source code on your website.
  • The best tag management systems unite tagged data in one place - automatically.
  • Now the best tag management systems track a data record each time a consumer touches your brand - and deliver it to you in one place.
  • what each consumer has viewed, on what platform, how long they spent with your content, and whether they purchased anything. You get a unified view for everything the consumer has done across all marketing channels.
  • they include the right to be forgotten, easier access to your own data, explicit consent over the use of your data, and privacy by design by default.
  • And, it's clear that the best tag management systems can be a foundation for building those elusive, one-to-one relationships with customers, while using marketing analytics to further improve your marketing decisions about how, when, and where to relate to them.
cezarovidiu

Using Email to Get the Conversion (Without Stalking) | ClickZ - 0 views

  • The reality of the inbox is that people subscribe to a lot more stuff than they are committed to reading. As a result, they sift through the advertising and marketing noise to find the gems--the messages they connect with and that add value to their lives.
  • your email has to add value to your customers' lives
  • From your initial sign up process to the content and frequency of your messaging, your most important job is showing your audience that you respect the privilege of being invited into their inbox.
  • ...15 more annotations...
  • Rule #1: Don't ask for more information than you'd personally be willing to give. Asking for too much information in an opt-in form can be a major deterrent to visitors who would otherwise be likely to sign up.
  • Make signing up as simple as possible by requiring only the bare minimum. In many cases, this means just the email address. Every field you add to your form beyond that will decrease the chances of someone filling it out.
  • Here's another tip: If you really want to convince a visitor to opt in to your communications, make it clear that the value they'll receive greatly outweighs the hassle of signing up
  • An opt-in form that says something like "Sign up for our newsletter," doesn't offer any benefit to the visitor. Give people a reason to opt-in by offering them something they'll care about, like: "Sign up for our monthly newsletter and gain instant access to our 57-page e-book on X."
  • Offers of buying guides, e-books, case studies, online videos, and instant coupons are all great incentives to test.
  • I recently welcomed two kittens into the family and we buy our supplies from Petco. As soon as I signed up for Petco's Pals Rewards program, the store proceeded to email me every single day with a new coupon offer. Can you guess what I did? Yep, I opted out. I'll still buy pet supplies from Petco, but at some point, the annoyance became greater than the value of the coupons.
  • One of the most critical steps in structuring your e-commerce email campaign is to set the publish frequency to align with the types of products you're selling and who you're selling to. At a bare minimum, segment your audience into two broad categories of current customers and prospects.
  • When you're communicating with prospective customers, offer discounts, promotions and pre-sale notifications and buying tips in your emails, to move them along the conversion path.
  • You can further segment your email list by those you send to frequently, those you send to less frequently and those you send to only sometimes.
  • You'll find your sweet spot by tracking conversions from the list, looking at the opt-out rate and by allowing your audience to manage the frequency of the communications (for example, by giving them the option to change the frequency before they opt out entirely).
  • When most people opt in to receive B2B email communications, they are at the top of the conversion funnel; the "awareness" stage. A smart B2B email campaign will then provide the right content to bring the buyer deeper into the conversion funnel, with content specific for each stage of the buying cycle.
  • Here are some ideas to get you started: Explore learning concepts that get the reader up to speed on the ideas surrounding your services, and that demonstrate your brand's unique perspective.  Dive into the ideas behind why a service like yours is so important to customers, what to look for in a company, and how your service or ideas compare to others.  Answer common questions your prospective customers have at each stage of the buying cycle and even after the purchase.
  • Don't forget you're not selling to rational people. Most of the buying decisions in a B2B environment are based on what could happen if the choice is wrong. Unlike the consumer market, where an item can be easily returned if it doesn't meet the buyer's needs, making the wrong purchase decision in the B2B arena could be extremely costly.
  • Your goal as the marketer is to arm the potential buyer with content that will reduce any fear and uncertainty about selecting your business over the competition.
  • Think of topics like, "7 Biggest Mistakes People Make When Choosing [insert your service here]" as a basis for building your case. If you have a sales team, ask them for the most common objections they hear from prospects, and create your content around the specific concerns known to be top-of-mind for many buyers.
cezarovidiu

Installing Hadoop for Fedora & Oracle Linux(Single Node Cluster) | accretion infinity - 0 views

  • Hadoop is a framework written in Java for running applications on large clusters of commodity hardware and incorporates features similar to those of the Google File System (GFS) and of the Map Reduce computing paradigm. Hadoop’s HDFS is a highly fault-tolerant distributed file system and, like Hadoop in general, designed to be deployed on low-cost hardware. It provides high throughput access to application data and is suitable for applications that have large data sets.
  • Some of the Hadoop projects we will talk about are: HDFS : A distributed filesystem that runs on large clusters of commodity machines. Map Reduce: A distributed data processing model and execution environment that runs on large clusters of commodity machines. Pig: A data flow language and execution environment for exploring very large datasets. Pig runs on HDFS and MapReduce clusters. HBase: A distributed, column-oriented database. HBase uses HDFS for its underlying storage, and supports both batch-style computations using MapReduce and point queries (random reads). ZooKeeper: A distributed, highly available coordination service. ZooKeeper provides primitives such as distributed locks that can be used for building distributed applications. Oozie: Oozie is a workflow scheduler system to manage Apache Hadoop jobs.
  • Oracle Linux as the operating system and Hadoop 1.1.2 or 1.2.0
1 - 16 of 16
Showing 20 items per page