Skip to main content

Home/ BI-TAGS/ Group items tagged measure

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

Create a Measure and KPI (Tutorial) - 0 views

technet.microsoft.com/...hh272049.aspx

Business Intelligence measure kpi tutorial

shared by cezarovidiu on 21 Feb 13 - No Cached
  • In this lesson you will use PowerPivot to create and manage a measure and a Key Performance Indicator. A measure is a formula that is created specifically for use in a PivotTable (or PivotChart) that uses PowerPivot data. Measures can be based on standard aggregation functions, such as COUNT or SUM, or you can define your own formula by using DAX. For more information about measures, see Measures in PowerPivot.
  • cezarovidiu on 21 Feb 13
     
    "Create a Measure and KPI (Tutorial)"
cezarovidiu

Creating Palo OLAP cubes and dimensions with Talend - 0 views

www.robertomarchetto.com/ate-palo-olap-cubes-dimensions

palo talend

shared by cezarovidiu on 03 Jun 14 - No Cached
  • Creating Palo OLAP cubes and dimensions with Talend
  • Step 1: Create a Palo database with Talend tPaloDatabase
  • Step 2: Add Palo dimensions with tPaloDimension
  • ...3 more annotations...
  • Step 3: Create a Measures dimension
  • OLAP Measures in Palo are defined in a single dimension, with element values as measure names. For example to add a "PiceList" and "Quantity" measure we'll create a dimension named "Measures" with two numeric elements: "PriceList" and "Quantity".
  • Step 4: Create Palo OLAP Cubes with Talend tPaloCube
cezarovidiu

Magic Quadrant for Business Intelligence and Analytics Platforms - 0 views

www.gartner.com/...reprints.do

gartner Bi

shared by cezarovidiu on 12 Feb 13 - No Cached
  • 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.
  • cezarovidiu on 12 Feb 13
     
    "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

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

www.clickz.com/...so-much-more-than-social-media

social marketing

shared by cezarovidiu on 29 Oct 13 - No Cached
  • 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

Comparing Arbitrary Time Periods in OBIEE - 0 views

www.kpipartners.com/...rbitrary-Time-Periods-in-OBIEE

obiee time series

shared by cezarovidiu on 28 Oct 13 - No Cached
  • The Ago() “time series function” can be used to show data for a  previous time period, as long as the previous time period corresponds to a level that has been defined in the period hierarchy. A typical period hierarchy containing day, month, quarter, and year levels would allow you to use the Ago function to construct measures showing data for day ago, month ago, quarter ago, year ago (or N days ago, N months ago, etc.).
1 - 6 of 6
Showing 20▼ items per page