Skip to main content

Home/ BI-TAGS/ Group items tagged technical

Rss Feed Group items tagged

cezarovidiu

Oracle Apps technical - 0 views

  •  
    "Oracle Apps technical"
cezarovidiu

Filling a Critical Role in Business Today: The Data Translator - Microsoft Business Int... - 0 views

  • a lot of articles calling data scientists and statisticians the jobs of the future
  • there are more immediate needs that, when addressed, will have a much greater business impact.
  • Right now we have huge opportunities to make the data more accessible, more “joinable” and more consumable. Leaders don’t want more data – they want more information they can use to run their businesses.
  • ...5 more annotations...
  • Every company has hundreds of millions of records about their sales, expenses, employees and so on, with dozens of insights yet to be discovered through simple comparison or triangulation of relevant data.
  • Why don’t we focus on this? I think because it’s very difficult to do – being successful in this “data translator” role requires a unique set of skills and knowledge, the combination of which I call the BASE skillset: Business understanding Ability to synthetize and simplify Storytelling skills Expertise in data visualization
  • Business Understanding This one seems obvious, but it doesn’t mean simply understanding the financials of a business. Rather, it means truly knowing the operational details, the incentives, the install base, market growth, penetration, the competition, etc. An analyst can’t just know the technical aspect of a report or the math behind the numbers, but what is truly driving a pattern in terms of product quality, competition, incentives and/or offerings. The best analysts are able to mathematically isolate the key levers of a trend and then suggest actions to react to or take advantage of those trends. Ability to Synthetize and Simplify This is, in my opinion, the most underrated and underappreciated skill. Combing through thousands of data points and netting out 3-4 key issues in under 10 minutes, and then communicating these to a group of execs with very different analytical skills, is truly difficult. The key is to make it simple but not simplistic, which means you still capture the complexity even as you get to the few core insights. It requires a very thorough effort to gather all the relevant information before categorizing, prioritizing and deciding if it is significant. After a while, you become an expert and can sniff things out quickly. At the same time, there is the danger of missing anomalies when you jump to conclusions based only on a summary look.
  • Storytelling Skills There are stages that should be followed when explaining complex ideas, something data translators are frequently expected to do. The best storytellers start by giving context and trying to couple the current discussion to something the audience already knows, ensuring the story is well structured and connected. We have to move from a “buffet style” business review with thousands of numbers packed in tables to a layered approach that will guide the audience to focus first on the most relevant messages, diving deeper only when necessary. Minto Pyramid Principles, which are built around a process for organizing thought and communication, are helpful in making sure you really focus on what is important and relevant, versus being obsessed in telling every fact. Expertise in Data Visualization I am glad to finally see so much focus on Information Visualization and I believe this is correlated to the explosion of data. Traditional methods of organizing data do not facilitate an intuitive understanding of key information points or trends. For instance, the two examples below contain data on car sales across the U.S. The first, an alphabetized list, is much less intuitive than the second, which shows those sales on a map in Power View. With Power View, right away you can identify the states with the highest sales: CA, FL, TX, NY. (Workbook available here)
  • There is no better way to see patterns or trends than data visualization, making expertise in this area – both technical and analytical – critical for data translators.
cezarovidiu

BI Brief - Four Legs of a Successful Business Intelligence (BI) Project Team - 0 views

  • 1. Project Sponsorship and Governance 2. Project Management 3. Development Team (Core Team) 4. Extended Project Team
  • 1. Project Sponsorship and Governance IT and the business should form a BI steering committee to sponsor and govern design, development, deployment, and ongoing support. It needs both the CIO and a business executive, such as CFO, COO, or a senior VP of marketing/sales to commit budget, time, and resources. The business sponsor needs the project to succeed. The CIO is committed to what is being built and how.
  • 2. Project Management Project management includes managing daily tasks, reporting status, and communicating to the extended project team, steering committee, and affected business users. The project management team needs extensive business knowledge, BI expertise, DW architecture background, and people management, project management, and communications skills. The project management team includes three functions or members: Project development manager - Responsible for deliverables, managing team resources, monitoring tasks, reporting status, and communications. Requires a hands-on IT manager with a background in iterative development. Must understand the changes caused by this approach and the impact on the business, project resources, schedule and the trade-offs. Business advisor - Works within the sponsoring business organization. Responsible for the deliverables of the business resources on the project's extended team. Serves as the business advocate on the project team and the project advocate within the business community. Often, the business advocate is a project co-manager who defers to the IT project manager the daily IT tasks but oversees the budget and business deliverables. BI/DW project advisor - Has enough expertise with architectures and technologies to guides the project team on their use. Ensures that architecture, data models, databases, ETL code, and BI tools are all being used effectively and conform to best practices and standards.
  • ...2 more annotations...
  • 3. Development Team (Core Team) The core project team is divided into four sub-teams: Business requirements - This sub-team may have business people who understand IT systems, or IT people who understand the business. In either case, the team represents the business and their interests. They are responsible for gathering and prioritizing business needs; translating them into IT systems requirements; interacting with the business on the data quality and completeness; and ensuring the business provides feedback on how well the solutions generated meet their needs. BI architecture - Develops the overall BI architecture, selects the appropriate technology, creates the data models, maps the overall data workflow from source systems to BI analytics, and oversees the ETL and BI development teams from a technical perspective. ETL development - Receives the business and data requirements, as well as the target data models to be used by BI analytics. Develops the ETL code needed to gather data from the appropriate source systems into the BI databases. Often, a system analyst who is a expert in the source systems such as SAP is part of the team to provide knowledge of the data sources, customizations, and data quality. BI development - Create the reports or analytics that the business users will interact with to do their jobs. This is often a very iterative process and requires much interaction with the business users.
  • 4. Extended Project Team There are several functions required by the project team that are often accomplished through an "extended" team: Players - A group of business users are signed up to "play with" or test the BI analytics and reports as they are developed to provide feedback to the core development team. This is a virtual team that gets together at specific periods of the project but they are committed to this role during those periods. Testers - A group of resources are gathered, similarly to the virtual team above, to perform more extensive QA testing of the BI analytics, ETL processes, and overall systems testing. You may have project members test other members' work, such as the ETL team test the BI analytics and visa versa. Operators - IT operations is often separated from the development team but it is critical that they are involved from the beginning of the project to ensure that the systems are developed and deployed within your company's infrastructure. Key functions are database administration, systems administration, and networks. In addition, this extended team may also include help desk and training resources if they are usually provided outside of development.
cezarovidiu

2013 ERP research: Compelling advice for the CFO : Enterprise Irregulars - 0 views

  • ERP vendor selection. As the following graph shows, the primary candidates for ERP software were SAP, Oracle, Microsoft, Epicor, and Infor:
  • The cloud question. Despite the hype, only 14 percent of respondents are using ERP delivered as Software as a Service (SaaS). Although the best cloud vendors can deliver superior security and reliability than most internal IT departments, market momentum to ERP in the cloud is not there yet, as the following diagram illustrates:
  • Important lessons. Implementing an ERP system is always complex because the deployment drives changes to both data and processes that extend across departmental boundaries inside the organization.
  • ...4 more annotations...
  • Software projects aren’t just technical endeavors. They’re also political, financial, emotional, structural, strategic, process and people-centric initiatives. Ignoring any one of these dimensions is done at the project manager’s peril.
  • Today’s CFO must balance the demands of two competing forces: the extraordinary wave of innovation (and the process changes these bring) against the regulatory, control-driven forces who want every process, every exception, and device to be documented, controlled and secured. In recent years, CFOs have spent tens of billions of dollars (or more) with audit firms to document the control points and risks within their existing ERP solutions.
  • ERP can bring significant benefit but implementation requires careful attention to both business planning and technology activities. For this reason, achieving project success and business value demand that CFO and CIO work together as a collaborative unit.
  • Therefore, it is essential to create this partnership and show your entire organization that the business and technology teams can communicate, collaborate, and share knowledge on a systematic and consistent basis. This collaboration is the true underlying strategy for gaining maximum value from ERP or any other enterprise initiative.
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

