Home > Uncategorized > daily 02/19/2014

daily 02/19/2014

    • Force.com Excel Connector





        Jump to:   navigation ,   search  

        <!– start content –> 

      Data Cleaning via Excel


      This Excel Add-in provides bi-directional access to the Force.com API via the Toolkit for Office, and is useful for cleaning and mass-updating salesforce.com-based data from within a spreadsheet. Updated features include access to Products2 and custom objects, API names or labels, simple query wizard, readable user names, and more.  




        <!– Here’s where I want my views to be displayed –> 

       SMAC (Salesforce Mobile Administration Console) is a mobile application which enables you to  quickly and easily manage your salesforce.com objects, users, and data.
    • CLIq provides a simple wizard to create directory structures and configuration files for the Salesforce Data Loader Command Line Interface. You can spend hours configuring the CLI manually, or use CLIq and you will have a working configuration in less than 5 minutes. After creating a CLIq configuration, you can reference the Data Loader documentation and make adjustments as needed.
      • Validates your username/password, queries, and entity names (avoids case-sensitivity issues)
      • Write SOQL statements (for Exports) – You’ll need to know how to write SOQL.
      • Configure Data Loader to write directly to Databases
      • Automatically configure SDL file.
    • Data Loader





        Jump to:   navigation ,   search  

        <!– start content –> 



      Data loader.png


      The Force.com platform offers you a development environment which you can use to create your own custom applications. Frequently, you will use the Force.com platform to create applications that operate on data that you already have in some form – in comma-separated variable files, spreadsheets or other relational databases. 

      The Data Loader is an easy to use graphical tool that helps you to get your data into Salesforce objects. The Data Loader can also be used to extract data from database objects into any of the destinations mentioned above. You can even use the Data Loader to perform bulk deletions by exporting the ID fields for the data you wish to delete and using that source to specify deletions through the Data Loader. 

      The Data Loader requires the use of the Force.com API. If your Salesforce edition allows the use of the API (Enterprise, Unlimited and Developer Editions), you can download the Data Loader from the Setup menu, under Administer heading – Data Management

    • How can you pull data from Salesforce into Excel (and/or Excel PowerPivot)? What’s the best way to do it on a recurring basis?


      We need to pull data to Excel from SF, and have it updated at least weekly. What’s the best way to go about it?

    • There are a number of ways to do it. My general tool of choice when I just want a simple 1- or 2-way CSV integration is the Salesforce Data Loader. It’s free, it works well, and it has a command-line interface so you can set your extracts/updates to run on a pre-defined schedule. The main downside is that it’s not as user-friendly and feature-rich as some of the third party tools out there.
    • Monday, September 16, 2013





       Tableau vs. Power Pivot Part 1: Basic Functionality 





       Today, we will begin a new series comparing two of the top self-service BI tools on the market, Tableau and Power Pivot.  Most people would say that Tableau is a “visualization” tool and Power Pivot is a “modeling” tool.  However, is this really true?  That’s what we’re here to find out.  We’re going to put many of the features of Tableau up against Power Pivot, and vice-versa, to see what they can really do.  This type of examination was done about three years ago.  Click here if you would like to read it.  Many of the flaws listed for Tableau have been worked out in the newer releases, while Power Pivot has not gotten the same treatment.  This is a major issue when comparing purchased products to free products.  However, our examination is from the user’s perspective.  This means that current and future functionality must be considered, as well as pricing.  As usual, we will use the Superstore Sales sample data set from Tableau.
    • xperience creating reports and dashboards in Salesforce.com would be a strong plus.
       Desired Experience: Several years in an analyst program at an investment bank or private equity fund.















































































       <!– corrects IE6 width calculation –> 




      This Blog

      Linked From Here

      This Blog
      Linked From Here

       <!– google_ad_section_start(name=default) –>  


      Friday, November 23, 2012





       PowerPivot Viz – Historical Sales Versus Forecast Continuous Line Chart 






    • This tutorial shows how you can use the world’s most widely used BI tool, Microsoft Excel, to get direct SQL access via ODBC to SaaS applications hosted in the cloud.  More specifically, we’ll look at how Excel power users can leverage PowerPivot to build enhanced analytic capabilities directly on top of Salesforce.com data (Sales cloud, Service cloud, Force.com, Database.com).  This data can then be mashed up with other data sources for 360 degree analytics.  This is self-service BI at its finest since absolutely no staging database is required; and you are leveraging existing SQL-92 skills to directly access live data.















































































       <!– corrects IE6 width calculation –> 





       <!– google_ad_section_start(name=default) –>  


      Monday, November 11, 2013





       Tableau vs. Power Pivot Part 9: Introductory Time Intelligence 





       Today, we will talk about utilizing Time Intelligence within both of these tools.  Time Intelligence is probably the most common category of KPIs.  Everybody wants to know how they compared against last year, last quarter, the last three months, etc.  For this reason, both of these tools have built-in functionality for these calculations.  However, we will limit this investigation to the introductory problems, as we are calling them.  In later posts, we will get into the more complex Time Intelligence situations.  As usual, we will use the Superstore Sales sample data set from Tableau.
    • Key Performance Indicators (KPIs) in Power Pivot

      Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of a metric against a defined target. The KPI gauges the performance of the value, defined by a Base calculated field, against a Target value, also defined by a calculated field or by an absolute value. If your model has no calculated fields, see Create a calculated field.

      • A PowerPivot Author:



        1. Loads data into PowerPivot 
        2. Creates relationships and formulas (we can call this “modeling”) 
        3. Builds reports, dashboards, etc. based on #2 
        4. Shares #3 with others
    • Unlike the PowerPivot Authors, SharePoint is one place where growing/hiring in-house expertise is the wrong thing to do.  It just takes entirely too long.  And once you finally find or develop a competent SharePoint admin, they leave for a consulting firm.
    • They know Excel. 
    • They are a good (and efficient) communicator.
    • They ask good questions
    • They can place themselves in the shoes of the consumers
    • How does it work?


      This route requires you to sit a single three-hour exam in either May or November each year. It assesses your knowledge of the material covered in the management level of the CIMA Professional Qualification.

    • Welcome to CIMA USA


      Keep up to date with the latest news and events in the region.


      To find out how to become a CIMA student, or other student/member related queries (fees, exemptions, exam centres, etc), please get in touch with CIMA contact on cima.contact@cimaglobal.com or +44 (0)20 8849 2251. 


      Our CIMA USA member contact, Ruby Kaur, works in a voluntary capacity for local queries only.

    • CIMA has a fast track route to the professional qualification for students with an MBA.

      See our MBA route page for everything you need to kn

    • In this course you are introduced to the discipline of statistics as a science of understanding and analyzing data. You will learn how to effectively make use of data in the face of uncertainty: how to collect data, how to analyze data, and how to use data to make inferences and conclusions about real world phenomena.

      The course was originally developed as a complement to the similarly-titled Coursera course, and based on the material covered in the open-source book OpenIntro Statistics (Second Edition). So if you prefer to go through the material at your own pace and speed, the latter will be a perfect source for supplementary material.

      No formal background is required for this course, but some basic mathematical skills will come in handy. A genuine interest in data analysis is a plu

    • A good take-down bow should only cost you a couple hundred bucks and if you take care of it, you can expect it to last your lifetime. Not only is the bow itself affordable, but the ammunition (arrows) are cost effective too. Once you hone your shooting skills, you should be able to retrieve your arrows after shooting and reuse them over and over again. With a little practice, you can also easily make your own arrows using wooden dowels or even natural-found wood and plant shafts.
    • Delete Your Creativity and Productivity Blocks

      You really only need to remember one thing: just start. Beginning is everything. You creativity and productivity blocks exist because you don’t trust yourself enough to just create. Words don’t hit the page because you care about what they are too much to let them. You edit in your head, and then you end up with very little or nothing. When you’re trying to solve a problem or come up with an idea, the same thing applies. You have to stop filtering things out. Just get your ideas and your effort out of your head and into the world. Once you do, you can edit it later.

      You have to delete these blocks to get anything done without a ton of frustration. It may seem easier said than done, but you really just have to let your thoughts happen and put them out there. Write, draw, discuss, or use any method that helps you get ideas out of your head. If you try to edit, delete the notion before it takes root. If you can clear a path for your thoughts to get out, they will.

    • Uncouple from phone and hold or mount for flexible shooting
    • Uncouple from phone and hold or mount for flexible shooting

      The DSC-QX10 can also be used uncoupled from the smartphone. Hold the camera in one hand and your phone in the other, or use the universal tripod screw to mount your camera to any number of mounts to experience versatile, freestyle shooting.

    • 1 / 2.3? Exmor R CMOS
    • On the final leg of the women’s 4×5 kilometer relay this weekend in Sochi, the little differential number for the Swedish women’s team was 25 seconds, well behind the Finns and Germans at the lead. Charlotte Kalla of Sweden blew through the final 5K of the race at a suicidal pace, overcame both the Finns and German on the last stretch, and like everyone else does at the finish line, flopped across the line and onto the snow, exhausted, spent and indistinguishable from someone shot at a great distance by a sniper.
    • but how it is a sport of average mechanics matched with inhuman endurance
    • This is not a joke: some relatives of mine in the State Department watched Swedish videos made for foreigners about interacting with Swedes, most of which focused on situations where the Swedes found casual interaction to be rude. Per the videos, these situations included pretty much every daily social situation, and meeting people in Sweden is hard.
    • Finland might not even be Scandinavian in anything but geography, and might not be anything other than Finland, a separate dimension of taciturn people born with the ability to steer rally cars on icy roads through dense forests at 120 miles per hour and go weeks without saying anything at all. Finns scare Russians, and I’m not sure if I want to live that far over on the spectrum of personally terrifying nationalities.
    • Americans just trust anything with the word Tuscan in front of it even if they have no idea what it means.
    • Charlotte Kalla would be the personification of that thing, the thing the Finns call sisu. It is a resilience transcending any adversity including defeat, the snow, the Russians, the horrible winters or isolation. It carries through, and finishes no matter the cost.
    • Snapchat is a huge App Engine success story. The fact that Snapchat, an app with crazy growth and image sharing, hasn’t ever fallen over like so many startups do when they scale, is a point of pride for the developer tool suite.
    • The band could then play Thus Spake Zarathustra while the Wranglers ride Bevo (who really should be towing a wagon) onto the field with a flaming spear.
    • This should pump-up the crowd enough for 98% of them to stay standing for the entire game; this symbolizes their love of Depression-era radio dramas.
       And one sixth of the time, we do all of this in Mexico.
    •  “We have to solve this because we are talking about the season ticket-holders of tomorrow,” said Oklahoma athletic director Joe Castiglione. “But interests and attitudes are changing so rapidly it’s not easy to quickly identify what we need to do.”
    • Phone service is terrible during games and it’s hard to stay in touch with the world for the three hours you’re in the stadium.”
    • Clark Mott, Texas Tech: “There was a questionable fumble play and while it was being reviewed on the field, I read on Twitter on my phone that people who were watching on TV said it was a fumble. I then realized that being at home and watching on TV gives you such better insight into what is happening.
    • The most common complaints included restrictions on tailgating at the stadium, or the quality of presentation of the games on television compared to the sight lines and breaks in the action at the stadium.
    • Stillman ranked sitting with friends, sitting close to the field, the outcome of the game, tailgating, the student section atmosphere, food specials and entertainment before the importance of Wi-Fi.
    • there’s little added value from being in the stands watching the game.”
    • An average of 28.8 percent of those who bought tickets didn’t show up to home games.
    • “At Georgia? Traditional music and a PA announcer barely yelling ‘Let’s make some noise ‘on third down.”
    • The conclusion? The highest percentage of tickets used in each of the last four seasons came at night games, including a 6 p.m. kickoff against Tennessee-Martin in Sept. 2010, which had only a 7 percent no-show rate, the best over the last four years of home games.
    • For its first two home games, the school gave away a total of $5,000 that was to be equally split among 10 student fans. Even that wasn’t a complete success, as three of the $500 prizes went unclaimed.
    • The next day, the school suspended the priority block seating of 20 student organizations, usually reserved for fraternities and other powerful student groups, citing its guidelines which mention that those in the reserved sections can have their privileges revoked due to “early departure from the stadium.”
    • “At a minimum we will be providing tens of thousands of apps able to run on the Tizen platform, and we’ve had discussions that go up into the hundreds of thousands,”
    • By developing its own operating system rather than relying almost entirely on Android, Samsung hopes to give users a unified experience on devices ranging from phones and netbooks to in-vehicle systems and smart TVs
    • If Tizen becomes a credible alternative to Android, it could threaten Google’s long-term ability to continue steering users to Google products and gathering the data that fuels the Google advertising juggernaut.
    • Tizen grew out of Nokia’s MeeGo platform and is now being developed by an industry consortium led by Samsung and Intel.
    • Another factor in Tizen’s favor: numerous companies now make software known as “middleware” that was not available when Android and Apple’s iOS launched. It lets a writer create a new app once, then click a few buttons to put that app in various app stores, ready to run on several operating systems.
    • When an Android update breaks the compatibility layer, and apps start to fail on Tizen, people will leave Tizen behind.  This is inevitable.  Android would need its own version of app store to remain viable long term.
    • “The new Microsoft Dynamics CRM update democratizes social listening, adds new marketing capabilities for more impact and enables businesses to deliver outstanding customer service. With this new release, we are essentially changing the CRM game.”

Posted from Diigo. The rest of my favorite links are here.

Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: