Skip to main content

Home/ BI-TAGS/ Group items tagged power

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
cezarovidiu

Download Microsoft Power Query for Excel - Office.com - 0 views

office.microsoft.com/...rer-for-excel-FX104018616.aspx

excel add-ins data discovery power query

shared by cezarovidiu on 17 Oct 13 - No Cached
  • Microsoft Power Query is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access.
  • Power Query enables users to easily discover, combine, and refine data for better analysis in Excel. Power Query includes a public search feature that is currently intended for use in the United States only.
cezarovidiu

Does Excel Power Pivot Replace the Data Warehouse? | SQL Server BI Blog - 0 views

sqlmag.com/...r-pivot-replace-data-warehouse

power pivot

shared by cezarovidiu on 14 Feb 15 - No Cached
  • Excel Power Pivot is targeted for Personal and Team Business Intelligence (BI) solution use cases.
  • Power Pivot also is excellent for quick prototypes and proofs-of-concept.
  • no row level security,
  • ...2 more annotations...
  • The more advanced features include partitioning for large-scale data sources and role based security.
  • A data mart or data warehouse is often the blessed, single version of the truth since it uses governed, controlled data loading and ETL processes to combine disparate data sources, applies extensive business logic and proven data modeling design patterns that can securely, accurately and efficiently report data changes over time periods.
cezarovidiu

Office 2013 SKU's needed for Power BI add-ins or to manipulate existing PowerPivot work... - 0 views

blogs.technet.com/...t-workbooks-in-excel-2013.aspx

office excel power BI

shared by cezarovidiu on 05 Jan 15 - No Cached
  • Note: Power Pivot and Power View on the standalone retail 32-bit and 64-bit SKUs were added with the October 2013 updates. If you have one of these SKU's but do not see the add-in, please apply the most recent updates and test for improvement. 
cezarovidiu

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

blogs.msdn.com/...today-the-data-translator.aspx

BI microsoft

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

PowerPivot, Power View and Inquire availability - the definitive Microsoft answer - 0 views

www.ion.icaew.com/...he-definitive-Microsoft-answer

office excel licensing

shared by cezarovidiu on 19 Oct 14 - No Cached
  • With their inclusion in Excel standalone, at a cost of less than £100, any financial barrier to obtaining the benefit of these features is greatly reduced.
  • Excel 2013 Standalone Volume License and Standalone Retail 32-bit and 64-bit.
  • PowerPivot and the two new add-ins - PowerView and Inquire, are only available on certain SKUs (versions). These include:
cezarovidiu

Tips and tricks for creating reports - Microsoft Power BI Preview - 0 views

support.powerbi.com/...nd-tricks-for-creating-reports

power BI geolocation geo-coding maps bing-maps

shared by cezarovidiu on 02 Feb 15 - No Cached
  • When you create a Map, you're often looking to plot Countries, States, and Cities.  If you use name columns after the geographic designation it will help Bing guess what you're looking to display. For example, if you have a field of US state names such as "California" and "Washington", Bing might return the location of Washington, DC instead of Washington State for the word "Washington".  Naming the column "State" will improve the geocoding.  The same is goes for columns named "Country", "State", and "City".  
cezarovidiu

10 Reasons Why CEOs Don't Understand Their Customers - Forbes - 0 views

www.forbes.com/...ont-understand-their-customers

crm

shared by cezarovidiu on 28 Feb 13 - No Cached
  • 1) Do bad customer experiences cause people to switch brands? In a 2011 research project conducted by CX application vendor RightNow, 89% of consumers said that yes, a bad experience has spurred them to switch brands. But in the brand-new study of business-executive perceptions that’s the subject of this column, only 49% of the surveyed executives said yes.  QUESTION: What steps do you need to take to close this dangerous perception gap? 2) While 97% of executives say CX is critical to the success of their company, and 91% say they’re committed to making their company a CX leader, only 20% would rate their own CX initiatives as “advanced,” with a dedicated CX leader in place, initial projects pushed to the optimization phase, and the overall project extended to new channels and groups . QUESTION: What are the obstacles preventing you from aligning your actions with your words? If you say it’s a “budget” issue, aren’t you really talking about strategic priorities rather than line items? 3) Most companies have a clear and direct understanding of the looming CX challenge and the powerful interaction of social media. The study found that the top two drivers for CX initiatives are (a) rising expectations from customers (59%),  and (b) the impact of social media on customers’ ability to broadcast good and bad experiences (37%). Now, even if you’re able to somehow rationalize those findings, here’s one that not even the most-accommodating executive can dismiss:
  • 4) Being a CX laggard can cost those companies many tens of millions or even hundreds of millions of dollars in lost revenue: executives estimated that the lack of positive, consistent, and brand-relevant customer experience can cause them to lose out on a staggering 20% in annual revenue.
  • Worse yet, all that money’s likely to wind up in the pockets of your competitors!
  • ...1 more annotation...
  • 5) While 81% of execs said they believe that social media is an essential ingredient in delivering great customer experiences, 35% of responding companies still do not have social media for sales channels, and another 35% still do not have social media for customer service. QUESTION: How do you plan to close that dangerous gap?
cezarovidiu

MicroStrategy Suite | MicroStrategy - 0 views

www.microstrategy.com/freereportingsoftware

MicroStrategy Bi free *****

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

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

Angel's BI Blog: Excel Data Explorer and the Twitter Search API - 0 views

www.angelsbiblog.com/...plorer-twitter-search-api.html

'data explorer' excel

shared by cezarovidiu on 19 Jun 13 - No Cached
  • its a very powerful query engine/data transformation tool.
  • what's fascinating is its ability to load web data from static html pages, tables on web pages, web services, etc. I had a need to search recent activity on Twitter and decided to test drive Data Explorer in Excel.
1 - 20 of 25 Next ›
Showing 20▼ items per page