13 things to consider when implementing a CRM plan | Econsultancy - 0 views

  • These are few of the benefits of implementing a good quality CRM All of your clients’ information is stored in one place, it’s easy to update and share with the whole team. Updates by colleagues should be saved immediately. Every member of your team will be able to see the exact point when your business last communicated with a client, and what the nature of that communication was. CRMs can give you instant metrics on various aspects of your business automatically.  Reports can be generated. These can also be used to forecast and plan for the future. You will be able to see the complete history of your company’s interaction with a client. Calendars and diaries can be integrated, relating important events or tasks with the relevant client.  Suitable times can be suggested to contact customers and set reminders.
  • Finding one system that will fit your needs in one package may not be possible, so be aware that you may need to customise it to fit into your company. There are infinite possibilities here so don’t get too carried away as costs will rise accordingly.
  • Ensure that the CRM works on mobile devices and can be accessed remotely. Employees aren’t necessarily sat at their desks when it needs to be used or updated. Real-time updates are necessary for ensuring that clients aren’t contacted twice with the exact same follow up.
  • ...4 more annotations...
  • Will it work for Outlook, Gmail or whichever email provider your company uses? 
  • Does you CRM have full social media integration? It’s vital that any customers or clients interacting with you on social channels can be included in your CRM updates. You will find this happens increasingly as your public facing channels become more popular. For more detailed information download our best practice guide CRM in the social age.  
  • Do you have a fully CRM trained analytics team that can study and understand the data and reports the system will generate? It’s probably wise to implement a cleansing plan for your existing data before the new system is implemented. Sifting through contacts to remove any duplicated or defunct leads.
  • Having an extra piece of software in the company, especially one as integral as this, means there’s a lot more to manage and possibly to go wrong. Make sure you have the technical support in place to ensure its smooth running.
cezarovidiu

Why BI projects fail -- and how to succeed instead | InfoWorld - 0 views

  • A successful initiative starts with a good strategy, and a good strategy starts with identifying the business need.
  • The balanced scorecard is one popular methodology for linking strategy, technology, and performance management. Other methodologies, such as applied information economics, combine statistical analysis, portfolio theory, and decision science in order to help firms calculate the economic value of better information. Whether you use a published methodology or develop your own approach in-house, the important point is to make sure your BI activities are keyed to generating real business value, not merely creating pretty, but useless, dashboards and reports.
  • Next, ask: What data do we wish we had and how would that lead to different decisions? The answers to these questions form top-level requirements for any BI project.
  • ...10 more annotations...
  • Instead a team of data experts, data analysts, and business experts must come together with the right technical expertise. This usually means bringing in outside help, though that help needs to be able to talk to management and talk tech.
  • Nothing makes an IT department more nervous than asking for a feed to a key operational system. Moreover, a lot of BI tools are resource hungry. Your requirements should dictate what, how much, and how often (that is, how “real time” you need it to be) data must be fed into your data warehousing technology.
  • In other words, you need one big feed to serve all instead of hundreds of operational, system-killing little feeds that can’t be controlled easily.
  • You'll probably need more than one tool to suit all of your use cases.
  • You did your homework, identified the use cases, picked a good team, started a data integration project, and chose the right tools.
  • Now comes the hard part: changing your business and your decisions based on the data and the reports. Managers, like other human beings, resist change.
  • oreover, BI projects shouldn't have a fixed beginning and end -- this isn't a sprint to become “data driven.”
  • A process is needed
  • and find new opportunities in the data.
  • Here's the bottom line, in a handy do's-and-don'ts format: Don’t simply run a tool-choice project Do cherry-pick the right team Do integrate the data so that it can be queried performance-wise without bringing down the house Don’t merely pick a tool -- pick the right tools for all your requirements and use cases Do let the data change your decision making and the structure of your organization itself if necessary Do have a process to weed out useless analytics and find new ones
1 - 10 of 10
Showing 20 items per page